Talk:Documentation/Calc Functions/PRICEDISC

    From The Document Foundation Wiki

    SF Comments

    (1) Summary. Suggest replacing with – “Calculates a price per 100 currency units of face (par) value for a non-interest paying, discounted security”.
    (2) Returns. Change “security with a discount” to “non-interest paying, discounted security”. Move “per 100 currency units of face value” forwards so that it is after “price”. Maybe mention that the result is in currency units.
    (3) Arguments, general. Please update descriptions of Settlement, Maturity, Redemption and Basis to match the corresponding arguments for PRICE().
    (4) Arguments, Discount. Change “discount of security” to “annual discount rate of the security.”. Presumably expressed as either a percentage or a decimal fraction.
    (5) Arguments, 1st bullet. Change “valid dates” to “a valid date”. Change “an” to “a”. Insert space before open round bracket.
    (6) Arguments, 2nd bullet. Insert “the” before “Settlement”. Settlement = Maturity should, and does, give an error.
    (7) Arguments, 3rd bullet. Change “their” to “its”. Change “they are” to “it is”.
    (8) Arguments, 4th bullet. Delete “of”.
    (9) Arguments, 5th bullet. I would remove the text in brackets as it does not really add anything.
    (10) Additional details. Maybe include a link to Wikipedia’s “Zero-coupon bond” page.
    (11) Additional details. Suggest adding the following high-level formula – “PRICEDISC = Redemption Value - (Redemption Value * Discount Rate * Days to Maturity / Days in Year)”.
    (12) Examples, 1st example. Delete “in per cent”. Add “currency units” after “100”. Insert “the” before “price discount”. The formula specifies Basis 2; the text states Basis 4.
    (13) Examples, 2nd example. Delete “in per cent”. Add “currency units” after “100”. Insert “the” before “price discount”.
    (14) Examples, 4th example. Insert “the” before “Settlement”.

    --Stevefanning (talk) 2020-11-24T20:17:57 (UTC)