Issue 25439 - YIELDDISC: Excel vs Calc
Summary: YIELDDISC: Excel vs Calc
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-02-13 03:16 UTC by chiamyh
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
patch to fix this issue (767 bytes, patch)
2004-02-13 09:52 UTC, daniel.rentz
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description chiamyh 2004-02-13 03:16:12 UTC
I am comparing the YIELDDISC function for Excel 2000 and Calc in OOo 1.1.0. 
Both the applications run on the Windows 2000 Professional.
 
Let's say:
a) Settlement = 01/01/2001
b) Maturity = 12/31/2003
c) Price = 100
d) Redemption = 300
 
The results in Excel are as follows:
Basis 0: 66.6667%
Basis 1: 66.7276%
Basis 2: 65.8135%
Basis 3: 66.7276%
Basis 4: 66.7285%
 
The results in Calc are as follows:
Basis 0: 22.2679%
Basis 1: 22.2882%
Basis 2: 21.9829%
Basis 3: 22.2882%
Basis 4: 22.2885%

The results in Calc are incorrect.
Comment 1 frank 2004-02-13 08:15:15 UTC
Hi Daniel,

one for you I think.

Frank
Comment 2 frank 2004-02-13 08:15:55 UTC
Oooppps, forgot the target.
Comment 3 daniel.rentz 2004-02-13 09:50:38 UTC
Accepted. I will attach a patch.
Comment 4 daniel.rentz 2004-02-13 09:52:42 UTC
Created attachment 13099 [details]
patch to fix this issue
Comment 5 daniel.rentz 2004-05-25 12:54:58 UTC
fixed in src680/dr18
Comment 6 mci 2004-05-27 11:02:49 UTC
*** Issue 17214 has been marked as a duplicate of this issue. ***
Comment 7 mci 2004-05-27 11:04:09 UTC
sorry, I made a mistake....

issue i17214 is NOT duplicate to this issue...
Comment 8 daniel.rentz 2004-06-03 14:58:44 UTC
reopened to change owner
Comment 9 daniel.rentz 2004-06-03 14:59:34 UTC
back to QA
Comment 10 daniel.rentz 2004-06-03 15:00:33 UTC
back to fixed
Comment 11 oc 2004-06-28 14:36:29 UTC
verified in internal build cws_dr18
Comment 12 frank 2004-10-06 11:50:25 UTC
Found integrated in master src680m54 using Linux, Solaris and Windows build