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