COUPNUM

Number of coupons between dates

Description
Calculates the number of interest payments/coupons between the given settlement data and the investment's maturity date.
Function signature
COUPNUM(settlement: String, maturity: String, frequency: Number, basis: String = us_nasd) => Number
Parameter
Description
Settlement
The security's settlement date.
Maturity
The security's maturity or end date.
Frequency
Yearly interest/coupon payments count (1, 2, or 4).
Basis
Method to use for counting days per month/year:
`us_nasd` (default): 30-day month, 360-day year, i.e. US (NASD).
`actual`: Actual number of days per month/year.
`actual_360`: 360 day year, actual number of days per month.
`actual_365`: 365 day year, actual number of days per month. This means leap years are not taken into account.
`european`: Like `us_nasd`, but for months that are not 30 days long, European standards are used.
Examples
date1 = "2020-02-01T13:06:15+03:00"
date2 = "2023-12-31T13:06:15+03:00"
date3 = "2020-01-31T13:06:15+03:00"
date4 = "2023-10-31T13:06:15+03:00"
date5 = "2020-01-30T13:06:15+03:00"
date6 = "2023-10-30T13:06:15+03:00"
date7 = "2020-01-31T13:06:15+03:00"
date8 = "2023-10-30T13:06:15+03:00"
Formula
Return value
COUPNUM(date1, date2, 2, "actual")
8
COUPNUM(date3, date4, 1, "us_nasd")
4
COUPNUM(date5, date6, 1)
4
COUPNUM(date7, date8, 4, "european")
15

COUPNCD

COUPPCD

Last updated 9 months ago

Formula	Return value
`COUPNUM(date1, date2, 2, "actual")`	`8`
`COUPNUM(date3, date4, 1, "us_nasd")`	`4`
`COUPNUM(date5, date6, 1)`	`4`
`COUPNUM(date7, date8, 4, "european")`	`15`

Parameter	Description
Settlement	The security's settlement date.
Maturity	The security's maturity or end date.
Frequency	Yearly interest/coupon payments count (1, 2, or 4).
Basis	Method to use for counting days per month/year: `us_nasd` (default): 30-day month, 360-day year, i.e. US (NASD). `actual`: Actual number of days per month/year. `actual_360`: 360 day year, actual number of days per month. `actual_365`: 365 day year, actual number of days per month. This means leap years are not taken into account. `european`: Like `us_nasd`, but for months that are not 30 days long, European standards are used.