Manuals/calci/ODDFYIELD
Jump to navigation
Jump to search
ODDFYIELD(settle, M, I, FC, R, P, redem, F, basis)
Where 'settle' is the security's settlement date, 'M' is the security's maturity date, 'I' is the security's issue date, 'FC' is the security's first coupon date, 'R' is the security's interest rate, 'P' is the security's price, 'redem' is the security's redemption value, 'F' is the number of coupon payments per year ans 'basis' is the type of day count basis to use.
This function computes the yield of a security that has an odd first period.
- ODDFYIELD shows the error value, when 'settle', 'M', 'I', or 'FC' is not a valid date or 'R' or 'Yield' < 0.
- Basis must be between 0 and 4.
- M >FC > settle > I
ODDFYIELD
Lets see an example,
ODDFYIELD(settle, M, I, FC, R, P, redem, F, basis)
B
10-15- 2010
01-10-2023
09-15-2010
01-10-2011
4.35%
75
100
2
0
=ODDFYIELD(B2,B3,B4,B5,B6,B7,B8,B9,B10) is 0.0751
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10-15- 2010 | 0.0751 | ||
| Row2 | 01-10-2023 | |||
| Row3 | 09-15-2010 | |||
| Row4 | 01-10-2011 | |||
| Row5 | 4.35% | |||
| Row6 | 75 | |||
| Row7 | 100 | |||
| Row8 | 2 | |||
| Row9 | 0 |
