Manuals/calci/couppcd
Jump to navigation
Jump to search
COUPPCD(settle, M, F, basis)
where,
Settle - the security's settlement date.
M - the security's maturity date.
F - the number of coupon payments per year and Basis- Type of day count basis.
This function returns a date that represents previous coupon date before the settlement date.
F must be 1,2,or 4
COUPPCD shows there value when Basis<0 or Basis>4, and settlement date greaterthan or equal to maturity date.
COUPPCD
Lets see an example in (Column3,Row1)
=COUPPCD(B2,B3,B4,B5)
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 |