next up previous contents index
Next: YIELDMAT Up: A Function Reference Previous: YIELD

YIELDDISC

 

Syntax: @YIELDDISC(S, M, PR, RD[, B])

S = settlement date
M = maturity date
PR = the price of the security per $100 face value
RD = redemption value of the security at maturity per $100 face value
B = (Optional) the day count basis to be used:

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

@YIELDDISC returns the annual yield for a discounted security. All dates must be entered as serial date value.

Example:

@YIELDDISC(@DATE(93, 3, 1), @DATE(93, 5, 1), 98, 875, 100, 0) = 0.06827


next up previous contents index
Next: YIELDMAT Up: A Function Reference Previous: YIELD

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