Home › Functions › Financial › ODDFPRICE
fx
ODDFPRICE
Financial  ·  Since: Excel 2003  ·  9 languages

Returns the price per $100 face value of a security having an odd (short or long) first period.

🌐 Translations

English ODDFPRICE
Deutsch UNREGER.KURS
Français PRIX.PCOUPON.IRREG
Español PRECIO.PER.IRREGULAR.1
Italiano PREZZO.PRIMO.IRR
Português PREÇOPRIMINC
Nederlands AFW.ET.PRIJS
Polski CENA.PIERW.OKR
Русский ЦЕНАПЕРВНЕРЕГ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ 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)

Related functions

Copied to clipboard