math finance is a blog on Quantitative finance code, quantitative methods in finance focusing on derivative pricing, quantitative trading and risk management, with featured entries:
Free real time stock quotes Neural network prediction
Binary Options Trading Elliott Wave Analysis

Bootstrapping interest rate curve

[Unknown 2008/09/08 15:49 | by abiao ]
Bootstrapping is a technique for building a zero-coupon yield curve from the prices of a set of coupon bonds through forward replacement.

Using these zero-coupon bonds we can deduce forward and spot rates for all time to maturities by making a couple of assumptions (including linear interpolation). The term structure of spot rates is recovered from the bond yields by solving for them recursively, this iterative process is called the BootStrap Method.

http://janroman.dhis.org/stud/Bootstrap_2006.xls shows how to implement Boostrapping method in Excel, more can be found at his website http://janroman.dhis.org/index_eng2.html.
Latest Quant jobs
Code » VBA/Excel | Comments(0) | Trackbacks(0) | Reads(10684)
Comments separate us from potatoes
Nickname
Password Optional
Site URI Optional
Email Optional
Enable HTML Enable UBB Enable Emots Hidden Remember