[GNC] Price update not working

R Losey rlosey at gmail.com
Mon Oct 10 00:48:34 EDT 2022


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> 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/
>
>
> 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>> 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://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>
> > Micah 6:8



-- 
_________________________________
Richard Losey
rlosey at gmail.com
Micah 6:8


More information about the gnucash-user mailing list