- Picture and text skills
- Case
Returns the number of days in the interest payment period where the settlement date is located.
Grammar
COUPDAYS(settlement, maturity, frequency, [basis])
Important: You should enter the date using the DATE function, or pass the date as Input the results of other formulas or functions. For example, use the function DATE(2008,5,23) to enter May 23, 2008. The problem occurs if the date is entered as text.
COUPDAYS function syntax has the following parameters:
▪Settlement Required. The settlement date of a security. The settlement date of the securities is the date after the issuance date when the securities are sold to the purchaser.
▪Maturity Required. The maturity date of a security. The expiry date is the date when a security expires.
▪Frequency Required. Number of annual interest payments. If you pay annually, frequency = 1; if you pay semiannually, frequency = 2; if you pay quarterly, frequency = 4.
▪Basis Optional. The type of day count basis to use.
Basis | Daily counting basis |
0 or omitted | US (NASD) 30/360 |
1 | Actual/Actual |
2 | Actual/360 |
3 | Actual/365 |
4 | Europe 30/360 |
Remarks
▪ Dates can be stored in tables as serial numbers that can be used for calculations. By default, the serial number for January 1, 1900 is 1, and the serial number for January 1, 2008 is 39448 because it is 39448 days from January 1, 1900.
▪The settlement date is the date when the buyer purchases the coupon (such as a bond). The maturity date is the date when the coupon expires. For example, a 30-year bond issued on January 1, 2008, was purchased by a buyer six months later. The issuance date is January 1, 2008, the settlement date is July 1, 2008, and the maturity date is 30 years after the issuance date of January 1, 2008, that is, January 1, 2038.
▪All parameters will be truncated.
▪If the settlement or expiration date is not a valid date, COUPDAYS returns the #VALUE! error value.
▪ If frequency is any number other than 1, 2, or 4, COUPDAYS returns the #NUM! error value.
▪ If basis < 0 or basis > 4, COUPDAYS returns the #NUM! error value.
▪ If settlement ≥ maturity, COUPDAYS will return a #NUM! error value.
Example
Data | Description | Description | strong>|
---|---|---|---|
2011 -1-25 | Settlement Day | ||
2011-11-15 | Expiration date | < /td> | |
2 | Pay semi-annually (see information above) | ||
1 | In actual days/actual The number of days is the basis for daily counting (see information above) | ||
Formula | Explanation | results | |
=COUPDAYS(A2,A3,A4,A5) | The number of days in the bond coupon period including the settlement date under the above conditions. | 181 |
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-cai-wu-han-shu-COUPDAYS-han-shu-ji-suan-jie-suan-ri-fu-xi-qi-tian-shu.html
评论列表(196条)
测试