I have a list of stocks and their historical volatilities. Is there a formula
that can be used in excel which could estimate the trading range of the stock
for a given day ?

Thank you in advance.