Syntax. ODDFYIELD(Settlement,Maturity,Issue,First_Coupon,Rate,Price,Redemption, Frequency,Basis)

Definition. This function calculates the yield of a fixed-interest security for the duration from the settlement date to the maturity date. It takes into consideration that the first interest period might be shorter or longer than the other regular interest periods.


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

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

  • Issue (required) The date of the emission of the security.

  • First_Coupon (required) The date of the first interest payment.

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

  • Price (required) ...

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.