WebCab XL Community Edition

EuropeanEvaluation.CallOnCurrency Method (Double, Double, Double, Double, Double, Double)

Evaluates the value of a European call option on a currency.

public double CallOnCurrency(
   double ForeignRate,
   double ExchangeRate,
   double Strike,
   double RiskFreeRate,
   double Volatility,
   double TimeToMaturity
);

Parameters

ForeignRate
The continuously compounded risk free interest rate in the foreign currency given in decimal formal (i.e. 1 percent = 0.01).
ExchangeRate
The present exchange rate on which the option is defined.
Strike
The exchange rate at which the option can be exercised.
RiskFreeRate
Continuously compounded risk free interest rate in the base currency expressed in decimal format (i.e. 1 percent = 0.01).
Volatility
The volatility of the exchange rate given in decimal format (i.e. 1 percent = 0.01).
TimeToMaturity
Time to the maturity of the option (in years).

Remarks

The full name of this function inside Excel is Option_EuropeanEvaluation_CallOnCurrency_ByTimeSpans.

See Also

EuropeanEvaluation Class | Options Namespace | EuropeanEvaluation.CallOnCurrency Overload List