Scripting Formulas Finance


FINANCE.TBILLPRICE(settlement, maturity, discount)

Calculates the price 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.