Online quotes fetching latest stock price but incorrect date; currency exchange rate also not working

John Ralls jralls at ceridwen.us
Sat Feb 17 23:03:58 EST 2018


And by “operating system’s time zone is correct” he means “in Australia” (or Asia somewhere), because if you’re in America then the closing price really is from the 15th.

Regards,
John Ralls

> On Feb 17, 2018, at 7:32 PM, Ronal B Morse <ron at morsehouse.com> wrote:
> 
> I guess the first step is to verify that the system time and date is correct and the operating system's time zone setting is correct.
> 
> RBM
> 
> 
> 
> On 02/17/2018 07:10 PM, Justin Smith wrote:
>> Hi,
>> 
>> Gnucash is not updating stock quotes correctly for me. The stock price is
>> correct but an incorrect date is used.
>> 
>> This is confirmed when testing using gnc-fq-dump. E.g.
>> 
>> ALPHAVANTAGE_API_KEY=<mykey> gnc-fq-dump alphavantage NAB.AX
>> Finance::Quote fields Gnucash uses:
>>     symbol: NAB.AX               <=== required
>>       date: 02/15/2018           <=== recommended
>>   currency: AUD                  <=== required
>>       last: 29.2200              <=\
>>        nav:                      <=== one of these
>>      price:                      <=/
>>   timezone:                      <=== optional
>> 
>> Today's date is Feb 18. The price is actually the closing price for last
>> Fri 16 Feb.
>> 
>> Gnucash then overwrites the historical price for Feb 15, with the price for
>> Feb 16.
>> 
>> This happens for all my ASX stocks.
>> 
>> At the same time, Gnucash is also consistently returning the error "Unable
>> to retrieve quotes for these items: CURRENCY:USD". This sounds unrelated if
>> it wasn't for the fact that it started happening at the same time as the
>> above date issue...
>> 
>> I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (PPA). And Finance::Quote
>> 1.48 (installed from git).
>> 
>> Any ideas?
>> 
>> 
>> Thanks,
>> Justin.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> 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