ACCRINT DAX Function (Financial)
Returns the accrued interest for a security that pays periodic interest.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Issue |
The security’s issue date. |
|
| First_interest |
The security’s first interest date. |
|
| Settlement |
The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. |
|
| Rate |
The security’s annual coupon rate. |
|
| Par |
The security’s par value. |
|
| Frequency |
The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4. |
|
| Basis | Optional |
The type of day count basis to use. |
| Calc_method | Optional |
A logical value that specifies the way to calculate the total accrued interest when the date of settlement is later than the date of first_interest. A value of TRUE (1) returns the total accrued interest from issue to settlement. A value of FALSE (0) returns the accrued interest from first_interest to settlement. If you do not enter the argument, it defaults to TRUE. |
Return values
Remarks
Basis sets the day-count method. Use 0 or omit the value for US (NASD) 30/360. Use 1 for actual/actual. Use 2 for actual/360. Use 3 for actual/365. Use 4 for European 30/360.
Calc_method sets the interest window when Settlement is after First_interest. TRUE (or omit the value) returns interest from Issue to Settlement. FALSE returns interest from First_interest to Settlement.
Frequency must be 1, 2, or 4. Rate and Par must be greater than 0. Issue must be earlier than Settlement.
Examples
-- ACCRINT returns accrued interest for a security that pays periodic interest
-- Example terms:
-- Issue 1-Mar-2007, First interest 31-Aug-2008, Settlement 1-May-2008
-- Rate 10%, Par 1000, Frequency 2 (semiannual), Basis 0 (30/360)
EVALUATE
{
( "From issue (calc_method TRUE)", ACCRINT ( DATE ( 2007, 3, 1 ), DATE ( 2008, 8, 31 ), DATE ( 2008, 5, 1 ), 0.1, 1000, 2, 0 ) ),
( "From first interest (FALSE)", ACCRINT ( DATE ( 2007, 3, 1 ), DATE ( 2008, 8, 31 ), DATE ( 2008, 5, 1 ), 0.1, 1000, 2, 0, FALSE ) )
}
| Value1 | Value2 |
|---|---|
| From issue (calc_method TRUE) | 116.944444444444 |
| From first interest (FALSE) | 66.9444444444445 |
Last update: Oct 14, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/accrint-function-dax