View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Estimating Stock Trading Range From Historical Volatility


That same formula failed on selecting the winning horse in the Kentucky
Derby.
And, to get closer to what I used to do, it also failed to predict Brawn
racing's success this year.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"carl" wrote in message
...
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.