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