Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I build automated currency exchange rate into Excelspreadsheet?
I'm building an Excel spreadsheet which requires input of foreign
currency exchange rates. Rather than a user manually input or update an exchange rate, is there some way of having the exchange rate automatically inserted into the spreadsheet, for instance if the user is online with the spreadsheet open, I'm wondering if perhaps some html code can be buried into a spreadsheet cell which achieves desired result. Any tips appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I build automated currency exchange rate into Excel spreads
Hi,
Here's an example method but note I may not have picked the best website to use, you may have you own favourite. In internet explorer navigate to http://www.x-rates.com/ Copy this address from address bar Select A1 in your worksheet and then Data|Import external data|New web query Paste the address from above in the address bar, click GO and you will be directed to the web site. Scroll until you find the table you want and click the yellow arrow and it will turn into a tick. Click import and the table will be imported. If you right click within the table in Excel you can set things like the refresh frequency. Mike " wrote: I'm building an Excel spreadsheet which requires input of foreign currency exchange rates. Rather than a user manually input or update an exchange rate, is there some way of having the exchange rate automatically inserted into the spreadsheet, for instance if the user is online with the spreadsheet open, I'm wondering if perhaps some html code can be buried into a spreadsheet cell which achieves desired result. Any tips appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I build automated currency exchange rate into Excelspreadsheet?
If you don't mind delayed quotes, I have a free open-source add-in
that might be of use. The add-in, documentation on its functions, and sample templates can be found in the files area of this Yahoo group: http://finance.groups.yahoo.com/group/smf_addin/ Some examples to get one or more quotes from Yahoo's current quotes interface (array-entered functions): =RCHGetYahooQuotes("USDJPY=X") =RCHGetYahooQuotes("USDJPY=X","l1d1t1ba") =RCHGetYahooQuotes("USDJPY=X,USDEUR=X","l1d1t1ba") =RCHGetYahooQuotes(A1:A2,"l1d1t1ba") On Jun 1, 1:02 am, wrote: I'm building an Excel spreadsheet which requires input of foreign currency exchange rates. Rather than a user manually input or update an exchange rate, is there some way of having the exchange rate automatically inserted into the spreadsheet, for instance if the user is online with the spreadsheet open, I'm wondering if perhaps some html code can be buried into a spreadsheet cell which achieves desired result. Any tips appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a Exchange Currency Rate into Excel | Excel Worksheet Functions | |||
euro-sterling exchange rate | Excel Discussion (Misc queries) | |||
vlookup for exchange rate | Excel Worksheet Functions | |||
Exchange rate function | Excel Programming | |||
how to calculate exchange rate? | Excel Discussion (Misc queries) |