Talk:Documentation/Calc Functions/COUPDAYBS

SF Comments

 * (1) Summary. Is the following an improvement? “Calculates the latest coupon date falling before or on the settlement date and returns the number of days between that coupon date and the settlement date.”.
 * (2) Returns. Suggest the following re-word – “Returns a non-negative integer which is the count of days from the previous coupon date until the settlement date”.
 * (3) Arguments, Settlement. Suggest replacing “date at which the interest accrued up until then is to be calculated” with “settlement date”.
 * (4) Arguments, Maturity. Suggest replacing “date on which the security matures (expires)” with “maturity date”.
 * (5) Arguments, Frequency. I see no value in the table and would delete it.
 * (6) Arguments, Basis. I would include a link to Wikipedia’s “Day count convention” page.
 * (7) Arguments, 1st bullet. Suggest the following re-word for better grammar – “If either of Settlement or Maturity is not a valid date then the function returns a value (#VALUE!) error.”. However, may be worth mentioning that dates are essentially just numbers (search for "date and time functions" in the Help).
 * (8) Arguments, 2nd bullet. Insert “the” before “Settlement”.
 * (9) Arguments, 3rd bullet. Suggest the following re-word for better grammar – “If either Frequency or Basis is a non-integer value, then the function uses its floor value, i.e. it is truncated to an integer value.”.
 * (10) Arguments, 5th bullet. Change “ny” to “any”. I would remove the text in brackets as it does not really add anything.
 * (11) Additional details. Might be worth stating that the function calculates back from the maturity date to find the required coupon date.
 * (12) Examples, 1st and 2nd examples. I do not recall using the term “daily balance interest calculation” in the previously reviewed financial functions. Perhaps we should use “day count convention”, which seems to be a commonly used term.
 * (13) Examples, 4th example. Insert “the” before “Settlement”.
 * (14) 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-13T10:29:50 (UTC)

LV Comments
Updated the page based on SF comments.