[GNC] Price update not working
Geoff
cleanoutmyshed at gmail.com
Mon Oct 10 01:00:40 EDT 2022
Hmmmm I think I may have just about run out of ideas.
If the GUI is just as slow as the CLI we have ruled that variable out.
Perhaps you could try using "Yahoo as JSON" as the Quote Source in the
Securities Editor. It won't take you very long to swap over your 18
securities, and this will eliminate Alpha Vantage as the cause, although
if gnc-fq-dump is fast then this is unlikely to make a difference.
As a last resort, you can try running GnuCash in debug mode and see if
anything useful emerges. I don't know how to do this, but Google is
probably your friend.
Good luck!
Geoff
=====
On 10/10/2022 3:48 pm, R Losey wrote:
> I'm not fetching that many -- maybe around 18 or so (I didn't count). In
> the "old" days from the GUI, it would only take seconds (that was
> pre-Alpha Vantage)
>
> I'm not sure how busy their servers are... but when I run the
> gnc-fq-dump program using Alpha Vantage and getting four quotes, it
> returns in 1-2 seconds. I ran the full gnucash-cli program using "time",
> and it shows over 7 minutes to complete.
>
> I doubt very much that my ISP is throttling me... I'm running Linux
> (Ubuntu) and it is mostly idle.
>
> Now the data file may be an idea... it's about 1.5M... it's on a NAS, so
> it has to go through the home network, so that is slower... and I don't
> know how much parsing the gnucash-cli program has to do.
>
> The GnuCash GUI is also very, very slow using "multiple" (which uses
> Alpha Vantage first). I didn't time it, but it was minutes.
>
> I don't think this is network, but it may be... nothing else seems to be
> slow... and the gnc-fq-dump is very fast.
>
>
>
> On Sat, Oct 8, 2022 at 5:11 AM Geoff <cleanoutmyshed at gmail.com
> <mailto:cleanoutmyshed at gmail.com>> wrote:
>
> Hi Richard
>
> Glad to hear you can now fetch prices.
>
> > It is supposed to take so long? There is a long (7 minute) delay
> before
> > the update finishes... I've been using the gnucash-cli command line.
>
> That does seem a long time, but how long is a piece of string? (as my
> father used to say ;--)
>
> How many prices are you fetching?
> How busy are Alpha Vantage's servers?
> Are Alpha Vantage throttling you?
> Is your ISP throttling you?
> How fast, and how busy, is your machine?
> How long does it take to fetch a single price manually from the command
> line?
> How long does it take to open and save your GnuCash data file?
> Have you tried using the GnuCash GUI instead of the gnucash-cli command
> line?
>
>
> As a benchmark, my 13 year old Windows 10 desktop consistently
> retrieves
> prices for 30 odd securities in about 3 seconds using the GnuCash GUI,
> but in my case Finance Quote pulls them directly from the local stock
> exchange and doesn't use Alpha Vantage.
>
> I did a few command line tests for a single security using Alpha
> Vantage
> and it averages around 2.2 seconds from the other side of the world -
> see attached screenshot.
> [Technically it is slightly quicker than this which includes invoking
> the Python interpreter to measure the elapsed time.]
>
> Perhaps others on this list who do use Alpha Vantage can relate their
> own experiences?
>
> Finally, if you do know your way around Linux, Wire Shark is your go to
> friend for network troubleshooting:
> https://www.wireshark.org/ <https://www.wireshark.org/>
>
>
> Good luck!
>
> Regards
>
> Geoff
> =====
>
>
> On 8/10/2022 6:29 pm, R Losey wrote:
> > Hi... yes, I did not have al ALPHAVANTAGE_API_KEY and that was the
> > issue. Things now seem to be updating properly.
> >
> > It is supposed to take so long? There is a long (7 minute) delay
> before
> > the update finishes... I've been using the gnucash-cli command line.
> >
> > On Sat, Oct 8, 2022 at 1:03 AM Geoff <cleanoutmyshed at gmail.com
> <mailto:cleanoutmyshed at gmail.com>
> > <mailto:cleanoutmyshed at gmail.com
> <mailto:cleanoutmyshed at gmail.com>>> wrote:
> >
> > Hi Richard
> >
> > If you have configured your GnuCash securities to retrieve
> their prices
> > using AlphaVantage then you need to make sure that you have
> entered
> > your
> > API Key in GnuCash preferences.
> >
> > Also, depending on the problem, it may help if you upgrade to
> a later
> > version of of Finance Quote:-
> >
> >
> https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2 <https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2> <https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2 <https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2>>
> >
> https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz <https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz> <https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz <https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz>>
> >
> > Hope this helps.
> >
> > Regards
> >
> > Geoff
> > =====
> >
> >
> > On 8/10/2022 4:58 pm, R Losey wrote:
> > > I just installed GnuCash on Ubuntu 22.04LTS (it is version 4.8
> > from the
> > > Ubuntu Software area).
> > >
> > > On a different Ubuntu, I had an older version running, and
> back
> > then, price
> > > updates were working. I managed to mess up that gnucash Linux
> > install, so I
> > > haven't been updating quotes - I've been using GnuCash on
> other
> > operating
> > > systems, and since it is a pain to get the quotes working
> on them, I
> > > haven't bothered.
> > >
> > > But now that I have a nice shiny Ubuntu, I have installed
> gnucash and
> > > thought I'd attempt to update prices. I merely get :
> > >
> > > "ERROR <gnc.scm> There was an unknown error while
> retrieving the
> > price
> > >> quotes."
> > >
> > >
> > > I have Finance::Quote version 1.51 - it was installed
> along with
> > GnuCash 4.8
> > >
> > > Notes:
> > > - The reason I mentioned running updates some time ago (pre
> > version 4.0, I
> > > think) is that perhaps I need to do something in the
> securities
> > editor? I
> > > think that I no longer own some of securities tagged to get
> > updates, but I
> > > wouldn't think that would be a problem...
> > >
> > > - I remember reading something about ALPHAVANTAGE_API_KEY
> - the
> > debug text
> > > prints it as empty (for what that's worth)
> > >
> >
> >
> >
> > --
> > _________________________________
> > Richard Losey
> > rlosey at gmail.com <mailto:rlosey at gmail.com>
> <mailto:rlosey at gmail.com <mailto:rlosey at gmail.com>>
> > Micah 6:8
>
>
>
> --
> _________________________________
> Richard Losey
> rlosey at gmail.com <mailto:rlosey at gmail.com>
> Micah 6:8
More information about the gnucash-user
mailing list