Bootstraping US Zero curve from Quantlib XL

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Bootstraping US Zero curve from Quantlib XL

imachabeli
I' trying to build US libor curve using XL addin.
I get stuck at the point when ql requires to create ratehelper for libor.
I used YC_SwapDemo.xls as sample. qlSwapRateHelper needs an object for fixed
leg.
For euro there are predefined object like "EURIBOR6M" that defaults in its
constructor to UK calendar. Is there any other way to create ratehelper and
termstructure or I have to add similar classes to US Libor?

_________________________________________________________________
Messenger Café — open for fun 24/7. Hot games, cool activities served daily.
Visit now. http://cafemessenger.com?ocid=TXT_TAGHM_AugHMtagline



-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: Bootstraping US Zero curve from Quantlib XL

Eric Ehlers-2
Hello,

> I' trying to build US libor curve using XL addin.
> I get stuck at the point when ql requires to create ratehelper for libor.
> I used YC_SwapDemo.xls as sample. qlSwapRateHelper needs an object for
> fixed
> leg.
> For euro there are predefined object like "EURIBOR6M" that defaults in its
> constructor to UK calendar. Is there any other way to create ratehelper
> and
> termstructure or I have to add similar classes to US Libor?

As you noted the enumerations are implemented only for EUR but you can use
function qlIborIndex() to create a USD index.  For an example of
bootstrapping a yield curve please see workbook
QuantLibXL\Workbooks\StandaloneExamples\MarketData.xls in the 0.8.0
release.  Note that

- A dummy index pointing to an empty yield curve is used as an input to
the rate helpers
- After the YC is bootstrapped a call is made to
qlSetEuriborTermStructure() which redirects all the enumerated indices to
the new term structure

You would need to make the following changes for USD:

- Create indices explicitly rather than using the enumerations "EURIBOR6M"
etc.
- As there is no USD equivalent for qlSetEuriborTermStructure() you would
instead have to create new USD index objects dependent on the TS

I've received email from others who followed this approach for USD and it
seemed to work.

Regards,
Eric


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users