How to Filter Stocks based on Promoters' Holding/Stake/Interest | Filter Stocks using Google Sheet

Опубликовано: 13 Июнь 2026
на канале: Apply IT

7,115

141

@applyit #StockAnalysis #PromotersHolding #FilterStocks #GoogleSheet #ShareHoldingTrend
If you want to analyze stocks based on promoters' holding / stake / interest automatically and want to highlight or filter stocks based on whether promoters' holding or stake has decreased or increased, this video is for you. Generally, if promoters' holding is below 50%, it may not be a good stock. However if for any stock promoters' holding is increasing, it indicates positive sign and if promoters' holding is decreasing, it indicates negative sign. This video demonstrates how to grab or scrape share holding pattern's data from screener website and generate a trend of share holding pattern of last few quarters. Then based on whether share holding interest has increased or decreased, the stocks are highlighted using green color and red color, respectively.

Link to the spreadsheet
https://docs.google.com/spreadsheets/...

This video answers many related questions such as
How to bring Promoter Holding in Google Sheets
How do you check a promoter holdings
How to know promoter holdings has increased or decreased
How to track promoter holding
How to analyze promoter holdings
How to know automatically promoter holding increased
How to know automatically promoter holding decreased
How to monitor promoter holdings
How to know companies with zero promoter holdings
How to know companies with very less promoter holdings
How to know companies with very high promoter holdings
How to know promoter share holding pattern

Watch other USEFUL and INTERESTING Videos on Stock Analysis:
How to Highlight Stocks near or under 200 DMA automatically using Google Sheet | Stock Analysis
   • How to Highlight Stocks near or under 200 ...

Highlight Fundamentally Good Stocks using Google Sheet
   • How to Highlight Fundamentally Good Stocks...

How to Filter Good Stocks using Google Sheet
   • How to Filter Good Stocks using Google She...

NSE India Highlight stocks that are near 52 Week High or 52 Week Low automatically
   • How to Analyze stocks that are near 52 Wee...

Get NSE India Data into Google Sheet using GoogleFinance and update automatically
   • How to Get NSE India Data into Google Shee...