Browse By

Computational Finance: Building Monte Carlo (MC) Simulators in Excel

Option Pricing – Building Monte Carlo Simulators in Excel for pricing vanilla & Exotic Options

My first interaction with a Monte Carlo simulation was not a very pleasant experience.  It was a exam problem based on a difficult text book and an even more incomprehensible study note that I had hardly understood.  But over the years great teachers like Mark Broadie, friends like Carlos Desmaras and students at SP Jain and Alchemy platforms finally helped me crack the code behind Monte Carlo Simulations.

Simulated Price Series and Profit Margins

This note starts with the basic concepts and ends with some fairly complex applications of Monte Carlo Simulations tools. The interest rate modeling piece is covered with a downloadable pdf file that Mark shared with us at Columbia as part of his course on Security pricing.  Irrespective of how much I grow and write and teach it will be difficult for me to beat the simple elegance of his 10 pages on interest rate modelling.

  1. Computational Finance: Monte-Carlo (MC) Simulation method– Building Equities, Commodities, Currencies and Interest Rate MC Simulators in Excel
  2. Computational Finance: Building your first Monte Carlo (MC) simulator model for simulated equity prices in Excel
  3. Computational Finance: Monte Carlo (MC) Simulation method: Understanding drift, diffusion and volatility drag
  4. Computational Finance: Linking Monte Carlo Simulation, Binomial Trees and Black Scholes Equation

Simulation Interest Rates using Monte Carlo Simulation in Excel

  1. Computational Finance: Simulating Interest Rates using trees and Monte Carlo Simulation
  2. Computational Finance – Calibrating the Cox, Ingersoll, Ross (CIR) Interest Rate Simulator
  3. Computational Finance – US Treasury Curve Data – Principal Component Analysis (PCA) process, data and volatility function
  4. Computational Finance: Interest Rate Modeling: PCA analysis for HJM Interest Rate Simulation and calculating Eigenvectors in Excel


6 thoughts on “Computational Finance: Building Monte Carlo (MC) Simulators in Excel”

  1. Pingback: Computational Finance Posts Index | Learning Corporate Finance
  2. Trackback: Computational Finance Posts Index | Learning Corporate Finance
  3. Pingback: Mathematical Finance Option Pricing using Monte Carlo Simulators in Excel | Finance Training Course
  4. Trackback: Mathematical Finance Option Pricing using Monte Carlo Simulators in Excel | Finance Training Course
  5. Pingback: Understanding Delta Hedging for options using Monte Carlo Simulation | Finance Training Course
  6. Trackback: Understanding Delta Hedging for options using Monte Carlo Simulation | Finance Training Course
  7. Pingback: Dynamic Delta Hedging – Extending the Monte Carlo simulation model to Put contracts | Finance Training Course
  8. Trackback: Dynamic Delta Hedging – Extending the Monte Carlo simulation model to Put contracts | Finance Training Course
  9. Pingback: The Derivatives Pricing & Quant models 5 nights crash course | Finance Training Course
  10. Trackback: The Derivatives Pricing & Quant models 5 nights crash course | Finance Training Course
  11. Pingback: Simulation Modeling – Monte Carlo how to reference | Finance Training Course
  12. Trackback: Simulation Modeling – Monte Carlo how to reference | Finance Training Course

Comments are closed.