Euro foreign exchange reference rates

car.3205

  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.  

  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(&quot;http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml&quot;);
//the file is updated daily between 2.15 p.m. and 3.00 p.m. CET
foreach($XMLContent as $line){
if(preg_match(&quot;/currency='([[:alpha:]]+)'/&quot;,$line,$currencyCode)){
if(preg_match(&quot;/rate='([[:graph:]]+)'/&quot;,$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 &quot;1&euro;=&quot;.$attrs['RATE'].&quot; &quot;.$attrs['CURRENCY'].&quot;<br />&quot;;
}
}
$xml_parser= xml_parser_create();
xml_set_element_handler($xml_parser, &quot;StartElement&quot;, &quot;&quot;);
// 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 (&quot;http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml&quot;));
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(&quot;http://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml&quot;);
//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[&quot;rate&quot;].' '.$rate[&quot;currency&quot;].'<br/>';
//--------------------------------------------------
//Here you can add your code for inserting
//$rate[&quot;rate&quot;] and $rate[&quot;currency&quot;] into your database
//--------------------------------------------------
}
?>
Output of the code above
1&#8364;=1.3857 USD
1&#8364;=111.87 JPY
1&#8364;=1.9558 BGN
1&#8364;=24.598 CZK
1&#8364;=7.4562 DKK
1&#8364;=15.6466 EEK
1&#8364;=0.86860 GBP
1&#8364;=271.76 HUF
1&#8364;=3.4528 LTL
1&#8364;=0.7097 LVL
1&#8364;=3.9820 PLN
1&#8364;=4.2663 RON
1&#8364;=9.3610 SEK
1&#8364;=1.3708 CHF
1&#8364;=8.1920 NOK
1&#8364;=7.3470 HRK
1&#8364;=42.7523 RUB
1&#8364;=1.9887 TRY
1&#8364;=1.4216 AUD
1&#8364;=2.3638 BRL
1&#8364;=1.4150 CAD
1&#8364;=9.2437 CNY
1&#8364;=10.7467 HKD
1&#8364;=12383.89 IDR
1&#8364;=61.5200 INR
1&#8364;=1557.90 KRW
1&#8364;=17.1544 MXN
1&#8364;=4.3090 MYR
1&#8364;=1.8280 NZD
1&#8364;=59.741 PHP
1&#8364;=1.7968 SGD
1&#8364;=41.509 THB
1&#8364;=9.6827 ZAR
　　from:http://www.ecb.int/stats/exchange/eurofxref/html/index.en.html