Re: [office-formula] Second DURATION needed

[Eike Rathke <erack@sun.com>]

On Tuesday, 2007-03-20 16:22:47 -0500, David A. Wheeler wrote:

> Eike Rathke:
> > 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.
> 
> Excel has 5+1 parameters too.

Yes, I forgot to mention. Kspread has the 3 parameters DURATION.

> > I propose to rename the spec's current DURATION to LEGACY.DURATION and
> > add DURATION with 5 parameters.
> 
> I agree with the rename and addition of the 5+1 parameter DURATION.  In the words of Capt. Picard, please "make it so"!
> 
> Instead of "LEGACY.DURATION", though, can we find a better name? SIMPLE_DURATION or some such?  Anybody have a suggestion?

SIMPLE_DURATION then would be the only function with an underscore in
its name. How about PDURATION, as it returns a number of periods
required?

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.