Second DURATION needed

[Eike Rathke <erack@sun.com>]

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.