Manuals/calci/ODDLYIELD
Jump to navigation
Jump to search
ODDLPRICE(settle, M, LI, R,pr, 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, 'pr' is the security's price, '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 returns the yield of asecurity that has an odd last period.
- ODDLPRICE shows the error value, when 'settle', 'M', 'I', or 'FC' is not a valid date or 'R <0' or 'pr<=0'.
- Basis must between 0 and 4.
- M > settle > LI
ODDLYIELD
Consider an example in(Column2, Row3)
=ODDLYIELD(R1C1, R2C1, R3C1, R4C1, R5C1, R6C1, R1C2,R2C2)
The function returns 0.354477.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1/1/2008 | 2 | ||
| Row2 | 5/1/2008 | 0 | ||
| Row3 | 11/15/2007 | 0.354477 | ||
| Row4 | 3.75% | |||
| Row5 | 90.5 | |||
| Row6 | 100 |
