Estimating Stock Trading Range From Historical Volatility

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

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.
 
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.
 
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.
 
Thanks Don.

I won't put to much on the line then.

Do you have any suggestions regarding a formula to try in excel ?
 
Thanks Don.

I won't put to much on the line then.

Do you have any suggestions regarding a formula to try in excel ?
 
I was once a Regional Manager for ING (yellow lion) and learned a long time
ago not to try this. I write custom excel projects, many financial, but
won't do this. I don't want the blame.
 
I was once a Regional Manager for ING (yellow lion) and learned a long time
ago not to try this. I write custom excel projects, many financial, but
won't do this. I don't want the blame.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First 2023 ? From the frozen wastes of Wisconsin nowadays, but originally from the sophisticated part of Yorkshire....(Chuckle). 4
array formula with a dynamic range. 2
calculating the volatility of a stock 1
volatility 1
Is VLOOKUP what I need? 3
formula to lookup data in cell NEXT to another cell 3
Access Updating inventory levels 0
Historical Stock Close Value 4

Back
Top