LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Foreign Exchange

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! StanUkr Excel Worksheet Functions 0 September 14th 05 11:12 AM
how to calculate exchange rate? papa404 Excel Discussion (Misc queries) 2 August 2nd 05 01:43 PM
exchange contents of cells \jeremy via OfficeKB.com\ New Users to Excel 6 July 8th 05 03:14 AM
Reindex exchange folders Mark C Charts and Charting in Excel 0 December 21st 04 04:19 PM
smart tag for exchange rates normdrexel Excel Discussion (Misc queries) 1 November 26th 04 08:05 PM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"