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

TBILLPRICE

VDB

Last updated 11 months ago

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`

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