• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 647
  • Last Modified:

How can I verify currency exchange rates in Excel?

I have a workbook template that loads MSN MoneyCentral Investor Currency Rates table using the Data connection link, into a worksheet each time that it loads.

On another worksheet a user inputs a currency rate that has been set by an administrator for the day.
If the rate entered is a certain percentage different to the MSN rate then this is flagged to the user with the use of formulas.

My problem is that MSN have changed their table recently, it no longer includes the euro which is one of the main requirements.

How may I resolve this so that the workbook continues to provide this currency resource?
0
spar-kle
Asked:
spar-kle
2 Solutions
 
byundtCommented:
What is the URL for the MSN table that doesn't include the Euro?

When I went looking for one, the table I found has it:
http://investing.money.msn.com/investments/exchange-rates
0
 
spar-kleOperations DirectorAuthor Commented:
Thanks for your help.
I created a link to a different website address.

I was using: http://moneycentral.msn.com/investor/external/excel/rates.asp
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now