Excel ODDFPRICE Function
The ODDFPRICE function returns the price per $100 face value of a security with an odd (short or long) first period.
The ODDFPRICE function returns a numeric value.
- ODDFPRICE will return the #VALUE! error if issue, first_coupon, maturity or settlement is not a valid date.
- ODDFPRICE will return the #NUM! error if:
- rate < 0 or yld < 0;
- redemption ≤ 0;
- frequency is not the number 1, 2, or 4;
- basis < 0 or basis > 4;
- maturity > first_coupon > settlement > issue is not satisfied;
- The interval between maturity and first_coupon does not match the frequency interval.
- issue, first_coupon, settlement, maturity, frequency, and basis are truncated to integers.
- The result of the formula is a numeric value. To add a currency symbol to it, please apply the Format Cells feature.
To get the price per $100 face value of a security with the information as shown in the below table, please copy or enter the formula below in a blank cell, and press Enter to get the result:
If a security has the same information above except that the settlement date is March 15, 2021, you can add a DATE function to replace the C3 in the formula: