Talk:Documentation/Calc Functions/COUPNUM

    From The Document Foundation Wiki

    SF Comments

    (1) Summary. Suggest inserting “the” before “settlement”.
    (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 first step is to find the last coupon date before settlement using COUPPCD. The second step is to calculate the number of months between that coupon date and the maturity date. The final step is to calculate months * frequency / 12.
    (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, change “interest dates are there” to “coupon dates are there after the settlement 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:45:24 (UTC)

    LV Comments

    Updated the page based on SF comments.