Talk:Documentation/Calc Functions/INTRATE

SF Comments

 * (1) Summary. A bit confusing for me as currently written. Suggest the following reword – “Calculates the equivalent un-compounded interest rate that would have to be paid on a zero-coupon security (or other item) purchased at an investment value and sold at a redemption value.”.
 * (2) Syntax. Update to match help page – Basis is an optional parameter.
 * (3) Returns. Insert “equivalent annual” before “interest”. Also, change “of fully vested security with” to “for”. Also need to explain that the returned value is a percentage interest rate expressed as a decimal number.
 * (4) Arguments, Settlement. Change “date at which the interest accrued up until then is to be calculated” to “purchase date”.
 * (5) Arguments, Maturity. Change “security matures (expires)” to “item was sold”.
 * (6) Arguments, Redemption. Change “redemption value of the security per 100 currency units of par value” to “amount received for the item”.
 * (7) Arguments, Basis. Please update to address comments on other instances of this argument.
 * (8) Arguments, 2nd bullet. Change “an” to “a”. Insert space before open round bracket.
 * (9) Arguments, 3rd bullet. Insert “the” before “Settlement”. I think it also returns an error if the two are equal.
 * (10) Arguments, 5th bullet. Change “ny” to “any”. I would remove the text in brackets as it does not really add anything.
 * (11) Examples, 1st examples. Change “The basis is daily balance calculation (basis = 3)” to “Day count convention (Basis) 3 is used”. Change “average annual level of interest” to “equivalent annual interest rate”.
 * (12) Examples, 2nd example. Change “The basis is daily balance calculation (basis = 0 by default)” to “Day count convention (Basis) 0 is used by default”. Change “average annual level of interest” to “equivalent annual interest rate”.
 * (13) Example, 4th example. The formula given is the same as that used in the 1st example and does not give an error. Also, insert “the” before “Settlement”.

--Stevefanning (talk) 2020-11-19T10:38:41 (UTC)