Re: Online quotes fetching the wrong price

2018-02-08 Thread farleykj 
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

2018-02-08 Thread Justin Smith 
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 Smith  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 
> 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

2018-02-08 Thread Derek Atkins 
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  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 
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

2018-02-08 Thread Justin Smith 
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

2018-02-08 Thread David T. via gnucash-user 
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.

Online quotes fetching the wrong price

2018-02-07 Thread Justin Smith 
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.