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