⌨ Syntax
ODDFPRICE(settlement,maturity,issue,first_coupon,rate,yld,redemption,frequency,[basis])
Arguments
settlement
(required)
— The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
maturity
(required)
— The security's maturity date. The maturity date is the date when the security expires.
issue
(required)
— The security's issue date.
first_coupon
(required)
— The security's first coupon date.
rate
(required)
— The security's interest rate.
yld
(required)
— The security's annual yield.
redemption
(required)
— The security's redemption value per $100 face value.
frequency
(required)
— The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.
basis
(optional)
— The type of day count basis to use.
▶ Examples
=ODDFPRICE(A2,A3,A4,A5,A6,A7,A8,A9,A10)