QuantlibXL with Office 2003 Service Pack 3

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

QuantlibXL with Office 2003 Service Pack 3

Yang Ye
Hi,

We got a problem for functions returning double with Office 2003 SP3.
E.g.  function qlSmileSectionVolatility. Sometimes, it return just 0;
Sometimes, it return a very big number (negative/positive). We could
trace to

returnValue = ObjectIdLibObjPtr->volatility(
              StrikeCpp);
return &returnValue;

returnValue is still correct before return. But Excel displayed the
wrong number.

Thanks.

Regards,
Yang Ye

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: QuantlibXL with Office 2003 Service Pack 3

Ferdinando M. Ametrano-3
On Wed, Mar 3, 2010 at 9:09 AM, Yang Ye <[hidden email]> wrote:

> We got a problem for functions returning double with Office 2003 SP3.
> E.g.  function qlSmileSectionVolatility. Sometimes, it return just 0;
> Sometimes, it return a very big number (negative/positive). We could
> trace to
>
> returnValue = ObjectIdLibObjPtr->volatility(
>               StrikeCpp);
> return &returnValue;
>
> returnValue is still correct before return. But Excel displayed the
> wrong number.

this is the second report I receive about this kind of problem. what
version of Excel are you using?

An user wrote me about Excel 2003 (11.8169.8172) SP3 having the bug
while Excel 2003 (11.8237.8221) SP3 is working correctly.
I use Excel 2003 (11.8220.8202) SP3 and don't have this problem.

I googled around with no luck, I hope somebody more knowledgeable will help

ciao -- Nando

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users