Login  Register

Re: floating rate bond pricing on excel using quantlib

Posted by John O'Sullivan on Apr 26, 2017; 1:57pm
URL: http://quantlib.414.s1.nabble.com/floating-rate-bond-pricing-on-excel-using-quantlib-tp18225p18227.html

Silvia: have you tried calling ohRangeRetrieveError with the reference of the erroring cell as a paramter? That will give you a more detailed error message.

On 26 April 2017 at 14:16, Silvia Buttarazzi <[hidden email]> wrote:
BootstrapCurvaEonia&Swap6M&GvTItalia&PricingEngines.xlsx
<http://quantlib.10058.n7.nabble.com/file/n18225/BootstrapCurvaEonia%26Swap6M%26GvTItalia%26PricingEngines.xlsx>
Hi,
I'm trying to price a plain floating rate bond (namely a CCT€) using the
quantlib functions developed for excel (please see attached file, sheet
12.BondTassoVariabile)
Unfortunately, the qlBondCleanPrice is always returning #NUM! although I
think I set the needed parameters.
Could you please help me in understanding where I get wrong? Thank you very
much indeed.
Moreover I would like to know if you could suggest a different way to price
a floating rate bond. I was trying to use the function CCTE but stil I'm not
able to get a price.
I look forward to hearing from you.
Many thanks in advance for your help.

Silvia








. BootstrapCurvaEonia&Swap6M&GvTItalia&PricingEngines.xlsx
<http://quantlib.10058.n7.nabble.com/file/n18225/BootstrapCurvaEonia%26Swap6M%26GvTItalia%26PricingEngines.xlsx>




--
View this message in context: http://quantlib.10058.n7.nabble.com/floating-rate-bond-pricing-on-excel-using-quantlib-tp18225.html
Sent from the quantlib-users mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users