Finance Train LogoFinance Train
Learning LibraryTemplatesBlog
Data Science Bundle
Finance TrainFinance Train
Learning LibraryTemplatesBlog
Data Science Bundle
📑Excel & Spreadsheets

Get Foreign Exchange Rates in Excel

August 11, 2011
1 min read

This spreadsheet is designed to help you import the historical foreign exchange rates for any currency pair in the excel sheet.

The spreadsheet makes use of the historical rates from oanda.com

This is how it works:

  1. Enter a Currency pair. For example, if you want the quotes for EUR/USD, then EUR will be the first currency, and USD will be the second currency.
  2. Enter the Start date and the end date for the period for which you want the data.
  3. Hit the "Get Forex Data" button.
  4. The results will be displayed in the "Data" sheet along with the chart.

Downloads

Resources

Foreign Exchange Rates

Excel

Learning Library

Practical resources on data science, machine learning, and AI for finance professionals.

Browse Library
Mini Roadmap - Data Science for Finance
Free Download

Mini Roadmap: Data Science for Finance

A step-by-step guide covering Python, SQL, analytics, and finance applications.

Finance Train

Learn data science and AI skills for finance through practical courses and tutorials.

Learn

  • Learning Library
  • Course Directory
  • Blog

Resources

  • Templates & Downloads
  • Tools
  • Tables
  • Calculators

Company

  • About
  • Contact
  • Privacy
  • Terms

© 2026 Finance Train. All rights reserved.