Friday, January 04, 2008


For bhatia

Query "u could help me out in providing formula being used on excel to identify the stocks which are bullish, thanks"

Sir,there are 2 ways to the scan the stocks in excel:

First method:u have to apply all the indicators(MACD,RSI,Mov.Aver..etc..) to NSE bhav copy and find out which stocks are giving highest no.of Bullish signals...

disadvantages:time consuming and tiring to find out on excel sheet since NSE has 1000+ stks...if u want scan them with 5 trading days data it could lead to crashing of MS Office excel application..thats why i avoid them.

Second method:u can cherry pick your favorite stks(preferably less than 10 stks)...and apply the indicators individual to them and when they get bullish,go for the kill!! and vice versa..i use this method ,since its comfortable to me.

normally i prefer to track less than 5 stks at a time,to avoid confusion...
Post a Comment

Popular Posts for last 7 days

All Time Popular Posts

Eq mkt Holidays for the 2017 year

Sr. No.

126-Jan-2017ThursdayRepublic Day
404-Apr-2017TuesdayRam Navami
514-Apr-2017FridayDr.Baba Saheb Ambedkar Jayanti/ Good Friday
601-May-2017MondayMaharashtra Day
726-Jun-2017MondayId-Ul-Fitr (Ramzan ID)
815-Aug-2017TuesdayIndependence Day
925-Aug-2017FridayGanesh Chaturthi
1002-Oct-2017MondayMahatama Gandhi Jayanti
1119-Oct-2017ThursdayDiwali-Laxmi Pujan*

*Muhurat Trading will be conducted. Timings of Muhurat Trading shall be notified subsequently.

The holidays falling on Saturday / Sunday are as follows:

Sr. No.DateDayDescription
109-Apr-2017SundayMahavir Jayanti
202-Sep-2017SaturdayBakri ID
504-Nov-2017SaturdayGurunanak Jayanti