couponNextDate (int sett, int mat, Finance::Banking::YearlyFreq freq, Finance::Banking::YearBasis basis=yb_USA)
Calculate the next coupon date for a security.
Excel: COUPNCD
Function Documentation
intcouponNextDate(
int
sett
int
mat
Finance::Banking::YearlyFreq
freq
Finance::Banking::YearBasis
basis = yb_USA
)
Calculate the next coupon date after the settlement date. This
value may never be equal to the settlement date.
For a security, the settlement date is the date after issue when
the security is traded to the buyer. The maturity date is the date
at which the security expires.
The yearly frequency to be used in financial calculations
Type
Description
yf_Annual
Payments are made annually.
yf_SemiAnnual
Payments are semi-annual (2 per year).
yf_Quarterly
Payments are quarterly (4 per year).
Authors:
James Warren (August 2005)
Type
Value
Description
yb_US
0
US (NASD) 30/360 - As with the European 30/360 (yb_EU, with the additional provision that if the end date occurs on the 31st of a month it is moved to the 1st of the next month if the start date is earlier than the 30th.
yb_Act
1
Uses the exact number of elapsed days between the two dates, as well as the exact length of the year.
yb_Act360
2
Uses the exact number of elapsed days between two dates but assumes the year only have 360 days
yb_Act365
3
Uses the exact number of elapsed days between two dates but assumes the year always has 365 days
yb_EU
4
European 30/360 - Each month is assumed to have 30 days, such that the year has only 360 days. Start and end dates that occur on the 31st of a month become equal to the 30th of the same month.
Parameters:
sett
The settlement date, expressed as a serial Julian date.
mat
The maturity date of the settlement, expressed as a serial Julian date.