next up previous contents index
Next: TBILLYIELD Up: A. Function Reference Previous: TBILLEQ   Contents   Index


TBILLPRICE

Syntax: TBILLPRICE(S, M, D)

S = Settlement date
M = Maturity date
D = Discount rate of Treasury bill

TBILLPRICE returns the price per $100 face value for a Tresury bill, given settlement date S, maturity date M, and discount rate D. Dates must be expressed as serial date values.

Example:

TBILLPRICE(DATE(93, 4, 2), DATE(93, 7, 5), 9.25%) = 98.5847

Excel function: N/A


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