Finance-Quote 1.42 released!

[Russell Mercer]

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 <bradhaack at 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, ? ?? <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.
>>
>
> _______________________________________________
> 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.
>