TBILLYIELD
A Treasury bill's yield.
Group: Financial. Compatible with DAX.
Syntax
TBILLYIELD ( <settlement>, <maturity>, <pr> )| 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. |
pr | Number | What the bill costs, in percent of what it pays at maturity. |
Returns
Number. The yield, as a decimal.
Remarks
- (100 − pr) / pr × 360 / days: the gain on the price paid, a year of 360 days.
- A price of 0 or less 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
The yield of the 91-day bill
Bought at its price for a 4 % discount; the yield is higher, as it is earned on the lower price.
EVALUATE
ROW (
"Yield", TBILLYIELD ( DATE ( 2026, 11, 2 ), DATE ( 2027, 2, 1 ), TBILLPRICE ( DATE ( 2026, 11, 2 ), DATE ( 2027, 2, 1 ), 0.04 ) )
)| Yield |
|---|
| 0.04040857559771 |