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