[2008] Get Forex Rates From Internet

[KenBZim]

I have an app that connects to a mysql database.
This app uses foreign currency rates in a big way to establish prices for various commodities.
At the moment these rates are captured into the db manually each day.
My question is :
Is it possible to obtain these rates at regular intervals each day from the Internet?
And if so how would one go about achieving this operation?
The Sever on which the db resides does have a permanent connection to the internet.
Any help you can give would be greatly appreciated

[jmcilhinney]

I imagine you'd be able to find a web service from banks or other financial institutions that would provide up-to-date exchange rates, e.g.

http://www.newyorkfed.org/markets/pilotfx.html

[KenBZim]

Thanks
I will check it out

[KenBZim]

Thanks
That is just what I am looking for.
The site even gives an example for .NET but it is in C# which I do not understand, I also don't have any experience with XML.
This may be out of my league but I would like to learn how to interact with web services using VS2008 can anyone point me in the right direction??

Many Thanks

Ken

[danasegarane]

Try MSDN

MSDN