WebCab XL Community Edition

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

Calculates the present value in accordance with the Black-Scholes model of a European put option on an investment asset which does not make any cash payments to holders (such as dividends, coupons or interest payments).

public double Put(
   double StockPrice,
   double Strike,
   double RiskFreeRate,
   double Volatility,
   DateTime EvaluationDate,
   DateTime MaturityDate,
   string CalendarName
);

Parameters

StockPrice
The present price of the stock price.
Strike
The strike price of the put option.
RiskFreeRate
The continuously compounded risk free interest rate expressed in decimal format (i.e. 1 percent = 0.01).
Volatility
The volatility of the underlying asset price 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

The full name of this function inside Excel is Option_EuropeanEvaluation_Put.

See Also

EuropeanEvaluation Class | Options Namespace | EuropeanEvaluation.Put Overload List