OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-formula] Do definitions vary?

Hi Patrick,

On Thursday, 2009-12-10 11:52:18 -0500, Patrick Durusau wrote:

> A question from the financial functions section:
> Do any of the following (for example), change from function to function?
>> /issue/ The security's issue or dated date.
>> /first/ The security's first interest date.
>> /settlement/ The security's settlement date.
>> /coupon/ The security's annual coupon rate.
>> /par/ The security's par value, that is, the principal to be paid at  
>> maturity.
>> /frequency /The number of coupon payments per year.
>> /basis/ The type of day-count basis to use; see section 3.10.6

I _think_ they don't change. Care has to be taken though, for example,
in ACCRINT settlement is defined as settlement date, in ACCRINTM
settlement is defined as maturity date, it looks like they have equal
meaning, but I'm not sure. But then we have COUPDAYBS, COUPDAYSNC and
others where both, settlement and maturity, are different parameters.

I'm by no means a financial functions expert..


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

PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]