WorksheetFunction.OddFPrice (Excel)

Returns the price per $100 face value of a security having an odd (short or long) first period.

The following table describes the values that can be used for Arg9.

OddFPrice (Arg1, Arg2, ..., Arg9)

Dim dblOddFPrice As Double
dblOddFPrice = WorksheetFunction.OddFPrice(Arg1:=, Arg2:=, Arg3:=, Arg4:=, Arg5:=, Arg6:=, Arg7:=, Arg8:=)


Arg1, Arg2, ..., Arg9

Arg1 - Settlement - the security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer

Arg2 - Maturity - the security's maturity date. The maturity date is the date when the security expires

Arg3 - Issue - the security's issue date

Arg4 - First_coupon - the security's first coupon date

Arg5 - Rate - the security's interest rate

Arg6 - Yld - the security's annual yield

Arg7 - Redemption - the security's redemption value per $100 face value

Arg8 - Frequency - the number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4

Arg9 - Basis - the type of day count basis to use