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
Last update: Oct 3, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/accrint-function-dax