Difference between revisions of "Manuals/calci/PRICEMAT"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">PRICEMAT(settle, M, I, R, yield, basis)</fon...") |
(No difference)
|
Revision as of 21:42, 24 October 2013
PRICEMAT(settle, M, I, R, yield, basis)
Where 'settle' is the security's settlement date, 'M' is the security's maturity date, 'I' is the security's issue date, 'R' is the security's interest rate, 'yield' is the security's annual yield, and 'basos' is the type of day count basis to use.
This function computes the price per $100 face value of a security that pays interest.
- PRICEMAT shows the error value, when 'settle', 'M', 'I', or 'I' is not a valid date or 'R' or 'Yield' < 0.
- Basis must between 0 and 4.
- PRICEMAT counts the error value when settle ≥ M.
PRICEMAT
Lets see an example,
PRICEMAT(settle, M, I, R, yield, basis)
B
03-20-2008
05-18-2008
12-12-2007
6%
6%
0
=PRICEMAT(B2,B3,B4,B5,B6,B7) is 99.9844
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 03-20-2008 | 99.984362 | ||
Row2 | 05-18-2008 | |||
Row3 | 12-12-2007 | |||
Row4 | 6% | |||
Row5 | 6% | |||
Row6 | 0 |