WebCab XL Community Edition

BlackScholes.ParasianMC Method 

Evaluates a Parasian option in accordance with the Black-Scholes model using a Monte Carlo pricing technique.

public double ParasianMC(
   string OptionType,
   double CurrentTime,
   double Maturity,
   double InitialPrice,
   double Strike,
   string UpDown,
   string InOut,
   double BarrierLevel,
   double Rebate,
   double MonitorInterval,
   double TimeToTrigger,
   double RiskFreeRate,
   double Volatility,
   int TimeSteps,
   int RandomWalks
);

Parameters

OptionType
This parameter is a string which specifies whether the options contract is of CALL or PUT type. If the option is a call options then please input the string "CALL", if the option is a put option then please input "PUT".
CurrentTime
The absolute time in years when the contract is evaluated. That is, if we wish to evaluate the contract on the 1st Jan 2010, then the currentTime should be set to 2010. If however we wish to evaluate the contract on the 1st July 2010, then the currentTime should be set to 2010.5.
Maturity
The absolute time in years when the option contract expires. For example, if the contract expires on 1st Jan 2010, then the maturity should be set to 2010. If however the contract expires on the 1st July 2010, then the maturity should be set to 2010.5.
InitialPrice
The price of the underlying asset at the currentTime. Please note that we evaluate the option for the currentTime, which may not be not present time until the maturity of the option contract.
Strike
The strike (or exercise) price of the option. This is the price at which the right to buy (in the case of a Call option) or the right to sell (in the case of a Put option) provide by the option can be acted upon.
UpDown
If you are evaluating an `up Parasian option' then you should input UP, if you are evaluating a `down Parasian option' then you should input DOWN. Recall, that a Parasian option is an `up option' if the trigger barrier is higher than the initial underlying asset price, or is a `down option' if the trigger barrier is lower than the initial underlying asset price.
InOut
If you are evaluating an `in Parasian option' when the payoff is paid if the option is triggered then you should input IN, if you are evaluating an `out Parasian option' when the payoff is paid if the option is not triggered then you should input OUT.
BarrierLevel
The price level of the underlying asset at which the Parasian option is triggered.
Rebate
The compensation paid at maturity to the holder of the Parasian option if the option is not triggered and hence the (normal) payoff is not paid.
MonitorInterval
The periods in years between consecutive readings of the market variable which triggers the Parisian option. Note that since no market variable can be continuously monitored it is usual that the contract will explicitly state at what intervals the market variable on which the contracts depends is read. The monitoring interval will imply a sequence of moments in time at which the market variables values are recorded and used to determine whether the trigger has been met.

Note that the length of the monitoring periods should be smaller than the time step periods used within the Monte Carlo procedure. If this is not the case then the time steps intervals will be taken to be equal to the monitoring period.

.
TimeToTrigger
This is the minimum total amount of time which must be spent with the barrier condition satisfied in order for the contract to the triggered. Note that for the Parisian option this period of time must be one complete intervals, whereas here it only matter that the sum of the periods for which the triggered was satisfied is more than a given level.
RiskFreeRate
The risk free interest rate at the point currentTime expressed in decimal format (i.e. 1 percent = 0.01).
Volatility
An estimate of the volatility of the underlying asset (or market variable) which the option depends on at the time currentTime, expressed in decimal format (i.e. 1 percent = 0.01). See the Volatility class within the Options XL Service for procedures which assist in the estimation of the volatility.
TimeSteps
The total number of time divisions used in the construction of a Monte Carlo simulation. Please note that as this parameter is increased the synthetic Random walks will converge to `real' continuous Random walks. Therefore, as the number of time steps increases the expectation of a higher level of accuracy will also increase. Also note that the computational time required will also increase in proportion to the number of time steps used.
RandomWalks
The total number of Random walks used within the Monte Carlo simulation. As the number of Random walks increases so the corresponding accuracy (in the sense given below) increase along with a proportional increase in the computation time. Note that since Monte Carlo is a probabilistic procedure the `accuracy' can only be interpreted in a probabilistic sense. That is, as the number of Random walks increases the corresponding accuracy will increase in the sense that for a given confidence level, the corresponding confidence intervals width will decrease like: two times, one over the root of N, where N is the number of Random walks. Please see the PDF documentation for a precise formulation of the confidence interval of the Monte Carlo procedure and further discussion.

Remarks

Parasian Options

The Parasian option is a hybrid of a Parisian option which is itself a type of Barrier option. In short, the Parasian option is a cumulative Parisian option in the following sense. For the Parasian option to be triggered the sum of the periods for which the trigger is satisfied must to greater than a given interval given below as the timeToTrigger. Whereas the Parisian option requires that the option satisfies the trigger condition for some given continuous period of time.

Classification of Parasian Options

The effect of the option being triggered will depend on the type of option considered. The types of Parasian Options are classified in accordance with the following criteria:

  1. Put or Call: Determines whether the option when triggered gives the holder the right to buy or sell the underlying asset.
  2. Knock In or Knock Out: If the option is of In type then the payoff is triggered if the barrier condition is satisfied, if the option is of Out type then the option payoff is triggered if the barrier condition is NOT triggered. In the case of the knock Out option if the barrier condition is satisfied then the option will expire worthless.
  3. Up or Down: An Up Parisian option is an option where the trigger barrier is higher than the initial price, where a Down Parisian option is an option where the trigger barrier is lower than the initial price.

Excel Remarks

The full name of this function inside Excel is Exotic_BlackScholes_ParasianMC.

Exceptions

Exception TypeCondition
EvaluationExceptionThrown when any runtime errors occurs.

See Also

BlackScholes Class | ExoticOptions Namespace