HELP: Getting Real Time Currency Exchange Rates In SQL

• Alasdair Thomson

  Hall of Fame

  Points: 3630

  More actions

  May 26, 2009 at 1:59 pm

  #200803

  Hello All,

  I need some direction with regards to LIVE (Real Time access to currency exchange rates) for use in my DB queries. I have some reports which have figures in (Amount, Currency) which any Amounts in dollars and euros need converting into pounds sterling at whatever the rate is.

  I can do this manually but REALLY dont want to!

  I have read up on Web Services using currency:

  http://msdn.microsoft.com/en-us/library/ms365190(SQL.90).aspx

  This looks a little too involved for our level of expertise! So I have found an XML format with the info I need:

  http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml

  I can use this XML and convert into a SQL Table but the issue I have is I want the XML file to be updated automatically from this website without manual intervention. How can I do this, or is there an easier way to get what I need.?

  Please Help!

• cb-697162

  Old Hand

  Points: 382

  More actions

  May 28, 2009 at 3:06 am

  #1001263

  Hi Alasdair

  Lots of sites on the web offering Excel add-ins that poll ex-rates overnight - perhaps you could use one of these?

  Or look at OANDA.com - they advertise "FXP" - (Foreign Exchange Protocol) for on-line currency rates - but I don't know the cost.

  Happy hunting

  cb