[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Second DURATION needed
Hi, Currently we have a DURATION defined as DURATION( Number rate ; Number currentValue ; Number desiredValue ) This probably because OOo for some legacy reason had implemented it for compatibility with whatever application. However, OOo also defines DURATION_ADD( Number Settlement ; Number Maturity ; Number Coupon ; Number Yield ; Number Frequency [ ; Integer Basis = 0 ] ) which btw is also used to compute MDURATION. Gnumeric has DURATION with those 5+1 parameters and additionally has a function G_DURATION with 3 parameters same as OOo's DURATION. I propose to rename the spec's current DURATION to LEGACY.DURATION and add DURATION with 5 parameters. Does anyone have a mathematical formula for DURATION offhand? Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.