Get Foreign Exchange Rates in Excel

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.

Post Resources

Member-only
Finance Train Premium
Accelerate your finance career with cutting-edge data skills.
Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.
I WANT TO JOIN
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Saylient AI Logo

Accelerate your finance career with cutting-edge data skills.

Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.

Join Finance Train Premium