Quote date in gnucash different from retrieved by gnc-fq-dump

Hajo Hindriks hhn10 at gmx.net
Fri Jul 31 07:21:46 EDT 2015


Hi Gus

Would you mind sharing how you accomplished your own source? How did you 
integrate it in F::Q and how was it recognized in Gnucash? I am a new 
user and just got F::Q to work, unfortunately I have a fund that it not 
supported by any of the sources, and the supplier has a page with the 
price information, so I would like to try to write my own quote source 
as well.

Kind regards, Hajo

On 29.07.2015 13:43, Lt. Goose wrote:
> I'm getting unexpected results when updating quotes in gnucash 2.6.7
> (updated yesterday). I've written my own quote source and integrated it
> into Finance::Quote (1.37). It is recognized by gnucash so that I can
> select it from within the program and use it to retrieve quotes.
>
> However, the date returned in the quote (2015-07-29 12:00:00, as can be
> seen in debug trace messages [1]) is different from the one returned by
> Finance::Quote (2015-07-28, see gnc-fq-dump output in [2]). Detailed output
> of gnc-fq-dump can be seen in [3].
>
> Am I missing something or does gnucash use execution date to insert the
> quote value? Should date string be formatted some other way? (I mimicked
> yahoo quote return values).  Is this the way it should work?
>
> I'd appreciate any insights on this matter.
>
> Thanks in advance.
> Gus.
>
> -------
>
> [1] gnucash.trace.log output
> * 13:27:16 DEBUG <gnc.scm> handling-request: (bolsamadrid ECR.BME REE.BME)
> * 13:27:19 DEBUG <gnc.scm> results: ((ECR.BME (symbol . ECR.BME)
> (gnc:time-no-zone . 2015-07-29 12:00:00) (last . 0.73) (currency . EUR))
> (REE.BME (symbol . REE.BME) (gnc:time-no-zone . 2015-07-29 12:00:00) (last
> . 72.48) (currency . EUR)))
>
>
> [2] gnc-fq-dump output
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump bolsamadrid REE.BME
> ECR.BME
> Finance::Quote fields Gnucash uses:
>      symbol: REE.BME              <=== required
>        date: 28/07/2015           <=== required
>    currency: EUR                  <=== required
>        last: 72.4800              <=\
>         nav:                      <=== one of these
>       price: 72.4800              <=/
>    timezone:                      <=== optional
> =====
>
> Finance::Quote fields Gnucash uses:
>      symbol: ECR.BME              <=== required
>        date: 28/07/2015           <=== required
>    currency: EUR                  <=== required
>        last: 0.7300               <=\
>         nav:                      <=== one of these
>       price: 0.7300               <=/
>    timezone:                      <=== optional
>
>
> [3] gnc-fq-dump verbose output
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v bolsamadrid REE.BME
> ECR.BME
> Finance::Quote fields Gnucash uses:
>      symbol: REE.BME              <=== required
>        date: 28/07/2015           <=== required
>    currency: EUR                  <=== required
>        last: 72.4800              <=\
>         nav:                      <=== one of these
>       price: 72.4800              <=/
>    timezone:                      <=== optional
>
> All fields returned by Finance::Quote for stock REE.BME
>
> stock           field  value
> -----           -----  -----
> REE.BME      currency: EUR
> REE.BME          date: 28/07/2015
> REE.BME     day_range: 72.0400 - 72.6600
> REE.BME          high: 72.6600
> REE.BME       isodate: 2015/07/28
> REE.BME          last: 72.4800
> REE.BME           low: 72.0400
> REE.BME        method: bolsamadrid
> REE.BME          name: REE.BME
> REE.BME      p_change: 0.42
> REE.BME         price: 72.4800
> REE.BME        source: Finance::Quote::Bolsamadrid
> REE.BME       success: 1
> REE.BME        symbol: REE.BME
>
> =====
>
> Finance::Quote fields Gnucash uses:
>      symbol: ECR.BME              <=== required
>        date: 28/07/2015           <=== required
>    currency: EUR                  <=== required
>        last: 0.7300               <=\
>         nav:                      <=== one of these
>       price: 0.7300               <=/
>    timezone:                      <=== optional
>
> All fields returned by Finance::Quote for stock ECR.BME
>
> stock           field  value
> -----           -----  -----
> ECR.BME      currency: EUR
> ECR.BME          date: 28/07/2015
> ECR.BME     day_range: 0.6550 - 0.7450
> ECR.BME          high: 0.7450
> ECR.BME       isodate: 2015/07/28
> ECR.BME          last: 0.7300
> ECR.BME           low: 0.6550
> ECR.BME        method: bolsamadrid
> ECR.BME          name: ECR.BME
> ECR.BME      p_change: 9.45
> ECR.BME         price: 0.7300
> ECR.BME        source: Finance::Quote::Bolsamadrid
> ECR.BME       success: 1
> ECR.BME        symbol: ECR.BME
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



More information about the gnucash-user mailing list