T-bill yield

Returns the yield of a treasury bill.

Syntax

Tbillyield < > (Settlement, Maturity, Price)

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.

Price is the price per $100 of face value

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
• Price £ 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.