How do I insert a foreign exchange formula in excel that updates it's conversion rate on a daily basis?

I want to create a file that converts USD (US Dollars) into PHP (Philippine Pesos) for merchandise (Magic: the Gathering playing cards) that I wish to collect and sell. The prices that I see on the internet are always in USD. I'd like to create an excel file that updates the USD-PHP exchange rate daily so that I can see how much the prices of my merchandise fluctuate. Thanks in advance!How do I insert a foreign exchange formula in excel that updates it's conversion rate on a daily basis?I have created an Excel file that will convert from USD to PHP, or from PHP to USD.

Just enter the USD price into the yellow USD cell, or the PHP price into the yellow PHP cell.



http://tinyurl.com/26k8tqh



You will just need to %26quot;Refresh%26quot; the External Data every day.

The Excel Sheet will pull Exchange Rates from:

http://www.exchange-rates.org/converter/How do I insert a foreign exchange formula in excel that updates it's conversion rate on a daily basis?You have to find a web site that has the exchange rate and link it to you excel sheet.

www.exchange-rates.org/history/PHP/USD?is one I found.

I think it best that you just insert the hyper-link in your spread sheet; then each day click on it, copy the rate for that day or hour and copy it into you sheet as an input value.

Have you formula refer to that value. This will then update your prices.