I just saw another thread on the email list with a link to the finance quote dev list. It looks like the issue with retrieving quotes is probably not due to a problem on Windows, or how it is installed, but limitations on the Alphavantage API with how it handles requests. This limitation is then causing the f:q server to max out on requests.
Given that we are only 6 days on from the apocalypse, some patience is likely in order to give the f:q devs time to get a handle on this. Here is the link to the discussion board for anyone interested: https://sourceforge.net/p/finance-quote/discussion/12832/thread/af96314b/?limit=25#feb4/b8ce On Tue, Nov 7, 2017 at 8:46 AM, brad <bradha...@fastmail.us> wrote: > I got the system error in gnucash yesterday too, with FQ 1.40. I'm not > getting that error right now, but not getting the quotes either. I've > updated to 1.43 > > Running the identical gnc-fq-dump cmd, sometimes gives an error & > sometimes works > > gnc-fq-dump -v alphavantage IWD > --- snip non useful bits ... > > All fields returned by Finance::Quote for stock IWD > > stock field value > ----- ----- ----- > IWD errormsg: Invalid API call. Please retry or visit the > documentation (https://www.alphavantage.co/documentation/) for > TIME_SERIES_DAILY. > ... > > just a few seconds later it works > > gnc-fq-dump -v alphavantage IWD > Finance::Quote fields Gnucash uses: > symbol: IWD <=== required > date: 11/06/2017 <=== required > currency: USD <=== required > last: 120.0700 <=\ > nav: <=== one of these > price: <=/ > timezone: <=== optional > > All fields returned by Finance::Quote for stock IWD > > stock field value > ----- ----- ----- > IWD close: 120.0700 > IWD currency: USD > IWD date: 11/06/2017 > IWD high: 120.1400 > IWD isodate: 2017-11-06 > IWD last: 120.0700 > IWD low: 119.7800 > IWD method: alphavantage > IWD open: 119.9200 > IWD success: 1 > IWD symbol: IWD > IWD volume: 1235771 > > > On 11/07/2017 09:19 AM, Russell Mercer wrote: > >> I would like to echo the same result that jctchen is having. I installed >> the new version of finance quote after adding the API key, then set the >> source to Unknown/alphavantage, which is how it shows on Windows. >> >> I receive the same error when I hit the Get Quotes button. It took >> probably 20 seconds before it returned this error. >> >> Not sure if there is a place to find a log for it, but if anyone has >> pointers in that regard, I would be happy to post it. >> >> Thanks for your efforts so far, they are much appreciated. >> >> Russell >> >> On Nov 7, 2017, 05:00 -0800, ? ?? <jctc...@outlook.com>, wrote: >> >>> Thank you, Erik. >>> >>> I've updated F-Q to 1.43 successfully. >>> And, >>> Got an API Key from AlphaVantage, set it in Windows Environment Variable. >>> Changed the GnuCash online quote source to Other/alphavantage in >>> Security Editor. >>> >>> But I still got error message (something like "System error when getting >>> quote") when I updated the security prices. >>> All share prices remained unchanged. >>> >>> BTW, I use multiple currencies. New F-Q will work well with update of >>> currency exchange rate? >>> >>> Thank you, jctchen >>> >>> -----Original Message----- >>> From: Erik Colson [mailto:e...@ecocode.net] >>> Sent: Tuesday, November 7, 2017 2:46 PM >>> To: ? ?? <jctc...@outlook.com >>> Cc: Gnucash-User <gnucash-user@gnucash.org >>> Subject: Re: Finance-Quote 1.42 released! >>> >>> >>> ? ?? <jctc...@outlook.com> writes: >>> >>> Error reading 'C:\strawberry\cpan\FTPstats.yml': Alert: While trying >>>> to 'parse' YAML file 'C:\strawberry\cpan\FTPstats.yml' >>>> .. >>>> Stashing away as 'C:\strawberry\cpan\FTPstats.yml.1510022664' to >>>> prevent further interruptions. You may want to remove that file later. >>>> Could not rename: Permission denied >>>> >>> I'm by no means a Windows expert, but I would try manually removeing >>> FTPstats.yml and restart the installation. >>> >>> best >>> -- >>> erik colson >>> _______________________________________________ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> 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 >> 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 > 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 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.
