TBILLEQ (PQL - xl)

This function returns the equivalent yield for a Treasury bill (or T-bill)

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

TBILLEQ(settlement, maturity, discount)

Function Arguments

Name

Description

Type

Optional

settlement

Settlement date for the Treasury bill

StringOrNumber

maturity

Maturity date for the Treasury bill

StringOrNumber

discount

Discount rate for the Treasury bill

Number

Comments

This function is the same as the Microsoft Excel 'TBILLEQ' function - using the same inputs, logic and outputs.