WorksheetFunction.OddFYield (Excel)

Returns the yield of a security that has an odd (short or long) first period.

OddFYield (Arg1, Arg2, ..., Arg9)

Dim dblOddFYield As Double
dblOddFYield = WorksheetFunction.OddFYield(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 - Pr - the security's price

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