Talk:Documentation/Calc Functions/COUPPCD
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.