Component 
Resolution  Exotic Options 




Function Definition 
oX_Quanto(CallPut, ForeignValue, FXRateSpot, FXRateFixed, ValueDate, ExpiryDate, Spot, Strike, RiskFreeD, RiskFreeF, DividendYield, RateVolatility, AssetVolatility, Correlation, OutputFlag) Values a fixed exchangerate foreignequity option (quanto) 




Function Parameters 



Parameters 
Description 

Parameter Type 

Restrictions 

. 

CallPut 

Option type. 

Enumerated Constant 

1  Call 

ForeignValue 

Should the option value be returned in units of Foreign or Domestic currency? 

Enumerated Constant 

1  Foreign 

FXRateSpot 

Spot exchange rate. When the option value is returned in units of foreign currency, the exchange rate should be quoted in units of foreign currency per unit of domestic currency. When the option value is returned in units of domestic currency, the exchange rate should be quoted in units of domestic currency per unit of foreign currency. 

Double 


FXRateFixed 

Fixed exchange rate. When the option value is returned in units of foreign currency, the exchange rate should be quoted in units of foreign currency per unit of domestic currency. When the option value is returned in units of domestic currency, the exchange rate should be quoted in units of domestic currency per unit of foreign currency. 

Double 


ValueDate 

Valuation date. 

Date 


ExpiryDate 

Expiry date of the option. 

Date 


Spot 

Current market price of the underlying asset. 

Double 

Spot > 0 

Strike 

Strike price of the option. 

Double 

Strike > 0 

RiskFreeD 

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

Double 


RiskFreeF 

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

Double 


DividendYield 

Continuous dividend yield of the underlying asset, expressed as an annually compounded Actual/365 rate. 

Double 


RateVolatility 

Annualized volatility of the exchange rate, expressed as a decimal. 

Double 

RateVolatility > 0 

AssetVolatility 

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

Double 

AssetVolatility > 0 

Correlation 

Correlation between the asset price and the domestic exchange rate. 

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.