https://bugs.documentfoundation.org/show_bug.cgi?id=100652
Bug ID: 100652
Summary: DURATION & DURATION_ADD function
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Duration function defined in help:
http://vm173.documentfoundation.org/text/scalc/01/04060119.xhp#bm_id3154671
Duration function defined in ODFF> 6.12.18DURATION
Summary: Returns the Macaulay duration of a fixed interest security in years
Syntax: DURATION( Date Settlement ; Date Maturity ; Number Coupon ; Number
Yield ; Number Frequency [ ; Basis Basis = 0 ] )
Returns: Number
Constraints: Yield >=0, Coupon >= 0, Settlement <= Maturity; Frequency = 1, 2,
4
Semantics: Computes the Macaulay duration, given:
Settlement the date of purchase of the securityMaturity the date when the
security matures
DURATION_ADD function
https://help.libreoffice.org/Calc/Financial_Functions_Part_One#DURATION_ADD
So ODF>duration = Calc>DURATION_ADD. It's confusing.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
