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 22 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.2923 up USD RSS
JPY Japanese yen 133.26 up JPY RSS
BGN Bulgarian lev 1.9558 eq BGN RSS
CZK Czech koruna 26.069 down CZK RSS
DKK Danish krone 7.4535 up DKK RSS
GBP Pound sterling 0.85570 up GBP RSS
HUF Hungarian forint 289.06 down HUF RSS
LTL Lithuanian litas 3.4528 eq LTL RSS
LVL Latvian lats 0.7002 up LVL RSS
PLN Polish zloty 4.1784 down PLN RSS
RON New Romanian leu 1 4.3479 down RON RSS
SEK Swedish krona 8.5451 down SEK RSS
CHF Swiss franc 1.2599 up CHF RSS
NOK Norwegian krone 7.4650 down NOK RSS
HRK Croatian kuna 7.5745 up HRK RSS
RUB Russian rouble 40.3220 up RUB RSS
TRY Turkish lira 2.3791 up TRY RSS
AUD Australian dollar 1.3253 up AUD RSS
BRL Brasilian real 2.6344 up BRL RSS
CAD Canadian dollar 1.3315 up CAD RSS
CNY Chinese yuan renminbi 7.9232 up CNY RSS
HKD Hong Kong dollar 10.0301 up HKD RSS
IDR Indonesian rupiah 12619.13 up IDR RSS
ILS Israeli shekel 4.7759 up ILS RSS
INR Indian rupee 71.8070 up INR RSS
KRW South Korean won 1440.76 up KRW RSS
MXN Mexican peso 15.9251 up MXN RSS
MYR Malaysian ringgit 3.9047 up MYR RSS
NZD New Zealand dollar 1.5923 up NZD RSS
PHP Philippine peso 53.254 up PHP RSS
SGD Singapore dollar 1.6314 up SGD RSS
THB Thai baht 38.511 up THB RSS
ZAR South African rand 12.2836 down 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.2923 USD

1€=133.26 JPY

1€=1.9558 BGN

1€=26.069 CZK

1€=7.4535 DKK

1€=0.85570 GBP

1€=289.06 HUF

1€=3.4528 LTL

1€=0.7002 LVL

1€=4.1784 PLN

1€=4.3479 RON

1€=8.5451 SEK

1€=1.2599 CHF

1€=7.4650 NOK

1€=7.5745 HRK

1€=40.3220 RUB

1€=2.3791 TRY

1€=1.3253 AUD

1€=2.6344 BRL

1€=1.3315 CAD

1€=7.9232 CNY

1€=10.0301 HKD

1€=12619.13 IDR

1€=4.7759 ILS

1€=71.8070 INR

1€=1440.76 KRW

1€=15.9251 MXN

1€=3.9047 MYR

1€=1.5923 NZD

1€=53.254 PHP

1€=1.6314 SGD

1€=38.511 THB

1€=12.2836 ZAR

Quelle: EZB