Syntax. ODDLYIELD(Settlement,Maturity,Last_Interest,Rate,Price,Redemption, Frequency,Basis)

Definition. This function calculates the yield 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 loan becomes the property of the purchaser.

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

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

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

  • Price (required) The price of the security on the day of settlement as a 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.