True Range (TR)
Function Syntax
Calculates the True Range values from high, low, and close prices.
=TR(data)
data
(array):
Range of columns containing the date, Open, high, Low, close, volume data.
Returns:
A two-column array of dates and their corresponding TR values.
Output Example
Below is an example of the resulting array when applying the custom =TR() function.