Component 
Resolution  Exotic Options 




Function Definition 
oX_Asian_ARO_MC(CallPut, ValueDate, IssueDate, ExpiryDate, Spot, AverageSpot, Strike, RiskFree, Carry, Volatility, FixDates, Simulations, OutputFlag) Calculates the value of an arithmetic average rate Asian option using a Monte Carlo simulation 




Function Parameters 



Parameters 
Description 

Parameter Type 

Restrictions 

. 

CallPut 

Option type. 

Enumerated Constant 

1  Call 

ValueDate 

Valuation date. 

Date 


IssueDate 

Date at which the option was written. 

Date 


ExpiryDate 

Expiry date of the option. 

Date 


Spot 

Current market price of the underlying asset. 

Double 

Spot > 0 

AverageSpot 

Average price of the underlying asset. 

Double 


Strike 

Strike price of the option. 

Double 

Strike > 0 

RiskFree 

Risk free interest rate, expressed as an annually compounded Actual 365 rate. 

Double 


Carry 

Net cost of carry, expressed as an annually compounded Actual 365 rate. 

Double 


Volatility 

Annualized volatility of the underlying asset, expressed as a decimal. 

Double 

Volatility > 0 

FixDates 

List of the dates upon which rate fixes occur. 

Vector 

FixDates vector must be a range of values 1 cell wide and 1 or more cells high. 

Simulations 

Number of simulations to perform 

Long 

Simulations > 0 

OutputFlag 

Indicates which result, or set of results, will be displayed in the worksheet. When returning more than one value, the function must be entered as an array function. 

Enumerated Constant 

0  All values 
Copyright 2013 Hedgebook Ltd.