TBILLPRICE
What a Treasury bill costs, in percent of its face value, for a discount rate.
Group: Financial. Compatible with DAX.
Syntax
TBILLPRICE ( <settlement>, <maturity>, <discount> )| Parameter | Type | Description |
|---|---|---|
settlement | Date | The day the buyer takes the security over; later than its issue. |
maturity | Date | The day the security ends and its face value is repaid. |
discount | Number | How far below its face value the bill is sold, as a yearly rate. |
Returns
Number. What the bill costs, in percent of its face value.
Remarks
- 100 × (1 − discount × days / 360), with the actual days from settlement to maturity.
- A discount of 0 or less, or one so large that the price would not be positive, is an error. A bill runs at most a year: settlement on or after maturity, or a maturity more than a year after settlement, is an error. The days are actual days, and the dates whole days.
Examples
A 91-day bill at a 4 % discount
EVALUATE
ROW (
"Price", TBILLPRICE ( DATE ( 2026, 11, 2 ), DATE ( 2027, 2, 1 ), 0.04 )
)| Price |
|---|
| 98.9888888888889 |