# Review of Lattice Construction Methods

Just before year end we put out our paper, titled "Review of Lattice Construction Methods"! This paper extends the generalized procedure for building trees for short rates by Hull & White. A generalization for any mean and standard deviation of the underlying short rate model is presented. In addition we review the methodologies for constructing lattice models and give a step-by-step explanation on how to construct trinominal trees. We apply the formalism to some explicit examples of various complexity.

Full text can be found here

# Theta : A Test for Short Rate Model Lattice

While short rate models have lost ground to libor market models for valuation of (complex) interest rate derivatives, they remain popular for Asset and Liability Management. As a result you may find yourself implementing a short rate model. Often the choice is to implement a lattice approach, perhaps in combination with a Monte Carlo framework. One critical step in these models is to match the model discounts to the ones observed in the market. This makes to model (almost) arbitrage free. To match the market a numerical root finding algorithm needs to be used, for example Newton Raphson. This poses the challenge that mistakes in the model may not be obvious as the root finder can still find parameters to match the market even though there are mistakes in the model. Our suggestion is to check the root finder solution to known analytical solution of the Hull White model using functional form for the zero curve that is continuous and two times differentiable.

# Generalized Procedure for Building Short Rate Trees in Excel / VBA using LevmarExcel

In a previous we blog we reproduced example 1 of the  2014 paper John Hull and Alan White “Generalized Procedure for Building Short Rate Trees”. In the paper the authors derive a generalized method for the construction of short rate trees. This generalization is interesting as it allows for one tree (or lattice) construction algorithm for all one-factor short rate models. Continue reading

# Generalized Procedure for Building Short Rate Trees in Excel / VBA

In their 2014 paper John Hull and Alan White derive generalized method for the construction of short rate trees. This generalization is interesting as it allows for one tree (or lattice) construction algorithm for all one factor short rate models. The only difference between the various models is the function , which is explained briefly here and in detail in the paper. Continue reading

# Reproduction Example 1 of Generalized Procedure for Building Trees

In a recent (2014) paper John Hull and Alan White demonstrate a generalized method for the construction of short rate trees. Keen to understand the model we tried to reproduce the results of the first example mentioned in the paper on page 10. The example considers the short rate model:

which is transformed using