quantlibxl

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

quantlibxl

Garrison Qian
Hi,
 
I installed QuantLibXL and loaded the addins (including framework), but when I open up standalone files, most of the calculation cells were shown as #NUM.  simple option one works.  did I miss anything?
 
thanks a lot,
Garrison


Looking for last minute shopping deals? Find them fast with Yahoo! Search.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users
Reply | Threaded
Open this post in threaded view
|

Re: quantlibxl

Eric Ehlers-2
Hi Garrison,

On Fri, March 14, 2008 6:32 pm, Garrison Qian wrote:
> Hi,
>
> I installed QuantLibXL and loaded the addins (including framework), but
> when I open up standalone files, most of the calculation cells were shown
> as #NUM.  simple option one works.  did I miss anything?
>
> thanks a lot,
> Garrison

Please try this:
- start Excel
- open QuantLibXL-0.9.0\xll\QuantLibXL-vc80-mt-s-0_9_0.xll
- open
QuantLibXL-0.9.0\Workbooks\StandaloneExamples\InterestRateDerivatives.xls
- Hit Ctrl-Alt-F9

What happens when you follow the steps above?  Does the workbook
recalculate correctly?  For example do you see a PV in cell
=[InterestRateDerivatives.xls]Swaps!$I$17 ?

Thanks,
Eric



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users