Formula Engine Reference Guide
 

 

Back to Class Index

 

ODDFPRICE(S, M, I, FC, R, Y, RD, F[, B])

Description
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)