Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 361
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 361
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Are there any templates for recording stock/share trading? Ronsan Excel Discussion (Misc queries) 0 July 24th 06 03:03 AM
calculating the volatility of a stock Richard M 2006 Excel Discussion (Misc queries) 1 May 9th 06 09:55 PM
Monthly Stock Return Volatility frank Excel Discussion (Misc queries) 6 February 21st 06 06:18 PM
measuring historical volatility JELLO Excel Discussion (Misc queries) 7 January 18th 06 09:12 AM
stock chart -- how to include only trading days Jordan Burkart Charts and Charting in Excel 2 August 6th 05 05:28 AM


All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"