Aug
26

## Nelson Siegel interest rate model calibration

Often we need to model the yield curve for bond pricing and risk analysis purpose, for instance,

The valuation of products requires the modelling of the entire covariance structure. Historical estimation of such large covariance matrices is statistically not tractable anymore.

Need strong structure to be imposed on the co-movements of financial quantities of interest.

Specify the dynamics of a small number of variables (e.g. PCA).

Correlation structure among observable quantities can now be obtained analytically or numerically.

Simultaneous pricing of dierent options and hedging instruments in a consistent framework.

There are dozens of interest rate models used by practioners, Nelson-Siegel term structure model is one of them gained popularity. here is a spreedsheet showing how to fit Extended Nelson Siegel Spot Rate with Solver.

http://janroman.dhis.org/

http://janroman.dhis.org/finance/Excel/NelsonSiegelYieldCurveModel.xls

wiki(Nelson-Siegel)

Hot posts:

15 Incredibly Stupid Ways People Made Their Millions

Online stock practice

Ino.com: Don't Join Marketclub until You Read This MarketClub Reviews

World Changing Mathematical Discoveries

Value at Risk xls

Random posts:

wavelet analysis

Friday reading list 22/01/2010

Google Quant Staff

Black Litterman Model (I)

OLS Regression with missing values

The valuation of products requires the modelling of the entire covariance structure. Historical estimation of such large covariance matrices is statistically not tractable anymore.

Need strong structure to be imposed on the co-movements of financial quantities of interest.

Specify the dynamics of a small number of variables (e.g. PCA).

Correlation structure among observable quantities can now be obtained analytically or numerically.

Simultaneous pricing of dierent options and hedging instruments in a consistent framework.

There are dozens of interest rate models used by practioners, Nelson-Siegel term structure model is one of them gained popularity. here is a spreedsheet showing how to fit Extended Nelson Siegel Spot Rate with Solver.

http://janroman.dhis.org/

http://janroman.dhis.org/finance/Excel/NelsonSiegelYieldCurveModel.xls

wiki(Nelson-Siegel)

**People viewing this post also viewed:**

Hot posts:

Random posts:

Satiishh

2010/12/03 04:53 [Add/Edit reply] [Clear reply] [Del comment] [Block]

Find the spot rate uptill nest coupon using Nelson-Siegel Model when settlement date is 15th March 2003 & nest coupon is 23rd September 2003, Beta0=8, Beta 1=-1.85,Beta2=-4 and tau = 15.

Pages: 1/1 1