Bug 129361 - YIELD function in Calc provides different result than Excel, when there is one coupon period or less until redemption.
Summary: YIELD function in Calc provides different result than Excel, when there is on...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2019-12-13 04:37 UTC by Jack
Modified: 2020-01-13 20:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example with Yield function (14.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-13 10:16 UTC, Roman Kuznetsov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jack 2019-12-13 04:37:01 UTC
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.
Comment 1 Roman Kuznetsov 2019-12-13 10:11:32 UTC
I can confirm a difference between Calc and Excel in

Version: 6.5.0.0.alpha0+ (x64)
Build ID: ff566c67d67e96c97bcf4064b39df6998733c84e
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 2 Roman Kuznetsov 2019-12-13 10:16:31 UTC
Created attachment 156545 [details]
Example with Yield function

You can open it in MSO and will see another result than in Calc
Comment 3 Jack 2020-01-13 20:51:44 UTC
Should be fixed ASAP. It's very common to buy and sell bonds that mature in less than 6 months.