Login     Register

        Contact Us     Search

XLeratorDB/financial Documentation

SQL Server ACCRINTM function


ACCRINTM
 
Updated: 5 August 2010
Use ACCRINTM to calculate the accrued interest for a security that pays interest at maturity.
Syntax
SELECT [westclintech].[wct].[ACCRINTM] (
  <@Issue, datetime,>
 ,<@Settlement, datetime,>
 ,<@Rate, float,>
 ,<@Par, float,>
 ,<@Basis, nvarchar(4000),>)
Arguments
@Issue
the issue date of the security. @Issue is an expression that returns a datetime or smalldatetime value, or a character string in date format. 
@Settlement
the settlement date occurring within the coupon period of the security. @Settlement is an expression that returns a datetime or smalldatetime value, or a character string in date format. 
@Rate
the coupon rate of the security expressed in decimal terms. @Rate is an expression of type float or of a type that can be implicitly converted to float.
@Par
the par value of the security. @Par is an expression of type float or of a type that can be implicitly converted to float.
@Basis
is the type of day count to use. @Basis is an expression of the character string data type category.
Basis
Day count basis
0 or omitted
US (NASD) 30/360
1
Actual/Actual
2
Actual/360
3
Actual/365
4
European 30/360
 
Return Type
float
Remarks
·         If @Basis < 0 or @Basis > 4, ACCRINTM returns an error
Examples
 
SELECT wct.ACCRINTM('04/01/2008'
,'06/15/2008'
,.1
,1000
,3)
Here is the result set
----------------------
20.5479452054795

 

See Also

 



Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service