Nifty Option trading automated excel sheet

Nifty Option trading automated excel sheet

 Nifty Option trading automated excel sheet





What is this excel sheet about?

  1. This excel sheet is about the total positions of participants in stock market futures
Why do we need to know the positions of participants?
  1. Because we need to know the working principle of the stock market.
What is the working principle of the stock market?
  1. The 90/90/90 Phenomenon
    1. It says 90% of retail traders lose their 90% capital within 90 days.
    2. The broker provides you the leverage  of 40x 
    3. If you lose 2.5% with leverage you will blow your account by 100% in a single day.
    4. What if the broker takes the opposite side of your trade
    5. The broker always wins with a 90% success ratio.
    6. Your objective is to make money but the broker's objective is to take your money
    7. The infrastructure is built not for your benefit. It is built for the broker's benefit
How this excel sheet will help?
  1. This excel sheet calculates the total outstanding positions
  2. It automatically calculates intraday position changes
  3. Based on that it calculates long - short positions and buy, and sell signals.






  1. All steps are automated 
  2. We need to change the date 
Is this data really work?


Here is the result of this excel sheet Check the signal accuracy in December





  1. We test this excel sheet 
  2. If you believe data-driven in data driven trading system this is the system 
  3. We created this system after having experience of 8 years 
  4. We believe the data-driven decision is the only way to do trading in the stock market otherwise it is a gambling.
  5. Month wise result is shown above


Paid Excel Sheet Link. 

  1. Add To your Cart link
  2.  Pay and then download the excel sheet.



Inside Tips  using data points

  1. Always Check the net positions.
  2. Check Client Positions if they are bullish. The market will move down
  3. If they are the bearish market will move up
  4. But sometimes FII and client positions are the same in that case go with FII positions.

How to Use The Excel sheet.

  1. Change the date at the end of the day around 7 pm in the analysis sheet
  2. After changing the date check wait for 2 min
  3. Check whether the data is changed or not
  4. If data is changed visit the data excel sheet 
  5. Press ctrl+q only once carefully on the data excel sheet
  6. It will automate the excel data and your analysis is ready 


Post a Comment

0 Comments