COUPNUM
COUPNUM ( settlement , maturity , frequency [ , [ basis ] ] )
Description: Computes the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
Arguments:
Name |
Type |
Description |
||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
settlement |
number |
The security's settlement date. |
||||||||||||
maturity |
number |
The security's maturity date. |
||||||||||||
frequency |
number |
The number of coupon payments per year. For annual payments, frequency is 1; for semiannual payments, frequency is 2; for quarterly payments, frequency is 4. frequency is truncated to an integer. |
||||||||||||
basis |
number |
The truncated integer type of day count basis to use, as follows:
|
Time information in the date arguments is ignored.
Return Type and Value: number – The number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
However, if
settlement or maturity is out of range for the current date base value,
#NUM!is returned.settlement ≥ maturity,
#NUM!is returned.frequency is any number other than 1, 2, or 4,
#NUM!is returned.basis < 0 or basis > 4,
#NUM!is returned.