Re: [GNC] gnucash cli

2025-03-24 Thread Jon Schewe
I worked around the limits by using a python script that automatically executes a delay when quotes aren't retrieved. You may need to increase the delay if you're running into another limit. On Sun, 2025-03-23 at 12:27 -0400, Keith Bellairs wrote: > I need to breakup my securities price update in

Re: [GNC] gnucash-cli doesn't retrieve quotes from "unknown" sources

2023-12-27 Thread Gustavo R. Montesino
On Mon, Dec 11, 2023 at 10:27 PM Gustavo R. Montesino wrote: > On Mon, Dec 11, 2023 at 2:20 PM john wrote: > > > On Dec 11, 2023, at 03:07, Gustavo R. Montesino > > > wrote: > > > > On Sun, Dec 10, 2023 at 9:30 PM john wrote: > > > > > On Dec 10, 2023, at 03:40, Gustavo R. Montesino > > > > >

Re: [GNC] gnucash-cli doesn't retrieve quotes from "unknown" sources

2023-12-11 Thread Gustavo R. Montesino
On Mon, Dec 11, 2023 at 2:20 PM john wrote: > > On Dec 11, 2023, at 03:07, Gustavo R. Montesino wrote: > > On Sun, Dec 10, 2023 at 9:30 PM john wrote: > > On Dec 10, 2023, at 03:40, Gustavo R. Montesino wrote: > > Hello, > > I'm running gnucash 5.4 from Debian testing/sid repo and getting > upd

Re: [GNC] gnucash-cli doesn't retrieve quotes from "unknown" sources

2023-12-11 Thread john
> On Dec 11, 2023, at 03:07, Gustavo R. Montesino wrote: > > On Sun, Dec 10, 2023 at 9:30 PM john > wrote: >>> On Dec 10, 2023, at 03:40, Gustavo R. Montesino >>> wrote: >>> >>> Hello, >>> >>> I'm running gnucash 5.4 from Debian testing/sid repo and getting >>> u

Re: [GNC] gnucash-cli doesn't retrieve quotes from "unknown" sources

2023-12-10 Thread john
> On Dec 10, 2023, at 03:40, Gustavo R. Montesino wrote: > > Hello, > > I'm running gnucash 5.4 from Debian testing/sid repo and getting > updated commodity quotes through "gnucash-cli --quotes get". > > Recently I've noticed that gnucash-cli isn't getting quotes from > "unkonwn" Finance::Qu

Re: [GNC] gnucash-cli -Q get

2023-07-28 Thread Ken Farley
I've not used this functionality but from what I read in the documentation the command you're referencing is intended to be used to update prices in a Gnucash data file. Presumably it's a way to execute the task of Tools->Price Database->Get Quotes, without actually starting up the Gnucash GUI.

Re: [GNC] gnucash-cli options - accounts, dates and other settings

2021-09-01 Thread flywire
Chris, Can you describe that datafile and how it is used? Also the gsettings schemas for gsettings queries. > --gsettings-prefix arg Set the prefix for gsettings schemas for gsettings queries. This can be useful to have a different settings tree while debugging. > Report Generation Options: >

Re: [GNC] gnucash-cli options - accounts, dates and other settings

2021-08-31 Thread Michael or Penny Novack
On 8/31/2021 1:20 PM, Dale Alspach wrote: The run date of a report is actually quite useful. This is especially the case when multiple persons are involved with analyzing the data and making correcting entries. I work with a small charitable organization. We get reports from the bookkeeper a fe

Re: [GNC] gnucash-cli options - accounts, dates and other settings

2021-08-31 Thread Dale Alspach
The run date of a report is actually quite useful. This is especially the case when multiple persons are involved with analyzing the data and making correcting entries. I work with a small charitable organization. We get reports from the bookkeeper a few days before the meeting. I may spot somethin

Re: [GNC] gnucash-cli options - accounts, dates and other settings

2021-08-31 Thread Christopher Lam
There's no mechanism to modify report options from the command line. The gnucash-cli is meant mainly to run reports with sensible defaults (eg balance sheet) and saved reports (eg transaction report with modified options). On Tue, 31 Aug 2021, 5:53 pm flywire, wrote: > This report needs accounts

Re: [GNC] gnucash-cli options - accounts, dates and other settings

2021-08-31 Thread Michael or Penny Novack
On 8/31/2021 5:52 AM, flywire wrote: This report needs accounts and dates to be specified in Win10 and I'd like to tweak some other settings. "A datafile may be specified to describe some saved options." Where is the documentation for gnucash-cli ? Maybe missing the main point? For most reports

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-14 Thread list+gnucash
On 2021-06-12 23:49, Jim DeLaHunt wrote: …I submit that installing packages with MacPorts or Homebrew has aspects of installing application software, as well as aspects of altering the OS. Installing application software is a reasonable thing for people to do with their personal computers. I d

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-13 Thread John Ralls
> On Jun 12, 2021, at 11:49 PM, Jim DeLaHunt wrote: > > On 2021-06-12 20:49, John Ralls wrote: >> >>> On Jun 12, 2021, at 6:31 PM, Jim DeLaHunt wrote: >>> >>> On 2021-06-12 09:13, John Ralls wrote: >>> > On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: > > OK, I can understan

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-12 Thread Jim DeLaHunt
On 2021-06-12 20:49, John Ralls wrote: On Jun 12, 2021, at 6:31 PM, Jim DeLaHunt wrote: On 2021-06-12 09:13, John Ralls wrote: On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: OK, I can understand that the MacPorts installation of perl may be configured to look for perl packages in MacP

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-12 Thread Jim DeLaHunt
aHunt Sent: Sat Jun 12 21:31:41 EDT 2021 To: gnucash-user@gnucash.org Subject: Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS On 2021-06-12 09:13, John Ralls wrote: On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: OK,

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-12 Thread John Ralls
> On Jun 12, 2021, at 6:31 PM, Jim DeLaHunt wrote: > > On 2021-06-12 09:13, John Ralls wrote: > >>> On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: >>> >>> OK, I can understand that the MacPorts installation of perl may be >>> configured to look for perl packages in MacPorts locations, a

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-12 Thread D. via gnucash-user
to be a fault of Gnucash or its documentation. David Original Message From: Jim DeLaHunt Sent: Sat Jun 12 21:31:41 EDT 2021 To: gnucash-user@gnucash.org Subject: Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on mac

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-12 Thread Jim DeLaHunt
On 2021-06-12 09:13, John Ralls wrote: On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: OK, I can understand that the MacPorts installation of perl may be configured to look for perl packages in MacPorts locations, and ignore the system locations. But I don't understand wny the GUI app of G

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-12 Thread John Ralls
> On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt wrote: > > OK, I can understand that the MacPorts installation of perl may be configured > to look for perl packages in MacPorts locations, and ignore the system > locations. But I don't understand wny the GUI app of GnuCash apparently can > find

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-12 Thread Jim DeLaHunt
John: I appreciate your help. 1. The default per on my path fails gnc-fq-check: % perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check You need to install the following Perl modules:   Finance::Quote Use your system's package manager to install them, or run 'gnc-fq-update' as ro

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

2021-06-11 Thread John Ralls
Jim, Start with perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-check from Terminal to make sure that perl can find F::Q and which perl from Terminal to see what is the default perl. If gnc-fq-check fails then perl -e 'print join("\n", @INC), "\n";' will show you where perl-fro

Re: [GNC] gnucash-cli --quotes get

2021-05-27 Thread Cam Ellison
On 2021-05-27 10:50 a.m., John Ralls wrote: On May 27, 2021, at 10:35 AM, Cam Ellison wrote: On 2021-05-27 10:08 a.m., mike823 wrote: Hi Robin, I used your code to load quotes and I've noticed that when runs multiple times, it will create multiple quote records for the same day. Any way to

Re: [GNC] gnucash-cli --quotes get

2021-05-27 Thread mike823
I’m also only interested in the market closing price. The question is how will GnuCash handle multiple quotes for one day. Which one will actually be used to valuate the portfolio? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _

Re: [GNC] gnucash-cli --quotes get

2021-05-27 Thread Robin Chattopadhyay
It’s probably possible, but getting the script this far is at the far frontier of my Python abilities. Plus, for my purposes, I’m only interested in the market closing price so I only run the script once per day, Tues-Sat. I don’t need an intraday level of granularity. Cheers, Robin On Thu, May

Re: [GNC] gnucash-cli --quotes get

2021-05-27 Thread John Ralls
> On May 27, 2021, at 10:35 AM, Cam Ellison wrote: > > On 2021-05-27 10:08 a.m., mike823 wrote: >> Hi Robin, >> >> I used your code to load quotes and I've noticed that when runs multiple >> times, it will create multiple quote records for the same day. Any way to >> avoid this behavior? I me

Re: [GNC] gnucash-cli --quotes get

2021-05-27 Thread Cam Ellison
On 2021-05-27 10:08 a.m., mike823 wrote: Hi Robin, I used your code to load quotes and I've noticed that when runs multiple times, it will create multiple quote records for the same day. Any way to avoid this behavior? I mean, if you re-run it, it should just update the quote for the day, not cr

Re: [GNC] gnucash-cli --quotes get

2021-05-27 Thread mike823
Hi Robin, I used your code to load quotes and I've noticed that when runs multiple times, it will create multiple quote records for the same day. Any way to avoid this behavior? I mean, if you re-run it, it should just update the quote for the day, not create a new one. Thanks. -- Sent from: h

Re: [GNC] gnucash-cli --quotes get

2021-05-18 Thread Glenn Fowler
I have not done it myself but according to the docs you have to compile it yourself with the option enabled: https://www.gnucash.org/docs/v4/C/gnucash-guide/ch_python_bindings.html https://wiki.gnucash.org/wiki/Python_Bindings On Tue, May 18, 2021 at 11:27 AM mike823 wrote: > Are GnuCash with

Re: [GNC] gnucash-cli --quotes get

2021-05-18 Thread mike823
Is there a build for GnuCash with python bindings (binaries) available anywhere? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preference

Re: [GNC] gnucash-cli --quotes get

2021-05-18 Thread mike823
Are GnuCash with python bindings binaries available anywhere? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread mike823
Thank you. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucas

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread Robin Chattopadhyay
Here's the file; I think the attachment should pass through, the input CSV has no headers and comma separated values in order below: Example: Mnemonic, Price, Price Date (-mm-dd), Namespace, Currency Code "94986H103",62.8194,2021-05-14,"401K","USD" It works for me, in lines 10-12, you can adj

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread Jack Frillman via gnucash-user
And I wrote a Python scripts and a BASH script that scrapes the prices off of the webpage and creates csv file. On 5/17/21 5:28 PM, Robin Chattopadhyay wrote: I have a Python script that I've created that takes in a CSV file and loads the prices into Gnucash. I would be willing to share it; I k

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread mike823
I use a SQLite backend and I would love to test your script. Could you email it to me? Thanks. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscript

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread Robin Chattopadhyay
I have a Python script that I've created that takes in a CSV file and loads the prices into Gnucash. I would be willing to share it; I know it works with the SQLite backend, I haven't tested it with any other backend. Robin On Mon, May 17, 2021 at 6:59 AM mike823 wrote: > I might do it. I am lo

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread John Ralls
> On May 17, 2021, at 4:58 AM, mike823 wrote: > > I might do it. I am looking in gnucash/gnucash-cli.cpp and I see the code > bellow in Gnucash::GnucashCli::start . Is another developer already working > on the same functionality? > > > >if (m_quotes_cmd) >{ >if (*m_quotes_c

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread mike823
I might do it. I am looking in gnucash/gnucash-cli.cpp and I see the code bellow in Gnucash::GnucashCli::start . Is another developer already working on the same functionality? if (m_quotes_cmd) { if (*m_quotes_cmd != "get") { std::cerr << bl::format (bl::tran

Re: [GNC] gnucash-cli --quotes get

2021-05-16 Thread John Ralls
No, --quotes-get runs finance quote. Importing via the command line is not yet implemented and AFAIK isn't on any core developer's todo list, so you're welcome to jump in and provide a pull request. Regards, John Ralls > On May 16, 2021, at 4:10 PM, mike823 wrote: > > Can "gnucash-cli --quot