Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How can I verify currency exchange rates in Excel?

Posted on 2013-06-27
3
602 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

840 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