- Function SecurityCouponNextDate(SettlementDate, MaturityDate, Frequency, NextDate)
SecurityCouponNextDate
The function SecurityCouponNextDate
returns the first coupon-date
next to settlement date of a security that pays interest at the end of
each coupon period.
SecurityCouponNextDate(
SettlementDate, ! (input) scalar string expression
MaturityDate, ! (input) scalar string expression
Frequency ! (input) numerical expression
NextDate ! (output) string parameter
)
Arguments
- SettlementDate
The date of settlement of the security. SettlementDate must be in date format.
- MaturityDate
The date of maturity of the security. MaturityDate must also be in date format and must be a date after SettlementDate.
- Frequency
The number of coupon payments in one year. Frequency must be 1 (annual), 2 (semi-annual) or 4 (quarterly).
- NextDate
The date on which the coupon period ends and on which the next coupon period starts.
Note
The function SecurityCouponNextDate
is similar to the Excel function
COUPNCD
.
See also
General equations for securities with multiple coupons.