--------------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