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)