bondconvexity2(cpn;mat;dcb;issu;first;freq;setl;price)

Returns the bond convexity given price (general).

Syntax

bondconvexity2(cpn;mat;dcb;issu;first;freq;setl;price)

Input

Argument Type Description
cpn integer or decimal The annual coupon rate expressed as a percentage

A scalar value or the name of a column

mat integer The maturity date

A scalar value or the name of a column

dcb text The day count basis (dcb)

A text value or the name of a column

Generally, dcb should be 'ACTACT' for U.S. Treasury Notes and Bonds and 'I30360' for U.S. corporate bonds. For more information, see Daily count basis.

issu integer The original dated date

A scalar value or the name of a column

first integer The first coupon date

A scalar value or the name of a column

The first coupon date and the maturity date must be a whole number of freq periods apart.

freq integer The number of coupon payments per year (e.g., 2 for semiannual)

A scalar value or the name of a column

setl integer The settlement date

The setl argument must be a valid date and cannot be a column name or N/A.

price integer or decimal The price (without accrued interest) expressed as a percentage

A scalar value or the name of a column

Note: One of the arguments must reference a column. This does not include setl, which cannot be a column name.

Return Value

Returns the convexity of the bond.

The bondconvexity2(cpn;mat;dcb;issu;first;freq;setl;price) handles N/A values as follows:
  • If cpn, mat, or price are N/A, the result is N/A.
  • If dcb is N/A, actual/actual is used.
  • If freq is N/A, it is assumed to be 2 (semiannual).
  • If issu is N/A, it is assumed to be 30 years prior to maturity.
  • If first is N/A, it is assumed to be the first date after issue that is an integral number of payment periods from maturity.
Note: 1010data has not audited these computations and takes no responsibility for their accuracy or precision. Please do not use the result of this function to trade securities without independently verifying the result.