Manuals/calci/COUPDAYSNC
Jump to navigation
Jump to search
COUPDAYSNC(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 counts the number of days from the settlement date to the next coupon 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.
COUPDAYSNC
Lets see an example,
COUPDAYSNC(settle, M, F, basis)
B
January 25, 2009
November 15, 2011
2
1
=COUPDAYSNC(B2,B3,B4,B5)is110
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | January 25, 2009 | |||
| Row2 | November 15, 2011 | |||
| Row3 | 2 | |||
| Row4 | 1 | |||
| Row5 | 110 | |||
| Row6 |
