TBILLEQ

Scripting Formulas Finance

FINANCE.TBILLEQ

FINANCE.TBILLEQ(settlement, maturity, discount)

Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.

  • settlement: Settlement date of the security, the date after issuance when the security is delivered.
  • maturity: Maturity or end date of the security, when it can be redeemed at face or par value.
  • discount: Discount rate of the bill at time of purchase.