Exchange Rates

[Guest]

Has anyone created a connection from Excel into the WSJ to automatically
download and update exchange rates.
Any kind of help will be greatly appreciated.

Michael Arch.

 

[Randy Harmelink]

Why not just get them from the current quotes area on Yahoo?

http://finance.yahoo.com/currency

Downloads can be automated pretty easily. For example, something
like:

http://download.finance.yahoo.com/d/quotes.csv?s=USDJPY=X+USDEUR=X&f=sl1d1t1ba&e=.csv

If you need more details on tools to get such data into EXCEL easily,
visit one of these Yahoo groups (the second one is mine):

http://tech.groups.yahoo.com/group/xltraders/
http://finance.groups.yahoo.com/group/smf_addin/

 

[Guest]

My company uses this data for financial reporting calculations that are
required by the SEC, the wall street journal is an acceptable source.
However, I'm not sure Yahoo is.
Thanks for the links, I will check it out.

Michael Arch.