ODDFYIELD(S, M, I, FC, R, PR, RD, F [, B])

 

Description

This function returns the yield per $100 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.

 

PR

The price of the security per $100 face value.

 

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:

 

 

Examples

 

ODDFYIELD(A1, A2, A3, A4, 7.85%, 113.598, 100, 2, 1) = 0.0625,

Where A1 = DATE(92, 11, 11), A2 = DATE(2005, 3, 1), A3 = DATE(92, 10, 15), A4 = DATE(93, 3, 1).