Exchange rate feeds

[sgpratley]

I'm building a site which has some USD and EUR prices included in it and want to show an indication of the current price in GBP.

I've figured out a script that uses the following XML file of rates vs the Euro. supplied by the European Central Bank
http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml

I can use this for Euros, and I could quite easily do 2 conversions to get the USD prices into GBP, but does anyone know of a service that provides this in relation to GBP to start with?

I've seen some osCommerce scripts that reference Oanda.com but that looks like it costs about $1,000 per month?

[JonDeals]

I use

Exchange Rates: U.K. Pound Sterling

on a couple of sites. It's free and it works well (updated every 20 mins) - the only thing is you have to do a little preg_match to get the rate from the xml item title as it's not in the most friendly format.

PHP Code:

if(!$xml = simplexml_load_file('http://currencysource.ez-cdn.com/GBP.xml')){
    trigger_error('Error reading XML file',E_USER_ERROR);
}

$rss = $xml->channel;

foreach($rss->item as $item){

preg_match('/1 GBP \= ([A-Z]+) \(([0-9\.\,]+)\)$/',$item->title,$matches);

if ($matches[1] != "") {
//Do whatever you want with the code here (insert rates into database etc)
// $matches[1] is the currency code (EUR, USD) etc
// $matches[2] is the rate in comparison to UK £
}

} 


Hope that helps.

[sgpratley]

Thanks Jon, looks perfect

Thanks for the detail in the code also, saved me a good while figuring it out!