Amit dhamja market analysis excel sheet fully automated for nifty options

Amit dhamja's market analysis  excel sheet is fully automated for nifty options

In this blog, we will share the detailed analysis of our automated excel sheet and its accuracy with back-tested data sets which will help you to identify the direction of the market for the next day. We can say that these data points are really helpful for finding the direction of the market and this excel is worth every single rupee.  This excel Sheet automatically fetches the data from the website and automatically does the analysis for the next day. The detail of how to use this excel sheet is provided in the later section of the blog.

Our Automated excel sheet for nifty options

Advance nifty option trading automated excel sheet with back Testing 

Here is the result of the excel sheet 

Excel sheet consists of Two Sections One is intraday and the other is Total positions and 3 players

1. FII - Client - Pro Desk
2. FII - Foreign Institution 
3. Client - Retail Investors (small retail investors with a big dream of earning from call option )
4. Pro - Desk (Broker like Up stock, Motilal & many others )
5. FII and Pro desk win 90% of the time 
6. 90-90-90. Most retail investors lose 90% of the retail investors lose 90% of capital in 90 days.
7. FII and Pro Desk Enjoy the profit from the loss of retail investors
8. Retail investors trade based on emotion- sentiment, and news
9. FII and pro desk use data points
10. The day retail investors use data points for trading this percentage will increase and become more competitive.
11. Mostly new retail investors lose money in options trading without using any data points.

Paid Excel Sheet Link. 

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

result of our back tested excel sheet data

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.

 Index Futures

1. Index futures are the most important data set in this sheet.
2. If the Client increased long positions in index futures FII and Pro will create fresh short positions 
3. This provides us a hint that FII and Pro never take decisions that will cause a loss of money
4. If the client creates long positions in index futures and other FIO and the procreates short positions market will move in a negative direction the next day but we need to see other positions too to conclude.
5. This insight is the first indicator for the next day's movement. We need to watch the total net positions before concluding our decisions.
6. FII and client are the active players in this Index futures section Pro doesn't participate in the section.

Index Options Call 

1. In this section usually clients and Pro are mostly active FII don't participate in these sections they increase their positions only if there is some big movement in the market. 
2. FII creates always long positions in index calls otherwise it is for hedging purposes of index futures if they create short positions in index futures.
3. Client and Pro Desk are the key players in the index option call.
4. If clients are long in index call options Pro desk will be short.
5. If Clients are short Pro desk will create long positions.
6. Usually Clients always lose money therefore we need to choose the position of pro desk for trade.

 Index Options Put

1. In this section FII are mostly active They usually create long positions in Put options.
2. FII usually creates 2 lakh put long positions on an average basis this level is normal and it is not an alarming level
3. If FII Creates 3 lakh positions input long this is a alarming level. All the time market gives correction whenever FII creates 3 lakh positions in index put long.
4. On the other hand Client creates short positions in the index option put long which suggests that the client's position is bullish they are not expecting any correction. 
5. Whenever client positions are over the 3 lakh mark Market gives correction and Pro and FII enjoy the profit and all the retail investors lose money. Because they are not using any data point for trading.
6. If their decision is based on data they will never create opposite positions of FII and pro desk.

Stock Futures.

1. In stock future positions are usually mixed. We need to correlate the data with other positions like cash market - Index future data
2. If FII are selling in cash they will increase their position in cash and they will create a short position in index futures which is a negative sign
3. If FII is selling in cash and increasing the position in index futures position and put long position is below 3 lakh mark. It indicates a mild bullish sign. The market can be slightly bullish and sideways.
4. If FII is buying in cash they will create a short position and create a long position in the index future it is a bullish sign. The market will move up.
5. Client usually trades against FII positions and pro positions.
6. As usual Client lose here too. 
7. Before taking buying and selling decision we need to analyze the total position as bullish or bearish.

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 

If you are not able to do Please with the video on how to do it.

Other Important Excel sheet link

1. Automatic excel sheet for Sectoral Index Delivery Scanner