ICAEW.com works better with JavaScript enabled.

Historic exchange rates

The Knowledge guide to foreign exchange rates looks at the best print and electronic sources for current and historical rates. On this page we focus on sources for historic exchange rates.

An important consideration with web sources for historic rates is that they usually give figures for the working week only. If you are looking for an end of month rate and enter the last day of a month in any given year, you should be aware that it may show up as unavailable if this is also a date at the weekend.

Online sources

FT Markets Data

The FT provides tables of foreign exchange rate data through their Market Data website for the last three years.

To use this service:
1. Go to the data archive page and choose the option for 'Currencies' from the 'Choose a category' drop down menu.
2. Select the desired FT table from the 'Choose a report' drop down menu.
3. Select the date you require from the calendar and your table should appear.

Tables available include:

PACIFIC Exchange Rate Service

The Pacific Exchange Rate Service offers an extensive range of current and historic exchange rate data. The service is provided by Professor Antweiler of the University of British Columbia's Sauder School of Business and is primarily for the academic community, i.e., economists and other researchers. The earliest historic exchange rates start in 1971. However, some data is only available from the first year of the website's launch in 1996.

The Database Retrieval System provided by Pacific Exchange Rate Services allows you to select a base currency, a target currency, time span, volume or price notation and a frequency of figures within that (daily, weekly or monthly). Data can be downloaded in a variety of word processor and spreadsheet friendly formats for ease of use.

The Pacific Exchange Rate Service also includes a quick reference source for historic annual exchange rates for three currencies from 1948 to the last full year.

Each reference document gives the annual rate against 24 international currencies for the years 1948-2000. These have been compiled from a variety of sources, including the IMF, World Bank and OECD.

Oanda

Oanda is a commercial website providing foreign exchange, currency trading, and information services. The website includes a range of historic services covering 164 currencies. The data range is generally from 1990 onwards, but the start point of data for each currency varies. It is worth noting that the rates provided by Oanda are averages of figures gathered from Telerate, Bridge, and Reuters rather than being closing market prices.

  • FXHistory - a tool that allows you to display the exchange rate (daily averages) between the two currencies of your choice for a date range of up to 2000 days. The date range available is given as 1990 onwards, through there are exceptions (Deutschmark to US Dollar rates go back as far as April 1973).
  • FXDaily - for a specified date and home currency you can create a table showing the exchange rate with any number of additional currencies from 1990 onwards.

XE.com - Universal Currency Converter Services

XE.com provides a combination of historic and current exchange rate services. In looking for historic exchange rates their most useful service is the Interactive Currency Table service. This covers 79 world currencies with data going back to 1st January 1995. The service is easy to use, just choose a base currency and a date. The service then creates a web page with a table showing exchange rates with that currency on the date you specify.

Bank of England

The Bank of England provides exchange rates through their Bank of England Statistical Interactive Database - interest & exchange rates data - interest & exchange rates data page. This includes the rates for many currencies against sterling and the dollar as both monthly averages and end month rates. The site provides monthly, quarterly and annual tables going back to January 1963 provided in various forms including HTML, excel, XML and CSV files.

In addition their Statistical Abstract - 2002 contains tables in excel format containing Interest and exchange rates data providing monthly averages for foreign exchange rates between December 1975 and July 1999 against the Dollar and Sterling. They include:

  • 23.1 - Foreign exchange rates against sterling December 1975 to June 2002
  • 23.2 - Foreign exchange rates against US dollar December 1975 to June 2002
  • 23.3 - Effective exchange rates December 1975 to June 2002

The information contained within the Bank of England Statistical Abstract pages are not 'official' rates and are no more authoritative than rates provided by any commercial bank operating in the London market.

Print sources

The ICAEW Library & Information Service can provide information from a range of print sources on end of month, monthly average and annual average exchange rates. Unfortunately we are unable to provide historical daily rates.

Financial Statistics (ONS)

Financial Statistics is a monthly publication from the Office for National Statistics. Chapter 7 covers Exchange Rates, and provides:

  • Sterling exchange rate index against a basket of 24 major world currencies (Table 7.1A) with:
    - month by month for the past 4 years
    - yearly averages for the five years
  • End month rates and forward margins against sterling for 7 major currencies including the Canadian dollar, US dollar and Japanese Yen (Table 7.1B)
  • Interest rate differentials and exchange rates (Table 7.1C)

The Bank of England is the source for all the tables listed above.

Simon's Direct Tax Service

Simon's Direct Tax Service maintains a list of foreign exchange rates, as published annually by the Inland Revenue for general use in converting amounts in foreign currency to sterling. The tables are located in Binder 9 International, Part F 6.1 and start in 1981-82 continuing up to the most recent year end. The averages for the year to 31st March and 31st December are given for 60 currencies from the Argentine peso to the Zimbabwe dollar.

The Library & Information Service currently subscribes to Simon's Direct Tax Service through the online platform from Lexis-Nexis.

International Financial Statistics

International Financial Statistics is a monthly publication from the International Monetary Fund in Washington. The publication dates back to 1974. The ICAEW Library & Information Service holds copies of the January and July editions from 2007 until 2012 (as well as a copy of the edition for December 2012) to maintain a record of monthly interest rates between these years. The main features of International Financial Statistics are:

  • An introduction to exchange rates and exchange rate arrangements
  • Table of Exchange Rate Arrangements and Anchors of Monetary Policy
  • Daily Exchange Rates for 40 currencies against the US dollar. For example the July 2004 edition gives the daily rates for May 2004
  • Detailed entries for 172 countries give exchange rates against the dollar in a combination of months, quarters and annually back to 1997 - far more detailed than many sources will give you for some of the smaller countries.

Financial Times

The exchange rates printed in the Financial Times can be checked by visitors to the library by looking at the back issues in the Library & Information Service. The last three months are held in print format and previous editions are maintained on microfilm and date back to 1975.

The Stock Exchange Weekly Official Intelligence

The Stock Exchange Weekly Official Intelligence gives the daily currency exchange rate for the last 5 days in 18 currencies including the traded prices of EC currencies against sterling. No indication is given to explain how this figure has been calculated, but the trend in the volume is to give closing prices. A note adds that other currency rates are available on request.

The Library & Information Service holds back copies of the Stock Exchange Weekly Official Intelligence up until Saturday June 19th 2004. It is published and marketed by FT Interactive Data, on behalf of The London Stock Exchange PLC.

FT Capital Gains Tax Service

The annual volume of FT Interactive Data's Capital Gains Tax Service lists a number of exchange rates for the UK and the Republic of Ireland. These include:

  • Foreign Exchange rates on 31st March 1982 for 24 currencies (rate of exchange to £1)
  • Foreign exchange rates on April 5th 1974 for 22 currencies are listed for Irish CGT purposes (free rate of exchange to £1 and rate based on 28-3/8% dollar premium)
  • Daily exchange rates for Irish Punts to the Pound (Sterling), to assist with CGT calculations in the republic of Ireland. The rates listed cover the period of April 9th 1984 to April 5th 2004 and give the day's spread for punts to the pound for every working day of the year

Can't find what you are looking for?

If you're having trouble finding the information you need, ask the Library & Information Service. Contact us by telephone on +44 (0)20 7920 8620, by fax on +44 (0)20 7920 8621 or by email at library@icaew.com.

Every effort has been made to ensure that the information given in this Knowledge Guide is correct. However, the content of sites changes frequently and members should satisfy themselves that the information they contain is suitable for the purposes they wish to use it for. We would be grateful to receive notification of any links that do not work at the library email address above.

ICAEW accepts no responsibility for the content on any site to which a hypertext link from this site exists. The links are provided ‘as is’ with no warranty, express or implied, for the information provided within them. Please see the full copyright and disclaimer notice.