par: A number value representing the par (face) or maturity value of the security. par is commonly a number like 100, 1,000, or 1,000,000. par is often formatted as currency. If par is omitted (comma, but no value), par is assumed to be 1000.
frequency: A European method for dates falling on the 31st of a month.
The currency shown in this function result depends on your Language & Region settings (in System Preferences in macOS 12 and earlier, System Settings in macOS 13 and later, and Settings in iOS and iPadOS).
Example 1
Suppose you are considering the purchase of a hypothetical security. The security was issued December 14, 2008 (issue), has a first coupon payment date of July 1, 2009 (first), will settle May 1, 2009 (settle), pays interest at an annual rate of 10% (annual-rate) semiannually (frequency), has a face value of $1000 (par), and interest is calculated based on a 30/360 days basis (days-basis). Note that in this example, the settlement date is assumed to be before the first coupon date.
=ACCRINT ("12/14/2008", "07/01/2009", "05/01/2009", 0.10, 1000, 2, 0) returns approximately 38.0555555555556, which represents the interest accrued between the issue date and the settlement date.
Example 2
Suppose you are considering the purchase of the same hypothetical security described in Example 1, except that the settlement date is September 15, 2009, after the first coupon date.
=ACCRINT ("12/14/2008", "07/01/2009", "09/15/2009", 0.10, 1000, 2, 0) returns approximately 75.2777777777778, which represents the interest accrued between the issue date and the settlement date.