Euro foreign exchange reference rates

The reference rates are usually updated around 16:00 CET on every working day, except on TARGET closing days. They are based on a regular daily concertation procedure between central banks across Europe, which normally takes place at 14:15 CET.

As of 1 July 2016 the reference rates are updated at around 16:00 CET.

More information can be found in the press release of 7 December 2015 and the accompanying document.

Euro foreign exchange reference rates: 26 July 2016

Downloads

Current rates

Historical rates

To import CSV files into your spreadsheet, choose a setting that uses a dot "." as decimal separator (such as UK or US format).

Related information

For developers

How to parse the data in PHP

Regular expression example


<?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&euro;='.$rate[1].' '.$currencyCode[1].'<br/>';
        
//--------------------------------------------------
        //Here you can add your code for inserting
        //$rate[1] and $currencyCode[1] into your database
        //--------------------------------------------------
      
}
    }
  }
?>

XML parser example


<?php
  
function StartElement($parser$name$attrs) { 
    if (!empty(
$attrs['RATE'])) {
      echo 
"1&euro;=".$attrs['RATE']." ".$attrs['CURRENCY']."<br />"
    }
  }
    
$xml_parserxml_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_parserfile_get_contents ("http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml"));
    
xml_parser_free($xml_parser);
?>

Example

SimpleXML.php


<?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&euro;='.$rate["rate"].' '.$rate["currency"].'<br/>';
    
//--------------------------------------------------
    //Here you can add your code for inserting
    //$rate["rate"] and $rate["currency"] into your database
    //--------------------------------------------------
  
}
?>

Output of the code above

1€=1.0997 USD
1€=114.67 JPY
1€=1.9558 BGN
1€=27.021 CZK
1€=7.4393 DKK
1€=0.83710 GBP
1€=313.16 HUF
1€=4.3629 PLN
1€=4.4657 RON
1€=9.5124 SEK
1€=1.0870 CHF
1€=9.4370 NOK
1€=7.4855 HRK
1€=72.8920 RUB
1€=3.3508 TRY
1€=1.4599 AUD
1€=3.6080 BRL
1€=1.4553 CAD
1€=7.3357 CNY
1€=8.5301 HKD
1€=14488.80 IDR
1€=4.2260 ILS
1€=74.0420 INR
1€=1249.22 KRW
1€=20.6734 MXN
1€=4.4693 MYR
1€=1.5561 NZD
1€=51.855 PHP
1€=1.4925 SGD
1€=38.494 THB
1€=15.8672 ZAR

Framework for the euro foreign exchange reference rates: