April 8th, 2008, 1:03 am
Yes, it does. Basically Part II, chapters 5 through 16 revolve around excel sheets and libraries. That includes binomial lattice of discount bonds, fra, swaps, swaptions as well as trinomial lattice for H-W and B-K. It's all in the table of contents. Full disclosure that I studied under one of the authors. Code is in-depth and contains a full numerical library of math/stats functions which, after getting used to, greatly enhances the ability of VBA/Excel to do some powerful math stuff way more efficiently than I ever could. Spreadsheets are used as the GUI with VBA doing all the work (the numerical libraries doing the heavy lifting mostly via matrices). With the numerical libraries, its a bit different from regular macros you may be used to.