Estimating Stock Trading Range From Historical Volatility
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. |
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. |
Estimating Stock Trading Range From Historical Volatility
Thanks Don.
I won't put to much on the line then. Do you have any suggestions regarding a formula to try in excel ? "Don Guillett" wrote: 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. |
All times are GMT +1. The time now is 02:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com