next up previous contents index
Next: PRICEMAT Up: A. Function Reference Previous: PRICE   Contents   Index


PRICEDISC

Syntax: PRICEDISC(S, M, D, RD[, B])

S = settlement date
M = maturity date
D = discount rate of the security
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

PRICEDISC returns the price per $100 face value of a discounted security.

Example:

PRICEDISC(DATE(93, 2, 1), DATE(93, 6, 1), 6.5%, 100, 0) = 97.8333

Excel function: N/A


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