Interest Rates and Time ValueThis is the introduction section for [PRM Exam I](https://financetrain.com/prm/prm-exam-i/).
It pre...
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
You may find these interesting
Nominal Interest Rate and Effective YieldWhen you go to a bank enquiring about the deposit rates, the rates specified by the bank can be expr...
Exchange-traded versus Over-the-counter (OTC) Deri...An exchange traded product is a standardized financial instrument that is traded on an organized exc...
How Interest Rate Swaps Work?An interest rate swap is an exchange of cash flows between two parties where party A pays a fixed ra...
Details of an Interest Rate Swap ContractAn interest rate swap is an exchange of cash flows between two parties where party A pays a fixed ra...
How Interest Rate Caps Works?An interest rate cap (or ceiling) is an agreement between the seller or provider of the cap and a bo...
Basel II - Internal Ratings Based (IRB) ApproachThis approach involves assigning risk weights based on the internal rating of the borrowers. The rat...
How Interest Rate Floors Work?An interest rate floor is similar to an interest rate cap agreement. An interest rate floor is an ag...
How Interest Rate Collars Work?An interest rate collar (or floor ceiling) is an agreement where the seller or provider of the colla...
Forex: Bid and Offer RatesExchange rates are commonly expressed as two rates, the bid price and the offer price, for example:
...
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 JOINJOIN 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.