Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 791
Default Exchange Rates

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 122
Default Exchange Rates

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/...1d1t1ba&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/

Michael wrote:
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.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 791
Default Exchange Rates

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.

"Randy Harmelink" wrote:

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/...1d1t1ba&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/

Michael wrote:
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Analyzing foreign exchange rates Colleen Excel Discussion (Misc queries) 0 April 29th 09 04:34 AM
Automatic Exchange Rates Why Tea Excel Programming 5 December 19th 06 08:29 AM
Foreign Exchange peterthistle Excel Discussion (Misc queries) 2 November 21st 05 02:19 PM
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! StanUkr Excel Worksheet Functions 0 September 14th 05 11:12 AM
smart tag for exchange rates normdrexel Excel Discussion (Misc queries) 1 November 26th 04 08:05 PM


All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"