Double Barrier Option

Last updated 9 November 2026

Function reference › Equity Derivatives › Double Barrier Options

4 GIAnalyzer functions for Excel. Optional arguments are shown in [brackets].

GIA_EQD_DoubleBarrier_Greeks

Returns the Greeks of an equity double barrier option, given volatility, continuous dividend yield and interest rate.

GIA_EQD_DoubleBarrier_Greeks(OptionType, BarrierType, SharesNumber, Strike, BarrierL, BarrierU, EDate, DDate, S, Vol, DividendYield, InterestRate, VDate, Comp, Days, GreekType)

Returns: Greeks of an equity double barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType`	Required	The option's barrier type (In, Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`BarrierL`	Required	The option's lower barrier.
`BarrierU`	Required	The option's upper barrier.
`EDate`	Required	The expiry date.
`DDate`	Required	The delivery date.
`S`	Required	The spot price.
`Vol`	Required	The volatility of the underlying asset.
`DividendYield`	Required	The continuous annual dividend yield.
`InterestRate`	Required	The interest rate.
`VDate`	Required	The value date.
`Comp`	Required	The compounding basis of the interest rate (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
`Days`	Required	The time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)
`GreekType`	Required	The Greek's type returned by the function (Delta, Gamma, Vega, Theta, Rho1, Rho2, Vanna, Volga)

GIA_EQD_DoubleBarrier_GreeksFromCurve

Returns the Greeks of an equity double barrier option, given volatility, continuous dividend yield and interest rate curve.

GIA_EQD_DoubleBarrier_GreeksFromCurve(OptionType, BarrierType, SharesNumber, Strike, BarrierL, BarrierU, EDate, DDate, S, Vol, DividendYield, CurveDates, CurveRates, VDate, Comp, Days, Interp, GreekType)

Returns: Greeks of an equity double barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType`	Required	The option's barrier type (In, Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`BarrierL`	Required	The option's lower barrier.
`BarrierU`	Required	The option's upper barrier.
`EDate`	Required	The expiry date.
`DDate`	Required	The delivery date.
`S`	Required	The spot price.
`Vol`	Required	The volatility of the underlying asset.
`DividendYield`	Required	The continuous annual dividend yield.
`CurveDates`	Required	The array of dates in the interest rate curve.
`CurveRates`	Required	The array of rates in the interest rate curve.
`VDate`	Required	The value date.
`Comp`	Required	The compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
`Days`	Required	The time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
`Interp`	Required	The interpolation method (Linear, LogLinear, CubicSpline, Exponential)
`GreekType`	Required	The Greek's type returned by the function (Delta, Gamma, Vega, Theta, Rho1, Rho2, Vanna, Volga)

GIA_EQD_DoubleBarrier_TV

Returns the theoretical value (TV) of an equity double barrier option, given volatility, continuous dividend yield and interest rate.

GIA_EQD_DoubleBarrier_TV(OptionType, BarrierType, SharesNumber, Strike, BarrierL, BarrierU, EDate, DDate, S, Vol, DividendYield, InterestRate, VDate, Comp, Days)

Returns: Theoretical value (TV) of an equity double barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType`	Required	The option's barrier type (In, Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`BarrierL`	Required	The option's lower barrier.
`BarrierU`	Required	The option's upper barrier.
`EDate`	Required	The expiry date.
`DDate`	Required	The delivery date.
`S`	Required	The spot price.
`Vol`	Required	The volatility of the underlying asset.
`DividendYield`	Required	The continuous annual dividend yield.
`InterestRate`	Required	The interest rate.
`VDate`	Required	The value date.
`Comp`	Required	The compounding basis of the interest rate (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
`Days`	Required	The time basis of the interest rate (act/360, act/365, act/act, 30E/360, 30I/360)

GIA_EQD_DoubleBarrier_TVFromCurve

Returns the theoretical value (TV) of an equity double barrier option, given volatility, continuous dividend yield and interest rate curve.

GIA_EQD_DoubleBarrier_TVFromCurve(OptionType, BarrierType, SharesNumber, Strike, BarrierL, BarrierU, EDate, DDate, S, Vol, DividendYield, CurveDates, CurveRates, VDate, Comp, Days, Interp)

Returns: Theoretical value (TV) of an equity double barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType`	Required	The option's barrier type (In, Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`BarrierL`	Required	The option's lower barrier.
`BarrierU`	Required	The option's upper barrier.
`EDate`	Required	The expiry date.
`DDate`	Required	The delivery date.
`S`	Required	The spot price.
`Vol`	Required	The volatility of the underlying asset.
`DividendYield`	Required	The continuous annual dividend yield.
`CurveDates`	Required	The array of dates in the interest rate curve.
`CurveRates`	Required	The array of rates in the interest rate curve.
`VDate`	Required	The value date.
`Comp`	Required	The compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
`Days`	Required	The time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
`Interp`	Required	The interpolation method (Linear, LogLinear, CubicSpline, Exponential)