Online quotes fetching the wrong price

[Justin Smith]

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
>