Whole document tree
    

Whole document tree

COUPDAYS

COUPDAYS

Name

COUPDAYS -- 

Description

COUPDAYS returns the number of days in the coupon period of the settlement date.

@settlement is the settlement date of the security.

@maturity is the maturity date of the security.

@frequency is the number of coupon payments per year.

@eom = TRUE handles end of month maturity dates special.

Allowed frequencies are: 1 = annual, 2 = semi, 4 = quarterly, 6 = bimonthly, 12 = monthly.

@basis is the type of day counting system you want to use:

0 MSRB 30/360 (MSRB Rule G33 (e))

1 actual days/actual days

2 actual days/360

3 actual days/365

4 European 30/360

5 European+ 30/360

(see the gnumeric manual for a detailed description of these bases)

If @frequency is invalid, COUPDAYS returns #NUM! error.

If @basis is omitted, MSRB 30/360 is applied.

If @basis is invalid, #NUM! error is returned.

Examples

COUPDAYS (DATE(2002,11,29),DATE(2004,2,29),4,0) = 90

COUPDAYS (DATE(2002,11,29),DATE(2004,2,29),4,0,FALSE) = 90

COUPDAYS (DATE(2002,11,29),DATE(2004,2,29),4,1,FALSE) = 91

See also