QuantlibXL - qlZeroCurve

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

QuantlibXL - qlZeroCurve

Circo Giuseppe (DAM)
Hi all,
 
I'm using the QlXL function "qlZeroCurve" to input zero coupon swap
rates to QL, but from my analysis I think that the function qlZeroCurve
assumes informed rates as continuously compounded. Is there any way to
inform QL that the rates are under another compounding type?
I know I could use discount factors (qlDiscountCurve) to avoid that but
as I am doing sensitivity analysis by adding spreads to my zero rates I
would like to avoid this double manipulation,
any help is welcome,
Ciao,


-------------------------------------------------------------------------
My e-mail address has been harmonized into @dexia.com !
Please remember to update your contact list.

Veuillez noter que mon adresse e-mail est harmonisée en @dexia.com !
N'oubliez pas de mettre à jour votre liste de contacts.

Meine E-Mailadresse wurde harmonisiert zu @dexia.com
Vergessen Sie nicht Ihre Kontaktadresse anzupassen.

Mijn e-mailadres is geharmoniseerd naar @dexia.com.
Vergeet niet uw contactenlijst aan te passen.
-------------------------------------------------------------------------
Dexia disclaimer:
http://www.dexia.com/maildisclaimer.htm
-------------------------------------------------------------------------
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: QuantlibXL - qlZeroCurve

Ferdinando M. Ametrano-3
On Tue, Jan 26, 2010 at 2:04 PM, Circo Giuseppe (DAM)
<[hidden email]> wrote:
> I'm using the QlXL function "qlZeroCurve" to input zero coupon swap
> rates to QL, but from my analysis I think that the function qlZeroCurve
> assumes informed rates as continuously compounded. Is there any way to
> inform QL that the rates are under another compounding type?

no, those zeros have to be continuously compounded.

Anyway it's high on my priority list to add support for simple
compounding zeros, just because it's one of the choice Bloomberg has
implemented... stay tuned

ciao -- Nando

------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users