Syntax. ODDLPRICE(Settlement,Maturity,Last_Interest,Rate,Yld,Redemption, Frequency,Basis)

Definition. This function calculates the price of a fixed-interest security in a final interest period whose length is different from the regular interest periods in the past. Compound interest is not taken into consideration.


  • Settlement (required) The date when the bond becomes the property of the purchaser.

  • Maturity (required) The day when the repayment of the certified amount takes place.

  • Last_Interest (required) The date of the final (regular) interest payment.

  • Rate (required) The nominal yield (annual interest rate) of the bond.

  • Yld (required) The market interest rate of bonds of the given duration.

  • Redemption (required) The percentage ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.