TBILLYIELD (PQL - xl)

This function returns the 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

TBILLYIELD(settlement, maturity, pr)

Function Arguments

Name

Description

Type

Optional

settlement

Settlement date for the Treasury bill

StringOrNumber

maturity

Maturity date for the Treasury bill

StringOrNumber

pr

Price per $100 face value for the Treasury bill

Number

Comments

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