Issue 92177 - ODDFPRICE, ODDFYIELD faulty
Summary: ODDFPRICE, ODDFYIELD faulty
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needhelp, oooqa
Depends on:
Blocks: 110571
  Show dependency tree
 
Reported: 2008-07-27 08:42 UTC by drking
Modified: 2014-01-21 02:33 UTC (History)
2 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description drking 2008-07-27 08:42:18 UTC
As documented in the June08 ODFF draft:

ODDFPRICE("1990-06-01"; "1995-12-31"; "1990-01-01"; "1990-12-31"; 6%; 5%; 1000; 
1; 1)
gives an error.

ODDFYIELD("1990-06-01"; "1995-12-31"; "1990-01-01"; "1990-12-31"; 6%; 790; 100; 
1; 1)
gives an error.

ODDLPRICE("1990-06-01"; "1995-12-31"; "1990-01-01"; 2%; 1.5%; 100; 4; 1)
is inaccurate; gives same result as 
ODDLPRICE("1990-06-01"; "1995-12-31"; "1990-01-01"; 2%; 1.5%; 100; 1; 1).

ODDLYIELD("1990-06-01"; "1995-12-31"; "1990-01-01"; 2%; 103; 100; 4; 1)
is inaccurate; gives same result as
ODDLYIELD("1990-06-01"; "1995-12-31"; "1990-01-01"; 2%; 103; 100; 1; 1).

It turns out that this was discussed in the forums at least as early as 2005, 
but no-one raised an issue.
Comment 1 drking 2008-08-15 19:38:30 UTC
The code for 2 of these functions has simply been commented out, and an error 
call inserted - which explains why they always return an error ;)
Comment 2 Rainer Bielefeld 2010-04-02 18:55:19 UTC
ODDLPRICE does work with "Ooo-Dev 3.2.1 multilingual version English UI WIN XP:
[OOO300m14 (Build 9489)]" and example from HELP, so I strike this from summary.

ODDLYIELD does work with "Ooo-Dev 3.2.1 multilingual version English UI WIN XP:
[OOO300m14 (Build 9489)]" and example from HELP, so I strike this from summary

For ODDFPRICE, ODDFYIELD I can't find a working formula (always "#VALUE" or
error 502) - may be this is the reason why there is no example in help? I filed
Issue 110571 for missing examples.

My knowledge concerning these Financial Functions is rather poor, someone should
check my results.
Comment 3 Rob Weir 2014-01-21 02:33:48 UTC
Code that we could possibly use, under the Apache License:

http://fsprojects.github.io/ExcelFinancialFunctions/

It would need to be ported to C++, but at least it has the logic.