Wednesday, February 3, 2010

Currency Rates in Excel


So, you are getting ready for that trip to Europe, (or wherever in the world you are going), and you would like to download the most up-to-date currency exchange rates directly into the Excel workbook you are using for your trip planning. Piece of Cake!

Here is what you do in Excel 2003:
1) Select cell A1
2) Go to Data / Import External Data / Import Data and choose MSN MoneyCentral Investor Currency Rates
3) Click OK

Bamm! In a few seconds, you will have the exchange rates for Argentine Pesos to Venezuelan Bolivars!

If you are using Excel 2007:

1) Select cell A1
2) Go to Data / Get External Data / Existing Connections and choose MSN MoneyCentral Investor Currency Rates
3) Click OK

Does that Rock or What? I see that today you can get 9,360 Indonesian Rupiahs for one US Dollar (sounds like a bargain…)!

7 comments:

SimCon said...

You can also use Yahoo Finance to get real-time foreign exchange rates in Excel. See here

ANOOne Digital said...

I have been using the plugin below for quite some time. Works great for me. It uses Yahoo API and MSN money website to get live currency rates in Excel exposed as custom functions. i.e. =Fx_Convert(100,"USD","EUR")

http://technitya.com/content/Live-Currency-in-Excel

Harz said...

I use this. It works great for me.
http://marketxls.com/stock-quotes-in-excel/

Unknown said...

Much obliged for your educated post. We can get numerous advantages it. What's more, increment our business benefit and can fulfill the client give necessity administration. We are exceptionally appreciative to you.
Crude oil signals
commodity signals
Forex trading signals


Forex Signals Provider said...

Currency trade, forex exchange, fx alternate – these are all terms used to describe the exchanging of 1 currency for any other; as an example, the exchanging of u.S. Bucks to british kilos. Within the forex market, that is considered as shopping for pounds whilst simultaneously promoting greenbacks*. Due to the fact currencies are usually concerned, currencies are traded inside the form of foreign money pairs, with the pricing based totally on the trade rate offered by using dealers in forex buying and selling marketplace.
Forex Signals
Best Forex Signals

Forex Signals said...

The foreign exchange, and additionally called "the foreign exchange" market exists anywhere one currency is traded for another. It's the biggest monetary marketplace inside the international. Virtually if we examine the ny stock change trades vs changing hands in forex, we are able to discover forex marketplace is a lot of instances larger than both equity and treasury markets mixed.
Forex or "foreign exchange" is in which the cash of one state is traded with another. The most important and popular pairs of exchange within the foreign exchange market are "euro dollar", and you may see this pairs in all forex show screens as "eur/usd". There also are a number of others pairs but positive no longer important and not well-known as "eur/usd" pairs, like:-
1-the british pound, and you may see this pairs in all foreign exchange show displays as "gbp/usd".
2- the japanese yen, and you'll see this pairs in all forex show displays as "usd/jpy".
3- the swiss franc, and you'll see this pairs in all forex show screens as "usd/chf".
Automated Forex Trading
Forex signals

Jayden Rich said...

I really appreciate this post. I’ve been looking all over for this!

Buy Silver Coins In San Francisco