[QuantLibXL] qlVanillaSwap pricing

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

[QuantLibXL] qlVanillaSwap pricing

Matteo Castagna
I'm returned the following error while trying to get the NPV
 
ERROR - qlNPV - '[SwapPricing A.xls]Sheet1'!$G$26 - null term structure
set to par coupon
 
I saw a qlSetEuriborStructure(termStructure) is used in the example
spreadsheet and this rings a bell: nevertheless I'm trying to price a
non-EUR swap so I'm not sure this funcition should be used; on top of
this I'd like to price the same swap using more than one curve defined
on the same spreadsheet: using the same "Xibor" structure wouldn't cut
it, I guess.
Thanks. Matteo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://sourceforge.net/mailarchive/forum.php?forum=quantlib-users/attachments/20061222/87cd663a/attachment.html 

Reply | Threaded
Open this post in threaded view
|

Re: [QuantLibXL] qlVanillaSwap pricing

Matteo Castagna
Sorted out this one as well: just refer to the term structure object
while defining the Xibor index and all works.

________________________________

From: Matteo Castagna
Sent: 22 December 2006 15:53
To: '[hidden email]'
Subject: [QuantLibXL] qlVanillaSwap pricing


I'm returned the following error while trying to get the NPV
 
ERROR - qlNPV - '[SwapPricing A.xls]Sheet1'!$G$26 - null term structure
set to par coupon
 
I saw a qlSetEuriborStructure(termStructure) is used in the example
spreadsheet and this rings a bell: nevertheless I'm trying to price a
non-EUR swap so I'm not sure this funcition should be used; on top of
this I'd like to price the same swap using more than one curve defined
on the same spreadsheet: using the same "Xibor" structure wouldn't cut
it, I guess.
Thanks. Matteo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://sourceforge.net/mailarchive/forum.php?forum=quantlib-users/attachments/20061228/3815be5d/attachment.html