TBILLPRICE

US Treasury Bill price based on discount rate

Description

Returns a US Treasury Bill's price based on discount rate.

Function signature

TBILLPRICE(settlement: String, maturity: String, discount: Number) => Number

Parameter

Description

Settlement

The security's settlement date.

Maturity

The security's maturity or end date.

Discount

The discount rate of the bill at time of purchase.

Examples

Formula

Return value

TBILLPRICE("2010-01-01T13:06:15+03:00", "2010-12-30T13:06:15+03:00", 0.3)

69.75

TBILLPRICE("2010-01-01T13:06:15+03:00", "2010-06-12T13:06:15+03:00", 0.1)

95.5

TBILLPRICE("2010-01-01T13:06:15+03:00", "2010-03-30T13:06:15+03:00", 0.5)

87.77777778