FII trading activity volume data excel sheet download

FII trading activity volume data excel sheet download

FII trading activity volume data excel sheet download

In this blog, we will discuss how to find and record the FII - DII - PRO - RETAIL TRADERS  trading volume data. But why volume data is so important? Explained in this example:

Our Automated excel sheet for nifty options

Advance nifty option trading automated excel sheet with back Testing  



  1. Let say you have a water pipe with a water sprinkler attached to it.
  2. In this case, water is our price and the sprinkles are the volume 
  3. If we open the tap water will leave the sprinkle with no great force
  4. But if we open the tap and hold the one end of the pipe and store the water in the pipe and then release the water the water sprinkles will leave the pipe with high pressure
  5.  In both cases,  water is the same but the volume is a factor that causes the high pressure 

How to find and download the FII - DII - PRO - RETAIL TRADERS volume data

  1.  
  2. We update this excel sheet at the end of the day for next day trading or record the data by following the step explained in the blog
  3. Visit the link https://www.nseindia.com/products/content/all_daily_reports.htm
  4. Check the derivatives section
  5. Download the daily report  Participant wise Trading Volumes (csv)
  6. To record, the data of 30 days check the Archives section 
  7. Under the archives, section check the all historical report
  8. Under historical reports check the participant wise trading volume 
  9. Select the date and select the get data file
  10. Repeat this process and download the 30 days data
  11. Download the excel sheet to record the data
  12. Open the downloaded excel sheet 
  13. Open the historical data downloaded from Nse site
  14. Open the oldest date excel file copy the data  refer to the attached picture

  1. Open the FII trading activity volume data excel sheet 
  2. paste the data as shown in picture
  1. Check the total Long Contracts vs total short contract 
  2. Find the co-relation relationship between the data points 
  3. Develop the trading system based upon the data points 
  4. Backtest the system and find accuracy
  5. Plan your trade and then trade 
  6. Smart money vs Dumb money in the Stock market
  7. If you are a stock trader or investor answer this question?
  8. Supply and demand in the stock market
  9. when did bull market start? identify the starting point of the bull market
  10. Stock market learning - understand stock market rules and trade




Post a Comment

7 Comments

  1. Replies
    1. We updated the blog. Download the excel sheet now from the download link

      Delete
  2. can you make corelation sheet for this?

    ReplyDelete
    Replies
    1. https://stockfuturesnse.blogspot.com/2022/09/nifty-option-trading-automated-excel.html

      Delete
  3. Nice article. stockinvestor.in shares information related to stock market like stock market analysis, advice the tips to invest in the stock market, and also provides stock market recommendations.
    company profits
    shares online
    free brokers online

    ReplyDelete
  4. Replies
    1. https://stockfuturesnse.blogspot.com/2022/09/nifty-option-trading-automated-excel.html

      Delete

Thank you for your valuable comment