COUPPCD
Category: Financial Function.
Description: Returns a number that represents the previous coupon date before the settlement date.
Syntax: COUPPCD(settlement, maturity, frequency, [basis])
The COUPPCD function syntax has the following arguments:
Settlement: security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
Maturity: security's maturity date. The maturity date is the date when security expires.
Frequency: number of coupon payments per year. Annual payments, frequency = 1; for semiannual, frequency = 2; for quaterly, frequency = 4.
Basis: type of day count basis to use.