Online quotes fetching the wrong price

Derek Atkins derek at ihtfp.com
Thu Feb 8 09:17:06 EST 2018


No, the namespace has no meaning to gnucash. It's purely for human 
organization.  Change the stock code.

-derek
Sent using my mobile device. Please excuse any typos.



On February 8, 2018 9:10:53 AM Justin Smith <justin at smithpolglase.com> wrote:

> Thanks - that works for me too...
>
> So how do configure gnucash to use NAB.AX instead of NAB?
>
> I would have thought that setting the security type to "ASX" would have
> done that...
>
> Cheers,
> Justin.
>
>
> On 8 February 2018 at 21:20, Anthony Hepple <anthony at dhdevelopment.co.uk>
> wrote:
>
>> The ticker NAB.AX seems to work for me:
>>
>> ALPHAVANTAGE_API_KEY=<key> gnc-fq-dump alphavantage NAB.AX
>> Finance::Quote fields Gnucash uses:
>>     symbol: NAB.AX               <=== required
>>       date: 02/07/2018           <=== required
>>   currency: AUD                  <=== required
>>       last: 28.9000              <=\
>>        nav:                      <=== one of these
>>      price:                      <=/
>>   timezone:                      <=== optional
>>
>> On 8 February 2018 at 13:09, Justin Smith <justin at smithpolglase.com>
>> wrote:
>> > Hi David,
>> >
>> > Thanks for your email - it's interesting that it's not just me. I was
>> > hoping the issue was my configuration...
>> >
>> > You ask about NAB and Mar 13 but I have this same problem ("random" USD
>> > quotes) with *all* my ASX stocks (20+).
>> >
>> > Cheers,
>> > Justin.
>> >
>> >
>> > On 8 February 2018 at 21:01, David T. <sunfish62 at yahoo.com> wrote:
>> >
>> >> Justin,
>> >>
>> >> I see the same command line result. I will note that the date listed
>> there
>> >> is for 2017 (mine is the same), which suggests something is out of
>> whack.
>> >> Looking online, I see that NAB was at 33.14 on 03/13/2017, so that
>> doesn’t
>> >> work. I’ve tried various versions of the exchange (ASX, ASE, AX, all of
>> >> which appear out on the web) and the symbol (both the ticker, and the
>> ISIN, AU000000NAB4)
>> >> without success.
>> >>
>> >> Usually, when I see an old date, it means that the symbol ceased trading
>> >> for one reason or another (e.g., a merger or a company purchase), which
>> >> leaves the ticker “stuck” on the last day of existence. That isn’t the
>> case
>> >> here; was there anything funny that happened last March 13 for NAB?
>> >>
>> >> Sorry I can’t be of help. Maybe someone else has better chops.
>> >>
>> >> David
>> >>
>> >> On Feb 7, 2018, at 7:50 PM, Justin Smith <justin at smithpolglase.com>
>> wrote:
>> >>
>> >> Hi,
>> >>
>> >> I use gnc to track my stock portfolio of mostly Australian ASX stocks.
>> >> After yahoo closed their quoting service I set up alphavantage as per
>> the
>> >> instructions in the gnc FAQ (with key etc).
>> >>
>> >> I've just noticed that the online quotes for *all* my ASX stocks are
>> now in
>> >> USD, and that they are meaningless values too (i.e. not the ASX stock in
>> >> USD).
>> >>
>> >> This is confirmed when testing using gnc-fq-dump. E.g.
>> >>
>> >> ALPHAVANTAGE_API_KEY=<mykey> gnc-fq-dump alphavantage NAB
>> >> Finance::Quote fields Gnucash uses:
>> >>    symbol: NAB                  <=== required
>> >>      date: 03/13/2017           <=== recommended
>> >>  currency: USD                  <=== required
>> >>      last: 1.0800               <=\
>> >>       nav:                      <=== one of these
>> >>     price:                      <=/
>> >>  timezone:                      <=== optional
>> >>
>> >> The price of $1.08 USD is what gnc fetches today.
>> >>
>> >> The correct quote for ASX.NAB is around $28.24 AUD (or around $22.18
>> USD).
>> >>
>> >> A quick search didn't even find a NYSE or NASDAQ NAB so I have no idea
>> >> where F::Q is getting this quote from.
>> >>
>> >> Also I don't know why the date returned by gnc-fq-dump is 3/13/2017.
>> Very
>> >> odd.
>> >>
>> >> How does gnc-fq-dump determine the stock type? (e.g. ASX or NYSE)
>> >>
>> >> For all my ASX stocks, in the Security Editor, I have the following
>> >> settings:
>> >> * Type = ASX
>> >> * ISIN/CUSIP = <blank> (is that a problem?)
>> >> * Get Online Quotes is ticked
>> >> * Type of Quote = Unknown/alphavantage
>> >>
>> >> I am running GnuCash 2.6.17 on Ubuntu 17.04 Zesty (yes, end of life).
>> >> And Finance::Quote 1.48 (installed from git).
>> >>
>> >> Any clues?
>> >>
>> >>
>> >> Cheers,
>> >> 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.
>>
>>
>>
>> --
>> Anthony Hepple
>> 01704 227828 / 07931 504049
>> http://www.dhdevelopment.co.uk
>>
> _______________________________________________
> 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