How to Make Your Own Day Trading Scanner

How to Make Your Own Day Trading Scanner

In this article, I am going to discuss how to make your own day trading scanner step by step. Please read our previous article where we discussed 3 Techniques for Risk Management in Trading. Here, you will learn how to get the stock market data such as price, volume, and open interest data using a Google spreadsheet and how to analyze it. After reading this, you will be able to:

  1. Analyze end of data
  2. How to create your own Google spreadsheet for data analysis?
  3. How to use this sheet?
What is the end of data in stock?

Means what price did in that day. It shows open, close high, low, open interest, option chain data, etc.

Where to get this data?

After the market closed. NSEINDIA published this report in bhavcopy file

What to download?

Download the capital market bhavcopy file and Derivatives market bhavcopy file. The link is given below

https://www1.nseindia.com/products/content/all_daily_reports.htm

How to make your own Google spreadsheet scanner?

All the steps by step are described in the below video.

Use of scanner
  1. We can predict the stock trend by analyzing the end of the data?
  2. We can find stock for the next day?
What contains in this sheet?

Buy/sell column

So for long stock should have high volume, high OI, and PCR>1. So, we make our buy column by giving the above condition

Change in Volume and Change in the open interest column

If ultra-high volume we find. Then something unusual happened. by checking the chart we can determine whether the stock for tradable or not. Whether it breaks out from any support or resistance level with high volume. then we must keep it on our watch list

Change in price

Here we will find top gainer or top looser stock. Check in the chart why the top gainer and a top loser.

Change in PCR column

How to make own Day Trading Scanner

Gap up and gap down the column

This column update aftermarket open. Have a look at this sheet

Gap up and gap down column

How to use this scanner?

Let me tell you some basic information

For the trading purpose, avoid stocks with lower volumes and lower open interest

Why?

The analogy of volume and open interest in the market is like that of fuel to a fire. If the fuels are removed from a fire, the fire will go out. If fuel (volume and open interest) is removed from a price trend, the trend will change or move will stop. When open interest and volume decline, fuel is removed and the prevailing price trend is running on borrowed time. For a healthy, strong price trend (either up or down) to continue, open interest and volume ideally should increase, or at least not decline.

How to use own Day Trading Scanner

Option chain analysis

PCR=put to call ratio

Buy Rule: 1. Change in PCR(OI) is positive.

Sell Rule: 1. Change PCR(OI) is negative

In the video, I explain in live how to select stock for the next day based in end of day data analysis. Here is the list of stock that showing buys condition

How to create your own Google spread sheet for data analysis?

Even our scanner shows buy condition. After the market opens if our trading setup didn’t tell then I am happy to avoid trading.

Tips: If the index and sector are bullish trade with strong stock on the bullish side.

In the next article, I am going to discuss How to Select Stocks for Intraday Trading with lice examples. Here, in this article, I try to explain how to make your own day trading scanner and I hope you enjoy this article. Please join my Telegram Channel and YouTube Channel as well as my Facebook Group to learn more and clear your doubts. 

40 thoughts on “How to Make Your Own Day Trading Scanner”

  1. blank
    V. RamachandraReddy

    i required Google spread sheet scanner (Excel Format) with formula so that i can find right stock for the day trading
    please send it to my mail id

  2. blank

    Hi Sir,
    What a wonderful explanation. It was easier to understand. However can you share the spreadsheet and formula to get live price against symbol in the spreadsheet?

  3. blank

    Hello sir please find out the Google Scanner video some problem please resolve as soon as possible thanks and regards Samrat Banerjee I am big fan of you

    1. blank

      If you can share excel file, then please send it on the email.

      Are you taking training and classes on market analysis?

  4. blank

    Thanks for helping people like me

    Request you to please share latest excel scanner to me with below columns. As i dont know if any formula is used in this column that could affect any result in scanner.
    DBPDO
    DBPDH
    DBPDL
    DBPDC

  5. blank

    Sir,
    i required Google spread sheet scanner (Excel Format) with formula so that i can find right stock for the day trading
    please send it to my mail id.
    Regards

Leave a Reply

Your email address will not be published. Required fields are marked *