[Libreoffice-bugs] [Bug 130823] LibreOffice CALC TBILLYIELD function returns incorrect interest rate (Too low).

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Sep 5 15:15:51 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=130823

--- Comment #8 from edwardk at vivaldi.net ---
Dear Sirs,

I have provided ALL info necessary to reproduce this bug in the original
submission. The function

TBILLYIELD functions return incorrect interest rate.

Using the following inputs:

TBILLYIELD(Settlement; Maturity; Price)

(02/25/20, 03/24/20, 99.8775) returns .014718 SHOULD RETURN .01577

as verified with MS EXCEL


COMPARE THE RESULT OF CALC TBILLYIELD WITH THE MICROSOFT OFFICE EXCEL VERSION!

SEE COMMENT BELOW THE RESULT .014718 IS INCORRECT! This should be a simple fix!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200905/7e353c28/attachment.htm>


More information about the Libreoffice-bugs mailing list