COUPNCD(settle, M, F, basis)
- Settle - the security's settlement date.
- M - the security's maturity date.
- F - the number of coupon payments per year
- Basis - Type of day count basis.
Description
- This function returns a date that represents next coupon date after the settlement date.
- F must be 1,2 or 4
- COUPNCD shows there value when Basis<0 or Basis>4,
- Settlement date greater than or equal to maturity date.
Examples
?UNIQ17b134979b170de4-nowiki-00000003-QINU?
where
B2=2/25/2007
B3=10/15/2008
B4=2
B5=1
COUPNCD returns (Sun APRIL 15, 2007).