Posted by
Andrew Downes on
URL: http://quantlib.414.s1.nabble.com/quantlibXL-avoiding-full-calculation-Ctrl-Alt-F9-tp7411p7413.html
Hi,
I think the reason you need to do this is dependencies - Excel doesn't
evaluate cells in the correct order so is missing some information when
it comes to evaluate some cells. You can evaluate them in the correct
order by hand, but I usually use Ctrl-Alt-F9 to save time.
Cheers,
Andrew
>Institutional Portfolio Management
>Australia and New Zealand Banking Group Limited
>18/100 Queen St, Melbourne, 3000
>phone: +61 (0)3 9273 6542
-----Original Message-----
From:
[hidden email] [mailto:
[hidden email]]
Sent: Wednesday, 7 April 2010 7:09 PM
To: quantlib-users
Subject: [Quantlib-users] quantlibXL: avoiding full calculation
Ctrl-Alt-F9
Hi, I'm a newbie of QuantlibXL e probably this is a stupid question... I
wrote my first file simply mimicking a quantlibXL example (BS europ
option), but every time I open Excel, I must do a full calculation
(Ctrl-Alt-F9), otherwise the quantlibXL functions give me #NUM! or
#VALUE... Why? Is it possible to avoid this?
Thx a lot
Stefano
"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."
------------------------------------------------------------------------------
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