Talk:Documentation/Calc Functions/COUPDAYSNC

SF Comments

(1) Returns. Change “interest” to “coupon”.

(2) Arguments, general. After implementing my comments on COUPDAYBS, please update this section to match exactly the text in the Arguments section of the COUPDAYBS page.

(3) Additional details. The logic is as follows. If Basis = 1, 2 or 3 (when the actual days per month is used for counting days) then the function uses COUPNCD to find the next coupon date after the settlement date, and then calculates the number of days between the settlement date and that coupon date. For Basis= 0 or 4 (when 30 days are assumed per month) then the function calculates COUPDAYS – COUPDAYSBS.

(4) Examples, 1st and 2nd examples. I do not recall using the term “daily balance interest calculation” in all the previously reviewed financial functions. Perhaps we should use “day count convention”, which seems to be a commonly used term. Also, for consistency, change “interest payment” to “coupon date”.

(5) Examples, 4th example. Insert “the” before “Settlement”.

(6) Examples, general. Maybe include some examples which use the DATE function, enter dates as numbers and use the % format for the Rate argument.

--Stevefanning (talk) 2020-11-13T14:06:37 (UTC)

LV Comments

Updated the page based on SF comments.