Stocks scanned based on ID & NR7 Strategy for 1-3-2012

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 1-3-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 1 March 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5270
Low risk entry : 5360
Target : 5480
     
Bank Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 10080
Low risk entry : 10370
Target : 10680

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 29-2-2012


Stocks scanned based on ID & NR7 Strategy for 29-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 29 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Down
SAR : 5440
Low risk entry : 5380
Target : 5270 (moved up)
     
Bank Nifty Spot Rates Technical Trading Levels
Swing : Down
SAR : 10600
Low risk entry : 10380
Target : 10100 (moved up)

Online day trading strategy - Stocks futures scanned based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 28-2-2012

Day trading setup - Stocks scanned based on ID & NR7 Strategy for 28-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 28 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Down
SAR : 5500
Low risk entry : 5380
Target : 5230
     
Bank Nifty Spot Rates Technical Trading Levels
Swing : Down
SAR : 10760
Low risk entry : 10380
Target : 9950

How to filter stocks data, to get the data only for your watchlist or portfolio using Microsoft Excel

While maintaining the 10 day's cash market data for "Inside day Narrow Range Seven Setup Screener" I came across this problem of huge file size (Microsoft Excel not responding) as well as getting unnecessary results (illiquid stock show narrow range quite often). Therefore, I decided to reduce my screening result to only top 600 stocks ( sorted by rupee volume i.e total trade value)

You can download the stocks data filter excel file, free from here

Screenshot of  stocks data filter excel file below

How to use the file?
1) Copy the stock data in the first sheet "Downloaded Data", in this case I have downloaded stock bhavcopy data from NSE website.

2) Now in the second sheet "Filtered Data" I have used VLOOKUP function of Microsoft Excel to filter data, the stock list (600 stocks) for which I want the data, is added in the cells A700 to A1299. The filtered stock data is available between A2 to A601 cells with their respective price information.

That's all you need to do with this file. Before using the raw data from NSE bhavcopy, you can put that data in this file, it will filter out the excess data. You can change the stocks list as per your requirements, simply change the stock list (in the cells A700 to A1299) from 600 stocks to the stocks you want to track i.e the stocks in your portfolio or watchlist.

Hope you find it useful, please share if you like it.    

Stocks scanned based on ID & NR7 Strategy for 27-2-2012

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 27-2-2012

Comparative Relative Performance Of Stocks For This Week - Biggest Percentage Winners and Losers

Comparative Relative Performance Of Stocks For This Week - Biggest Percentage Winners and Losers

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 27 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Down
SAR : 5540
Low risk entry : 5470
Target : 5360
     
Bank Nifty Spot Rates Technical Trading Levels
Swing : Down
SAR : 10855
Low risk entry : 10630
Target : 10330

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 24-2-2012

Stocks scanned based on ID & NR7 Strategy for 24-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 24 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Down
SAR : 5620
Low risk entry : 5530
Target : 5430
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Down
SAR : 11210
Low risk entry : 10850
Target : 10550

Stocks scanned based on ID & NR7 Strategy for 23-2-2012

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 23-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 23 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Down
SAR : 5625
Low risk entry : 5570
Target : 5450
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Down
SAR : 11210
Low risk entry : 10980
Target : 10620

Stocks scanned based on ID & NR7 Strategy for 22-2-2012

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 22-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 22 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5500
Low risk entry : 5560
Target : 5680
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10850
Low risk entry : 11020
Target : 11350

Which stocks stood firm during the bear market?

Below is the list of stocks that stood firm during the bear market of 2011. These stocks have given average performance if we compare them with best performing stock since 20 December 2011(bear market bottom). However if we compare them on long term basis they have outperformed. Therefore, the short term performance in stocks(since 20 December 2011) is a combination of short covering induced buying and value buying, concentrated in beaten down stocks.

Short term relative performance of stocks - Up move is based on short covering and value buying

Checking the relative performance of stocks, we can clearly see that the recent up move is based on short covering and value buying, beaten-down stocks showing better relative performance in the short term.
Since the last bull market top (5 November 2010) many stocks are still down 41 %, on an average, while they are up 90%, on an average, since the bear market bottom (20 December 2011)

Top performing stocks since bear market low of 20 December 2011

Top performing stocks since bear market low of 20 December 2011

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for 21-2-2012

Stocks scanned based on ID & NR7 Strategy for 21-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 21 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5450
Low risk entry : 5530
Target : 5630
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10700
Low risk entry : 10930
Target : 11250

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 17-2-2012

Stocks scanned based on ID & NR7 Strategy for 17-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 17 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5400
Low risk entry  : 5480
Target : 5580
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10550
Low risk entry : 10780
Target : 11000

Stocks scanned based on ID & NR7 Strategy for 16-2-2012

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 16-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 16 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5380
Low risk entry : 5460
Target : 5580
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10500
Low risk entry : 10700
Target : 11000

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 15-2-2012

Stocks scanned based on ID & NR7 Strategy for 15-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 15 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5330
Low risk entry  : 5380
Target : 5480
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10300
Low risk entry : 10450
Target : 10680

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 14-2-2012

Stocks scanned based on ID & NR7 Strategy for 14-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 14 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5320
Low risk entry  : 5370
Target : 5480
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10280
Low risk entry : 10400
Target : 10680

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 13-2-2012


Stocks scanned based on ID & NR7 Strategy for 13-2-2012

Doji candlestick chart pattern, sideways consolidation for nifty for this week, Daily Update - 13 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5320
Low risk entry  : 5370
Target : 5480
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10220
Low risk entry : 10380
Target : 10680

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 10 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5320
Low risk entry  : 5360
Target : 5480
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10200
Low risk entry : 10350
Target : 10680

Stocks screened based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 10-2-2012

Stocks scanned based on ID & NR7 Strategy for 10-2-2012 

Day trading setup - Stocks scanned based on ID & NR7 Strategy for 9-2-2012

Online day trading strategy - Stocks futures scanned based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 9-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 9 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5300
Low risk entry  : 5340
Target : 5430
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10100
Low risk entry : 10230
Target : 10500

Day trading setup - Stocks scanned based on ID & NR7 Strategy for 8-2-2012

Online day trading strategy - Stocks futures scanned based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 8-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 8 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5270
Low risk entry  : 5340
Target : 5430
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 10080
Low risk entry : 10230
Target : 10500

Day trading setup - Stocks scanned based on ID & NR7 Strategy for 7-2-2012

Online day trading strategy - Stocks futures scanned based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 7-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 7 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5250
Low risk entry  : 5300
Target : 5420
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 9900
Low risk entry : 10100
Target : 10400

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 6 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5200
Low risk entry  : 5260
Target : 5380
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 9780
Low risk entry : 9950
Target : 10200

Day trading setup - Stocks scanned based on ID & NR7 Strategy for 3-2-2012

Online day trading strategy - Stocks futures scanned based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 3-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 3 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5160
Low risk entry  : 5220
Target : 5320
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 9750
Low risk entry : 9900
Target : 10200

Day trading setup - Stocks scanned based on ID & NR7 Strategy for 2-2-2012

Online day trading strategy - Stocks futures scanned based on Inside Day and Narrow Range Seven (NR7) setup for tomorrow 2-2-2012

Nifty & Bank Nifty Spot Rates, Technical Swing Trading Levels Daily Update - 2 February 2012

Nifty Spot Rates Technical Trading Levels
Swing : Up
SAR : 5100
Low risk entry  : 5170
Target : 5280
     
Bank Nifty Spot Rates Technical Trading Levels
Swing  : Up
SAR : 9600
Low risk entry : 9750
Target : 10000