Crystal Reports for Eclipse Designer Guide

CoupNum (settlementDate, maturityDate, frequency)

Description
CoupNum returns the number of coupon periods between the settlement date and maturity.
Arguments
  • settlementDate is a Date or DateTime specifying when the security was purchased.
  • maturityDate is a Date or DateTime, after the settlement date, specifying the date when the security matures.
  • frequency is a number specifying the number of coupons per year. The supported values are 1 (annual payments), 2 (semiannual payments), and 4 (quarterly).
  • Returns
    Number value
    Action
    CoupNum returns the number of coupon periods between the settlement date and maturity. The partial period between the settlement date and the first coupon date after the settlement date, is counted as one.
    Examples
    Suppose a 30-year bond was issued on March 15, 1995 with semiannual coupon dates. The bond was purchased on the secondary market on August 25, 2000 (the settlement date). The maturity date is 30 years after the issue date, or March 15, 2025.
    CoupNum(DateValue(2000,8,25),DateValue(2025,3,15),2)
    Returns 50. This is the number of six-month periods between August 25, 2000 and March 15, 2025, rounded up. Working backwards from maturity, there are 48 periods in the 24 years between March 15, 2001 and March 15, 2025 and a full period between September 15, 2000 and March 15, 2001. The partial period (only 21 days) between settlement date (August 25, 2000) and September 15, 2000 is also counted.
    Comments
    This function is designed to work like the Excel function of the same name.



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