Syntax. ODDFPRICE(Settlement,Maturity,Issue,First_Coupon,Rate,Yld,Redemption, Frequency,Basis)

Definition. Calculates the price of a fixed-interest security while taking into consideration the first interest period, which is shorter or longer than the remaining regular interest periods (quarter, half year, entire year).


  • 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.

  • 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.

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

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

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