writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + − − + − − − Line 22:
Line 18: − +
Manuals/calci/accrintm (view source)
Revision as of 09:20, 26 February 2014
, 09:20, 26 February 2014no edit summary
'''ACCCRINTM'''(I, Settle,R,Par,basis)
'''ACCCRINTM'''(I, Settle,R,Par,basis)
<math>I</math> Security's issue date.
*<math>I</math> Security's issue date.
<math>Settle</math> Security's settlement date should be after issue date.
*<math>Settle</math> Security's settlement date should be after issue date.
<math>R</math> Security annual coupon rate.
*<math>R</math> Security annual coupon rate.
<math>Par</math> Security par value
*<math>Par</math> Security par value.
<math>basis></math> Type of day count basis.
*<math>basis></math> Type of day count basis.
==Description==
This function returns the accumulated interest for a security that pays interest at maturity.
This function returns the accumulated interest for a security that pays interest at maturity.
Issue, Basis, Settlement be integers.
Issue, Basis, Settlement be integers.
ACCRINTM shows the error value when R less-than or equal to 0 or if Par less-than or equal to 0, basis<0 or basis>4 and I date greathearted or equal to settle date,
ACCRINTM shows the error value when R less-than or equal to 0 or if Par less-than or equal to 0, basis<0 or basis>4 and I date greathearted or equal to settle date,
where,
where,
'''M''' - number of days counted from issue date to matuarity date.
'''M''' - number of days counted from issue date to maturity date.
'''D''' - Annual Year Basis.
'''D''' - Annual Year Basis.