Common ODDLPRICE questions usually focus on errors, result checking, and filling formulas across multiple cells; this FAQ includes 3 common questions and a glossary.
FAQ
What should I do if ODDLPRICE returns an error value?
- Check whether each argument uses a valid calculable data type, and avoid storing numbers or dates as plain text.
- Make sure the arguments are separated with English commas.
- Review the referenced cells again and confirm that they do not contain extra spaces or invalid content.
Why does the ODDLPRICE result look different from what I expected?
- Check whether settlement, maturity, last_coupon, rate, and yld are entered correctly.
- Confirm that redemption, frequency, and
[basis]match the calculation conditions for the security. - Test the arguments one by one or move intermediate values into helper cells for review.
How can I use ODDLPRICE in multiple cells at once?
- Enter the ODDLPRICE formula in the first target cell.
- Drag the fill handle downward, or copy and paste the formula into the target range.
- Check whether relative and absolute references match your batch calculation needs.
Glossary
| Term | Definition |
|---|---|
| settlement | The security settlement date, which is the date when the transaction is settled. |
| maturity | The maturity date, which is the date when the principal is due. |
| last_coupon | The coupon-related date before the odd last coupon period used in the calculation. |
| basis | The day count basis used to determine date differences and interest calculations. |