ODDFPRICE
Returns the price per $100 face value of a security with an odd first period.
FinancialFinance & Accounting
What it does
Calculates price for odd first period.
Syntax
ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity.
Examples
Odd Period Price
Calculate price.
FORMULA
=ODDFPRICE(A2, B2, C2, D2, 0.05, 0.06, 100, 2)
RESULT
99.8
SAMPLE DATA
| A | |
|---|---|
| 1 | Dates |
| 2 | (See Args) |