Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How can I verify currency exchange rates in Excel?

Posted on 2013-06-27
3
Medium Priority
?
643 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 1200 total points
ID: 39280895
0
 
LVL 81

Assisted Solution

by:byundt
byundt earned 800 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

618 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