Average True RangeLive
The average true range is a technical indicator used to measure volatility by decomposing the range of asset price for a period (generally 14 days)
Moving average of true range
=AverageTrueRange("MSFT") - Returns ATR value for 14 day period
=AverageTrueRange("MSFT",30) - Returns ATR value for 30 day period
=AverageTrueRange("MSFT",30,"9/1/2021") - Returns ATR value for 30 day period with start date 1 September 2021
A stock with a high level of volatility has a higher ATR, and a low volatility stock has a lower ATR.
|Stocks ETFs Mutual Funds Currencies Cryptocurrencies|
|Stock||Average True Range|
AAC Holdings Inc.
Industry: Medical Care
Optionable: No Market Cap: 1,241 M 90-day average vol: 426,591
Previous close: 9.925 Open: 9.92 Bid: 9.94 Ask: 9.94
52 week range
Last updated: Friday 30th September 2022
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today