VBA example doesn't work!

[Maury Markowitz]

I'm trying to bootstrap myself in QL/VBA. I started with the example I found here:

http://www.quantlibaddin.org/serialization.html

Practically every line of this example has a problem that prevents it from working. The blackVolHandle= leaves out the "TARGET" parameter, exerciseHandle has a date that doesn't work, and engineHandle is missing the process handle parameter. I still can't get this working:

npv = Application.Run("qlInstrumentNPV", optionHandle)

Is there ANY documentation that I can use to see the parameters? Even the function builder inside Excel is only semi-useful, consisting largely of descriptions that are simply the parameter name! Since every single problem returns a Type 13 error, without some sort of mapping it seems I will spend the rest of my life attempting to figure out inputs!

Maury

[Eric Ehlers-2]

Hi Maury,

> I'm trying to bootstrap myself in QL/VBA. I started with the example I
> found
> here:
>
> http://www.quantlibaddin.org/serialization.html

I believe the page you're working from is actually this one:

http://www.quantlibaddin.org/faq.html

Because of the way in which the quantlibaddin.org domain name is
forwarded, the value in the address bar is not updated as you browse the
site.

> Practically every line of this example has a problem that prevents it from
> working. The blackVolHandle= leaves out the "TARGET" parameter,
> exerciseHandle has a date that doesn't work, and engineHandle is missing
> the
> process handle parameter. I still can't get this working:
>
> npv = Application.Run("qlInstrumentNPV", optionHandle)

That example was out of date, I have just fixed it and I apologize for the
frustration caused.

> Is there ANY documentation that I can use to see the parameters? Even the
> function builder inside Excel is only semi-useful, consisting largely of
> descriptions that are simply the parameter name! Since every single
> problem
> returns a Type 13 error, without some sort of mapping it seems I will
> spend
> the rest of my life attempting to figure out inputs!

The functions are documented at this link:

http://www.quantlibxl.org/auto/all_functions.html

Regards,
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