@visuarchie Hey, when creating the google sheet for the first time, do you get the table numbers of daily price from google finance on a real time basis? As my sheet is breaking apart because of the google finance formula everywhere, most of the time it saying “loading…” which is making it difficult for me to work on other formulas. Is there another way where i can just copy paste the daily data from somewhere reducing the load of the sheet to fetch data everytime?

Perhaps here, some discretion is not wrong. It is possible that we may never get a chance to buy, particularly with stocks that have small market cap, and it is also possible that some of these are operator driven, so they hit both UC and LC regularly. So we may feel to omit it completely if we look at the chart, or we can buy if we get a chance, but then it may hit a few LC after we buy, or by the time we buy, it may lose its place by another stock.

So, applying discretion of letting a stock go and replacing it with the immediate next one can be an option, or going ahead as per the rules is another.

I am not investing in the list, just sharing some thoughts and little experience with circuit stocks.

Correct, its about the profitability that justifies valuation, and not just sales

How can you use one metric to justify a stock? Take an example of this company has a price to sales of just 6.42 but then a PE of close to 80, it made 18Cr profit last year on a topline of 224Cr, 10Cr less than EcoReco which made 18Cr profit over a topline of 28Cr.
Just one metric doesn’t suffice, usually.

you are looking at sales
but they have a margin for 60%+.
they are targetting 300 Cr of sales with 60% margins, which comes to 180 cr EBITDA
even on a 10x EV/EBITDA, which is very conservative
you are looking at 1800 Cr m-cap