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)
W logo

W

NYE
Wayfair Inc. Class A
Consumer CyclicalSpecialty Retail
Watchlists:
Last updated: Thursday 17th July 2025
55.38
+2.01 (3.77%)
Prev Close:53.37
Open:54.31
Bid:53.0
Ask:55.45
52 Week Range
20.41
59.51
Volume:4,969,129
Mkt Cap:6,848 M
Price Target
$63.69
+15.0%

Average True Range

Live
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