next up previous contents index
Next: DOLLARDE Up: A. Function Reference Previous: DFT   Contents   Index


DISC

Syntax: DISC(S, M, P, R, B)

S = Settlement date
M = Maturity date
P = Price per $100
R = Redemption value per $100
B = (Optional) The day count basis to be used.

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

DISC returns the discount rate of a security.

Examples:

DISC(DATE(93, 1, 10), DATE(93, 7, 20), 97.375, 100, 3) = 0.05016

DISC(DATE(93, 1, 10), DATE(93, 7, 20), 97.375, 100) = 0.04974

Excel function: N/A


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