bondprice2(cpn;mat;dcb;issu;first;freq;setl;yld)

Syntax

bondprice2(cpn;mat;dcb;issu;first;freq;setl;yld)

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.
`yld`	integer or decimal	The bond-equivalent yield 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 price (without accrued interest) expressed as a percentage of par as a decimal value.

The bondprice2(cpn;mat;dcb;issu;first;freq;setl;yld) function handles N/A values as follows:

If cpn, mat, or yld 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.