Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to auto update currency exchange rates in EXCEL from website
Is it possible to auto update Currency Exchange rate on an Excel Sheet from
an internet based web site? If yes, then how and which site is best to use. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to auto update currency exchange rates in EXCEL from website
I find the best way is to do a web query. Go to 'Data' - 'Import
External Data' - 'New Web Query' Finance at Yahoo is very good an example URL is; http://finance.yahoo.com/currency/co...submit=Convert As you can see from above, should you want to automate the generation of these web queries, the URL is predictable - hence you can change the Currencies and amounts manually or programatically. If you wanted help with that, post another request. Cheers, Haydn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analyzing foreign exchange rates | Excel Discussion (Misc queries) | |||
How to create a Exchange Currency Rate into Excel | Excel Worksheet Functions | |||
Exchange Rates | Excel Programming | |||
Automatic Exchange Rates | Excel Programming | |||
smart tag for exchange rates | Excel Discussion (Misc queries) |