If you need up-to-date exchange rates, try loading the rates via XML from the European Central Bank. This sample gets you the latest exchange rates for USD-EUR conversion. It also has a link to other currency data. Just exchange the data link. We included a sample for Danish currency as well.
#Exchangerate feeds : http://www.ecb.int/home/html/rss.en.html $url = 'http://www.ecb.int/rss/fxref-usd.html' #$url = 'http://www.ecb.int/rss/fxref-dkk.html' $xml = New-Object xml $xml.Load($url) $xml.RDF.Item | ForEach-Object { $rv = 1 | Select-Object Date, Currency, Rate, Description $rv.Date = [DateTime]$_.Date $rv.Description = $_.description.'#text' $rv.Currency = $_.statistics.exchangeRate.targetCurrency $rv.rate = $_.statistics.exchangeRate.value.'#text' $rv }
And this is what the output looks like (provided you have Internet access and no proxy is required):
Date Currency Rate Description ---- -------- ---- ----------- 01.12.2011 14:15:00 USD 1.3492 1 EUR buys 1.3492 US dollar (USD) - The ... 30.11.2011 14:15:00 USD 1.3418 1 EUR buys 1.3418 US dollar (USD) - The ... 29.11.2011 14:15:00 USD 1.3336 1 EUR buys 1.3336 US dollar (USD) - The ... 28.11.2011 14:15:00 USD 1.3348 1 EUR buys 1.3348 US dollar (USD) - The ... 25.11.2011 14:15:00 USD 1.3229 1 EUR buys 1.3229 US dollar (USD) - The ...
