Manuals/calci/COUPNUM
Jump to navigation
Jump to search
COUPNUM(settle, M, F, basis)
Where 'settle' is the security's settlement date, 'M' is the security's maturity date, 'F' is the number of coupon payments per year, and 'basis' is the type of day count basis to use.
This function shows the number of coupons allocated between the settlement date and maturity date.
- COUPDAYSNC shows the error value, when settlement or maturity is not a valid date, or settlement ≥ maturity.
- Basis should be between 0 and 4 and 'F' should be 1, 2, or 4. Otherwise it shows error value..
COUPNUM
Lets see an example,
COUPNUM(settle, M, F, basis)
B
April 21, 2010
December 10, 2011
2
1
=COUPNUM(B2,B3,B4,B5) is 4
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | April 21, 2010 | |||
| Row2 | December 10, 2011 | |||
| Row3 | 2 | |||
| Row4 | 1 | |||
| Row5 | 4 | |||
| Row6 |
