Syntax: @ODDFPRICE(S, M, I, FC, R, Y, RD, F[, B])
S = settlement date
M = maturity date
I = issue date
FC = first coupon date of the security
R = annual coupon rate of the security
Y = annual yield of the security
RD = redemption value of the security at maturity per $100 face value
F = the number of coupon payments per year
B = (Optional) the day count basis to be used:
0 or omitted | 30/360 |
1 | actual/actual |
2 | actual/360 |
3 | actual/365 |
@ODDFPRICE returns the price per $100 face value of a security with an odd (short or long) first period.
Example:
@ODDFPRICE(A1, A2, A3, A4, 7.85%, 6.25%, 100, 2, 1) = 113.5977,
where A1 = @DATE(92, 11, 11), A2 = @DATE(2005, 3, 1), A3 =
@DATE(92, 10, 15), A4 = @DATE(93, 3, 1)