TBILLYIELD

US Treasury Bill yield based on price

Description

Returns a US Treasury Bill's yield based on price.

Function signature

TBILLYIELD(settlement: String, maturity: String, price: Number) => Number

Parameter

Description

Settlement

The security's settlement date.

Maturity

The security's maturity or end date.

Price

The price at which the security is bought

Examples

Formula

Return value

TBILLYIELD("2010-01-02T13:06:15+03:00", "2010-12-31T13:06:15+03:00", 98.45)

0.01561392

TBILLYIELD("2011-01-01T13:06:15+03:00", "2011-07-16T13:06:15+03:00", 51.78)

1.71045475

TBILLYIELD("2011-09-25T13:06:15+03:00", "2012-02-15T13:06:15+03:00", 48)

2.72727273