WebCab XL Community Edition

EuropeanEvaluation.CallOnIndex Method (Double, Double, Double, Double, Double, DateTime, DateTime, String)

Evaluates the value of a European call option on an index (for example the SP500 (US), FTSE100 (UK)).

public double CallOnIndex(
   double Yield,
   double IndexValue,
   double Strike,
   double RiskFreeRate,
   double Volatility,
   DateTime EvaluationDate,
   DateTime MaturityDate,
   string CalendarName
);

Parameters

Yield
The average yield of the contingents of the index given in decimal format (i.e. 1 percent = 0.01).
IndexValue
The value of the index on which the option is based.
Strike
The value of the index which is take as the strike of the option.
RiskFreeRate
The continuously compounded risk free interest rate expressed in decimal format (i.e. 1 percent = 0.01).
Volatility
The volatility of the index given in decimal format (i.e. 1 percent = 0.01).
EvaluationDate
The evaluation date of the option.
MaturityDate
The date when the option contract matures.
CalendarName
(Optional) The name of one of the implemented business calendars, "London" by default.

Remarks

Remark: We approximate the dividends paid by the components of the index by a continuous yield which is a reasonable assumption in many cases. However, if the capitalization of the index is concentrated around a relatively few number of assets then this approach may lead to mis-leading results. In this instance the method callWithDividends should be used with the underlying asset being taken as the index and the dividends considered being the dividends in the components of the constituents of the index.

Excel Remarks

The full name of this function inside Excel is Option_EuropeanEvaluation_CallOnIndex.

See Also

EuropeanEvaluation Class | Options Namespace | EuropeanEvaluation.CallOnIndex Overload List