Talk:Documentation/Calc Functions/TBILLYIELD
SF Comments
- (1) Summary. Insert “US” after “a” and use an initial uppercase letter for “Treasury”.
- (2) Returns. Suggest replacing with the following – “Returns a real number (a percentage, expressed as a decimal fraction) which is the yield for a US Treasury bill with the given arguments.”.
- (3) Arguments, Settlement. Change “date of purchase of the security” to “settlement / purchase date of the Treasury bill”.
- (4) Arguments, Maturity. Change “date on which the security matures (expires)” to “the maturity / redemption date of the Treasury bill”.
- (5) Arguments, Price. Suggest changing “price (purchase price) of the treasury” to “issue price for the US Treasury”.
- (6) Arguments, 1st bullet. Suggest replacing with “If either Settlement or Maturity is not a valid date then the function returns a value (#VALUE!) error”.
- (7) Arguments, 2nd bullet. Insert “the” before “Settlement”. Settlement = Maturity should also give an error.
- (8) Arguments, bullets. Need to include the error condition that occurs when the number of days between settlement and maturity is greater than 360 (when computed using a 360 day year basis). Please include an example of this in the Examples section.
- (9) Additional details. Suggest adding link to the Wikipedia page at https://en.wikipedia.org/wiki/United_States_Treasury_security#Treasury_bill.
- (10) Additional details. Suggest including the following paragraph – “A US Treasury bill (often shortened to T-bill) is a short term (up to a year) government security, sold at a discount to its par value (face value). It pays no interest and is redeemed at par value. The Treasury bill has a 360-day year basis.”.
- (11) Additional details. I have checked the code and the equation for this function is TBILLYIELD = ((100 – Price)/Price) x 360/DSM where DSM is defined as for TBILLEQ.
- (12) Additional details. It might be worth including a comment that the underlying formula for this function may not apply to Treasury bills issued by other governments.
- (13) Examples, 1st example. Change “treasury bill” to “US Treasury bill”.
- (14) Examples, 3rd example. Insert “the” before “Settlement”.
--Stevefanning (talk) 2020-11-27T16:26:33 (UTC)