Component 
Resolution  IRO Pricing 




Function Definition 
oIRbarrier1_Price(OptionType, ValueDate, EffectiveDate, MaturityDate, NotionalPrincipal, StrikeRate, Barrier, ResetFrequency, AccrualBasis, BusDayConv, InterpMethod, Volatility, ResetCycle, ResetCurve, DiscountingCurve, Holidays, Output) Calculates fair value and risk statistics for a standard interest rate barrier cap or floor 




Function Parameters 



Parameters 
Description 

Parameter Type 

Restrictions 

. 

OptionType 

Specifies whether the option is a cap, floor, or collar. 

Enumerated Constant 

1  Cap 

ValueDate 

The valuation date of the option. 

Date 

ValDate < SettleDate 

EffectiveDate 

The reset date of the first optlet. 

Date 

EffDate < MatDate 

MaturityDate 

The maturity date of the option. 

Date 

As above. 

NotionalPrincipal 

The notional value of the option. 

Double 

Notional >= 0 

StrikeRate 

The exercise price of the option. 

Double 


Barrier 


Either a single value, or an array of two values with the upper barrier first and the lower barrier second. 


ResetFrequency 

Frequency of the optlets. 

Enumerated Constant 

1  Annual 

AccrualBasis 

Basis for determining payment amounts. 

Enumerated Constant 

1  Act/Act (actual) 

BusDayConv 

Business day convention. Used to determine the start and end date of each optlet period. 

Enumerated Constant 

1  No Adjustment 

InterpMethod 

Interpolate discount factors or rates? 

Enumerated Constant 

1  Discount Factors 

Volatility 

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

Double 

Volatility > 0% 

ResetCycle 

Determines if the rate reset cycle is computed backwards from the maturity date or forwards from the effective date. 

Enumerated Constant 

1  Maturity Date 

PaymentTiming 

Determines the timing of the optlet payments. 

Enumerated Constant 

1  Advance 

ResetCurve 

Zero curve used for projecting the rates. 

Curve 

Curve must be three columns. 

DiscountingCurve 

Zero curve used for discounting. 

Curve 

Curve must be three columns. 

Holidays 

Schedule of nonbusiness days (excluding weekends) 

Date Range 

Leave blank if not applicable. 

Output 

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.