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

Average True Range

Live
1.07
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

CCB

1.07

NBHC

0.91

MYFW

0.69
Coastal Financial Corporation logo

Coastal Financial Corporation

Sector: 
Financial Services
   

Industry: 
Banks - Regional - US

41.56
 
USD
  
-0.12
  
(-0.29%)
Optionable: No  Market Cap: 551 M  90-day average vol: 44,596

Previous close: 41.68  Open: 41.21  Bid: 55.0  Ask: 55.0
52 week range    
31.00   
   54.41
Peers   
NA-CA / 
NABZY / 
NBHC / 
Last updated: Sunday 25th September 2022
57
MarketXLS Rank marketxls
60
Value marketxls
53
Technical marketxls
60
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