Euro foreign exchange reference 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.

 

Latest overview

Euro foreign exchange reference rates as at 21 May 2013

All currencies quoted against the euro (base currency)
Currency Spot RSS
  (1) As of 1 July 2005 the currency of Romania is the new Romanian leu (RON). 1 RON equals 10,000 old Romanian lei (ROL).
USD US dollar 1.2866 up USD RSS
JPY Japanese yen 132.33 up JPY RSS
BGN Bulgarian lev 1.9558 eq BGN RSS
CZK Czech koruna 26.098 down CZK RSS
DKK Danish krone 7.4527 down DKK RSS
GBP Pound sterling 0.84910 up GBP RSS
HUF Hungarian forint 290.42 up HUF RSS
LTL Lithuanian litas 3.4528 eq LTL RSS
LVL Latvian lats 0.6999 up LVL RSS
PLN Polish zloty 4.1898 up PLN RSS
RON New Romanian leu 1 4.3493 up RON RSS
SEK Swedish krona 8.5600 down SEK RSS
CHF Swiss franc 1.2476 up CHF RSS
NOK Norwegian krone 7.5065 down NOK RSS
HRK Croatian kuna 7.5713 up HRK RSS
RUB Russian rouble 40.2267 down RUB RSS
TRY Turkish lira 2.3788 up TRY RSS
AUD Australian dollar 1.3147 up AUD RSS
BRL Brasilian real 2.6293 up BRL RSS
CAD Canadian dollar 1.3212 eq CAD RSS
CNY Chinese yuan renminbi 7.8955 up CNY RSS
HKD Hong Kong dollar 9.9863 up HKD RSS
IDR Indonesian rupiah 12560.14 up IDR RSS
ILS Israeli shekel 4.7200 up ILS RSS
INR Indian rupee 71.2970 up INR RSS
KRW South Korean won 1429.23 down KRW RSS
MXN Mexican peso 15.8388 up MXN RSS
MYR Malaysian ringgit 3.8855 up MYR RSS
NZD New Zealand dollar 1.5781 up NZD RSS
PHP Philippine peso 53.134 up PHP RSS
SGD Singapore dollar 1.6209 up SGD RSS
THB Thai baht 38.366 up THB RSS
ZAR South African rand 12.2890 up ZAR RSS
ISK Icelandic krona - The last rate was published on 3 Dec 2008.      
 

Data downloads

Latest rates

Previous rates

  •   zipped– Can be imported into Excel and other spreadsheet applications
  •  XML file available for parsing (Last 90 days): http://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist-90d.xml
  •  XML file available for parsing, since 1999 : http://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.xml
  •  XML file available for parsing, since 1999 (Format: SDMX-ML): http://www.ecb.europa.eu/stats/eurofxref/eurofxref-sdmx.xml
  •  

Statistical Data Warehouse - Interactive data access

 

Background

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.

 

For developers

How to parse the data

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_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 );

?>

SimpleXML example



<?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.2866 USD

1€=132.33 JPY

1€=1.9558 BGN

1€=26.098 CZK

1€=7.4527 DKK

1€=0.84910 GBP

1€=290.42 HUF

1€=3.4528 LTL

1€=0.6999 LVL

1€=4.1898 PLN

1€=4.3493 RON

1€=8.5600 SEK

1€=1.2476 CHF

1€=7.5065 NOK

1€=7.5713 HRK

1€=40.2267 RUB

1€=2.3788 TRY

1€=1.3147 AUD

1€=2.6293 BRL

1€=1.3212 CAD

1€=7.8955 CNY

1€=9.9863 HKD

1€=12560.14 IDR

1€=4.7200 ILS

1€=71.2970 INR

1€=1429.23 KRW

1€=15.8388 MXN

1€=3.8855 MYR

1€=1.5781 NZD

1€=53.134 PHP

1€=1.6209 SGD

1€=38.366 THB

1€=12.2890 ZAR

Source: ECB