Talk:Documentation/Calc Functions/RECEIVED

SF Comments

 * (1) Summary. Suggest replacing with the following – “Calculates the amount returned at maturity for a discounted security which pays no interest”.
 * (2) Returns. Suggest changing “amount received at maturity for a zero-coupon bond” to “amount returned at maturity for a discounted security which pays no interest”.
 * (3) Arguments, Settlement. For consistency, suggest changing “date of purchase” to “settlement / purchase date”.
 * (4) Arguments, Maturity. Suggest replacing “date on which the security matures (expires)” with “maturity / redemption date of the security”.
 * (5) Arguments, Investment. Insert “positive” before “real number”. Suggest changing “purchase sum” to “value of the bond at purchase”.
 * (6) Arguments, Discount. Insert “decimal” before “fraction”. Change “discount of security” to “annual discount rate of the security”.
 * (7) Arguments, Basis. Please update to address comments on other instances of this argument.
 * (8) Arguments, 1st bullet. Suggest replacing with “If either Settlement or Maturity is not a valid date then the function returns a value (#VALUE!) error”.
 * (9) Arguments, 2nd bullet. Insert “the” before “Settlement”. I think it also returns an error if the two are equal.
 * (10) Arguments, 4th bullet. Change “their” to “its” and change “they are” to “it is”.
 * (11) Arguments, 5th bullet. I would remove the text in brackets as it does not really add anything.
 * (12) Examples, 4th example. The formula for this example is the same as that for the 1st example and, not surprisingly, does not return a 502 error.
 * (13) Examples, 5th example. In the formula given, the 502 error is probably caused by the 0 value for the Investment argument rather than the reason given in the Description field.
 * (14) Related LibreOffice functions. Why is INTRATE included here?
 * (15) ODF standard. The link opens the ODF but does not take the user directly to the function.

--Stevefanning (talk) 2020-11-26T10:38:35 (UTC)