https://bugs.documentfoundation.org/show_bug.cgi?id=156572
Bug ID: 156572 Summary: tbillyield() calculation returns incorrect yields for some dates Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: fwom...@gmail.com Created attachment 188708 --> https://bugs.documentfoundation.org/attachment.cgi?id=188708&action=edit tbillyield() does not match Excel formula and generates inconsistent numbers tbillyield() returns inconsistent sometimes incorrect yield values depending on the dates used, even though the number of days are the same. For example: settle mature days price tbillyield() computed 01/17/23 02/28/23 42 99.384 5.3127% 5.3127% 01/24/23 03/07/23 42 99.384 5.0712% 5.3127% 01/31/23 03/14/23 42 99.384 4.9585% 5.3127% The computed column uses the microsoft formula for tbillyield() is describe in https://support.microsoft.com/en-us/office/tbillyield-function-6d381232-f4b0-4cd5-8e97-45b9c03468ba tbillyield should produce the same value if the number of days and price are the same. Loading the same exact *.ods file into Excel produces correct values for tbillyeild() that matches the same computed values. So, LibreOffice is computing tbillyield() incorrectly. I hope other's aren't relying on this financial formula for their decisions. -- You are receiving this mail because: You are the assignee for the bug.