COUPPCD

Formulas / COUPPCD
Calculate the previous coupon date before the settlement date for a coupon bond.
=COUPPCD(settlement, frequency, maturity, [basis])
  • Settlement - required, the settlement date for a given security
  • Maturity - required, the date the security expires
  • Frequency - required, the number of coupon payments per year
  • Basis - [OPTIONAL]

Examples

    =COUPPCD(C6,C7,C10,C11) returns 1-Jul-2019. This Sourcetable function calculates the next coupon payment date, given the start and end dates of the bond, and the coupon frequency and basis.

    =COUPPCD(DATE(2019,9,1),DATE(2029,1,1),2,0) returns 1-Jul-2019 with hardcoded values. Here, the start and end dates are hardcoded as September 1, 2019, and January 1, 2029, respectively. The coupon frequency is 2 and the basis is 0.

Summary

The COUPPCD function can be used to quickly determine the previous coupon date before a given settlement date. It is an efficient tool for financial calculations.

  • The COUPPCD function returns the previous coupon date before the settlement date for a coupon bond. If the maturity date is not later than the settlement date, the function will return #NUM!.
  • The COUPPCD function does not ignore time.

Frequently Asked Questions

What is the COUPPCD function?
The COUPPCD function returns the previous coupon date before the settlement date for a bond.
How many arguments does the COUPPCD function take?
The COUPPCD function takes three required arguments.
What type of data can I use with the COUPPCD function?
The COUPPCD function can be used to return the previous coupon date before the settlement date for a bond.
What are the three arguments of the COUPPCD function?
  • The first argument is the settlement date.
  • The second argument is the maturity date.
  • The third argument is the frequency of the coupon payments.

Related Functions

Get smart about your data.

Connect, sync, and query data from 37+ data sources, without code.
Get unlimited access free for 14 days.