i have this excel sheet but i do not use it because it has pre determined observations which tend to mislead my judgment. i would like to look at the option chain movement and draw my own conclusions, whether right or wrong. these are not as per established norms so will not conform to any defined observations.
i look at the nse site and try to guage the mood, based on volumes at different strike levels. like now i see that there could be a little long unwinding going on from 11700 /30000 down. but then there is also some volumes at higher levels so i cannot with conviction say which way the market is heading. it could be a see-saw situation.
and moreover in such volatile emotion driven situations, the smart money is bound to take every single advantage and screw us royally. so i tend to become extremely careful and probably unnecessarily overcautious. i may lose a lot of trade because of this fear. but i would rather that than some massive loss