Delivery percentage and volume analysis in excel sheet for retail investors

Delivery percentage and volume analysis in excel sheet for retail investors

Delivery percentage and volume analysis




Delivery percentage and volume analysis is a very important indicator for deciding buying or selling of stock. Delivery based buying or selling decides the seriousness and long term view of the stock. Some of the basics of delivery percentage and volume analysis consist of 4 scenarios.
  1. If the delivery percentage increase - price increase -volume increases it is a sign of FII buying sign
  2. If the delivery percentage increase - price increase -volume decrease it is confusion. Don't trade when it is not clear if volume increased later then buy otherwise leave.
  3. If the delivery percentage increase - price decrease - volume increases or decreased it is a sign of FII selling sign. Exit from the stock volume, in this case, is not mattered because FII doesn't try to sell all their quantity in one day if they do the stock will fall more.
  4. If the delivery percentage decreased  - price increase - volume increases it is a sign of trap and speculative position is created in stock and stock will be volatile and it increases the chances of loss. Don't trade in this case also.

Step for the analysis of delivery percentage and volume analysis

  1. Download delivery percentage and volume analysis excel sheet
  2. Visit https://www1.nseindia.com/products/content/equities/equities/eq_security.htm
  3. Enter symbol name in columns
  4. Select 1-month time frame from the period selection box
  5. Click on the get data tab
  6. Download the excel sheet 
  7. Open downloaded delivery percentage and volume analysis excel sheet
  8. Open the downloaded file from nse
  9. Select the data and paste the data in the first spreadsheet
  10. Check the sum total value in sheet 1
  11. If the total is greater then 12 it is a buy signal
  12. If the total is less then 12 don not trade
  13. This excel sheet is not good to get the sell ideas
  14. It works well in buy signals
  15. This will reduce your time and efforts for analyzing the delivery and volume analysis of all the stock
  16. Trade only in nifty of top 100 stocks to get most out of it
  17. This sheet is for educational purpose only

Thank you for visiting our website www.retailbroker.in. Please ask or share your suggestions regarding our blogs and inputs regarding the stock market. Share the blog in your social media profile and with your friends to educate about the stock market.



Post a Comment

5 Comments

  1. Valuable information you made my day .

    ReplyDelete
    Replies
    1. Thank you for your valuable feedback on delivery-percentage-volume-analysis-excel-sheet- for retail-investors.

      Delete
    2. thanks for your valuable information

      Delete
  2. Bottomline is excel required / suggested excelsheet is NOT downlable.
    Period

    ReplyDelete
  3. Thanks for the excel sheet, It saves lot of time in analyzing the price and volume.

    In the Sheet1."Difference" section, why 13 period average is missing, why only 3, 5, 8 and 21?

    ReplyDelete

Please don't use any spam links on comment box.Thank you for visiting retailbroker.in. We will revert back to you soon