update world currencies
i have a layout which includes information about machines in my inventory, including the price i bought it at. i have a value list from which i can choose the currency of the price (either USD, CAD, EUR, GBP, or JPY). i then have a field which calculates the buy price in USD (using exchange rates). as a temporary fix, i have set up fields where i manually enter the necessary exchange rates, from which the USD Buy Price is calculated depending on the Buy Currency selected.
however, what i am aiming for is live updating of the exchange rates, so that i will not have to update the rates every day. for example, XE.com has CSV/HTML/XML data files with updating rates (http://www.xe.com/dfs/product.php), and I am wondering if there is any way for me to set up the USD Buy Price field so that it automatically draws from the live exchange rates and calculates the price accordingly.
Please advise, thanks.