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.

TARGET closing days

Euro foreign exchange reference rates: 14 February 2020


Current reference rates

Historical reference rates

Between 16:00 CET on 28 November 2018 and 16:00 CET on 24 January 2019, some historical reference rate PDFs contained rates that were incorrect. All other formats (HTML, CSV, XML) contained the correct reference rates.

Historical reference rate PDFs for the following dates were affected: 28 May 2018, 29 May 2018, 30 May 2018, 4 June 2018, 5 June 2018, 6 June 2018, 14 June 2018, 12 November 2018, 19 November 2018, and 21 November 2018.

Time series

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

//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)
//the file is updated at around 16:00 CET
foreach($XMLContent as $line){
//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

function StartElement($parser$name$attrs) { 
    if (!empty(
$attrs['RATE'])) {
"1&euro;=".$attrs['RATE']." ".$attrs['CURRENCY']."<br />"
// 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 (""));



//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)
//the file is updated at around 16:00 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.0842 USD
1€=119.11 JPY
1€=1.9558 BGN
1€=24.828 CZK
1€=7.4713 DKK
1€=0.83208 GBP
1€=335.67 HUF
1€=4.2490 PLN
1€=4.7684 RON
1€=10.5085 SEK
1€=1.0641 CHF
1€=137.50 ISK
1€=10.0258 NOK
1€=7.4490 HRK
1€=68.9116 RUB
1€=6.5735 TRY
1€=1.6151 AUD
1€=4.6927 BRL
1€=1.4363 CAD
1€=7.5757 CNY
1€=8.4214 HKD
1€=14870.88 IDR
1€=3.7177 ILS
1€=77.4660 INR
1€=1283.75 KRW
1€=20.1606 MXN
1€=4.4886 MYR
1€=1.6864 NZD
1€=54.806 PHP
1€=1.5090 SGD
1€=33.848 THB
1€=16.1139 ZAR

Framework for the euro foreign exchange reference rates:

ECB introduces changes to euro foreign exchange reference rates, 7 December 2015