|
From: rohan t. <rot...@ya...> - 2021-06-17 04:05:14
|
HiI am following up on this - Are there any users of the xl version ? I note the May2021 update of the XL wrapper has removed some deprecated functions/classes: Release 1.22.0 - May 2021 - Deleted obsolete classes FDAmericanEngine, FDEuropeanEngine, FDBermudanEngine There appear no forums using the XL version, and all discussions are around Python in the main in a developer theme. Does anyone have any views ? Kind regardsRohan ----- Forwarded message ----- From: rohan talwar <rot...@ya...>To: qua...@li... <qua...@li...>Sent: Thursday, 3 June 2021, 11:31:53 GMT+10Subject: American option, discrete dividends HiI hope all are well, and thanks in advance for any help provided. Is anyone able to tell me how to determine appropriate dependencies for the XL implementation, when trying to value a single option on equity. I attach the option.xls (*_rt.xls) which comes in the standalone worksheets, and I have set up a parallel option (on RIO as the case may be). I was aiming to do FD to bump inputs (Perturb is the language often used her I think I recall) and establish risk sensitivities. I am pointing the pricing engine to "AEQPB", However, I get wrong engine, but little else, as the process to establish the pricing engine returns ok, even when providing an american exercise type. I am using ver 1.21, on excel ver 2105, 365 apps for enterprise. ObjectHandler::PricingEngineConstructor2 | String | Class | | AEQPB | QuantLib::AdditiveEQPBinomialTree | | CRR | QuantLib::CoxRossRubinstein | | JOSHI | QuantLib::Joshi4 | | JR | QuantLib::JarrowRudd | | LR | QuantLib::LeisenReimer | | TIAN | QuantLib::Tian | | TRI | QuantLib::Trigeorgis | Kind regardsRohan |