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.
