Back to Class Index
ODDFPRICE(S, M, I, FC, R, Y, RD, F[, B])This function returns the price per $100 face value of a security with an odd (short or long) first period. Parameters 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 Example ODDFPRICE(A1, A2, A3, A4, 7.85%, 6.25%, 100, 2, 1) = 113.5977 where A1 = DATE(92, 11, 11), A2 = DATE(2006, 3, 1), A3 = DATE(92, 10, 15), A4 = DATE(93, 3, 1) |