WorksheetFunction.AccrInt Method

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function AccrInt ( _
    Arg1 As Object, _
    Arg2 As Object, _
    Arg3 As Object, _
    Arg4 As Object, _
    Arg5 As Object, _
    Arg6 As Object, _
    Arg7 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Object
Dim Arg3 As Object
Dim Arg4 As Object
Dim Arg5 As Object
Dim Arg6 As Object
Dim Arg7 As Object
Dim returnValue As Double

returnValue = instance.AccrInt(Arg1, Arg2, _
    Arg3, Arg4, Arg5, Arg6, Arg7)

double AccrInt(
    Object Arg1,
    Object Arg2,
    Object Arg3,
    Object Arg4,
    Object Arg5,
    Object Arg6,
    Object Arg7
)

Parameters

• Arg1
  Type: System.Object

  Issue date - Security's issue date.

• Arg2
  Type: System.Object

  First interest - Security's first interest date.

• Arg3
  Type: System.Object

  Settlement - Security's settlement date

• Arg4
  Type: System.Object

  Rate - Security's annual coupon rate.

• Arg5
  Type: System.Object

  Par - Security's par value.

• Arg6
  Type: System.Object

  Frequency - Number of coupon payments per year.

• Arg7
  Type: System.Object

  Basis - The type of day count basis to use.

Return Value

Type: System.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.

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

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace