Intraday Volatility Calculation in Excel Sheet

Hi Vipul!

No, that is not related to the data available on NSE or BSE.

Let me put it in some other way.

If you want to do Intraday Trading in a particular scrip. You already have High, Low, Open, Close prices. What you want is what would be an ideal Buy Level or Sell Level and what possible targets we can set or stop loss we can maintain.

If you look at the screenshot I have shared in my current post, it has exactly that calculation.

At what price we should go long.
At what price we should go short.
Etc.

This is prepared based on some mathematical formulas which include mean and deviation etc.

Just trying to do it in Excel.