Talk:Documentation/Calc Functions/COUPPCD

    From The Document Foundation Wiki

    SF Comments

    (1) Summary. Suggest the following re-word – “Calculates the last coupon date prior to or on the settlement date.”.
    (2) Result. Suggest the following replacement – “Returns a number representing the last coupon date prior to or on the settlement date. Since Calc handles date / time values as numerical values, you may need to format the result to view it as a date”.
    (3) 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.
    (4) Additional details. Might be worth stating that the function calculates back from the maturity date to find the required coupon date.
    (5) 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 date prior to purchase” to “coupon date prior to the settlement date”.
    (6) Examples, 4th example. Insert “the” before “Settlement”. Also, there is a spurious apostrophe in the formula, immediately after the function name.
    (7) 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:57:45 (UTC)

    LV Comments

    Updated the page based on SF comments.