Sunday, December 28, 2014

YTD Leaders

Below are weekly charts of  GATI / Gabriel / Auro Pharma:

Watch the pullbacks towards the 50 day average.

Saturday, December 27, 2014

Candid Video - Kalai Wala


This husband-wife team are kalai walas who go around the neighborhood cleaning utensils. This sight has become rare in Mumbai but still there are some people who make a living out of this. I shot this video from an 2nd floor apartment house.


Below is the December performance - a bad month for the markets.

Only the banking sector is just in the green. FMCG also hasn't suffered much so these two sectors are relatively outperforming.

Friday, December 26, 2014

Nifty @ 8200

After the last weeks pullback the index is just trying to stay above the 82 mark. The market needs to stabilize above this and I'm in favor of a continuation of the uptrend. 

Sector Performance

Thursday, December 25, 2014

Fun - PW Generator in Excel

If you have many accounts then you need to generate a different password for each account. Besides, you need to keep changing them every now and then. This can get really difficult as you might run out of ideas and reach a dead end and wonder what password to set for each account. Here's a simple idea on Excel which generates two random capital letters followed by two random numbers and again two random capital letters and two random numbers. 

In column A, cell 1, type the formula =CHAR(RANDBETWEEN(65,90))

Copy this to cell B1

In cell C1, type the formula =RANDBETWEEN(1,9) and copy it to cell D1

Repeat the process for the EFGH cells and you're on! 

After you're through with this then press F9 and you'll get a new set of characters and numbers like this:

Have fun!

Wednesday, December 24, 2014

Nifty - Full Gaps

This year we had 26 full gap ups and 3 full gap downs. For starters, a full gap up occurs on the EOD charts if the low of a day is greater than the high of the previous day and a full gap down occurs if the high of a day is lower than the low of the previous day.

On the other hand, there were 92 partial gap ups and 54 partial gap downs.

Nifty - Daily % Returns

Here's a plot of the daily % returns of Nifty. As you can see there were more up days than down days this year and generally the trend was up with only two serious corrections along the way - the one in September and the recent one which lasted for two weeks in this month.

Monday, December 22, 2014

Nifty Intraday Range

The black lines are intraday ranges. The yellow is a 10 day average. If you blow this average up then it looks like this:

Intraday range can be a good proxy for volatility. Volatility is cyclical and goes through alternate expansion and contraction phases. Currently we are near the top end of expansion and it should start mean reverting in the next few days.