Component 
Resolution  Exotic Options 




Function Definition 
oX_TwoAssetCashOrNothing(AssetOneUpDown, AssetTwoUpDown, ValueDate, ExpiryDate, SpotOne, SpotTwo, StrikeOne, StrikeTwo, Payoff, RiskFree, CarryOne, CarryTwo, VolatilityOne, VolatilityTwo, Correlation, OutputFlag) Calculates the option value and Greeks for a twoasset cashornothing option using Heynen and Kat's (1996) method 




Function Parameters 



Parameters 
Description 

Parameter Type 

Restrictions 

. 

AssetOneUpDown 

Barrier direction. 

Enumerated Constant 

1  Up 

AssetTwoUpDown 

Barrier direction. 

Enumerated Constant 

1  Up 

ValueDate 

Valuation date. 

Date 


ExpiryDate 

Expiry date of the option. 

Date 


SpotOne 

Current market price of the first underlying asset. 

Double 

SpotOne > 0 

SpotTwo 

Current market price of the second underlying asset. 

Double 

SpotTwo > 0 

StrikeOne 

First strike price of the option. 

Double 

StrikeOne > 0 

StrikeTwo 

Second strike price of the option. 

Double 

StrikeTwo > 0 

Payoff 

Amount paid out if the option expires in the money. 

Double 


RiskFree 

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

Double 


CarryOne 

Net cost of carry of the first underlying asset, expressed as an annually compounded Actual 365 rate. 

Double 


CarryTwo 

Net cost of carry of the second underlying asset, expressed as an annually compounded Actual 365 rate. 

Double 


VolatilityOne 

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

Double 

VolatilityOne > 0 

VolatilityTwo 

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

Double 

VolatilityTwo > 0 

Correlation 

Correlation between the prices of the first and second assets. 

Double 

Correlation > 1 

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  Value & Greeks 
Copyright 2013 Hedgebook Ltd.