QuantLibXL functions return #num

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

QuantLibXL functions return #num

tarpanelli@libero.it
Hello,
I am using the workbooks YieldCurveBootstrapping.
Initially, I loaded and updated it correctly.
Then I added another sheet to do some computations. At the beginning
everithing lloked ok but when I updated the workbooks once again the list of
values in column H and I  (those to show the date and data of the yield curve)
into the sheet "bootstrapping and cells F23, F25, F26 and F27, in the same
sheet, return an error "#NUM".

How can I solve it such that I can update the cells correctly?

thanks

Paolo

------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: QuantLibXL functions return #num

Ferdinando M. Ametrano-3
Hi Paolo

> I am using the workbooks YieldCurveBootstrapping.
> Initially, I loaded and updated it correctly.
> Then I added another sheet to do some computations.
> [...]
> and cells F23, F25, F26 and F27, in the same
> sheet, return an error "#NUM".
>
> How can I solve it such that I can update the cells correctly?

It would help if you specify which version are you using and attach
the workbook.

Beside to read the error message associated to (e.g.) cell F23 you can
use ohRangeretrieveError(F23): this can wonders compared with #NUM

Anyway I suggest you use the 1.0.1 release candidate available here:
http://sourceforge.net/projects/quantlib/files/prerelease/
If the problem persist with 1.0.1 send your modified workbook as
attachment and I'll take a look into it

ciao -- Nando

------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users