bondprice1(cpn;mat;dcb;setl;yield)

Syntax

bondprice1(cpn;mat;dcb;setl;yield)

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
`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.
`setl`	integer	The settlement date The `setl` argument must be a valid date and cannot be a column name or N/A.
`yield`	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 bondprice1(cpn;mat;dcb;setl;yield) function handles N/A values as follows:

If cou, mat, or yield are N/A, the result is N/A.
If dcb is N/A, actual/actual is used.

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.