Manuals/calci/COUPDAYBS
Jump to navigation
Jump to search
COUPDAYBS(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 'B' is the type of day count basis to use.
This function returns the number of days from the beginning of the coupon period to the settlement date.
- Basis must be between 0 and 4 and 'F' should be 1,2 or 4
- When settlement ≥ maturity, COUPDAYBS shows the error value.
COUPDAYBS
Lets see an example,
COUPDAYBS(settle, M, F, basis)
B
January 25, 2008
November 15, 2009
3
1
=COUPDAYBS(B2,B3,B4,B5) is 71
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | January 25, 2008 | |||
| Row2 | November 15, 2009 | |||
| Row3 | 3 | |||
| Row4 | 1 | |||
| Row5 | 71 | |||
| Row6 |
