Retrieving stock prices fails
Klaus Dahlke
klaus.dahlke at gmx.de
Thu Jan 15 14:34:28 EST 2009
Hi,
it seems that something is wrong with the plain 'europe' method for Yahoo whereas 'yahoo_europe' works:
$ ./stockdump.pl europe BAS.DE
Can't call method "rows" on an undefined value at /usr/lib64/perl5/vendor_perl/5
.8.8/HTML/TableExtract.pm line 224.
$ ./stockdump.pl yahoo_europe BAS.DE
$VAR1 = {
'BAS.DEday_range' => undef,
'BAS.DEeps' => '4.16',
'BAS.DEname' => 'BASF',
'BAS.DEyear_range' => undef,
'BAS.DEsymbol' => 'BAS.DE',
'BAS.DEprice' => '23.18',
'BAS.DEsuccess' => 1,
'BAS.DEdiv_yield' => '7.07',
'BAS.DElast' => '23.18',
'BAS.DEnet' => '-0.88',
'BAS.DEdiv' => '1.95',
'BAS.DEp_change' => '-3.66',
'BAS.DEtime' => '16:35',
'BAS.DEmethod' => 'yahoo_europe',
'BAS.DEcurrency' => 'EUR',
'BAS.DEbid' => '23.07',
'BAS.DEcap' => undef,
'BAS.DEisodate' => '2009-01-15',
'BAS.DEpe' => '4.16',
'BAS.DEopen' => '24.25',
'BAS.DEclose' => '24.06',
'BAS.DEdate' => '01/15/2009',
'BAS.DEvolume' => '7764135',
'BAS.DEask' => '23.14',
'BAS.DEavg_vol' => '8926500'
};
The error with 'europe' occurs because the csv-file cannot be retrieved:
http://uk.finance.yahoo.com/d/quotes.csv --> Sorry, Internal Server Error.
Cheers,
Klaus
On Wed, 14 Jan 2009 22:44:06 -0700
Trevor Farlow <trevor.farlow at gmail.com> wrote:
> Have you tried other pricing sources besides the two Europe entries, Julius?
>
> I have been having consistent retrieval failure for the last few months
> using the sources Single: Yahoo or Multiple: USA (Yahoo, Fool ...) with
> the error: "Unable to retrieve quotes for these items:" followed by all
> my securities. In response to this thread I tried the Single: Europe
> source and it fetched prices. Notably, however, the source Multiple:
> Europe (Yahoo...) fails with the same error as above.
>
> gnc-fq-dump yahoo_europe INL.F gives the same successful output as David's.
>
> I'm running a build of r17773 configured with --enable-aqbanking
> --enable-hbci. (Price retrieval began failing consistently (same error)
> some months ago with the Ubuntu packages, so I compiled from source to
> ensure the flaw was not in the distribution.)
>
> I'm still interested in getting USA sources working - are all currently
> included pricing sources verified as working?
>
>
> David Reiser wrote:
> > Oops. One more thing, INL.F goes in the Symbol/Abbreviation field. The
> > Symbol field contents are what GnuCash feeds to finance::quote for
> > retrieval.
> >
> > I don't think the contents of the ISIN field matter at the moment.
> >
> > Dave
> > On Jan 14, 2009, at 11:01 PM, David Reiser wrote:
> >
> >
> >> works for me:
> >>
> >> $gnc-fq-dump yahoo_europe INL.F
> >> Finance::Quote fields Gnucash uses:
> >> symbol: INL.F <=== required
> >> date: 01/14/2009 <=== required
> >> currency: EUR <=== required
> >> last: 9.97 <=\
> >> nav: <=== one of these
> >> price: 9.97 <=/
> >> timezone: <=== optional
> >>
> >> On Jan 14, 2009, at 10:41 PM, Julius wrote:
> >>
> >>
> >>> Hi,
> >>>
> >>> gnucash is unable to update stock prices for intel (INL.F), unknown
> >>> error.
> >>>
> >>> Versions:
> >>> gnucash-2.2.7
> >>> Finance::Quote 1.15
> >>>
> >>> this works:
> >>> perl stockdump.pl -c EUR YAHOO INL.F
> >>> returns prices and other information
> >>>
> >>>
> >>> in new security i added:
> >>>
> >>> Full name: Intel
> >>> Symbol... : Intel
> >>> Type: Eurex
> >>> ISIN: INL.F
> >>> Fraction: default
> >>>
> >>> Get Online Quotes:
> >>> ive tried
> >>> Single: Yahoo Europe
> >>> and
> >>> Multiple: Europe (Yahoo)
> >>>
> >>> both failed, any ideas?
> >>>
> >>> greets
> >>>
> _______________________________________________
> 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