MicroStrategy ONE
T-bill price
Returns the price of a treasury bill per $100 of face value.
Syntax
Tbillprice(Settlement, Maturity, Discount)
Where:
Settlement is the settlement date. This is the date on which the treasury bill is purchased.
Maturity is the maturity date. This is the date on which the treasury bill expires.
Discount is the discount rate.
Expression
Where:
DSM is the number of days from settlement to maturity.
This excludes any maturity date that is more than one calendar year past Settlement.
Usage Notes
If Settlement or Maturity is not an integer, it is truncated.
The engine returns an empty cell if:
- Either Settlement or Maturity is not a valid date
- Discount £ 0
- Settlement > Maturity
- Maturity is more than one year after Settlement
The Settlement date and the Maturity date should be included within single quotations in the expression for the expression to be considered as a valid expression.