Good day everyone…

I’ve been struggling to calculate the True Range for a price data set which I’m going to use to calculate the average true range and for some other calculations.

I tried using ChatGPT to give me a starting point for this but I’m still not getting any result.

$${TR}$$ = MAX($${High}$$ - $${Low}$$, ABS($${High}$$ - $${PREV_Close}$$), ABS($${Low}$$ - $${PREV_Close}$$))

Chat GPT gave me this.

The Google Sheet formula I’m trying to replicate is this:

=AVERAGE(QUERY(C2:C6,“select max(Col1) - min(Col1) label max(Col1) - min(Col1)‘’”))

But I don’t need the Average part just yet.

What would be the most efficient and simplest way to do this?

Any help would be greatly appreciated