Talk:Documentation/Calc Functions/RECEIVED

    From The Document Foundation Wiki

    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)