FII - DII data  amit dhamja market analysis  excel sheet fully automated

In this blog, we will share a very important data point to analyze the market and find the direction of the market. Excel sheet contains 4 divisions.

1. Daily data
2. Total positions trend
3. Net trade of today
4. Total Position 

Fully AUTOMATED  Excel sheet PAID  

Other important data points

1. Index future
2. Index call
3. Index put
4. Stock future

Key Players of market

1. FII 
2. Pro
3. DII
4. Client

How these dataPoints works?

1. If FII data and pro data points are aligned market will move in one direction e.g. If FII are bullish and pro are the bullish market will move up and vice versa.
2. If FII and pro data are not aligned market will remain in sideways 
3. What data point suggests us the bullish sign or bearish sign?
4. If FII or pro increased their positions in Index futures and Increase position in put short It is a bullish sign
5. If FII or pro increased their positions in Index call long and Increase position in put short It is a bullish sign
6. If FII or pro increased their positions in stock future long and Increase position in put short It is a bullish sign
7. If FII or Pro decreased their positions in the Index futures and increase position in put long it is a bearish sign
8. and vice versa in all other cases.

We will share the excel sheet daily. Visit the blog and read the market report 

Important questions for retail investors you will find all the answers in the blog

1. Do you plan your trade before the market opens?
2. How important for you to calculate your risk?
3. What is overtrading?
4. What was the motivation you become the trader?
5. Do you have the explanation for your trade decision why you buy or sell?
6. Do you have any trading strategies?
7. What is the success rate of your trading strategies?
8. How you avoid the emotional trap?
9. Do you identify the driving force for the market?
10. Do you try to hide your losing positions and show your winning position?
11. How you react when your trade goes against you?
12. Do you try average losses?
13. Do you decrease your trading volume when you are loosing?
14. Do you increase your trading volume when you are winning?
15. When did you decide to cover your positions?
16. Do you have a trading system for trading?
17. What percentage of your trade is based up the trading system?
18. Do you have any trading rules?
19. Smart money vs Dumb money in the Stock market
20. The truth of the brokerage industry, Trading expert & retail traders

• Why implied volatility increase or decrease in options?

• How to find reliance industries correlation with nifty?

• How to calculate implied volatility for nifty options?

• Learn the basics of implied volatility?

• Option chain implied volatility and options greeks calculation excel sheet download