ACCRINT(mixed $issue, mixed $firstinterest, mixed $settlement, float $rate, float $par = 1000, integer $frequency = 1, integer $basis) : float
Returns the accrued interest for a security that pays periodic interest.
Excel Function: ACCRINT(issue,firstinterest,settlement,rate,par,frequency[,basis])
The security's issue date.
The security's first interest date.
The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
The security's annual coupon rate.
The security's par value. If you omit par, ACCRINT uses $1,000.
the number of coupon payments per year. Valid frequency values are: 1 Annual 2 Semi-Annual 4 Quarterly If working in Gnumeric Mode, the following frequency options are also available 6 Bimonthly 12 Monthly
The type of day count to use. 0 or omitted US (NASD) 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 4 European 30/360