Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Data

Average True Range

Live
3.40
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)

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/2021") - Returns ATR value for 30 day period with start date 1 September 2021

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

A

3.40

TMO

12.37

PKI

4.21

DHR

7.22

TER

2.97

NATI

1.10

ILMN

9.52

AME

2.76

BRKR

1.72

GE

2.04
Agilent Technologies Inc. logo

Agilent Technologies Inc.

Sector: 
Healthcare
   

Industry: 
Diagnostics & Research

123.72
 
USD
  
2.11
  
(1.74%)
Optionable: Yes  Market Cap: 36,001 M  90-day average vol: 1,415,703

Previous close: 121.61  Open: 122.77  Bid: 125.05  Ask: 125.05
52 week range    
112.52   
   165.68
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Thursday 29th September 2022
58
MarketXLS Rank marketxls
70
Value marketxls
23
Technical marketxls
81
Quality marketxls

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock
Are you?
twitterstocktwits
Call: 1-877-778-8358
Ankur Mohan MarketXLS
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