Nifty Option trading automated excel sheet
3 min readSep 5, 2022
What is this excel sheet about?
- This excel sheet is about the total positions of participants in stock market futures
Why do we need to know the positions of participants?
- Because we need to know the working principle of the stock market.
What is the working principle of the stock market?
- The 90/90/90 Phenomenon
- It says 90% of retail traders lose their 90% capital within 90 days.
- The broker provides you the leverage of 40x
- If you lose 2.5% with leverage you will blow your account by 100% in a single day.
- What if the broker takes the opposite side of your trade
- The broker always wins with a 90% success ratio.
- Your objective is to make money but the broker’s objective is to take your money
- The infrastructure is built not for your benefit. It is built for the broker’s benefit
How this excel sheet will help?
- This excel sheet calculates the total outstanding positions
- It automatically calculates intraday position changes
- Based on that it calculates long — short positions and buy, and sell signals.
- All steps are automated
- We need to change the date
Is this data really work?
- We test this excel sheet from march 27–04–2022
- Here are the results
- We back-tested the data for 44 trades
- Out of 44 trades 33 are profitable
- 10 trade went against us
- We traded Only 100 Qty
- Profit of 470100
- If you believe data-driven in data driven trading system this is the system
- We created this system after having experience of 8 years
- 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.
- Add To your Cart link
- Pay and then download the excel sheet.
Inside Tips using data points
- Always Check the net positions.
- Check Client Positions if they are bullish. The market will move down
- If they are the bearish market will move up
- But sometimes FII and client positions are the same in that case go with FII positions.
How to Use The Excel sheet.
- Change the date at the end of the day around 7 pm in the analysis sheet
- After changing the date check wait for 2 min
- Check whether the data is changed or not
- If data is changed visit the data excel sheet
- Press ctrl+q only once carefully on the data excel sheet
- It will automate the excel data and your analysis is ready
Other Important Excel sheet link