deepcalc
DocsODDFPRICE

ODDFPRICE

View as markdown/docs/functions/oddfprice.md Ask Claude about this pageOpens Claude with this page's address

Returns the price of a security with an odd first period.

  • Excel: Not checked yet
  • Google Sheets: No equivalent
  • Returns: Number

Examples

=ODDFPRICE(DATE(2026,2,1), DATE(2031,1,1), DATE(2026,1,1), DATE(2026,7,1), 0.05, 0.06, 100, 2)
Result 95.79103039423495

Syntax

ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])
settlement
number required
maturity
number required
issue
number required
first_coupon
number required
rate
number required
yld
number required
redemption
number required
frequency
number required
basis
number optional
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.