Problems getting quotes for funds

Fred Bone Fred.Bone at dial.pipex.com
Fri Feb 22 04:49:44 EST 2008


[reposting, *with* the attachment this time]

On 14 February 2008 at 22:54, David Reiser said:

> If you can find the folder containing the finance-quote modules, you 
> could apply the attached patch, and it should work as long as you  don't
> have any quote retrievals pointed at Yahoo USA (Yahoo Asia and  Australia
> might also be a problem -- I haven't tested). On my mac  they're in a
> folder something like:  perl5/5.8.8/Finance/Quote/Yahoo/ Base.pm and
> Europe.pm. There are only 3 changes, so you could hand  edit pretty easily
> too. Then use the isin+country code for the ticker.

I tried the suggested solution, but it doesn't do the trick for me. I 
asked for a share and a fund, both quoted on LSE.

The command
 perl gnc-fq-dump yahoo_europe TOMK.L GB0033031260GBP
returns

Finance::Quote fields Gnucash uses:
    symbol: TOMK.L               <=== required
      date: 02/22/2008           <=== required
  currency: GBP                  <=== required
      last: 1.8775               <=\
       nav:                      <=== one of these
     price: 1.8775               <=/
  timezone:                      <=== optional
=====

Finance::Quote fields Gnucash uses:
    symbol: GB0033031260GBP      <=== required
      date: 02/21/2008           <=== required
  currency: GBP                  <=== required
      last: 1705.64              <=\
       nav:                      <=== one of these
     price: 1705.64              <=/
  timezone:                      <=== optional

which looks good. However, Price Editor can't process the second of 
these. It doesn't return any error (which it will do if, for example, I 
change the symbol to something random); it just appears to ignore the 
information returned.

Using my browser to issue the same command that Gnucash issues (results 
attached), I see that the data returned differs - and the number of 
fields returned for the share is two less than the number requested. I'm 
not sure whether this matters.

The *only* prices returned for the fund are those that end up in the 
fields captioned "last" and "close" - the others come back as "N/A". I'm 
wondering whether the Price Editor is preferring one of the others but 
the gnc-fq-dump code doesn't know about this.

-------------- next part --------------
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  quotes10.xls
     Date:  22 Feb 2008, 8:35
     Size:  287 bytes.
     Type:  Excel-sheet
-------------- next part --------------
A non-text attachment was scrubbed...
Name: quotes10.xls
Type: application/octet-stream
Size: 287 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20080222/badb3b5d/attachment.obj 


More information about the gnucash-user mailing list