Get FX rate from web (Excel 2000)

Topic

New Reply

I would like to get month end currency exchange rates from the web, so no one needs to input them. I think it can be done through a web query, but I’ve never done this before, plus I couldn’t find a site to link to. Could someone help? Thank you!

Reply | Quote

Replies

Maybe this will get you started in the right direction.

1) Open and minimize an instance of Excel
2) Navigate to the folder C:Program FilesMicrosoft OfficeOfficeQueries
3) Double click on “Microsoft Investor Currency Rates”

When I did it, it put data from MSN MoneyCentral Investor into my Excel sheet that I had minimized. Where you go from there as far as editing the query I cannot tell you. There may be another way of calling the query without navigating to the folder, but I stumbled upon it the other evening and could not tell you how to otherwise call the query without saving it first.

Reply | Quote

Actually, under the Data/Get External Data menu, selecting “Run saved query” will take you to the same spot, plus evidently a few others.

Reply | Quote

Mike,
Thank you for your reply. I did try as you said. Attached is what I got. I couldn’t modify the query to give the currencies that I want, or give me the rates at month end. Is there a way to do it?
Thank you!

Reply | Quote

Y…I get the same thing…Since the sites that you are querying are free, I do not imagine that you have many options about which data you wish to display. If you are set up for online trading, I am sure your brokerage firm could help you get the information you need. Otherwise, I have not really felt the need to delve into the web~excel connectivity issue very much, so I am pretty much out of ideas except as outlined above.

Reply | Quote

I did a Data | GetExternalData | NewWebQuery to http://www.trustnet.com/general/rates.asp and experimented until I found that table 9 was what you want. See attached worksheet. HTH –Sam

Reply | Quote

I went to Data | Get external data | NewWebQuery, hit the browse button and go a Message
“To use this feature, you must have a World Wide Web Browser such as Microsoft Internet Explorer” !!

Wonder what I have broken now?

Peter

Reply | Quote

Do you have a browser connected to the world-wide-web? Should work with IE or Netscape.

Reply | Quote

Yes, I am using IE5 under Win2K. be a job to browse this lounge with out one!

Peter

Reply | Quote

Well duh! I’m totally flumoxed, can you use Data | GetExternalData | RunSavedQuery to run one of the precanned MS ones? Do you have XL2K?

Reply | Quote

I have xl2k, I can get the external data ok if I know the path, I just cant use explorer to browse for it.

Peter

Reply | Quote

Can you go to the web site in IE, copy the URL, return to the Excel query, and paste it into the query box?

Reply | Quote

I have not tried it with a web site as such, but the saved Querys work and a html file on my harddrive linked in Ok

Peter

Reply | Quote