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|
Accelerate Diagnostics Inc.
Industry: Diagnostics & Research
Optionable: Yes Market Cap: 174 M 90-day average vol: 996,192
Previous close: 1.66 Open: 1.62 Bid: 1.85 Ask: 1.85
52 week range
Last updated: Sunday 25th 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