mbsprice1(type;cpn;wac;wam;setl;pptype;pprate;yld)

Syntax

mbsprice1(type;cpn;wac;wam;setl;pptype;pprate;yld)

Input

Argument	Type	Description
`type`	text	The MBS type used for determining payment delays. For more information, see MBS type. A text value or the name of a column
`cpn`	integer or decimal	The passthrough rate expressed as a percentage A scalar value or the name of a column
`wac`	integer or decimal	The weighted average coupon (WAC) of the underlying mortgages, expressed as a percentage A scalar value or the name of a column
`wam`	integer	the weighted average remaining term (in months) of the underlying mortgages 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.
`pptype`	text	The prepayment rate type Valid values are: `'CPR'` `'SMM'` `'PSA'` A text value or the name of a column
`pprate`	integer or decimal	The prepayment rate expressed as a percentage A scalar value or the name of a column
`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 in the decimal data type.

If type, cpn, wac, wam, pptype, pprate, or yld are N/A, the result is N/A.

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.