Here you go, my friend AW10 (I too was working on it after lunch siesta)
For NR setup, I only trust FUT data, and hence I have worked on calculations only with FUT data, which I have from Nov 2007.
The months with NARROWEST daily ranges (as % to open price) are:
AUGUST, SEPTEMBER & DECEMBER
The months with WIDEST daily ranges (as % to open price) are:
OCTOBER, NOVEMBER & JANUARY
In short, in line with the principles of the MARKET CYCLE, after droughts in August & September, we have a bumper October & November. (yeah yeah HAPPY DIWALI )
And after FIIs enjoy their Christmas while bringing dullness during December, they open their cash bags during January.
I am uploading the working excel file, in case someone wants to do more R&D...
Here's the link to the file...
:thumb: