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 <[email protected] <mailto:[email protected]>> 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
[email protected] <mailto:[email protected]>
Micah 6:8
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to