WebCab XL Community Edition

Options Namespace

Classes

ClassDescription
BinaryOptions This XL Service evaluates the pay-off from a Binary option at expiry.
EuropeanDelta Within this XL Service we consider the evaluation of the Delta of European options on equities, equity indexes, currencies and futures contracts in accordance with the classical Black-Scholes model.
EuropeanEvaluation Within this XL Service we consider the evaluation of the present value of European options on equities, equity indexes, currencies and futures contracts in accordance with the Black-Scholes model.
EuropeanGamma Within this XL Service we consider the evaluation of the Gamma of European options on equities, equity indexes, currencies and futures contracts in accordance with the classical Black-Scholes model.
EuropeanRho Within this XL Service we consider the evaluation of the Rho of European options on equities, equity indexes, currencies and futures contracts in accordance with the classical Black-Scholes model.
EuropeanTheta Within this XL Service we consider the evaluation of the Theta of a European option on equities, equity indexes, currencies and future contracts in accordance with the classical Black-Scholes model.
EuropeanVega Within this XL Service we consider the evaluation of the Vega of a European option on equities, equity indexes, currencies and future contracts in accordance with the classical Black-Scholes model.
ImpliedVolatility This XL Service calculates the implied volatility for a given European (call or put) option.
OptionStrategies This XL Service evaluates the payoff functions of a number of different option trading strategies.
PutCallParity Within this XL Service we implement put-call parity relations for:
  1. Vanilla Options where the underlying asset does not pay dividends
  2. Vanilla options where the underlying asset pays a continuous dividend
  3. Binary Options where the underlying asset does not pay dividends
.
Volatility This XL Service consists of a collection of methods for estimating and rescaling the volatility.