About the course.

There is a great value saving combination. The package guides include Monte Carlo Simulation, option pricing, Delta Hedging, Interest Rate Simulations and IRS Pricing.

There are 19 EXCEL templates and 8 PDF files in the master package.

The old subscription package that was discontinued was a great deal for customers.

The details of the individual packages are here. If you need a component that is not here under the same special pricing, please let us know and we would be happy to create a custom offer for you.

The Monte Carlo Simulation has option pricing.

1. Derivative pricing is a form of pricing.

The alternate approach is based on the techniques documented by Professor Mark Broadie at Columbia Business School. It uses an alternative approach to price European and American calls and put options.

2. Monte Carlo simulation has models and applications.

There are topics on how to build a Monte Carlo simulation in EXCEL, how to calculate VaR for futures and options, and an alternative approach to the original Monte Carlo simulation.

EXCEL files are included in the Monte Carlo Simulation with option pricing package guide.

1. The supporting excel file for the alternate binomial tree methodology for the products mentioned above
2. Option pricing using the Traditional Binomial Tree approach
3. Option pricing using the Black-Scholes option pricing formula
4. An example of how the Ladder call option may be priced using Monte Carlo Simulation in EXCEL (standalone Excel file)
5. 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.

Simulation of interest rate

The PDF file has some information.

1. Components of interest rate models
2. Features of good models
3. Criteria employed when selecting models
4. Differences between various types of term structure models
5. Estimation and calibration of parameters for, and construction of, the one-factor equilibrium Cox-Ingersoll-Ross (CIR) model
6. Construction and utilization of the one-factor no-arbitrage Black-Derman-Toy (BDT) model
7. Principal Component Analysis (PCA) for the determination of a workable number of components / factors for the Heath, Jarrow, Merton (HJM) model
8. Construction of the multi-factor no-arbitrage Heath-Jarrow-Merton (HJM) model

There are EXCEL files included.

• Zero Coupon and Forward rate term structures derivation and construction (pre-requisite)
• Calibration of a CIR Model’s parameters to a historical rates data set
• Construction of a BDT model
• Utilization of the results of a BDT model
• Principal Component Analysis
• Construction of a HJM 3-factor model

Hedging order higher.

The course gives a step by step guide on how to build a hedging model that considers hedging the higher order Greeks of the trader’s position. The model uses the Solver function. The objective function and constraints are discussed in the course. The results are explained in light of various objectives.

Two simplistic illustrations, one based on hedging a single short position, the other based on hedging a portfolio of short positions, walk the reader through the various elements of the model. When constraints and objectives are changed, there are changes to the base model. Portfolio allocation limits are also considered.

The package has a PDF course and a EXCEL file.

It is possible to construct Volatility Surfaces in EXCEL.

The volatility surface plots market volatilities across moneyness and maturity. Local volatilities are referred to as consistent volatilities within the surface market. Local volatilities use implied volatilities and a one factor Black Scholes model to drive local volatility values.

Option Greeks is one of the last topics covered in a graduate level course on option pricing. Since it is based on an advance level understanding of the subject, most schools and professors give it a wide berth in undergraduate and graduate level courses. If you want to build the surface, you need to enroll in a level II or level III course.

One of the changes market practitioners use to side step the constant volatility assumption is calibrating volatility surfaces.

The package includes the following.

• A 30 page PDF guide that shows how to build a volatility surface step by step in EXCEL using Dupire’s formula.
• An EXCEL spreadsheet that is used as a simple teaching template by the PDF tutorial above. The Excel sheet shows the implementation of Dupire’s formula as well as the resultant volatility surface. The sheet also shows Taleb’s implementation of implied forward volatility using term structure of volatility concepts.

Delta Hedging Greeks.

There are 3 EXCEL files in this product.

1. Greeks

• Calculation of the Black Scholes option price for a European Call and a European Put option
• Calculation of Greeks- Delta, Gamma, Vega, Theta & Rho- for a European Call and a European Put option
• Data table that captures the Black Scholes risk adjusted probabilities and option premium across a series of volatilities
• Graphical representation of Black Scholes risk adjusted probabilities and option premium against volatilities
• Data tables that capture the sensitivity of the Greeks against Spot, Strike, Time to maturity, Volatility and the Risk Free Rate respectively
• Graphical representation of the sensitivities of the various Greeks against Spot, Strike, Time to maturity, volatility and risk free rate respectively

2. Delta Hedging has a call option.

• Calculation of a 12-step Monte Carlo simulation model that generates the underlying stock price series
• Calculation of theoretical option values using the Black Scholes call option price formula
• Calculation of call option deltas at each rebalancing interval
• Calculation of a replicating portfolio that consists of a long position in Delta times the stock and a short position in the amount borrowed (net of the option premium received at inception) to fund the initial & subsequent incremental purchases
• Graphical representation of the theoretical option value and the replicating portfolio value over the life of the option
• Calculation of a tracking error for the difference between the value of the replicating portfolio and the theoretical value of the option
• Graphical representation of the tracking error across the life of the option
• Determination of the per period interest and principal portions of the amount borrowed
• Determination of the Gain (Loss) on sale of portions of the stock
• Setting up a Cash Accounting P&L that shows cash inflows from option premium received and strike received in the event the option is exercise and cash outflows from interest and principal repayment on the amount borrowed
• A choice of including of excluding the option premium in determining the amount borrowed at inception. In this case the Principal repaid will equal the gain (loss) if the option is not exercised.
• 100 simulated runs including a graphical depiction of the results showing the Net P&L, Amount borrowed (principal & interest) and Gain/ Losses; and averages across the 100 runs for each of these items

3. Delta Hedging has a put option.

• Calculation of a 12-step Monte Carlo simulation model that generates the underlying stock price series
• Calculation of theoretical option values using the Black Scholes put option price formula
• Calculation of put option deltas at each rebalancing interval
• Calculation of a replicating portfolio that consists of a short sale of Delta times the stock and lending of the initial (net of the option premium received at inception) & subsequent incremental short sales proceeds
• Graphical representation of the theoretical option value and the replicating portfolio value over the life of the option
• Calculation of a tracking error for the difference between the value of the replicating portfolio and the theoretical value of the option
• Graphical representation of the tracking error across the life of the option
• Determination of the per period interest and principal portions of the amount lent
• Determination of the Gain (Loss) on closing of short sale positions
• Setting up a Cash Accounting P&L that shows cash inflows from option premium received, interest earned on amount lent and sales proceeds from short sales and cash outflows from strike paid if the option is exercised
• A choice of including or excluding the option premium in determining the amount borrowed at inception. In this case the sales proceeds from short sales will equal the gain (loss) if the option is not exercised.
• 100 simulated runs including a graphical depiction of the results showing the Net P&L, Proceeds from Short Sales, Interest Earned and Gain/ Losses; and averages across the 100 runs for each of these items

There are interest rate swaps and options.

Topics are covered.

1. Definition of different types of interest rates
2. Overview of swap contract variations
3. Summary of the pricing process for interest rate swaps
4. Step-by-step methodology for deriving zero coupon and forward rate term structures
5. Step-by-step procedures for determining the price of interest rate swaps, Cross currency swaps,Interest rate options

The files are in excel.

• The calculation of zero coupon and forward rate curves from the par term structure
• The calculation of prices of interest rate swaps and cross currency swaps
• The calculation of prices of interest rate options