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:
- 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.
- Enter the Start date and the end date for the period for which you want the data.
- Hit the "Get Forex Data" button.
- The results will be displayed in the "Data" sheet along with the chart.
Post Resources
Member-only
Data Science in Finance: 9-Book Bundle
Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.
What's Included:
- Getting Started with R
- R Programming for Data Science
- Data Visualization with R
- Financial Time Series Analysis with R
- Quantitative Trading Strategies with R
- Derivatives with R
- Credit Risk Modelling With R
- Python for Data Science
- Machine Learning in Finance using Python
Each book includes PDFs, explanations, instructions, data files, and R code for all examples.
Get the Bundle for $29 (Regular $57)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.
