[GNC] Price update not working

[Geoff]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gnc_alphavantage_timing.jpg
Type: image/jpeg
Size: 72547 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20221008/21850053/attachment-0001.jpg>