deepcalc
DocsTBILLPRICE

TBILLPRICE

View as markdown/docs/functions/tbillprice.md Ask Claude about this pageOpens Claude with this page's address

Returns price per $100 for treasury bill.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=TBILLPRICE(DATE(2026,1,15), DATE(2026,7,15), 0.05)
Result 97.4861111111111

Syntax

TBILLPRICE(settlement, maturity, discount)
settlement
number required
maturity
number required
discount
number required
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.