Quote date in gnucash different from retrieved by gnc-fq-dump
Chris Good
chris.good at ozemail.com.au
Sun Aug 2 20:19:04 EDT 2015
> -----Original Message-----
> From: John Ralls [mailto:jralls at ceridwen.us]
> Sent: Monday, 3 August 2015 1:03 AM
> To: Chris Good <chris.good at ozemail.com.au>
> Cc: gnucash-user at gnucash.org
> Subject: Re: Quote date in gnucash different from retrieved by gnc-fq-dump
>
>
> > On Aug 2, 2015, at 2:24 AM, Chris Good < <mailto:chris.good at ozemail.com.au> chris.good at ozemail.com.au>
> wrote:
> >
> >
> > Hi John,
> >
> > I don't know if this is relevant...
> >
> > I just tested your new gnc-fq-helper (committed 27 July 2015).
> > Here is old 2.6.7 :
> >
> > echo (yahoo "AMZN") | perl -w gnc-fq-helper (("AMZN" (symbol .
> "AMZN")
> > (gnc:time-no-zone . "2015-07-31 16:00:00") (last . 536.15) (currency .
> > "USD")))
> >
> > Here is the new :
> > echo (yahoo "AMZN") | perl -w gnc-fq-helper (("AMZN" (symbol .
> "AMZN")
> > (gnc:time-no-zone . 2015-07-31 16:00:00) (last .
> > 536.15) (currency . "USD")))
> >
> > Note missing double quotes around datetime.
> >
> > When I run Get Quotes from GC with new : There was an unknown error
> > while retrieving the price quotes.
> >
> > Also, now that Lt. Goose mentions it,
> > yahoo_australia does return a date and time which in this case seems
> > to be when the stock exchange closed on Friday arvo, but the dates
> > loaded into the GC price table are the current local date when Get
> > Quotes was run. It has always done this in my experience.
> >
> > Shouldn't GC use the date returned by FinanceQuote?
> >
>
> Chris,
>
> Ah, good catch and easy to fix.
>
> How is Yahoo Australia formatting the date? Better yet, what’s a symbol that
> I can test with it?
>
>
> Regards,
> John Ralls
Hi John,
You can use symbols CBA or BOQ to test with.
For me:
E:\Program Files (x86)\gnucash\bin>echo (yahoo "CBA") | perl -w gnc-fq-helper
(("CBA" (symbol . "CBA") (gnc:time-no-zone . "2015-07-31 16:00:00") (last . 13.04) (currency . "USD")))
E:\Program Files (x86)\gnucash\bin>echo (yahoo_australia "CBA") | perl -w gnc-fq-helper
(("CBA" (symbol . "CBA.AX") (gnc:time-no-zone . "2015-07-31 16:11:00") (last . 87.56) (currency . "AUD")))
E:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v yahoo_australia CBA
Finance::Quote fields Gnucash uses:
symbol: CBA.AX <=== required
date: 07/31/2015 <=== required
currency: AUD <=== required
last: 87.56 <=\
nav: <=== one of these
price: 87.56 <=/
timezone: <=== optional
All fields returned by Finance::Quote for stock CBA
stock field value
----- ----- -----
CBA ask: 80.56
CBA avg_vol: 3033280
CBA bid: 91.93
CBA cap: 141530000000
CBA close: 87.08
CBA currency: AUD
CBA date: 07/31/2015
CBA day_range: 87.11 - 87.78
CBA div:
CBA div_date:
CBA div_yield:
CBA eps: 5.32
CBA ex_div: 2/17/2015
CBA exchange: Australian Stock Exchange
CBA high: 87.78
CBA isodate: 2015-07-31
CBA last: 87.56
CBA low: 87.11
CBA method: yahoo_australia
CBA name: CWLTH BANK FPO
CBA net: +0.48
CBA open: 87.56
CBA p_change: +0.55
CBA pe: 16.47
CBA price: 87.56
CBA success: 1
CBA symbol: CBA.AX
CBA time: 16:11
CBA volume: 6754751
CBA year_range: 73.57 - 96.69
Regards,
Chris Good
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4821 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150803/c33f3ed6/attachment.p7s>
More information about the gnucash-user
mailing list