WebCab XL Community Edition

EuropeanTheta.PutThetaOnCurrency Method (Double, Double, Double, Double, Double, DateTime, DateTime, String)

Returns the theta of a European put option on a currency.

public double PutThetaOnCurrency(
   double Interest,
   double ExchangeRate,
   double Strike,
   double RiskFreeRate,
   double Volatility,
   DateTime EvaluationDate,
   DateTime MaturityDate,
   string CalendarName
);

Parameters

Interest
The continuously compounded risk free interest rate on the foreign currency.
ExchangeRate
The exchange rate.
Strike
The exchange rate at which the currency option is exercised at.
RiskFreeRate
The continuously compounded risk free interest rate in the base currency.
Volatility
The volatility of the exchange rate.
EvaluationDate
The date when the theta of the option contract is evaluated.
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_EuropeanTheta_PutThetaOnCurrency.

See Also

EuropeanTheta Class | Options Namespace | EuropeanTheta.PutThetaOnCurrency Overload List