![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |