Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If the only currency conversion you ever want to do is from JPY to GBP, then
DataImport External DataNew Web Query -Use this website: http://finance.yahoo.com/currency/co...submit=Convert -Select the table in that site with the conversion rate Once you get the results in Excel, you can set up formulas that reference the Fx rate. Whenever you want to get the latest rate, right click on the results range and select Refresh Data Does that help? *********** Regards, Ron "peterthistle" wrote: With Excel 2003, is there a way to have a cell automatically update the foreign exchange rate of yen to British pounds from the internet, and then use that cell to do calculations? -- peterthistle ------------------------------------------------------------------------ peterthistle's Profile: http://www.excelforum.com/member.php...o&userid=28921 View this thread: http://www.excelforum.com/showthread...hreadid=486641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! | Excel Worksheet Functions | |||
how to calculate exchange rate? | Excel Discussion (Misc queries) | |||
exchange contents of cells | New Users to Excel | |||
Reindex exchange folders | Charts and Charting in Excel | |||
smart tag for exchange rates | Excel Discussion (Misc queries) |