Excel ODDLPRICE Function
The ODDLPRICE function returns the price per $100 face value of a security with an odd (short or long) last period.
The ODDLPRICE function returns a numeric value.
- ODDLPRICE will return the #VALUE! error if last_interest, maturity or settlement is not a valid date.
- ODDLPRICE 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 > settlement > last_interest is not satisfied;
- The interval between maturity and last_interest does not match the frequency interval.
- last_interest, 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: