Returns the accrued interest for a security that pays periodic interest.
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.
The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.
The type of day count basis to use.
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.
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://support.microsoft.com/en-us/office/accrint-function-fe45d089-6722-4fb3-9379-e1f911d8dc74