--- Begin Message ---
Package: libfinance-quote-perl
Version: 1.13-4
Severity: normal
1.13-4 broke retrieval of quotes of (some?) mutual funds (of the Dutch
market) through the yahoo_europe method. Example in case is INGBM.AS.
Here's my test code:
------ begin ----------
use Finance::Quote;
use Data::Dumper;
my $q = Finance::Quote->new();
my %data = $q->fetch('yahoo_europe', 'INGBM.AS');
#my %data = $q->fetch('yahoo_europe', 'KPN.AS');
print Dumper( {%data} );
------ end ----------
Output with 1.13-4 (with "undef" lines removed for brevity):
'INGBM.AS last' => '28.88',
'INGBM.AS name' => 'IBP ING BASIC MAT 6',
'INGBM.AS time' => ' 9:46PM',
'INGBM.AS isodate' => '2009-02-27',
'INGBM.AS open' => '28.43',
'INGBM.AS success' => 1,
'INGBM.AS volume' => '+1.58%',
'INGBM.AS price' => '28.88',
'INGBM.AS date' => '02/27/2009',
'INGBM.AS p_change' => '+0.45',
'INGBM.AS method' => 'yahoo_europe',
'INGBM.AS symbol' => 'INGBM.AS',
'INGBM.AS div_yield' => '0.00',
In particular:
- currency is undef, which makes it unusable by Gnucash
- p_change contains a net change, should contain percent
- net is undef
- volume contains what should be p_change
Output with 1.13-3 (on another machine):
'INGBM.AS net' => '+0.45',
'INGBM.AS last' => '28.88',
'INGBM.AS name' => 'IBP ING BASIC MAT 6',
'INGBM.AS time' => ' 9:46PM',
'INGBM.AS isodate' => '2009-02-27',
'INGBM.AS close' => '28.43',
'INGBM.AS price' => '28.88',
'INGBM.AS currency' => 'EUR',
'INGBM.AS date' => '02/27/2009',
'INGBM.AS p_change' => '+1.58',
'INGBM.AS method' => 'yahoo_europe',
'INGBM.AS symbol' => 'INGBM.AS',
'INGBM.AS div' => '0.00',
In particular:
- currency is now set, which saves the day for use with Gnucash
- p_change is now correct
- net is correct
But there is indeed something fishy going on with (Dutch) mutual funds
in yahoo UK finance: the yahoo CSV data is not in the same format for
stocks and for mutual funds! Mutual funds have an extra column
inserted between the third and fourth, which shifts all columns after
that one to the right. Apparently 1.13-3 had some magic so that it
still works, but 1.13-4 broke that.
A concrete example. I take a stock:
GET /d/quotes.csv?f=snl1d1t1c1p2vbapomwerr1dyj1qa2c4&e=.csv&s=KPN.AS HTTP/1.1
Host: uk.finance.yahoo.com
HTTP/1.1 200 OK
Date: Sat, 28 Feb 2009 23:28:17 GMT
Content-Type: application/vnd.ms-excel
KPN.AS,KONINKLIJKE KPN NV ,10.19,
9:46PM,02/27/2009,-0.03,-0.24%,10311130,10.19,10.20,10.22,10.15,N/A,N/A,0.77,0.77,0.35,5.39,N/A,8442941,EUR
Here, the fourth column is last trade time, and yahoo_europe method of
version 1.13-3 makes an OK, if not 100% correct job of decoding it
(e.g. div_date is supposed to contain the dividend pay date, but
contains its amount):
'KPN.AS close' => '10.22',
'KPN.AS cap' => '8442941',
'KPN.AS name' => 'KONINKLIJKE KPN NV ',
'KPN.AS success' => 1,
'KPN.AS volume' => '10311130',
'KPN.AS date' => '02/27/2009',
'KPN.AS currency_set_by_fq' => 1,
'KPN.AS net' => '-0.03',
'KPN.AS price' => '10.19',
'KPN.AS div' => '5.39',
'KPN.AS currency' => 'EUR',
'KPN.AS ask' => '10.20',
'KPN.AS open' => '10.15',
'KPN.AS pe' => '0.77',
'KPN.AS isodate' => '2009-02-27',
'KPN.AS eps' => '0.77',
'KPN.AS div_date' => '0.35',
'KPN.AS symbol' => 'KPN.AS',
'KPN.AS p_change' => '-0.24',
'KPN.AS last' => '10.19',
'KPN.AS method' => 'yahoo_europe',
'KPN.AS ex_div' => 'EUR ',
'KPN.AS time' => ' 9:46PM',
'KPN.AS bid' => '10.19'
1.13-4 gives exactly the same result.
'KPN.AS close' => '10.22',
'KPN.AS cap' => '7905630',
'KPN.AS name' => 'KONINKLIJKE KPN NV ',
'KPN.AS success' => 1,
'KPN.AS volume' => '10311130',
'KPN.AS date' => '02/27/2009',
'KPN.AS currency_set_by_fq' => 1,
'KPN.AS net' => '-0.03',
'KPN.AS price' => '10.19',
'KPN.AS div' => '3.53',
'KPN.AS currency' => 'EUR',
'KPN.AS ask' => '10.20',
'KPN.AS open' => '10.15',
'KPN.AS pe' => '0.77',
'KPN.AS isodate' => '2009-02-27',
'KPN.AS eps' => '0.77',
'KPN.AS div_date' => '0.36',
'KPN.AS symbol' => 'KPN.AS',
'KPN.AS p_change' => '-0.24',
'KPN.AS last' => '10.19',
'KPN.AS method' => 'yahoo_europe',
'KPN.AS ex_div' => 'EUR ',
'KPN.AS time' => ' 9:46PM',
'KPN.AS bid' => '10.19'
Now, if I take INGBM.AS (a mutual fund), here's the result:
GET /d/quotes.csv?f=snl1d1t1c1p2vbapomwerr1dyj1qa2c4&e=.csv&s=INGBM.AS HTTP/1.1
Host: uk.finance.yahoo.com
HTTP/1.1 200 OK
Date: Sat, 28 Feb 2009 23:28:45 GMT
Content-Type: application/vnd.ms-excel
INGBM.AS,IBP ING BASIC MAT 6,28.88,N/A,
9:46PM,02/27/2009,+0.45,+1.58%,N/A,N/A,N/A,28.43,N/A,N/A,N/A,N/A,N/A,N/A,0.00,N/A,N/A,N/A,N/A,EUR
You see? The fourth column, which contains "N/A" pushes the last trade
time & date, the net change, etc one column more to the right, and
gives the results already detailed above.
-- System Information:
Debian Release: 5.0
APT prefers unstable
APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.26-1-amd64 (SMP w/2 CPU cores)
Locale: LANG=fr_LU.UTF-8, LC_CTYPE=fr_LU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages libfinance-quote-perl depends on:
ii libcrypt-ssleay-perl 0.57-1+b1 Support for https protocol in LWP
ii libhtml-tableextract-perl 2.10-3 module for extracting the content
ii libwww-perl 5.820-1 WWW client/server library for Perl
ii perl 5.10.0-19 Larry Wall's Practical Extraction
libfinance-quote-perl recommends no packages.
libfinance-quote-perl suggests no packages.
-- no debconf information
The other machine (with 1.13-3):
ii libcrypt-ssleay-perl 0.57-1+b1
ii libhtml-tableextract-perl 2.10-3
ii libwww-perl 5.813-1
ii perl 5.10.0-19
--- End Message ---
