Solved

How can I verify currency exchange rates in Excel?

Posted on 2013-06-27
3
580 Views
Last Modified: 2013-06-28
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
Comment
Question by:spar-kle
3 Comments
 
LVL 5

Accepted Solution

by:
kumaresan2011 earned 300 total points
ID: 39280895
0
 
LVL 81

Assisted Solution

by:byundt
byundt earned 200 total points
ID: 39281518
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
 

Author Closing Comment

by:spar-kle
ID: 39283725
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now