Excel VBA codes for "An Efficient Lattice Search Algorithm for the Early Exercise Boundary in American Options"

Brian Byrne · Data Archiving and Networked Services (DANS) · 2019

This file provides Excel VBA codes of accelerated CRR binomial models: 1. “CRR_Conventional” model represents a two-dimensional static CRR binomial tree and does not apply any lattice search or acceleration techniques. 2. “CRR_Dynamic” model employs a one-dimensional dynamic tree. 3. “CRR_Dyn_Boundary” model augments the dynamic binomial tree using the intelligent lattice search algorithm. 4. “CRR_Dyn_Bound_Truncation” model is the most accelerated binomial model which comprehensively applies efficient lattice search, dynamic memory and truncation techniques.

Read the paper · More papers on PaperTik