New F & O Stock future important data

New F & O Stock future important data

This excel will be updated on a daily basis. Download the excel sheet and analyze the stock movement with respect to its other data points. This excel sheet includes the 3 days price change, Traded Volume, Daily volatility, Traded value, Delivery percentage, No of trade, Change in open interest, the total open interest of all the future and options stocks.

Before analyzing the excel sheet key points to remember

1. Download the excel sheet daily to analyze the stocks
2. Symbol( P3) represents the last day price change, (TV 3) traded value, (DQ 3) Delivery quantity, (NT 3) no of trade, (COI 3) change in open interest, (OI 3) Open interest.
3. All data points should suggest in one direction while analyzing the stocks data
4. Important data points are a volume-traded value-delivery percentage-open interest
5. Find and learn the correlation between these data point with respect to the price of the stock
6. Analyze the data using the filters in excel
7. Stock with high trading value indicates the high interest of professional traders
8. Filter the data with highest change in trading value
9. Stock with the high delivery percentage indicate the delivery based buying and selling
10. Therefore these two data points will help us to filter out the stock with professional traders are interest
11. Check the price change for those stocks with volume
12. If the stock is in an uptrend but small price change candle is forms called Doji with high volume what will happen next? If professional traders are bullish on the stock why the price spread is not big are they selling their holdings at that price point?
13. If the stock is in a downtrend but small price change candle is forms called Doji with high volume what will happen next? If professional traders are bearish on the stock why the price spread is not big. They stop their selling at that price point.
14. Always remember the rule if professional traders are bullish on the market why price does not move up instead of high volume.
15. If professional traders are bearish on the market why price doesn't move down instead of high volume
16. Check the no of trade represented by NT 
17. If NT is less and traded value is high from the previous day 
18. It suggests the professional trader trading 
19. If the NT is high it represents the retail traders trading
20. Change in open interest represents the continuation of price action
21. If price increase and open interest increase price continue to rise further
22. If price increase and open interest decrease price fall after touching resistance
23. If price decrease and open interest increase price fall further and can break the support level with an increase in open interest
24. If price decrease and open interest decreases price stops further down move and can take the support and reverse the trend.

Bank nifty implied volatility calculation excel sheet?

Bank nifty historical volatility calculation excel sheet

Harmonic pattern cheat sheet for the stock market - Part 3

Harmonic patterns cheat sheet for the stock market - Part 2

Bank nifty open interest excel sheet download

Harmonic patterns cheat sheet for the stock market - Part 1