ODDLPRICE(settlement,maturity,last_interest,rate,yld,redemption,frequency[,basis])
ODDLPRICE calculates the price per $100 face value of a security that has an odd last coupon period.
settlement is the settlement date of the security. maturity is the maturity date of the security. frequency is the number of coupon payments per year. Allowed frequencies are: 1 = annual, 2 = semi, 4 = quarterly. basis is the type of day counting system you want to use:
0 US 30/360
1 actual days/actual days
2 actual days/360
3 actual days/365
4 European 30/360