Curve building example

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

Curve building example

Jacopo.Zani

Hi all,
            I have just installed QuantlibAddin (both Release and Debug version) on py PC....I would like to begin to build discount factors curve from Depo-Swaps-Futures.

I am using an Excel Workbook (in the examples) named YC_SwapDemo.xls. I tried to build different curves using a lower number of instruments than the default (6 Futures instead 12 and 10 Swaps).

The creation of the cruve is successful but the function qlgetdf which gives out the discount factor for a given date, does not work. It gives out a #NUM error message in Excel.
Does anybody have a feedback on this problem?

Do the curve framework work with a fixed number of instrument only?

Regards

Jacopo

-----------------------------------------------------------------------------
Il presente messaggio di posta elettronica  non  comporta alcun vincolo e non
crea obblighi, salvo che ciĆ² non sia espressamente previsto da un preventivo
accordo scritto. Tale  messaggio e' confidenziale. qualora lo avesse ricevuto
per errore, La  preghiamo di  comunicarne la ricezione inviando una e-mail al
mittente e di distruggerne il contenuto. La informiamo inoltre che l'utilizzo
non autorizzato del messaggio o  dei suoi allegati potrebbe costituire reato.
La ringraziamo per la collaborazione.

This  e-mail  message does not imply  or cause  any obligation,  unless it is
provided  by a previous written  agreement.  This message is confidential: if
you  have  received  it  by mistake, please  advise immediately the sender by
e-mail  and destroy the message and its attachments.  You are hereby notified
that any  unauthorized  use  of the content of this message could  constitute
a criminal offence. Thank you.
-----------------------------------------------------------------------------
Reply | Threaded
Open this post in threaded view
|

Re: Curve building example

eric ehlers
Hi Jacopo,

> The creation of the cruve is successful but the function qlgetdf which gives
> out the discount factor for a given date, does not work.

This means that the creation of the yield curve object succeeded but
subsequent bootstrapping of the yield curve failed.

> It gives out a #NUM error message in Excel.

Any time a QuantLibAddin formula returns #NUM a corresponding error
message is written to the log file so you should have a look there for
more info.

> Do the curve framework work with a fixed number of instrument only?

No an arbitrary number of inputs is supported.

Regards,
Eric