Talk:Documentation/Calc Functions/ACCRINTM

SF Comments

(1) Summary. Suggest replacing with – “Calculates the accrued interest for a security that pays interest on maturity.”. (Involving the word maturity here gives a clue where the “M” comes from in the function’s name!)

(2) Returns. Suggest replacing with the following – “Returns a positive real number which is the accrued interest, expressed in the same currency units that were used for the security’s par value.”.

(3) Arguments, Rate. Delete “interest” after “coupon”. State that this can be entered as a percentage (e.g. “2.5%”) as well as a real number (e.g. “0.025”).

(4) Arguments, Par. Suggest including the same note under this parameter as appears for ACCRINT. (I have also added this suggestion to the list of Help changes.)

(5) Arguments, Basis. I would include a link to Wikipedia’s “Day count convention” page.

(6) Arguments, 1st bullet. Suggest the following re-word for better grammar – “If either of Issue or Settlement are not valid dates then the function returns a value (#VALUE!) error.”. However the whole bullet needs thinking about because dates are essentially just numbers (search for "date and time functions" in the Help) – for example =ACCRINTM(3,5,0.1) does not give an error.

(7) Arguments, 3rd bullet. Insert “the” before “Issue”.

(8) Arguments, 4th bullet. Suggest the following re-word for better grammar – “If Basis is a non-integer value, then the function uses its floor value, i.e. it is truncated to an integer value.”.

(9) Arguments, 5th bullet. Change “ny” to “any”. I would remove the text in brackets as it does not really add anything.

(10) Additional details. Please delete the material in this section. Instead include a link to Wikipedia’s “Accrued interest” page and include a simple equation which is valid for our application. That equation should express that the accrued interest = (Rate * Par) * (days of interest earned / days per year). (Note: I am aware this is not vastly different from what’s there already!)

(11) Examples, 1st and 3rd examples. Last sentence of the Description not understood. Can we replace with clearer – “The basis used is option 3 (exact number of days in month, year has 365 days)”.

(12) Examples, 3rd example. Insert space before open round bracket within description.

(13) Examples, general. Maybe include some examples which use the DATE function, enter dates as numbers and use the % format for the Rate argument.

(14) ODF standard. Is there some reason why we have not included the appropriate link here? (If we do add a reference to the ACCRINTM chapter in the ODF, we might consider noting that the ODF specifies Par to be a required argument while it is optional in Calc).

(15) Equivalent Excel functions. Is there some reason why we have not mentioned Excel’s ACCRINTM function?

--Stevefanning (talk) 2020-11-11T19:58:34 (UTC)

Ronnie

All points addressed. --Ronnie rg8888 (talk) 2020-12-21T07:13:16 (UTC)