Hi all,
1.) In calling qlXibor() from QuantlibXL I was unable to create the object successfully. I have all parameters lined up as defined except maybe for "TermStructureId". I am not sure if this should be a pre-created object, and for what purpose this is required. However if I put in a random "Test" string then all I got is a "#NUM!" error. 2.) In fact what I am trying is to create Xibor rates(or more generic floating rates) other than that of Euribor (which has been pre-built in 0.3.13). qlXibor() seems to be the place to start but if I am getting it all wrong can someone please point out what the right approach should be? Regards, Wilkie __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com |
Hi Wilkie,
in order to construct correcly a qlXibor object you need to provide an already existing term structure. For example you could have qlXibor("myXibor", "Usdibor", "2M", 2, "USD", "UnitedStates::NYSE", "Modified Following", "Actual/360", "UsdYieldCurve"), where the term structure UsdYieldCurve has been previously set up (using for example the function qlPiecewiseYieldCurve). The purpose of this parameter is to allow the calculation of forecasted fixings. qlXibor() is the right place to start if you aim to build Ibor- and Libor-like indexes in QLXL. Hope this helps. Regards, Katie On 8/29/06, Wilkie Lai <[hidden email]> wrote: > Hi all, > 1.) In calling qlXibor() from QuantlibXL I was unable > to create the object successfully. I have all > parameters lined up as defined except maybe for > "TermStructureId". I am not sure if this should be a > pre-created object, and for what purpose this is > required. However if I put in a random "Test" string > then all I got is a "#NUM!" error. > > 2.) In fact what I am trying is to create Xibor > rates(or more generic floating rates) other than that > of Euribor (which has been pre-built in 0.3.13). > qlXibor() seems to be the place to start but if I am > getting it all wrong can someone please point out what > the right approach should be? > > Regards, > Wilkie > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > QuantLib-users mailing list > [hidden email] > https://lists.sourceforge.net/lists/listinfo/quantlib-users > |
Free forum by Nabble | Edit this page |