35 years of sensex daily closings analysed (up to 18 Nov 2021)

Posted: Nov 21, 2021 20:41

SHARE

The sensex was published on January 1, 1986 (Wikipedia), and back-calculated index values from 1979 were also released with it.

For this study we will take figures only from 1986, as there would be a recency bias in the choice of stocks in the index.

(You can click on all the underlined terms in this piece to get more information on what they mean).

---

All the computations have been made using Google Sheets and its powerful GOOGLEFINANCE() function. This function is used extensively in our online course which is currently on, and is one of many subjects which you will learn. At the end of the course you will have your own large toolkit of Sheets which compute Risk & Money Management, Momentum Investing, Day-trading set-ups, several technical analysis indicators and many more!

You can read about the course at following link, which also has the registration form : Online Course: Trading and Investing Strategies : Course details

---

Daily data from Jan 2, 1986 (the first trading day that year) to Nov 18, 2021 has been taken, giving us 8,497 trading days.

The average daily YOY (Year-Over-Year) returns for the sensex between these dates is 17.48%%. Computation starts from Jan 2, 1987 - which is one year from the start of the data.

The sensex was 549.43 on Jan 2, 1986, and 59,636.01 on Nov 18, 2021, giving it a CAGR (Compound Annual Growth Rate) of 13.95% over 35 years and 322 days.

The highest YOY return was 266.9% between Mar 27, 1991 and Mar 31, 1992. The worst YOY return was -56.5% betweem Jan 11, 2008 and Jan 13, 2009.

We have 8,300 trading days for which the YOY returns were computed. Of these 5,711 (68.8%) days gave positive returns, and 2,589 (31.2%) gave negative (or zero) returns. The standard deviation of these returns is 33.5%. The YOY return on Nov 18, 2021 stood at 34.98%.

Apart from all the YOY statistics, the daily return data is also interesting. This computation starts from 1986 itself, as we do not have to wait a year for the YOY returns.

The average daily return for the sensex from Jan 3, 1986 to Nov 18, 2021 is +0.0686%. That is the arithmetic mean (AM). The Geometric Mean (GM) is +0.0552%. The GM is always less than the AM, unless all data points are identical, in which case they are the same.

When compounding returns, we must use the GM and not the AM. For instance, you can actually use the GM to get the Mar 16, 2021 closing from the Jan 2, 1986 one :
59636.01 = 549.43 * (1.000552) ^ 8496
59636.01 is the sensex's Nov 18, 2021 closing, 549.43 is that on Jan 2, 1986, 1.000552 is (1 + GM) for getting the multiplier for a single day. The operator ^ is "to the power of", and 8496 is the number of days of data. (You will need a few more decimal places in the GM to get the precise value).

The standard deviation of the daily returns is 1.6384%. The range between the average daily return plus and minus three standard deviations is -4.85% and 4.98%. If this were a Normal Distribution then we would expect 99.73% of the daily returns to be inside those two percentages. This would mean that we should not find more than 23 days where the sensex fell more than 4.85% or gained over 5.98%. However, there are 91 such points, the reason such distributions are said to have fat tails.

The largest single day gain was 20.8% on Mar 2, 1992 (11.7 standard deviations). There are five single day gains in excess of 10%.

The largest single day loss was 13.2% on Mar 23, 2020 (9.0 standard deviations). There are four single day losses in excess of 10%.

More stories about: Investing Markets

Blog

Comments