Learning Roadmap – Monte Carlo Simulation
If you would like to jump directly to the Monte Carlo master training reference please see Monte Carlo Simulations – How to reference. In addition to the master reference, we have also included links to the following Monte Carlo Simulation Training Courses:
a) Using Monte Carlo Simulation to price Exotic Options
b) Tweaking and Hacking Monte Carlo Simulation for more robust results.
The first focuses on application of Monte Carlo Simulation in Option pricing. The second suggests solutions for addressing the normality assumption challenge by replacing the normal distribution with the historical distribution. Click on any of the images to jump to the relevant course pages.
Courses linked to the first three images are free.
Option pricing using Monte Carlo Simulation
The Derivative and Option pricing package guide includes the following EXCEL files:
a. The supporting excel file for the alternate binomial tree methodology for the products mentioned above
b. Option pricing using the Traditional Binomial Tree approach
c. Option pricing using the Black-Scholes option pricing formula
d. Ladder call option priced using Monte Carlo simulation in EXCEL (standalone Excel file)
e. Derivative Pricing using Monte Carlo Simulation EXCEL file calculates the option prices for a number of vanilla and exotic options including Asian, Barrier, Lookback & Chooser Options. The “Exotic Option Pricing using Monte Carlo Simulation” EXCEL file calculates option prices using Monte Carlo Simulation:
- Vanilla European Call and Put options are priced for model calibration and tweaking
- Out of Money Call and Put options are priced to compared cost savings between vanilla and exotic option contracts
- Asian Call and Put options that replace the terminal price with the average of prices across the simulated path,
- Look-back Call option are priced to simulate maximum payoffs
- Barrier or Sudden Death Call option which has both in and out barriers above and below the strike,
- Ladder Call option with two rungs (high water marks) in addition to the original strike, and
- Chooser options which allow the owner to choose between a 9-month call or put option three months down the line.
Monte Carlo Simulation & risk exposure for fuel oil hedging
The fuel oil hedging is two cases rolled up in one. The first deals with the question of fuel expense volatility for an airline (easily extendable to logistics and supply chain businesses). The second deals with the inventory write down issues faced by refineries on fuel stock and processed supplied in storage and in pipelines.
My love affair with Monte Carlo Simulation – Switching out the Normal Distribution
A simulation is an experiment, and a MC simulator may be considered a machine that can churn out a series of experiments. The simulator will behave in a certain fashion (i.e. produce symmetric, asymmetric, normal and skewed, with thin tails or long fat tails) depending on the tool used to build the machine (i.e. the choice of distribution). By definition it will always be inaccurate and an approximation to the real world.
The basic Monte Carlo Simulation course package has now been updated to include:
- Simulated prices generated using Black Schole’s Terminal Price formula St=S0*exp[(r-q-0.5?2)t+??tzt]
- Random numbers, zts, obtained by normally scaling Excel’s RAND() function NORMINV(RAND())
- A path of prices, St, for 10 time steps, up to and including the Terminal price, ST
- Terminal Prices for 25 different scenarios using Excel’s DATA Table functionality
- Average Terminal Price across the 25 scenarios
What are the prerequisites?
- Computational Finance: Building Monte Carlo (MC) Simulators in Excel
- Monte Carlo Simulator with Historical Returns
- Monte Carlo Simulation – Variance Reduction procedures: Antithetic Variable Technique & Quasi Random sequences
- Convergence and Variance Reduction Techniques for Option Pricing Models
What are some applications of Monte Carlo simulations that I will learn about in this course?
In the next stage we consider Monte Carlo simulation applications:
- Interest rate modeling
- Option pricing
- Understanding elements of the Black Scholes formula
- Calculation of Value at Risk
- Pricing Ladder Options using a Monte Carlo simulator
- Pricing Exotic Options – Asian, Look backs, Barriers, Choosers
- Delta Hedging Applications
What are the additional topics I can read up on?
- Option pricing using Binomial Trees
- Derivative products
- What is N(d1) and how is it different from N(d2)?
- Interest Rate Simulation Crash Course
- The Refinery Case study – Session Transcript
- Jet Fuel Aviation Hedge Case Study
- Fuel Hedge model
- Cox-Ingersoll-Ross (CIR) Interest Rate model – EXCEL example
- Calculating VaR for Futures and Options – EXCEL
- Exotic Option Pricing using Monte Carlo Simulation
- Monte Carlo Simulation – Models and Applications
- Monte Carlo Simulation – Commodity – Example
- Monte Carlo Simulation – Currency – Example
- Monte Carlo Simulation – Equity – Example
- Monte Carlo Simulator with Historical Returns
- Monte Carlo Simulation with Option Pricing – Package
- Monte Carlo Simulation – Package
- Monte Carlo Simulation – Variance Reduction Procedures – EXCEL Examples
- Pricing Ladder Options using a Monte Carlo Simulator
- Understanding N(d1) & N(d2) – EXCEL Example
- Value at Risk using the Monte Carlo simulation with Historical Returns approach