- Function SecurityCouponDaysPostSettlement(SettlementDate, MaturityDate, Frequency, Basis)
SecurityCouponDaysPostSettlement
The function SecurityCouponDaysPostSettlement
returns the number of
days from the first coupon-date next to settlement date until settlement
date of a security that pays interest at the end of each coupon period.
SecurityCouponDaysPostSettlement(
SettlementDate, ! (input) scalar string expression
MaturityDate, ! (input) scalar string expression
Frequency, ! (input) numerical expression
[Basis] ! (optional) numerical expression
)
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).
- Basis
The day-count basis method to be used. The default is 1.
Return Value
The function
SecurityCouponDaysPostSettlement
returns the number of days from the first coupon-date next to settlement date until settlement date.
Note
The function SecurityCouponDaysPostSettlement
is similar to the
Excel function COUPDAYSNC
.