Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Search for stocks (e.g., AAPL, GOOGL, AMZN)
TRTX logo

TRTX

NYE
TPG RE Finance Trust Inc.
Real EstateREIT - Diversified
Watchlists:
Last updated: Thursday 17th July 2025
8.19
+0.15 (1.87%)
Prev Close:8.04
Open:8.1
Bid:7.99
Ask:8.24
52 Week Range
6.47
9.66
Volume:607,127
Mkt Cap:642 M
Price Target
$9.42
+15.0%

Average True Range

Live
0.16
Returns the Average True Range, measuring volatility by decomposing the range of asset price.

How calculated

Moving average of true range

Example usage

=AverageTrueRange("MSFT") - Returns ATR value for 14 day period
=AverageTrueRange("MSFT",30) - Returns ATR value for 30 day period
=AverageTrueRange("MSFT",30,"9/1/2022") - Returns ATR value for 30 day period with start date 1 September 2022

Notes

A stock with a high level of volatility has a higher ATR, and a low volatility stock has a lower ATR.

Assets

Stocks, ETFs, Mutual Funds, Currencies, Cryptocurrencies
Average True Range
StockAverage True Range

TRTX

0.16