[Libreoffice-bugs] [Bug 129361] New: YIELD function in Calc provides different result than Excel, when there is one coupon period or less until redemption.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129361
           Summary: YIELD function in Calc provides different result than
                    Excel, when there is one coupon period or less until
                    redemption.
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: russell_jackson_ii at hotmail.com

Description:
For example:

Settlement: 12/16/19
Maturity: 12/30/19
Rate 0.054
Price: 100
Redemption: 100
Frequency: 2
Basis: 4

Applying YIELD to this, results in 0.05268806713 in Excel, and
0.053332866925242 in LibraOffice Calc.

Excel uses a special formula when there is "one coupon period or less until
redemption:
https://support.office.com/en-us/article/yield-function-f5f5ca43-c4bd-434f-8bd2-ed3c9727a4fe

Steps to Reproduce:
Settlement: 12/16/19
Maturity: 12/30/19
Rate 0.054
Price: 100
Redemption: 100
Frequency: 2
Basis: 4

YIELD(12/16/19,12/30/19,0.054,100,100,2,4)

Actual Results:
Results in 0.053332866925242 in LibraOffice Calc.

Expected Results:
Results in 0.05268806713 in Excel


Reproducible: Always


User Profile Reset: No



Additional Info:
Should have had that same result as Excel.

-- 
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/20191213/aa1f822f/attachment.htm>