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.2866 USD1€=132.33 JPY1€=1.9558 BGN1€=26.098 CZK1€=7.4527 DKK1€=0.84910 GBP1€=290.42 HUF1€=3.4528 LTL1€=0.6999 LVL1€=4.1898 PLN1€=4.3493 RON1€=8.5600 SEK1€=1.2476 CHF1€=7.5065 NOK1€=7.5713 HRK1€=40.2267 RUB1€=2.3788 TRY1€=1.3147 AUD1€=2.6293 BRL1€=1.3212 CAD1€=7.8955 CNY1€=9.9863 HKD1€=12560.14 IDR1€=4.7200 ILS1€=71.2970 INR1€=1429.23 KRW1€=15.8388 MXN1€=3.8855 MYR1€=1.5781 NZD1€=53.134 PHP1€=1.6209 SGD1€=38.366 THB1€=12.2890 ZAR
Quelle: EZB