Hi Ed,
> I got Quantlib 0.9.7, but I am having some problems
>
> I first open QuantLibXL-vc80-mt-s-0_9_7.xll, then open standalone
> examples/InterestRateDerivatives.xls on office 2003. Then CTRL+ALT+F9 I17
> becomes NUM. I test xll by checking =qlVersion() which gives 0.9.7, thus
> that is loaded. I close InterestRateDerivatives.xls, reopen change rate in
> term structure worksheet, CTRL+ALT+F9 now I17 becomes VALUE, and if I
> close excel after his excel crashes. I tested this several times, error is
> repeatable.
>
> I will continue checking, but let me know if you have any ideas...
I just tried without success to recreate this error on Excel 2002. Will
try Excel 2003 tomorrow.
You sent your email on Sunday, that workbook is known not to work on a
non-business day and you have to set the evaluation date to a business day
with a call to qlSettingsSetEvaluationDate() - though it shouldn't crash
in any case. What happens if you run it now on a working day?
When you get the #NUM from cell I17 (in sheet Swaps I take it), what
message do you get from ohRangeRetrieveError()?
If the issue persists the next step is to recompile QuantLibXL from source
with the Debug configuration, then recreate the crash with the debugger
attached so that we get a stack trace. I'll do this if I manage to
recreate the error.
Thanks,
Eric
-------------------------
Eric Ehlers
nazcatech sprl | Brussels |
http://www.nazcatech.beDistributed computing for pricing analytics - Use Microsoft Excel as a
client to the Grid
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Locked
