How To Calculate The Average True Range (ATR) Using Excel

This video is just a short demonstration of how you're going to calculate the ATR using Excel.

Thank you for watching!

Please subscribe to our channel.

[keepcalm]

Got some video ideas... well honestly I just need your help. Would like to know how to do the exact same thing but to get the William %R, RGVI, SSL and Kijun-sen

[ahmadfaisal]

ATR can be calculated starting from row 16. as it's the average of current TR[0] down to TR[13]. if u start from row 17 means it's average of previous TR[1] down to TR[14].

[munivoltarc]

Please check your calculation CH - CL you mistakenly calculated it as CH-PC please correct it, thank you

[thinlizzinger]

Thanks for the tut. To copy down you can drag the lower right corner of your selection. If you have a previous column you can also doubleclick there and it will copy down to the end automatically. ;)