QuantLibXL-what is going on?

Posted by JURAJ HUSKA on
URL: http://quantlib.414.s1.nabble.com/QuantLibXL-what-is-going-on-tp779p781.html

Hello Team,

I tried to use QuantLibXL to build a vanilla swap object.  I defined the fixed and floating schedules, discount curve, etc. and passed it to qlVanillaSwap function.It seems that I created the object but then when I called related functions such as qlVanillaSwapFairRate I never was able to get a result (I got #NUM error, the log file said "empty object handle cannot be dereferenced"). Interestingly, some functions (e.g. qlVanillaSwapNominal) worked for the same object. It seems that only those functions which needed to calculate something returned an error.
Is there anything I need to understand in the architecture of QuantLibXL to get this right? (I tried deleting all objects and some other stuff, nothing helped)

On a similar note: when I close the worksheet and open it again, none of the created objects (fixed leg schedule, discount curve etc.) comes to existence, they do only after I click the corresponding cell and hit enter (I checked this using  ohListObjectIDs and ohObjectCount. Does this make sense? (automatic or manual recalculation setting didn't make any difference here...)

Experts, please help.

Thank you,

Juraj

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users