ActualActual ) Excel: 250.105148 LibreOffice: 249.982925 // the only function which seems to behave differently in Excel Office for Mac Financial. SemiAnnual, basis ) accrint Da圜ountBasis. in our tests, the numbers for European 30/360 basis were the same. Most likely the differences can be explained with YEARFRAC/day count implementations.ĭURATION in OO is a completely different function, the analog of Excel one is called DURATION_ADD. ActualActual ) Excel: -0.00327205 LibreOffice: -0.002925876 ACCRINT, DISC, DURATION, PRICE, YIELD, INTRATE, TBILL* and others ActualActual ) Excel: -0.00327563 LibreOffice: -0.002925876 // Returns the same value even though the frequency is different Financial. ActualActual ) Excel: 0.059976999 Financial.
These functions currently return invalid results (it's #VALUE! even for valid inputs).
Most of the differences are because of the day count conventions and root finding algorithm implementation details. The library was designed to be Excel-compliant (see Compatibility section), therefore its behavior is different from OpenOffice/LibreOffice. Difference between OpenOffice and the library
0 kommentar(er)
