next up previous contents index
Next: OR, XLOR Up: A. Function Reference Previous: ODDLPRICE   Contents   Index


ODDLYIELD

Syntax: ODDLYIELD(S, M, LC, R, PR, RD, F[, B])

S = settlement date
M = maturity date
LC = last 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) last period.

Example:

ODDLYIELD(A1, A2, A3.6.5%, 100.542, 100, 2, 0) = 0.0535,
where A1 = DATE(92, 2, 7), A2 = DATE(93, 8, 1), A3 = DATE(92, 2, 4)

Excel function: N/A


next up previous contents index
Next: OR, XLOR Up: A. Function Reference Previous: ODDLPRICE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003