Bug 130823 - LibreOffice CALC TBILLYIELD function returns incorrect interest rate (Too low).
Summary: LibreOffice CALC TBILLYIELD function returns incorrect interest rate (Too low).
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2020-02-20 20:34 UTC by edwardk
Modified: 2020-03-08 11:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
THIS FILES USES TBILLYIELD - RUN IN CALC AND EXCEL! NOTE DIFFERENCE (4.76 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-02-20 21:52 UTC, edwardk
Details

Note You need to log in before you can comment on or make changes to this bug.
Description edwardk 2020-02-20 20:34:24 UTC
Description:
LibreOffice CALC 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









Steps to Reproduce:
1.TBILLYIELD(Settlement; Maturity; Price)
(02/25/20, 03/24/20, 99.8775) 
2.
3.

Actual Results:
returns .014718

Expected Results:
SHOULD RETURN .01577

as verified with MS EXCEL


Reproducible: Always


User Profile Reset: No



Additional Info:
SHOULD RETURN .01577

as verified with MS EXCEL
Comment 1 m.a.riosv 2020-02-20 21:43:42 UTC
please attach a sample file for test.
Comment 2 edwardk 2020-02-20 21:52:11 UTC
Created attachment 158065 [details]
THIS FILES USES TBILLYIELD - RUN IN CALC AND EXCEL! NOTE DIFFERENCE

THIS FILES USES TBILLYIELD - RUN IN CALC AND EXCEL! NOTE DIFFERENCE
Comment 3 edwardk 2020-02-20 21:55:09 UTC
RUN ATTACHED FILE IN BOTH EXCEL AND CALC NOTE DIFFERENCE!
Comment 4 QA Administrators 2020-02-21 02:50:54 UTC Comment hidden (obsolete)
Comment 5 Roman Kuznetsov 2020-02-22 19:49:52 UTC
Edward, please write here info from LibreOffice's Help-About dialog
Comment 6 Karl 2020-03-08 11:03:48 UTC
hi,

have opend the attachement and confirm the same result .014718

Version: 6.4.1.2 (x64)
Build-ID: 4d224e95b98b138af42a64d84056446d09082932
CPU-Threads: 4; BS: Windows 10.0 Build 18363; UI-Render: GL; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: CL

regards