Description Computes the number of coupons between settlement and maturity. Maturity counts as a coupon date.
Syntax COUPNUM ( settlement, maturity, frequency [, calendar_type] )
Argument | Description |
---|---|
settlement | The date when the security is traded to the buyer. Dates in the argument list must be in the form of a serial number or text. |
maturity | The date the security expires and the remaining amount is paid to the investor. It must be later than settlement. Dates in the argument list must be in the form of a serial number or text. |
frequency | The number of interest payments per year. See "The frequency Argument" for more information. |
[calendar_type] | Optional. One of five methods of counting days for computing interest. See "The calendar_type Argument" for more information. |
Remarks This function rounds results up to the nearest integer, so if it finds 3 coupon periods plus 10 days, the result will be 4. This function truncates all arguments to integers.
Examples This function returns 4:
COUPNUM("1/25/93","8/31/94",2,0)
This function returns 7:
COUPNUM("1/25/93","8/31/94",4,0)
See Also COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPPCD