Posted by
Wilkie Lai on
URL: http://quantlib.414.s1.nabble.com/QuantlibXL-multiple-calls-to-qlSetEvaluationDate-tp5043.html
Hi Eric and all,
1.) I have experienced strange behavior with
qlSetEvaluationDate(). As I read from the
documentation there is only one global setting for
this variable in Excel so I would assume that once a
call to this function has been made, the evaluation
date will remain the same unless a different parameter
is passed to it. However I have come to notice that
with multiple calls to this function it actually set
the global date to another date, seems like a
hard-coded one: 2005/06/18. Can anyone share what is
going on behind the scene?
2.) Now because of this change in evaluation date I am
forced to do global recalculate (Ctrl-Alt-Shift F9,
usual Ctrl-Alt-F9 don't work) in order to fix the
date, but after multiple calls (usually 3-4 times)
then Excel will crash, pointing again to the XLL
library. Would this be a bug or there are other ways
to change/restate the evaluation date?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com