Crystal Reports for Eclipse Designer Guide

Duration

Description
Duration returns a number representing the duration of a bond.
Overloads
  • Duration (settlementDate, maturityDate, couponRate, yield, frequency)
  • Duration (settlementDate, maturityDate, couponRate, yield, frequency, basis)
  • Arguments
  • settlementDate is a Date or DateTime specifying when the security was purchased.
  • maturityDate is a Date or DateTime after the settlement date specifying when the security matures.
  • couponRate is a non-negative number specifying the interest rate for the security.
  • yield is a non-negative number specifying the security's yield.
  • frequency is a number specifying the number of coupons per year. The supported values are 1 (annual payments), 2 (semiannual payments), and 4 (quarterly).
  • basis is an optional number specifying the day basis system to use. The following types are supported:
    • 0 - American 30/360 (default)
    • 1 - actual/actual
    • 2 - actual/360
    • 3 - actual/365
    • 4 - European 30/360
  • Returns
    Number value
    Action
    Duration returns a number representing the duration of a bond. Duration is the weighted average of the coupon payment cash flows and is a measure of the bond's interest rate risk.
    Examples
    Suppose a ten-year bond with a coupon rate of 12%, a yield of 13%, and semiannual payments, is purchased on January 25, 2000 and has a maturity date of October 1, 2003. The default basis of 30/360 will be used.
    Duration(DateValue(2000,1,25),DateValue(2003,10,1),0.12,0.13,2)
    Returns 2.961918 as the bond's duration, representing 2.96 years.
    Comments
    This function is similar to the Excel function of the same name.
    See Also



  • SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/