Re: [Quantlib-users] Re: Quantlib-users digest, Vol 1 #521 - 5 msgs

[Ferdinando A. <na...@am...>]

Hi Theo,


>I am trying to work out how quantlibxl works. I have opened one of the 
>workbooks Blackscholes.xls. I noticed that cell B9 has value 
>qlEuropeanOption(A9,$B$1,$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,1) where its 
>passing all these cells parameter values.
>How does the spreadsheet know how to call qlEuropeanOption?
>I suppose there is a link to c++ dll somewhere.

have you installed the QuantLib addin QuantLibXL-vc71-mt-s-0_3_7.xll ?
In Excel select Tools | Addins then browse to locate 
QuantLibXL\xll\QuantLibXL-vc71-mt-s-0_3_7.xll on your hard disk.
Selecting the xll file you will be have it installed in Excel.

Now Excel should be able to call the function qlEuropeanOption which is 
provided in the QuantLibXL addin.

hope it helps

ciao -- Nando