The Excel COUPPCD FUNCTION stands for coupon previous date. In MS Excel, COUPPCD function is categorized under financial function. The function returns the previous coupon date, before the settlement date for security.
Purpose of Excel COUPPCD Function
To get the previous coupon date of the security.
Return value
The function returns the result in the form of a date.
Syntax
= COUPPCD(settlement, maturity, frequency, [basis])
Arguments
| Arguments | Description | Remarks |
| settlement | The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. | Mandatory |
| maturity | The security’s maturity date. The maturity date is the date when the security expires. | Mandatory |
| frequency | The number of coupon payments in a year: 1 = annual 2 = semi annual 4 = quarterly | Mandatory |
| [basis] | The type of day count basis to use. | Optional |
| BASIS | DAY COUNT BASIS |
| 0 or Omitted | US (NASD) 30/360 |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
Usage note
- All arguments are truncated to integers.
- If settlement or maturity is not a valid date, the function returns the #VALUE! error value.
- If frequency is any number other than 1, 2, or 4, the function returns the #NUM! error value.
- If basis < 0 or if basis > 4, the function returns the #NUM! error value.
- If settlement ≥ maturity, the function returns the #NUM! error value.
- Microsoft Excel stores date as sequential serial numbers so they can be used in calculations.
Availability
Since 2007 for Windows.
Since 2011 for Mac.