Thursday, December 25, 2014

Cricket Stats

I was playing around with cricket data for some time now, and there are some interesting observations

1) Average Runs scored per match YOY

2) Average Runs scored when tier2 teams won the toss and elected to bat

  3) Average Runs scored when tier2 ( Kenya, Zimbabwe) teams won the toss and elected to bowl

The above stats would state that maybe 2014 was a good year for cricket, but we have forgotten one important measure. The number of matches. More the number of matches, more the normalization ( averaging out )

In the following graphs, I plotted the average runs and the number of matches YOY for all the 3 forms of cricket

1) ODI

 2) T20

We see that for the year 2014 there is a surge in the number of runs scored in all 3 versions of the game. However, the data has fewer matches so statistically we cannot say for sure that 2014 has been a very good year.
However, I always thought that through the years, the number of runs scored have always been increasing, but that is not what we observer, especially between 2009 and 2013. Let us dig deeper

We see that in the year 2014, there were a lot of matches > 30 with the total being above 500. This drove the average up. From the graph we can make some more observations.

Now, we will  be applying similar stats on the following factors
1) Wickets fallen in a match
2) Runs scored till fall of first wicket
3) % of highest wicket partnership vs total runs

Will come up with the details

Potholes at Traffic Signals

Everybody must have at some time or the other faced a situation where we are stuck at a traffic signal, idly looking at the smoke coming out of the nearby truck. We keep looking ahead to notice the reason the traffic is held up. When we reach the signal, we find it was a pothole. How could the pothole hold up the entire traffic? It is very well true


average length of the vehicle 2.5
average speed of vehicles ( km / hr ) 30
time for whch the signal is open ( seconds ) 60
time for whch the signal is closed ( seconds ) 180
idling losses ( average ) mL/hr 500
Road Length ( in m ) 500

The above chart calculates the loss in  litres of petrol, per crossing, per period ( signal open + signal close ) assuming that there are 3 lanes. The x axis is the average speed of  vehicles, and the y axis shows the loss of oil due to "Idling"

The following link will now give you vehicle population of India. A graphical representation of the same is as follows
We see that there has been a humongous increase in 2 wheeler and small 4 wheelers in the last 2 decades. Assuming that out of this 50% vehicles get stuck at traffic signals (which is highly optimistic) the loss of oil runs into millions per year

With the following assumptions

Idling losses ( ml/Hr  ) 200
Average time wasted at traffic/pothole ( hr/day ) 0.5

The total cost currently would stand not less than 100 million INR. It is obviously much more but I tried to arrive at a calculated value with a conservative approach

Wednesday, December 24, 2014

Crime Against Women

Crime against women is on the rise, but what we read in the newspapers about violent attacks in only a tip of the iceberg. People might think molestation/rape is the foremost crime, but it is not. According to the data pulled from

1) DOWRY is one of the foremost reasons of crime against women and Andhra Pradesh has a huge chunk of it.  The numbers include cases registered for dowry prevention act

2) The following graph sums up all the registered cases by State. Uttar Pradesh might be sharing a low % here but we can attribute it to the low level of awareness of filing a case. I am trying to incoporate these factors but will have to get more data
3) The following graph looks at the age group of the people who commit crimes. As expected most of them lie in the 18-30 range
4) On trying to find out whether rural/urban has a part to play, it was found that the rural graph has more correlation than the urban graph

5)  I regressed the crime occurrences with the following factors

 The following are the results of the regression. We can see that the R Square is too less to say anything definite about the relationship of crime and the geographical boundaries. There are other factors

Age GroupR- Squared
<18 td="">5.82%
18 to 3016.76%
30 to 4514.86%
45 to 6013.97%
> 6011.77%

Age Group R- Squared
<18 td=""> 4.55%
18 to 30 7.38%
30 to 45 5.95%
45 to 60 5.70%
> 60 3.34%

Monday, November 10, 2014


Fundamental Ratios play a very important part in finding an equity investment of your risk appetite. I collected the fundamental ratios data for all the listed companies on NSE ( and BSE )  and tried to listout few stocks that should be considered for further analysis

Criteria 1 : P/E Ratio < 10 , SALES > 800 crores
Sales ( in crores )
National Wind Power Corporation Ltd.
Nagarjuna Fertilisers & Chemicals Ltd.(Old)
Trident Ltd.
National Steel and Agro Industries Ltd.
Monnet Ispat & Energy Ltd.
Sintex Industries Ltd.
Prakash Industries Ltd.
Uflex Ltd.
Diamond Power Infrastructure Ltd.
Escorts Ltd.
Kothari Products Ltd.
Mahanagar Telephone Nigam Ltd.

We see that MTNL has very strong fundamentals. IF we look at the stock price over the last 10 years
Click here for Image
This stock was unperturbed by even the 2008 Financial crisis. Such a stock is indeed very handy to have in your portfolio. Besides it also gave a 10% dividend
Another stock to look out for is Escorts Limited. This is a company based on agricultural machinery. With agriculture certain to get a big push from the government, it will be a good buy. One thing to note from its graph ( in fact all the graphs of its peers ) is that these stocks did not get affected much in the 2008 crisis. However, post 2008, people started putting in a lot of money on these stocks, leading  to a bubble. These stocks are a very good buy at times of a crisis
Click here for Escorts Chart
Click here for Jain Irrigation Chart 
Now if we go to the other side of the spectrum, we see companies with good P/E ratios but very low EPS too. These are extremely stable stocks with little volatility over a large period of time. A take a look at “National Steel and Agro Industries” reveals that the stock price graph over the last 10 years will reveal that it has stayed put at the 20 price mark. However the stable performance translates to huge dividends . National Steel and Agro gave a dividend of 150%

Criteria 2 : P/E Ratio > 700
Dividend %
Jain Irrigation Systems Ltd.
Futuristic Offshore Services & Chemical Ltd.
Future Retail Ltd.
Visagar Polytex Ltd.
20 Microns Ltd.

A very high P/E will immediately tell you about a company that is new or expanding its business in another domain. This will often have lower dividends
  • Visagar went on NSE on Jun 2013
  • 20 Microns in 2009
(All the data has been taken from and google finance )

Tuesday, August 26, 2014

Search for the Counter Cyclical

Statistics is very fascinating but it is only recently in the past year or so, I began to realize its power. As humans, we cannot be sure of anything ( unless it is thrown at our face) and statistics can help us get that extra boost of probability

In 2008 the market collapsed and almost every stock was dealing in RED. But were there any stocks that braved the downfall ? If there are any they would be a certain hedge on your portfolio.

As a simple exercise, I collected data from over 500 companies listed on NSE for the past 7-8 years and ran some simple correlations between the price trend and the index ( CNX 500 in this case )

There is a stock PETRONET.NS that in fact had a correlation -0.3 with the Index at that time. PETRONET does business in LNG. There can be a lot of reasons for this.One can say It belongs to the Energy/Petroleum sector. But when I checked  the stocks of other oil companies ( RELIANCE,ONGC etc) they did not have the same trend. Almost all of them suffered a fall

( The graph taking the plunge in 2008 is the CNX 500  vs PETRONET)

However, I played around and found another GAS company ( IGL -> IndraPrastha Gas )
This shows that although it trailed the Index during the 2008 downturn, it has always remained counter cyclical to the index post 2010
( The graph taking the plunge in 2008 is the CNX 500  vs INDRAPRASTHA Gas)
There might be hidden trends in the stock movement of the GAS companies. There can be many reasons
1) Does not India rely on imports for LNG
2) LNG is a necessity ( upturn or downturn )

We need to ascertain this trend for GAS companies. More updates coming