Single Barrier Option

Last updated 9 November 2026

Function reference › Equity Derivatives › Single Barrier Options

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

GIA_EQD_SingleBarrier_Greeks

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

GIA_EQD_SingleBarrier_Greeks(OptionType, BarrierType1, BarrierType2, SharesNumber, Strike, Barrier, EDate, DDate, S, Vol, DividendYield, InterestRate, VDate, Comp, Days, GreekType)

Returns: Greeks of an equity Single barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType1`	Required	The option’s barrier type (American, European)
`BarrierType2`	Required	The option's barrier type (Up-And-In, Up-And-Out, Down-And-In, Down-And-Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`Barrier`	Required	The option's 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_SingleBarrier_GreeksBinomial

Returns the Greeks of an equity Single barrier option, given volatility, continuous dividend yield and interest rate using the binomial tree pricing model.

GIA_EQD_SingleBarrier_GreeksBinomial(OptionType, BarrierType1, BarrierType2, SharesNumber, Strike, Barrier, EDate, DDate, S, Vol, DividendYield, InterestRate, VDate, Comp, Days, GreekType, n)

Returns: Greeks of an equity Single barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType1`	Required	The option’s barrier type (American, European)
`BarrierType2`	Required	The option's barrier type (Up-And-In, Up-And-Out, Down-And-In, Down-And-Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`Barrier`	Required	The option's 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)
`n`	Required	The number of steps in the binomial tree.

GIA_EQD_SingleBarrier_GreeksFromCurve

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

GIA_EQD_SingleBarrier_GreeksFromCurve(OptionType, BarrierType1, BarrierType2, SharesNumber, Strike, Barrier, EDate, DDate, S, Vol, DividendYield, CurveDates, CurveRates, VDate, Comp, Days, Interp, GreekType)

Returns: Greeks of an equity Single barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType1`	Required	The option’s barrier type (American, European)
`BarrierType2`	Required	The option's barrier type (Up-And-In, Up-And-Out, Down-And-In, Down-And-Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`Barrier`	Required	The option's 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_SingleBarrier_GreeksFromCurveBinomial

Returns the Greeks of an equity Single barrier option, given volatility, continuous dividend yield and interest rate curve using the binomial tree pricing model.

GIA_EQD_SingleBarrier_GreeksFromCurveBinomial(OptionType, BarrierType1, BarrierType2, SharesNumber, Strike, Barrier, EDate, DDate, S, Vol, DividendYield, CurveDates, CurveRates, VDate, Comp, Days, Interp, GreekType, n)

Returns: Greeks of an equity Single barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType1`	Required	The option’s barrier type (American, European)
`BarrierType2`	Required	The option's barrier type (Up-And-In, Up-And-Out, Down-And-In, Down-And-Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`Barrier`	Required	The option's 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)
`n`	Required	The number of steps in the binomial tree.

GIA_EQD_SingleBarrier_TV

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

GIA_EQD_SingleBarrier_TV(OptionType, BarrierType1, BarrierType2, SharesNumber, Strike, Barrier, EDate, DDate, S, Vol, DividendYield, InterestRate, VDate, Comp, Days)

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

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType1`	Required	The option’s barrier type (American, European)
`BarrierType2`	Required	The option's barrier type (Up-And-In, Up-And-Out, Down-And-In, Down-And-Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`Barrier`	Required	The option's 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_SingleBarrier_TVFromCurve

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

GIA_EQD_SingleBarrier_TVFromCurve(OptionType, BarrierType1, BarrierType2, SharesNumber, Strike, Barrier, EDate, DDate, S, Vol, DividendYield, CurveDates, CurveRates, VDate, Comp, Days, Interp)

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

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType1`	Required	The option’s barrier type (American, European)
`BarrierType2`	Required	The option's barrier type (Up-And-In, Up-And-Out, Down-And-In, Down-And-Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`Barrier`	Required	The option's 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)

GIA_EQD_SingleBarrier_ValueBinomial

Returns the value of an equity Single barrier option, given volatility, continuous dividend yield and interest rate using the binomial tree pricing model.

GIA_EQD_SingleBarrier_ValueBinomial(OptionType, BarrierType1, BarrierType2, SharesNumber, Strike, Barrier, EDate, DDate, S, Vol, DividendYield, InterestRate, VDate, Comp, Days, n)

Returns: Value of an equity Single barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType1`	Required	The option’s barrier type (American, European)
`BarrierType2`	Required	The option's barrier type (Up-And-In, Up-And-Out, Down-And-In, Down-And-Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`Barrier`	Required	The option's 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)
`n`	Required	The number of steps in the binomial tree.

GIA_EQD_SingleBarrier_ValueFromCurveBinomial

Returns the value of an equity Single barrier option, given volatility, continuous dividend yield and interest rate curve using the binomial tree pricing model.

GIA_EQD_SingleBarrier_ValueFromCurveBinomial(OptionType, BarrierType1, BarrierType2, SharesNumber, Strike, Barrier, EDate, DDate, S, Vol, DividendYield, CurveDates, CurveRates, VDate, Comp, Days, Interp, n)

Returns: Value of an equity Single barrier option

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`BarrierType1`	Required	The option’s barrier type (American, European)
`BarrierType2`	Required	The option's barrier type (Up-And-In, Up-And-Out, Down-And-In, Down-And-Out)
`SharesNumber`	Required	The number of shares.
`Strike`	Required	The option's strike price.
`Barrier`	Required	The option's 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)
`n`	Required	The number of steps in the binomial tree.