COUPNCD(settle, M, F, basis)
- is the security's settlement date.
- is the security's maturity date(Expire date).
- is the number of coupon(interest) payments per year(1,2 or 4)
- is the Type of day count basis.
is the security's settlement date.
is the security's maturity date(Expire date).
is the number of coupon(interest) payments per year(1,2 or 4)
is the Type of day count basis.Description
- This function returns a date that represents next coupon date after the settlement date.
- must be 1,2 or 4
- COUPNCD shows there value when Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle basis\lt 0} or Failed to parse (unknown function "\gt"): {\displaystyle basis\gt 0} Basis>4,
- must be greater than or equal to maturity date.
- is the calender system to use.
0 - US method (NASD), 12 months of 30 days each 1 - Actual number of days in months, actual number of days in year 2 - Actual number of days in month, year has 360 days 3 - Actual number of days in month, year has 365 days 4 - European method, 12 months of 30 days each
Examples
=COUPPCD(B2,B3,B4,B5)
Where
B2=2/25/2007
B3=10/15/2008
B4=2
B5=1
COUPPCD returns (Sun Oct 15, 2006).
References
?UNIQ7cf1cacc92d99ec2-nowiki-00000002-QINU?
Where
B2=2/25/2007
B3=10/15/2008
B4=2
B5=1
COUPPCD returns (Sun Oct 15, 2006).
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2/25/2007 | Sun Oct 15 00:00:00 UTC+0530 2006 | ||
| Row2 | 10/15/2008 | |||
| Row3 | 2 | |||
| Row4 | 1 | |||
| Row5 | ||||
| Row6 |