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.