Hi again,
I've searched old postings and found the following.
>>
On Wed, Mar 3, 2010 at 9:09 AM, Yang Ye <leafyoung@...> 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
>>
So obviously someone started the discussion, but seems that it never concluded.
FYI, my Excel 2003 is SP3 (11.8169.8221) and still comes back with 0 NPV.
I've tried Excel 2000 and it works fine.
Thanks.
- Hyung
On Wed, Feb 29, 2012 at 9:35 AM, Hyung-Seok Hahm
<[hidden email]> wrote:
Hi all,
Quick question.
I've installed a brand new QunatLibXL - ver 1.1.0 on my windows and run Option.xls, one of Stand Alone Examples.
The weird behavior is that the function, qlInstrumentNPV returns a right number in Excel 2007, but always returns 0 in Excel 2003.
I've tried this a number of times on different machines, so I'm pretty sure it's an Excel version problem.
Appreciate if anyone shares how to deal with this.
Thanks.
- Hyung
--
Hyungseok Hahm, PhD, FRM
Quantitative Analyst
Industrial Bank of Korea
Trading Department
Tel : 82-2-729-7081
Fax : 82-2-729-6084
E-mail : [hidden email]
Yahoo Msn : hyungseok.hahm
Google Talk : hs.hahm.ibk[hidden email]
LinkedIn: http://kr.linkedin.com/pub/dir/Hyung-seok/Hahm
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Locked
