Zero Curve Bootstrapping (from zero yields and bond prices)

Last updated 20 November 2026

Function reference › Bonds › Curve Fitting

1 GIAnalyzer function for Excel. Optional arguments are shown in [brackets].

GIA_Bonds_Bootstrap

Returns a zero curve bootstrapped from zero-coupon yields and fixed coupon bond prices: one point per bill and bond used, each bond repriced exactly.

GIA_Bonds_Bootstrap(ZeroCouponArray, FixedCouponArray, SDate, Comp, Days, Interp, ValueType, ExDays, DR)

Returns: A zero curve bootstrapped from zero-coupon yields and fixed coupon bond prices: one point per bill and bond used, each bond repriced exactly

ArgumentUseDescription
ZeroCouponArrayRequiredThe array of zero-coupon bond yields
FixedCouponArrayRequiredThe array of fixed coupon bond prices
SDateRequiredThe settlement date.
CompRequiredThe compounding basis of the interest rates (Annual, SemiAnnual, Quarterly, Monthly, Simple, Continuous)
DaysRequiredThe time basis of the interest rates (act/360, act/365, act/act, 30E/360, 30I/360)
InterpRequiredThe interpolation method (Linear, LogLinear, CubicSpline, Exponential)
ValueTypeRequiredBond price type (Clean, Dirty)
ExDaysRequiredThe number of days before coupon payment, during which the bond buyer is not entitled to receive the coupon.
DRRequiredThe date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment)