Manuals/calci/ODDFPRICE
Jump to navigation
Jump to search
ODDFPRICE(settle, M, I, FC, R, yield, 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, '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 calculates the price per $100 face value of a security having an odd first period.
- ODDFPRICE 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
- ODDFPRICE is calculated as follows:
ODDFPRICE
Lets see an example,
ODDFPRICE(settle, M, I, FC, R, yield, redem, F, basis)
B
10-15- 2010
01-10-2023
09-15-2010
01-10-2011
8.35%
5.25%
100
2
1
=ODDFPRICE(B2,B3,B4,B5,B6,B7,B8,B9,B10) is 127.7338
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 10-15- 2010 | 127.7338 | ||
| Row2 | 01-10-2023 | |||
| Row3 | 09-15-2010 | |||
| Row4 | 01-10-2011 | |||
| Row5 | 8.35% | |||
| Row6 | 5.25% | |||
| Row7 | 100 | |||
| Row8 | 2 | |||
| Row9 | 1 |
