rcbuchanan
asked on
XML Foreign Exchange rate feed ... into CF array?
Folks:
For me ... this is a tough one! I hope you can help!
I found an online rss xml feed for foreign currency exchange rates. I need to parse the xml feed into an array ...
so I can then import into a mysql table (which I feel pretty good about accomplishing).
BUT I've NO idea how XML stuff works (excuse pretty huge ignorance) ...
I'm hoping to do this:
- read XML file (see link) into these variables:
: exch_rate_date = (the date of the published rates (i.e. 2004-04-23))
: exch_rate_ccy [1,2,3 ... 6,7,8] = 'Malaysia' / 'Hong Kong' etc.
: exch_rate_num [1,2,3 ... 6,7,8] = 0.7287 etc (as a numeric with 4 decimal places)
That way ... I can then do a simple 'insert' into my database of the array contents.
http://www.ny.frb.org/markets/fxrates/FXtoXML.cfm?FEXdate=2004%2D04%2D23%2000%3A00%3A00&FEXtime=1200
Thanks for any guidance!
Richard Buchanan
The Opinion Exchange
For me ... this is a tough one! I hope you can help!
I found an online rss xml feed for foreign currency exchange rates. I need to parse the xml feed into an array ...
so I can then import into a mysql table (which I feel pretty good about accomplishing).
BUT I've NO idea how XML stuff works (excuse pretty huge ignorance) ...
I'm hoping to do this:
- read XML file (see link) into these variables:
: exch_rate_date = (the date of the published rates (i.e. 2004-04-23))
: exch_rate_ccy [1,2,3 ... 6,7,8] = 'Malaysia' / 'Hong Kong' etc.
: exch_rate_num [1,2,3 ... 6,7,8] = 0.7287 etc (as a numeric with 4 decimal places)
That way ... I can then do a simple 'insert' into my database of the array contents.
http://www.ny.frb.org/markets/fxrates/FXtoXML.cfm?FEXdate=2004%2D04%2D23%2000%3A00%3A00&FEXtime=1200
Thanks for any guidance!
Richard Buchanan
The Opinion Exchange
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok, ... am listing as new question 'cos I cannot see how to reassign new points to it! ... yikes.
Richard
Richard
ASKER
I found an online csv feed for foreign currency exchange rates. I need to parse the seven (7) days of rates into my mysql database table. I understand the database stuff ... BUT I've little clue about parsing csv files! (excuse pretty huge ignorance) ...
I'm hoping to do this:
- read first line (DATE ..) and store the SEVEN days reported into a simple array:
ccy_date [1,2,3 ... 7] = where each contains the date reported
- read the United States Dollar rates into ccy_USD [1,2,3 ... 7] array as numeric /w four decimal places so I can convert the Canadian Dollar reporting into USD reporting.
THEN ...
read EACH subsequent LINE (currency) as an INSERT into my database ...
insert into ccy_table
(ccy_name, ccy_date, ccy_rate)
values ( the csv'd country name, the csv'd date, the csv'd exch rate)
obviouly I'd use the ccy_USD [x] array field to convert the Canadian Dollar influence into the US Dollar spin.
the CSV rates are via:
http://www.bankofcanada.ca/en/financial_markets/csv/exchange_eng.csv
What do you think? [am trying to reload question with another 500 points ... be patient with me!]
Richard