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

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

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:

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

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

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:

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

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

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

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

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

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

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

[GNC] gnucash-cli --quotes get

2021-05-16 Thread mike823
Can "gnucash-cli --quotes get" load quotes from a file, like the import prices from CSV does? Thanks. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your