**Step 3: The Daily Range Formula**

Firstly, we calculate the Daily Range that is High Price – Low Price. Write this formula: =[@High]-[@Low]

We use this formula because we are inside of the table. If you have a spreadsheet without a table, you can write: =C2-D2

**Step 4: The High – Close[1] Formula**

We subtract from the Today High Price the Close of the yesterday candle. Write or copy and paste this formula: =ABS([@High]-E2)

**Step 5: The Low – Close[1] Formula**

We subtract from the Today Low Price the Close of the yesterday candle. Write or copy and paste this formula: =ABS([@Low]-E2)

**Step 6: True Range Formula**

Now we calculate the True Range, with this formula:

=MAX([@[High – Close'[1′]]]:[@[Low – Close'[1′]]];[@[Daily Range]])

**Step 6: Average True Range Formula for Excel**

Finally, we obtain the Average True Range with this formula:

=AVERAGE(I3:I17)

Substantially, we are creating one Moving Average of the last 14 True Range. For this reason, we start the calculation from J17.