Apache OpenOffice (AOO) Bugzilla – Issue 92177
ODDFPRICE, ODDFYIELD faulty
Last modified: 2014-01-21 02:33:48 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.
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 ;)
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.
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.