Talk:Documentation/Calc Functions/PRICEDISC

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)