Hi Mitul,
I think that the problem in your spreadsheet is in the evaluation date.
In fact the evaluation date is set to 06/01/10 and the futures that you are using are the one between 21/12/16 (U6) and 20/09/18 (M8), that is between 6Y and 9Y swaps.
The bootstrap fails because futures and swaps quotes are really different, 0.73% for the first futures (pillar date 21/12/16) against 3.027% for 7 years swaps (pillar date 09/01/17).
If you try to set evaluation date to today, the bootstrap succeed.
Hope this help.
Regards,
Paolo
Hello Mitul,I don't seem to be able to open the spreadsheet. May you just post the rates as text?
Thanks,Luigi
On Tue, Aug 30, 2016 at 10:41 PM Mitul Patel <[hidden email]> wrote:
------------------------------Hi,
I am a relatively new user to QLib XL. I am getting the following error when trying to bootstrap a rate curve as per the attached spreadsheet (cells E83 to E105).
'qlPiecewiseYieldCurveData - 1st iteration: failed at 12th alive instrument, maturity January 8th, 2018, reference date January 6th, 2010: root not bracketed: f[0.780492,0.866129] -> [9.956026e-004,1.327038e-002]'
The error seems to be caused by the 8y swap - removing that item from the curve construction does indeed get around this error.
I have read that it could be caused by the Loglinear interpolation, but changing to Linear did not change the outcome in this example. Also the error obtained is from an old version of Quantlib XL, so am not sure if the issue is resolved by a later version. Would be grateful for any guidance on this issue.
Many thanks,
Mitul
------------------------------ ------------------
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Free forum by Nabble | Disable Popup Ads | Edit this page |