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