Manuals/calci/ODDLPRICE
Jump to navigation
Jump to search
ODDLPRICE(settle, M, LI, R,yield, redem, F, basis)
Where 'settle' is the security's settlement date, 'M is the security's maturity date, 'LI' is the security's last coupon date, 'R' is the security's interest rate, 'yield' is the security's annual yield, 'redem' is the security's redemption value, 'F' is the number of coupon payments per year, and 'basis' is the type of day count basis to use.
This function computes the price per $100 face value of a security having an odd last coupon period.
- ODDLPRICE shows the error value, when 'settle', 'M', 'I', or 'FC' is not a valid date or 'R' or 'Yield' < 0.
- Basis must between 0 and 4.
- M > settle > LI
ODDLPRICE
Lets see an example,
ODDLPRICE(settle, M, LI, R,yield, redem, F, basis)
B
01-08-2008
05-18-2008
11-15-2007
4.35%
5.25%
$100
2
0
=ODDLPRICE(B2,B3,B4,B5,B6,B7,B8,B9) is 99.6691
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 01-08-2008 | 99.6691 | ||
| Row2 | 05-18-2008 | |||
| Row3 | 11-15-2007 | |||
| Row4 | 4.35% | |||
| Row5 | 5.25% | |||
| Row6 | $100 | |||
| Row7 | 2 | |||
| Row8 | 0 | |||
| Row9 | ||||
| Row10 |
