Currency conversion 1

[SPYDERIX]

Hi,

I'm looking to do currency conversion from CAD to USD on the fly but need to get the daily conversion rate. I know of one site that has the rate on it:

http://www.x-rates.com/d/USD/CAD/data120.html

The newest rate is added at the bottom. I either need to find a better site that shows this rate or I need to extract that rate from my posted url and then store it in my database. How do I go about grabbing that page and then seperating the value into a variable that I can use?

Thanks!

NATE

http://www.mainframe-webdesign.com

Got a question? Search G O O G L E for links to the fastest answers: www.google.com

 

[sleipnir214]

The Federal Reserve Bank of New York provides exchange-rate data in XML form at this page:

http://www.ny.frb.org/markets/fxrates/FXtoXML.cfm?FEXdate=2004-01-14 00:00:00&FEXtime=1200

where this part of the URL:

2004%2D01%2D14%2000%3A00%3A00

is a URL-encoded date-time stamp, which, as posted, reads decoded as 2004-01-15 00:00:00.

Construct the correct date-time string, open the URL as a file, and start reading the contents.

Look for the line that contains the string "Canada". The next line of the XML will look something like:

<Value InUsd=&quot;false&quot;>1.299</Value>

Strip off the <Value...>...</Value> tags and there's your exchange rate.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!