Wilder started with a concept called True Range (TR), which is defined as the greatest of the following:I took the high - low for each trading day in a calendar month and averaged those
- Method 1: Current High less the current Low
- Method 2: Current High less the previous Close (absolute value)
- Method 3: Current Low less the previous Close (absolute value)
ok
i take for day range either, High - Low OR High - Close OR Close - Low, whichever is MAX is day range (no need for absolute value tho)
=MAX(C10-D10,(ABS(C10-E11)),(ABS(E11-D10))) (revised formula)added ABS olute to ensure positive number
EDIT: looking at above formula, i may need to look closer at it, as I may have errors (revised)
then do a simple moving average, I think 14 day is usually used but I like a 20 day
=AVERAGE(OFFSET(P10,0,0,Q$5,1))
(P10 is number i'm averaging and No offsets from P10, Q$5 is the number of days to average and 1 column wide)
Last edited: