Excel Functions

Excel COUPPCD Function

Pinterest LinkedIn Tumblr

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.

Excel-COUPPCD-Function

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

ArgumentsDescriptionRemarks
settlementThe security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. Mandatory
maturityThe security’s maturity date. The maturity date is the date when the security expires. Mandatory
frequencyThe 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
BASISDAY COUNT BASIS
0 or OmittedUS (NASD) 30/360
1Actual/actual
2Actual/360
3Actual/365
4European 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.

Related Posts

Write A Comment