May 26, 2009 at 1:59 pm
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!
May 28, 2009 at 3:06 am
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy