The destination for Intelligent Screening & Reporting in India

(Aman Goklani) #597

Hey guys, I need help in framing a query on I hope somebody is able to help me with it. I have made queries on screener in the past, though I don’t know how to go about stringing this together.

What I’m essentially looking at is filtering companies that have consistently grown sales and profits y-o-y (each and every year) over 10, 7, 5 and 3 year periods. Even marginal growth is fine. The reason I’m looking to do this is to find companies that are resilient and are consistently growing their sales and profits irrespective of market cycles and other macro scenarios.

The best example of this is Page Industries. If you look at it, you would notice they have consistently grown their sales and profits for 10 years straight -

Any help assistance in helping stringing this query together will be much appreciated. Thanks.

(Bhavin Mehta) #598

Just noticed…
Most awaited peer comparison ( all stocks coming under same industry / section) is available now on screener.
Thanks @ayushmit ji.

(VijayShetty) #600 seems to be using “16 times PEG into EPS” for calculating Intrinsic Value.

Where did you get this formula from? I have never seen it being used elsewhere. It seems very counter intuitive. PEG ratio of undervalued companies will be low & PEG ratio of overvalued companies will be high. So with your formula - the intrinsic value of undervalued companies will be low & that of overvalued companies will be high. That makes no sense to me.

(saurabhshares) #601 is not showing consolidated and standalone figures as it used to show. Anything changed. Or any alternate way to see that in screener?

(Peabody) #602

In my filtered report some of the metrics are being shown twice, for e.g Sales growth, ROE, Profit growth etc.Does anyone know how to remove duplication.

(Parthgarg) #603

Intrinsic value is an user created ratio in our site and its formula is 16 times PEG into EPS.

In case you find this formula wrong or you use any other formula then you can always try to create your own custom ratio, which you can use anywhere on our site.
This can be accessed by clicking on “View Your Profile”.

(Bheeshma Sanghani, PhD) #604

Yes, its a derivation of the popular graham number which is value =eps*( 8+ 2g) where g is the expected growth rate

(VijayShetty) #605

Do user created ratios become public? I think that shouldn’t be done. This particular formula is absurd to say the least.

(Parthgarg) #607

Yes vijay screener activated this feature a long time back and then removed this feature. But since Intrinsic Value has been used in a lot of places hence screener cannot remove that ratio, but you can always make your own ratio if you feel like its wrong.

(Tushar) #608

I was looking at Sequent scientific in screener and found that TTM considers last years “Other Income” and calculates TTM accordingly. One off other incomes should not be considered in this years calc.

(VijayShetty) #609

For some stocks like Kewal Kiran & Syngene, Balance Sheet, Cashflow, P & L are available for 10 years for standalone but only for 2-3 years in consolidated. Any idea why is this?

(Sidhegde) #610

Consolidated statements are reported only if the company has subsidiaries on its books. So in the case of Kewal Kiran it could be because the company did not have any subsidiaries and hence reported only a standalone statement until 2-3 years ago.

(pradeep200417) #611

Yes There is a need to separate the goodwill, especially for companies with lot of acquisition.

(pradeep200417) #612

The working capital calculation in Screener excel is WC=Other Assets - Other Liabilities.

Working capital is normally calculated as the current assets minus the current liabilities.
So is the calculation correct in screener or is my understanding wrong?
Could someone guide me?

(uditvd) #613

Can anyone please let me know where can see list of stocks by market cap for various years ?

for example top 100 companies by market cap in 2015, 2016, 2017, 2018 etc

(Vishnu Ch) #614

You can “Edit Columns” and add one of the following four ratios to get the historical Market Cap.


(MHS) #615

(uditvd) #616

Thanks a lot, this helps :slight_smile: !!


Is it possible to find sector wise ratios in screener ? if yes, how and if not, can it be made available for filtering companies based on a certain sector?

(Changu Mangu) #618

Some quarterly results not getting updated on

Example: 3M and Care Ratings