Exchange Rates

PanzerAttack

Board Regular
Joined
Jan 3, 2008
Messages
197
Hi all not exactly Excel I know but I am working in Excel.

I need Daily Exchange Rates for 27 currencies from 01/01/2010 - 31/03/2013.

I've tried some of the websites mentioned on here and the Bank of England website comes close but nowhere can I get a full list of rates, they're either weekly or have days missing.

I wondered if someone had this somewhere around were able to send me a copy.

The format is simple:

Date Currency Rate
01/01/2010 AUD 1.5114

the countries I need are:

currencycode
AED
ARS
AUD
BRL
CAD
CHF
CNY
CZK
DKK
EUR
GBP
HKD
HUF
ILS
INR
JPY
MXN
NOK
NZD
PLN
SAR
SEK
SGD
THB
TRY
USD
ZAR

Thanks as always.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,215,274
Messages
6,123,993
Members
449,137
Latest member
abdahsankhan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top