A Trader Life
  • Introduction
  • Strategies
    • TOTUS
    • DOMINUS
    • One tool to rule them all
    • Scalper Crypto
      • Pair list 06/02/21
    • Swinger Crypto
    • CALCULUS
    • ETH V
    • BTC Correlation
    • IPSIMUS
    • VWAP Stock
    • MTF Stock
  • Courses
    • Anton Kreil – Professional Trading Masterclass
    • Introduction to Stocks
      • List of brokers for stock
      • Selling options for profits
      • Introduction to Stocks and Technical Analysis
    • Psychology
      • Some psychology
      • Inside a traders mind
      • 20 Trading rules
      • Do you want to be a professional trader?
      • Psychological Mindset
      • The defining decade and why your twenties matter and how to make the most of them now by Meg Jay sum
      • How to win friends and influence people by Dale Carnegie summary
      • Curious by Ian Leslie summary
      • A Mind For Numbers | Barbara Oakley summary
    • Excel Tips
      • Risk of ruining your account
      • How to make use of the peg ratio
      • How to combine a spread trade with PMI
      • How to calculate ATR
      • How to calculate implied volatility with excel
      • How to make use of distribution in financial markets using excel
Powered by GitBook
On this page

Was this helpful?

  1. Courses
  2. Excel Tips

How to calculate ATR

PreviousHow to combine a spread trade with PMINextHow to calculate implied volatility with excel

Last updated 3 years ago

Was this helpful?

The Average True Range (ATR) of an asset is a historical volatility indicator that calculates the average of a number of previous True Range values. The True Range (TR) of an asset can be defined as follows:

ATRx = (TRt + … + TRt-x) / Opent-x

Where: ATRx – Rolling x-day Average True Range TRt – True Range in period t Opent – Open price in period t

The ATR and TR values allow us to understand historical volatilities; and when we compare these values across various periods we can gauge how volatility of an asset has changed with time. By understanding ATR as a historical volatility indicator we can use is to appreciate the trading opportunities inherit in the asset and the risk that come with it. In this example we calculate rolling one day ATRs for the S&P500, and compare averages of these rolling ATRs over different periods in time.

2MB
atr-sp500.xls
Download - ATR SP500