Strange ZeroYields in QuanLibXL

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Strange ZeroYields in QuanLibXL

CH69
Hello,

I am using the yield curve bootstrapping example spreadsheet. I am looking at only swap rates to compute the zeroyield curve.

First off: If in the 30Y swap in the RateHelpers tab you put 13.1% you'll get NUM errors.
Second: The zero yields being produced are wrong.

Can you please tell me what I am doing incorrectly but I have gone thorough this a few times and now stuck. Thanks!

YieldCurveBootstrapping+TEST.xls