Solved

How can I verify currency exchange rates in Excel?

Posted on 2013-06-27
3
614 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
[X]
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
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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

730 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