Log-Range volatility for dummies?

different ways of volatility calc.

the question is: then?

prediction is the key

 

Exactly. Now if I could just figure out how to do that in excel.

 

noisy

 

Alright, I think you're legit. Hope this helps. Sample rtn period is monthly. High and Low are within the monthly window.

Good Luck.

 

Thank you sir! That's exactly what I needed. Don't know why those Phd's have to speak in Math Cant--your excel equation is just a tad more efficient.