How do I build automated currency exchange rate into Excelspreadsheet?

E

emailus

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.
 
M

Mike H

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
 
R

Randy Harmelink

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top