Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Are there any templates for recording stock/share trading? | Excel Discussion (Misc queries) | |||
calculating the volatility of a stock | Excel Discussion (Misc queries) | |||
Monthly Stock Return Volatility | Excel Discussion (Misc queries) | |||
measuring historical volatility | Excel Discussion (Misc queries) | |||
stock chart -- how to include only trading days | Charts and Charting in Excel |