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

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


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

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