Simulation, Pricing, Delta Hedging & Greeks Master Package – Finance training

A great value saving combination for practitioners and students. Includes every file from our package guides on Monte Carlo Simulation, Option Pricing, Delta Hedging, Interest Rate Simulations & IRS Pricing.

The master package includes 19 EXCEL templates and 8 handy PDF files.

A great deal for customers who wanted to buy the old subscription package that has now been discontinued.

Here are the details of the individual packages that have combined within this master package. If you need a component that is not here under the same special pricing, please let us know and we would be happy to creat a custom offer for you.

Monte Carlo Simulation with Option pricing

1.   Derivative Pricing

This course focuses on an alternative method of implementing a two-dimensional binomial tree compared to the traditional method of building a binomial tree in excel presented in most option pricing text books.The alternate approach is based on the techniques documented by Professor Mark Broadie at Columbia Business School as part of his coursework in Security Pricing and Computational Finance courses at Columbia University and allows us to extend a simple 3 step tree to a 50 – 100 step option pricing tree in a few minutes. It uses this alternative approach to price European & American calls and put options and Knock out and Knock in (Sudden Death) options.

2.   Monte Carlo Simulation – Models and Applications

The “Monte Carlo Simulation – Models and Applications” study guide includes topics on how to build Monte Carlo simulators in EXCEL and use these models to price vanilla and exotic options; how to calculate VaR for futures and options; an alternative approach to the original Monte Carlo simulator using historical returns rather than normally distribution returns and the impact of this approach on VaR numbers; fuel hedging risk management case studies; further applications like simulating interest rate term structures and forecasting the monetary policy rate.

The Monte Carlo Simulation with Option pricing package guide also includes the following EXCEL files:

  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.

Interest Rate Simulation

The PDF file covers:

  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

EXCEL files included:

Hedging Higher Order Greek

The course provides 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 is EXCEL based and uses the Solver functionality. The course discusses the setting and purpose of the objective function and constraints. It explains the results in light of various objectives including lower cost, minimization of gamma & vega, etc.

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. Tweaks to the base model are discussed to show how results are impacted when constraints and objectives are changed. Constraint redundancy and portfolio allocation limits are also considered.

The package consists of a PDF course and supporting EXCEL file containing the model.

Constructing Volatility Surfaces in EXCEL

A volatility surface plots market consistent volatilities across moneyness (strike prices) and maturity (time to expiry). Within the surface market consistent volatilities are referred to as local volatilities.  Rather than backing out volatility by applying the Black Scholes model in reverse to at the money options, local volatilities use implied volatilities and a one factor Black Scholes model to drive local volatility values across the surface.

Volatility surfaces, like Option Greeks, are among the last topics that get covered in a graduate level course on option pricing. Most schools and professors give it a wide berth in undergraduate and graduate level courses since it is based on an advance practitioner level understanding of the subject. While the topic may get some coverage in a level I course, a level II or level III course is what you need to enroll into to finally build the surface.

If you are familiar with Black Scholes equation and pricing models used for pricing European options, calibrating volatility surfaces is one of the tweaks market practitioners use to side step the constant volatility assumption.

The volatility surface package includes the following:

Delta Hedging Greeks – EXCEL

This product contains 3 EXCEL files.

1. Greeks

2. Delta Hedging – Call Option

3. Delta Hedging – Put Option

Pricing Interest Rate Swaps & Options

Topics 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 EXCEL files:


Tag : Simulation, Pricing, Delta Hedging & Greeks Master Package – Finance training Review. Simulation, Pricing, Delta Hedging & Greeks Master Package – Finance training download. Simulation, Pricing, Delta Hedging & Greeks Master Package – Finance training discount.  delta hedging formula. dynamic delta hedging. delta hedging pdf. delta neutral hedging example. delta hedge calculator. delta hedging excel spreadsheets.

Original Content