Nifty Option trading automated excel sheet

Retail Investor
3 min readSep 5, 2022

--

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
  2. It says 90% of retail traders lose their 90% capital within 90 days.
  3. The broker provides you the leverage of 40x
  4. If you lose 2.5% with leverage you will blow your account by 100% in a single day.
  5. What if the broker takes the opposite side of your trade
  6. The broker always wins with a 90% success ratio.
  7. Your objective is to make money but the broker’s objective is to take your money
  8. 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?

  1. We test this excel sheet from march 27–04–2022
  2. Here are the results
  3. We back-tested the data for 44 trades
  4. Out of 44 trades 33 are profitable
  5. 10 trade went against us
  6. We traded Only 100 Qty
  7. Profit of 470100
  8. If you believe data-driven in data driven trading system this is the system
  9. We created this system after having experience of 8 years
  10. We believe the data-driven decision is the only way to do trading in the stock market otherwise it is a gambling.

Paid Excel Sheet Link.

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

Other Important Excel sheet link

  1. Automatic excel sheet for Sectoral Index Delivery Scanner

--

--