COUPDAYBS

Name

COUPDAYBS -- 

Synopsis

COUPDAYBS(settlement,maturity,frequency[,basis])

Description

COUPDAYBS returns the number of days from the beginning of the coupon period to 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, COUPDAYBS returns #NUM! error.

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

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

Examples

COUPDAYBS (DATE(2002,11,29),DATE(2004,2,29),4,0) = 89

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

See also