Additional Functions

Last updated 9 November 2026

Function reference › Bonds › Additional Functions

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

GIA_Bonds_Additional_BloombergTimeBasisConvertor

Converts the time basis notation in Bloomberg to the one in GIA.

GIA_Bonds_Additional_BloombergTimeBasisConvertor(BloombergDays)

Argument	Use	Description
`BloombergDays`	Required	Time basis in Bloomberg used for coupon and accrued interest calculation.

Converts the number of coupons per year to coupon frequency in GIA (1, 2, 4 and 12 become Annual, SemiAnnual, Quarterly and Monthly, accordingly).

GIA_Bonds_Additional_CouponNumberConverter(CouponsPerYear)

Argument	Use	Description
`CouponsPerYear`	Required	The number of the bond's coupon payments per year (1, 2, 4, 12).

Returns the date of the bond's next payment given the payment frequency and the date of any of the bond's cashflows, either past or future.

GIA_Bonds_Additional_NextPaymentDate(VDate, PaymentDate, Frequency, DR)

Returns: Date of the bond's next payment given the payment frequency and the date of any of the bond's cashflows, either past or future

Argument	Use	Description
`VDate`	Required	The value date.
`PaymentDate`	Required	The payment date.
`Frequency`	Required	The frequency of the bond's payments (Annual, SemiAnnual, Quarterly, Monthly)
`DR`	Required	The date rolling method. Non-business days are Saturdays and Sundays; holidays are not supported (Following, ModifiedFollowing, Previous, ModifiedPrevious, NoAdjustment)