Navigation Path: Home > Statistics > Exchange rates > Euro foreign exchange reference rates
The reference rates are usually updated by 3 p.m. C.E.T. They are based on a regular daily concertation procedure between central banks across Europe and worldwide, which normally takes place at 2.15 p.m. CET.
For further information, please refer to the ECB press release: Additional reference exchange rates for the euro, 3 December 2010.
The reference exchange rates are published both by electronic market information providers and on the ECB's website shortly after the concertation procedure has been completed. Reference rates are published according to the same calendar as the TARGET system.
<?php
//This is a PHP(4/5) script example on how eurofxref-daily.xml can be parsed
//Read eurofxref-daily.xml file in memory
//For this command you will need the config option allow_url_fopen=On (default)
$XMLContent=file("http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml");
//the file is updated daily between 2.15 p.m. and 3.00 p.m. CET
foreach($XMLContent as $line){
if(preg_match("/currency='([[:alpha:]]+)'/",$line,$currencyCode)){
if(preg_match("/rate='([[:graph:]]+)'/",$line,$rate)){
//Output the value of 1EUR for a currency code
echo'1€='.$rate[1].' '.$currencyCode[1].'<br/>';
//--------------------------------------------------
//Here you can add your code for inserting
//$rate[1] and $currencyCode[1] into your database
//--------------------------------------------------
}
}
}
?>
<?php
function StartElement($parser, $name, $attrs) {
if (!empty($attrs['RATE'])) {
echo "1€=".$attrs['RATE']." ".$attrs['CURRENCY']."<br />";
}
}
$xml_parser= xml_parser_create();
xml_set_element_handler($xml_parser, "StartElement", "");
// for the following command you will need file_get_contents (PHP >= 4.3.0)
// and the config option allow_url_fopen=On (default)
xml_parse($xml_parser, file_get_contents ("http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml"));
xml_parser_free($xml_parser);
?>
<?php
//This is aPHP(5)script example on how eurofxref-daily.xml can be parsed
//Read eurofxref-daily.xml file in memory
//For the next command you will need the config option allow_url_fopen=On (default)
$XML=simplexml_load_file("http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml");
//the file is updated daily between 2.15 p.m. and 3.00 p.m. CET
foreach($XML->Cube->Cube->Cube as $rate){
//Output the value of 1EUR for a currency code
echo '1€='.$rate["rate"].' '.$rate["currency"].'<br/>';
//--------------------------------------------------
//Here you can add your code for inserting
//$rate["rate"] and $rate["currency"] into your database
//--------------------------------------------------
}
?>
1€=1.2888 USD
1€=131.07 JPY
1€=1.9558 BGN
1€=26.094 CZK
1€=7.4541 DKK
1€=0.85515 GBP
1€=292.18 HUF
1€=3.4528 LTL
1€=0.7005 LVL
1€=4.2092 PLN
1€=4.3655 RON
1€=8.5943 SEK
1€=1.2486 CHF
1€=7.5340 NOK
1€=7.5765 HRK
1€=40.4890 RUB
1€=2.3872 TRY
1€=1.3302 AUD
1€=2.6463 BRL
1€=1.3339 CAD
1€=7.9055 CNY
1€=10.0044 HKD
1€=12608.68 IDR
1€=4.7693 ILS
1€=71.8050 INR
1€=1454.95 KRW
1€=16.1081 MXN
1€=3.9060 MYR
1€=1.5932 NZD
1€=53.778 PHP
1€=1.6301 SGD
1€=38.561 THB
1€=12.3661 ZAR
