Finance-Quote 1.42 released!

brad bradhaack at fastmail.us
Tue Nov 7 11:46:36 EST 2017


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, ? ?? <jctchen at 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:eco at ecocode.net]
>> Sent: Tuesday, November 7, 2017 2:46 PM
>> To: ? ?? <jctchen at outlook.com
>> Cc: Gnucash-User <gnucash-user at gnucash.org
>> Subject: Re: Finance-Quote 1.42 released!
>>
>>
>> ? ?? <jctchen at 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 at 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 at 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.



More information about the gnucash-user mailing list