COUPPCD(S, M, F [, B]) |
![]() ![]() ![]() |
Description
This function returns the previous (most recent) coupon date before the settlement date.
Parameters
S
The settlement date.
M
The maturity date.
F
The number of coupon payments per year (frequency).
B
(Optional) The day count basis to be used:
0 or omitted |
30/360 |
1 |
actual/actual |
2 |
actual/360 |
3 |
actual/365 |
Examples
COUPPCD(DATE(93, 2, 15), DATE(94, 12, 20), 2, 0) = 33958
(Which corresponds to 12/20/92.)
Try Predictive Systems Lab
Need Help?
Contact support