next up previous contents index
Next: ODDLPRICE Up: A Function Reference Previous: ODDFPRICE

ODDFYIELD

 

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

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:

0 or omitted 30/360
1 actual/actual
2 actual/360
3 actual/365

@ODDFYIELD returns the yield per $100 of a security with an odd (short or long) first period.

Example:

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


next up previous contents index
Next: ODDLPRICE Up: A Function Reference Previous: ODDFPRICE

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999