ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to auto update currency exchange rates in EXCEL from website (https://www.excelbanter.com/excel-programming/395349-how-auto-update-currency-exchange-rates-excel-website.html)

Kylejo

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.


[email protected]

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



All times are GMT +1. The time now is 08:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com