accrint (Financial library)

Phillip J Shelton shelton11@dingoblue.net.au
Fri, 19 Jan 2001 09:35:11 +1000


--------------5DB578A4C0DB890D4343FAB8
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

This is the description of the function accrint

FUNCTION=ACCRINT
SYNTAX=ACCRINT(issue,first_interest,settlement,rate,par,frequency,basis)

DESCRIPTION
   ACCRINT calculates the accrued interest for a security that pays
periodic interest.  The  rate is the annual rate of the security and par
is the principle[?] value of the security. basis is the type of day
counting system you want to use:

           0  US 30/360
           1  actual days/actual days
           2  actual days/360
           3  actual days/365
           4  European 30/360

If basis is omitted, US 30/360 is applied.
If issue date or settlement date is not valid, ACCRINT returns  #NUM!
error.
If rate or par are zero or negative, ACCRINT returns #NUM! error.
If basis < 0 or basis > 4, ACCRINT returns #NUM! error.
If issue date is after settlement date or they are the same, ACCRINT
returns #NUM! error.

QUESTION: What is the first_interest meant to do? Is it a date?
QUESTION: How is frequency meant to be used.  My assumption is that the
frequency is  how often the interest is added to the principle.  And
will be one or more times per year.  Is there any case where you might
have interest added less then once a year?

gnumeric, from looking at the code for this functions I feel that it is
wrong but until I know what it is meant to do I can not help with the
patch to fix it.

Phill

--------------5DB578A4C0DB890D4343FAB8
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
This is the description of the function accrint

FUNCTION=ACCRINT
SYNTAX=ACCRINT(issue,first_interest,settlement,rate,par,frequency,basis)
DESCRIPTION
   ACCRINT calculates the accrued interest for a security that pays periodic interest.  The  rate is the annual rate of the security and par is the principle[?] value of the security. basis is the type of day counting system you want to use:
 
           0  US 30/360
           1  actual days/actual days
           2  actual days/360
           3  actual days/365
           4  European 30/360
 
If basis is omitted, US 30/360 is applied.
If issue date or settlement date is not valid, ACCRINT returns  #NUM! error.
If rate or par are zero or negative, ACCRINT returns #NUM! error.
If basis < 0 or basis > 4, ACCRINT returns #NUM! error.
If issue date is after settlement date or they are the same, ACCRINT returns #NUM! error.

QUESTION: What is the first_interest meant to do? Is it a date?
QUESTION: How is frequency meant to be used.  My assumption is that the frequency is  how often the interest is added to the principle.  And will be one or more times per year.  Is there any case where you might have interest added less then once a year?

gnumeric, from looking at the code for this functions I feel that it is wrong but until I know what it is meant to do I can not help with the patch to fix it.

Phill --------------5DB578A4C0DB890D4343FAB8--