After an overwhelming response to the previous article “Analysis of Nifty weekly change“, we got many suggestions to perform analysis using VIX. So, here we are with an interesting read on what we found during our expedition. Do read the previous article to get in sync with this analysis.
The mission of this analysis is to use VIX to find whether we can manage our trades when outlier(Nifty weekly change > +3% and Nifty weekly change < -3%) occurs.
I started the journey by analyzing the rightly skewed distribution of INDIAVIX and finding its statistical specifications like mean, median and standard deviation.
|Mean of VIX
|Median of VIX
|Standard Deviation of VIX
Here, I considered the data from 2011-2019. Seeing the volatility levels in March 2020, these numbers look very low, but even if I would have used the data of 2020, the mean might not have changed much because it was just a matter of 2-3 months(8 to 12 weekly data points) that VIX cooled off and reverted back to its mean.
Since this is a rightly skewed distribution and not a normal one, we cannot use mean+2*S.D formulae to state that 95% of the data is between this range. So, we will make use of our data to find it.
|% weeks when VIX was below 20
|% weeks when VIX was below 25
|% weeks when VIX was below 30
I thought VIX might be correlated with this week or previous week % change in Nifty. But, I found almost no correlation between the two. So, nothing could be concluded using just VIX and weekly %change.
|Correlation b/w present weekly %change and present week VIX
|Correlation b/w present weekly %change and previous week VIX
|Correlation b/w previous weekly %change and present week VIX
|Correlation b/w previous weekly %change and previous week VIX
This was rather disappointing. But I found a myth buster during my stint with the data. As a naive trader, I expected that volatility should act similarly for both the positive(Nifty weekly %change > 3%) and negative(Nifty weekly %change < 3%) outliers in Nifty. I used to think that volatility expands irrespective of the direction of movement. The correlation between weekly %change in Nifty and weekly %change in VIX helped me bust this myth.
|Correlation b/w weekly %change in Nifty and weekly %change in VIX
Although this was a weak correlation between weekly %change in Nifty and weekly %change in VIX, it tells us that volatility shoots up when the market falls and cools off when the market rises. This correlation also proves the fact that “Fear tends to manifest itself much more quickly than greed“.
What outliers told me?
It was also important to have a look at the outliers and find out a particular VIX value below which one can always be safe to trade without worrying about outliers.
|%outliers when VIX < 20
|%outliers when VIX < 25
|%outliers when VIX < 30
It is not at all surprising to see that most of the outliers occurs when VIX is below 30 as the mean and standard deviation of VIX suggests the same. It is worth to note that how we can easily lie using the above table. One could easily conclude that since 95% of outliers occur when VIX < 30, so why not trade strangles when VIX > 30. This happened because 98% of VIX data is below 30. Drawing such conclusions from the above table can be catastrophic for your financial health
It was fun to understand the psychology of traders using just VIX data and prove that fear is indeed stronger than greed. It might be very demotivating to not get any solid conclusions from the above analysis using VIX. But, it is fine to draw no conclusions rather than drawing wrong conclusions from the data.
You can find the analysis report and data* here.
Note: The close price of Nifty in the excel sheet may not exactly match with the adjusted close price of Nifty.This analysis is not any strategy. This analysis is just a base that can help you develop your own ideas or strategies.
That’s it for today.