My friend, you are my super hero!
The first thing on my list when I start making money with this is making you a fat donation.
I am starting to watch some excel courses to get really good at it. Would you care to explain to me why the formula in the TR (true range) column is that big?
=max(abs(D2-F3),abs(E2-F3),abs(D2-E2))
I saw that MAX returns the largest value in a set of values. In this case, you wanna see which is the highest value between D2-F3, E2-F3 and D2-E2 to use as true range?
I can see in the MA and ATR columns you are using a 6 day average, right? So to get different results, I just need to change the values here.
So when you are using the AVERAGE excel formula, you don't need to worry about inputing a formula like:
Current ATR = [(Prior ATR x 13) + Current TR] / 14
- Multiply the previous 14-day ATR by 13.
- Add the most recent day's TR value.
- Divide the total by 14
You just need to use AVERAGE and then choose the number cells (like in this case you used =average(H2:H8)
Thanks mate.