Re: Online quotes fetching the wrong price
You could also, without any alphavantage stuff, obtain quotes from the "yahoo_json" source, again using NAB.AX as the symbol. Hopefully yahoo won't kill off this source, too. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@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.
Re: Online quotes fetching the wrong price
Responding to my own email... Adding ".AX" to each security "Symbol/abbreviation" for ASX stocks fixed my issue. Yahoo didn't need this suffix, but alphavantage does. Now all good! Cheers, Justin. On 8 February 2018 at 22:10, Justin Smithwrote: > 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 > wrote: > >> The ticker NAB.AX seems to work for me: >> >> ALPHAVANTAGE_API_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 >> 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. 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, AU00NAB4) >> >> 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 >> 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= 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 = (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@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@gnucash.org >> > To update your
Re: Online quotes fetching the wrong price
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 Smithwrote: 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 wrote: The ticker NAB.AX seems to work for me: ALPHAVANTAGE_API_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 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. 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, AU00NAB4) >> 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 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= 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 = (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@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@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
Re: Online quotes fetching the wrong price
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.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, > AU00NAB4) > 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 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= 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 = (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@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@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.
Re: Online quotes fetching the wrong price
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, AU00NAB4) 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 Smithwrote: > > 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= 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 = (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@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@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.
Online quotes fetching the wrong price
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= 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 = (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@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.