The alphavantage module in Finance::Quote throttles the requests to comply with AlphaVantage's limit. Most stocks and funds supported by AlphaVantage are also available from yahoo_json, but currency exchange rates are not. For non-US exchanges the symbols might be different so check on finance.yahoo.com <http://finance.yahoo.com/> when switching sources. Yahoo_json isn't throttled.
Note that most of the other sources rely on screen-scraping and are therefore a bit brittle in the face of layout changes to the source's websites. Regards, John Ralls > On Oct 10, 2022, at 1:43 AM, Ismael Smajli <ism...@smajli.org> wrote: > > Hello Alpha Vantage's standard API usage is limited to five (5) API requests > per one (1) minute (https://www.alphavantage.co/premium/) My GnuCash (4.12) > Price Database lists 22 securities and it takes FINANCE::QUOTE (1.53) > slightly above 5min for the update. Regards Ismael On 2022-10-10 12:50, R > Losey <rlo...@gmail.com> 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... an d > > 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 > <cleanoutmys...@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 co > > mmand > > 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 .w > > ireshark.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 > <cleanoutmys...@gmail.com > > > <mailto:cleanoutmys...@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.c om > > /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 at > > tempt 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 > > > rlo...@gmail.com <mailto:rlo...@gmail.com> > > > Micah 6:8 > > > > > -- > _________________________________ > Richard Losey > rlo...@gmail.com > > Micah 6: 8 > >> _______________________________________________ > gnucash-user mailing list >> > gnucash-user@gnucash.org > 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. > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > 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. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org 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.
