TBILLPRICE (PQL - xl)

This function returns the price per $100 face value for a Treasury bill (or T-bill)

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

Syntax

TBILLPRICE(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 'TBILLPRICE' function - using the same inputs, logic and outputs.