GasGiant
|
You could use a small, scheduled program to grab the feed data, parse it, then process a short SQL INSERT query. Should be super easy. You'd need one insert per currency. If it were Euros (EUR), then your SQL might be... INSERT INTO ISMCR VALUES('USA', CURDATE, 'EUR', '$rate') where $rate is the exchange rate (up to six decimal places)
|