WorksheetFunction.AccrInt Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns the accrued interest for a security that pays periodic interest.

public double AccrInt (object Arg1, object Arg2, object Arg3, object Arg4, object Arg5, object Arg6, object Arg7);

Public Function AccrInt (Arg1 As Object, Arg2 As Object, Arg3 As Object, Arg4 As Object, Arg5 As Object, Arg6 As Object, Optional Arg7 As Object) As Double

Parameters

Arg1: Object

Issue date - Security's issue date.

Arg2: Object

First interest - Security's first interest date.

Arg3: Object

Settlement - Security's settlement date

Arg4: Object

Rate - Security's annual coupon rate.

Arg5: Object

Par - Security's par value.

Arg6: Object

Frequency - Number of coupon payments per year.

Arg7: Object

Basis - The type of day count basis to use.

Returns

Double

Remarks

Important: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

The following table describes the values that can be used for Arg5.

0 or omitted	US (NASD) 30/360
1	Actual/actual
2	Actual/360
3	Actual/365
4	European 30/360

Applies to