DESCRIPTION
A price range is the difference between the highest and lowest price at which a particular stock, commodity, currency, or other financial asset has traded over a given period. It measures the asset’s price variability during that period and can be used by traders and investors to evaluate the asset’s volatility.
GOOGLE SHEETS FORMULA
Cell B1 = Stock Code
Daily Range (DR)
A daily range refers to the difference between the highest and lowest prices of a financial asset during a single trading day.
=GOOGLEFINANCE(B1,"high")-GOOGLEFINANCE(B1,"low")Daily True Range (DTR)
The daily true range (DTR) is a measure of volatility that is calculated as the greatest of the following values:
the difference between the day’s high and low,
the difference between the previous day’s closing price and the current day’s high,
or the difference between the previous day’s closing price and the current day’s low.
=MAX(GOOGLEFINANCE(B1,"high"),GOOGLEFINANCE(B1,"closeyest"))-MIN(GOOGLEFINANCE(B1,"low"),GOOGLEFINANCE(B1,"closeyest"))