Option on a Fixed Coupon Bond

Last updated 9 November 2026

Function reference › Bonds › Bond Options

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

GIA_Bonds_OptionFixedBullet_RiskFromCurve

Returns the risk of a European option on a bond generating periodic fixed coupon payments, given an interest rate curve for discounting future cash flows.

GIA_Bonds_OptionFixedBullet_RiskFromCurve(OptionType, Strike, Vol, OptionEDate, FaceValue, CRate, CFr, StartAccrDate, MDate, DR, DaysCoupon, ExDays, DCurveDates, DCurveRates, VDate, Comp, Days, Interp, RM, [StartTerm], [EndTerm])

Returns: Risk of a European option on a bond generating periodic fixed coupon payments

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`Strike`	Required	The option's strike price.
`Vol`	Required	The volatility of the underlying bond's price
`OptionEDate`	Required	The option's expiry date.
`FaceValue`	Required	The bond's face value. For a long position, the sign is positive, and for a short position, it is negative.
`CRate`	Required	The bond's coupon rate.
`CFr`	Required	The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
`StartAccrDate`	Required	The start date of the bond's first accrual period.
`MDate`	Required	The bond's maturity date.
`DR`	Required	The date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment)
`DaysCoupon`	Required	The time basis for the accrual period calculation (act/360, act/365, act/act, 30E/360, 30I/360)
`ExDays`	Required	The number of days before coupon payment, during which the bond buyer is not entitled to receive the coupon.
`DCurveDates`	Required	The array of dates in the interest rate curve used for discounting cash flows.
`DCurveRates`	Required	The array of rates in the interest rate curve used for discounting cash flows.
`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)
`RM`	Required	The risk measure type (DV01, MacaulayDuration, ModifiedDuration, Convexity, KR01, BucketDV01, KRDuration, BucketDuration)
`StartTerm`	Optional	The starting term for Bucket and Key Rate measures.
`EndTerm`	Optional	The ending term for Bucket and Key Rate measures.

GIA_Bonds_OptionFixedBullet_RiskFromYield

Returns the risk of a European option on a bond generating periodic fixed coupon payments, given a single interest rate for discounting future cash flows.

GIA_Bonds_OptionFixedBullet_RiskFromYield(OptionType, Strike, Vol, InterestRate, OptionEDate, FaceValue, CRate, CFr, StartAccrDate, MDate, DR, DaysCoupon, ExDays, Yield, VDate, Comp, Days, RM)

Returns: Risk of a European option on a bond generating periodic fixed coupon payments

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`Strike`	Required	The option's strike price.
`Vol`	Required	The volatility of the underlying bond's price
`InterestRate`	Required	The interest rate.
`OptionEDate`	Required	The option's expiry date.
`FaceValue`	Required	The bond's face value. For a long position, the sign is positive, and for a short position, it is negative.
`CRate`	Required	The bond's coupon rate.
`CFr`	Required	The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
`StartAccrDate`	Required	The start date of the bond's first accrual period.
`MDate`	Required	The bond's maturity date.
`DR`	Required	The date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment)
`DaysCoupon`	Required	The time basis for the accrual period calculation (act/360, act/365, act/act, 30E/360, 30I/360)
`ExDays`	Required	The number of days before coupon payment, during which the bond buyer is not entitled to receive the coupon.
`Yield`	Required	The flat discounting 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)
`RM`	Required	The risk measure type (DV01, MacaulayDuration, ModifiedDuration, Convexity, KR01, BucketDV01, KRDuration, BucketDuration)

GIA_Bonds_OptionFixedBullet_ValueFromCurve

Returns the value of a European option on a bond generating periodic fixed coupon payments, given an interest rate curve for discounting future cash flows.

GIA_Bonds_OptionFixedBullet_ValueFromCurve(OptionType, Strike, Vol, OptionEDate, FaceValue, CRate, CFr, StartAccrDate, MDate, DR, DaysCoupon, ExDays, DCurveDates, DCurveRates, VDate, Comp, Days, Interp)

Returns: Value of a European option on a bond generating periodic fixed coupon payments

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`Strike`	Required	The option's strike price.
`Vol`	Required	The volatility of the underlying bond's price
`OptionEDate`	Required	The option's expiry date.
`FaceValue`	Required	The bond's face value. For a long position, the sign is positive, and for a short position, it is negative.
`CRate`	Required	The bond's coupon rate.
`CFr`	Required	The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
`StartAccrDate`	Required	The start date of the bond's first accrual period.
`MDate`	Required	The bond's maturity date.
`DR`	Required	The date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment)
`DaysCoupon`	Required	The time basis for the accrual period calculation (act/360, act/365, act/act, 30E/360, 30I/360)
`ExDays`	Required	The number of days before coupon payment, during which the bond buyer is not entitled to receive the coupon.
`DCurveDates`	Required	The array of dates in the interest rate curve used for discounting cash flows.
`DCurveRates`	Required	The array of rates in the interest rate curve used for discounting cash flows.
`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_Bonds_OptionFixedBullet_ValueFromPrice

Returns the value of a European option on a bond generating periodic fixed coupon payments, given the bond price.

GIA_Bonds_OptionFixedBullet_ValueFromPrice(OptionType, Strike, Vol, OptionEDate, FaceValue, CRate, CFr, StartAccrDate, MDate, DR, DaysCoupon, ExDays, Price, DCurveDates, DCurveRates, VDate, Comp, Days, Interp)

Returns: Value of a European option on a bond generating periodic fixed coupon payments

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`Strike`	Required	The option's strike price.
`Vol`	Required	The volatility of the underlying bond's price
`OptionEDate`	Required	The option's expiry date.
`FaceValue`	Required	The bond's face value. For a long position, the sign is positive, and for a short position, it is negative.
`CRate`	Required	The bond's coupon rate.
`CFr`	Required	The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
`StartAccrDate`	Required	The start date of the bond's first accrual period.
`MDate`	Required	The bond's maturity date.
`DR`	Required	The date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment)
`DaysCoupon`	Required	The time basis for the accrual period calculation (act/360, act/365, act/act, 30E/360, 30I/360)
`ExDays`	Required	The number of days before coupon payment, during which the bond buyer is not entitled to receive the coupon.
`Price`	Required	The bond's price
`DCurveDates`	Required	The array of dates in the interest rate curve used for discounting cash flows.
`DCurveRates`	Required	The array of rates in the interest rate curve used for discounting cash flows.
`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_Bonds_OptionFixedBullet_ValueFromYield

Returns the value of a European option on a bond generating periodic fixed coupon payments, given a single interest rate for discounting future cash flows.

GIA_Bonds_OptionFixedBullet_ValueFromYield(OptionType, Strike, Vol, InterestRate, OptionEDate, FaceValue, CRate, CFr, StartAccrDate, MDate, DR, DaysCoupon, ExDays, Yield, VDate, Comp, Days)

Returns: Value of a European option on a bond generating periodic fixed coupon payments

Argument	Use	Description
`OptionType`	Required	The option type (Call, Put)
`Strike`	Required	The option's strike price.
`Vol`	Required	The volatility of the underlying bond's price
`InterestRate`	Required	The interest rate.
`OptionEDate`	Required	The option's expiry date.
`FaceValue`	Required	The bond's face value. For a long position, the sign is positive, and for a short position, it is negative.
`CRate`	Required	The bond's coupon rate.
`CFr`	Required	The frequency of the bond's coupon payments (Annual, SemiAnnual, Quarterly, Monthly)
`StartAccrDate`	Required	The start date of the bond's first accrual period.
`MDate`	Required	The bond's maturity date.
`DR`	Required	The date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment)
`DaysCoupon`	Required	The time basis for the accrual period calculation (act/360, act/365, act/act, 30E/360, 30I/360)
`ExDays`	Required	The number of days before coupon payment, during which the bond buyer is not entitled to receive the coupon.
`Yield`	Required	The flat discounting 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)