CONVX

CONVX

Returns the convexity for an enumerated cashflow

Category: Financial

Syntax

CONVX(y,f,c(1), ... ,c(k))

y

the effective per-period yield-to-maturity, expressed as a fraction.

Range:

0 < y < 1

f

the frequency of cashflows per period.

Range:

f > 0

c(1), ... ,c(k)

a list of cashflows.

The CONVX function returns the value

[IMAGE]

where

[IMAGE]

c=convx(1/20,1,.33,.44,.55,.49,.50,.22,.4,.8,.01,.36,.2,.4);

The value returned is 42.3778.