On 13 June 2009 at 09:58, Henry Bremridge wrote:
| On Fri, Jun 12, 2009 at 06:19:14AM -0500, Dirk Eddelbuettel wrote:
| > |
| > | Oddly enough I received the following error messages
| > |
| > | Use of uninitialized value $b[2] in join or string at
/usr/share/perl5/Finance/YahooQuote.pm line 88.
| > | Ignoring symbol ^XCV with unparseable date
| > | Ignoring symbol ^XEU with unparseable date
| >
| > Yes, that is the 'Yahoo for daily data problem'. The code I have here has a
| > an alternative to Yahoo! for _historical_ data, which is different (as it
| > applies to 'fxbackpopulate' only.
| >
| > We can the --ubcfx option which uses the service at the Univ of British
| > Columbia in Vancouver. So also try
| >
| > beancounter --ubcfx --extrafx SEK update
| >
| Using ubcfx does not alter the warnings. I have now added two more
| currencies: GBP and HKD. They did not work. (eg No luck with symbol ^XBX)
That is because UBC so far only had 'experimental' status and is used _along_
with Yahoo. Yahoo generates the warning. So we need to suppress Yahoo.
Easy enough to test. In beancounter, around line 860, we define what
'update' does as
sub portfolio_update {
my $res = shift;
UpdateFXviaUBC($dbh, $res) if $Config{fxupdate} and $Config{ubcfx};
UpdateFXDatabase($dbh, $res) if $Config{fxupdate}; # update FX db
UpdateDatabase($dbh, $res) if $Config{equityupdate};
}
Here UpdateFXDatabase() is the default via Yahoo. So we want this instead:
sub portfolio_update {
my $res = shift;
if ($Config{fxupdate}) {
if ($Config{ubcfx}) {
UpdateFXviaUBC($dbh, $res);
} else {
UpdateFXDatabase($dbh, $res);
}
}
UpdateDatabase($dbh, $res) if $Config{equityupdate};
}
Let's try that for a few days. I also made the change here.
| > | I will come back to you on this as I want to check my data first: it
| > | could be due to sloppy entering of data.
| >
| > Ok. Yahoo! does create warnings. We may need to think about a new source
for FX.
| >
|
| Checked dates, all seem ok
|
| In terms of other sites: I currently find www.oanda.com very nice but a
| pain, came across
|
| http://www.x-rates.com/developers.html
That's a no as per
Fetching data with tools such as PHP, LWP, Java and Microsoft controls
for example are not permitted, as they cost this site bandwidth and do
not fulfill our advertising obligations.
| http://www.imf.org/external/np/fin/ert/GUI/Pages/CountryDataBase.aspx
That looks more promising.
Dirk
--
Three out of two people have difficulties with fractions.
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
