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)