VBA example doesn't work!

Posted by Maury Markowitz on
URL: http://quantlib.414.s1.nabble.com/VBA-example-doesn-t-work-tp5707.html

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