qlXibor and defining floating rates other Euribor in QuantlibXL

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

qlXibor and defining floating rates other Euribor in QuantlibXL

Wilkie Lai
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 


Reply | Threaded
Open this post in threaded view
|

Re: qlXibor and defining floating rates other Euribor in QuantlibXL

Manzoni Katiuscia
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
>