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: Excel-Functions
  Show dependency tree / graph
 
Reported: 2019-12-13 04:37 UTC by Jack
Modified: 2022-09-10 16:53 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
View All Add an attachment (proposed patch, testcase, etc.)

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.
Comment 4 Jack 2020-10-13 17:37:35 UTC 
Why is this taking so long to be corrected? How can I expedite this?