Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Average True Range

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


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
Average True Range
StockAverage True Range




Astra Space Inc logo

Astra Space Inc

Sector: Manufacturing   

Industry: Small Arms Ammunition Manufacturing

Optionable: Yes  Market Cap: 42 M  90-day average vol: 1,424,276

Previous close: 1.96  Open: 1.98  Bid: 1.72  Ask: 1.8
52 week range    
Last updated: Sunday 24th September 2023

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

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today