Screener Excel Template

By Marketcap

70 results found: Showing page 1 of 3

Edit Columns

S.No.	Name	CMP Rs.	P/E	Mar Cap Rs.Cr.	Div Yld %	NP Qtr Rs.Cr.	Qtr Profit Var %	Sales Qtr Rs.Cr.	Qtr Sales Var %	ROCE %	Sales Var 5Yrs %	Profit Var 5Yrs %	PEG
1.	Timken India	3054.20	50.51	22973.31	1.18	89.47	-0.53	772.99	2.67	20.93	14.24	12.63	4.65
2.	V-Guard Industri	330.50	49.64	14421.19	0.45	65.29	3.00	1340.92	3.63	19.50	17.38	10.56	4.62
3.	Berger Paints	541.25	57.08	63104.05	0.70	206.38	-23.50	2827.49	1.91	24.90	12.64	12.58	4.60
4.	Clean Science	907.30	32.81	9642.47	0.66	64.64	-4.15	211.31	-7.34	29.26	17.08	15.92	3.84
5.	Tata Elxsi	5030.50	46.73	31337.61	1.49	154.82	-32.52	918.10	-3.87	36.26	18.29	24.68	3.69
6.	Dr Lal Pathlabs	2874.50	45.07	24081.27	0.42	152.20	16.41	730.60	10.66	28.88	13.09	16.69	3.67
7.	Schaeffler India	3831.30	53.58	59884.63	0.73	306.65	24.08	2360.14	13.86	25.67	13.12	21.59	3.39
8.	Apollo Hospitals	7101.00	61.07	102101.48	0.27	494.00	25.98	6303.50	12.78	16.64	14.15	33.72	3.36
9.	Pidilite Inds.	1476.80	66.96	150296.01	0.68	584.60	8.36	3554.44	9.88	29.84	12.49	12.63	3.36
10.	Cams Services	755.20	42.50	18702.58	1.64	110.94	-3.71	353.89	3.51	54.75	15.06	21.96	2.91
11.	Rainbow Child.	1384.80	55.42	14063.91	0.22	75.62	-4.59	444.80	6.55	18.69	16.08	33.66	2.78
12.	CRISIL	4498.60	43.91	32898.27	0.56	193.10	12.56	911.24	12.24	35.60	13.49	14.43	2.74
13.	KSB	738.10	48.92	12845.83	0.54	67.50	9.40	649.60	5.37	23.82	14.38	21.96	2.69
14.	Tata Technolog.	660.00	38.63	26779.08	1.27	165.50	5.14	1323.33	2.07	25.80	12.63	21.37	2.46
15.	Indian Energy Ex	143.20	28.39	12769.04	2.09	121.61	14.64	152.24	9.34	53.61	15.81	19.79	2.33
S.No.	Name	CMP Rs.	P/E	Mar Cap Rs.Cr.	Div Yld %	NP Qtr Rs.Cr.	Qtr Profit Var %	Sales Qtr Rs.Cr.	Qtr Sales Var %	ROCE %	Sales Var 5Yrs %	Profit Var 5Yrs %	PEG
16.	UTI AMC	1146.40	25.02	14713.74	2.27	132.20	-52.75	418.55	-22.26	21.02	16.73	21.92	2.27
17.	Inox India	1141.00	43.34	10356.12	0.18	60.84	19.90	358.22	16.85	37.98	15.01	22.90	2.22
18.	Fine Organic	4409.20	33.77	13518.60	0.25	108.55	-7.57	597.29	0.25	26.39	16.93	20.04	2.05
19.	KFin Technolog.	1051.70	52.43	18131.41	0.71	93.31	4.47	309.23	10.25	32.75	19.38	134.47	1.81
20.	Mrs Bectors	271.20	61.10	8325.58	0.44	36.51	-6.24	551.42	11.11	18.14	19.71	36.41	1.69
21.	Elantas Beck	9506.25	54.55	7536.25	0.08	36.26	16.70	216.55	17.97	23.02	13.69	23.05	1.68
22.	Poly Medicure	1889.80	52.92	19154.92	0.19	91.80	5.02	443.88	5.68	20.08	19.44	28.38	1.58
23.	Transport Corp.	1048.30	18.52	8043.29	0.76	113.50	5.83	1204.90	7.50	20.52	10.57	22.20	1.50
24.	Ratnamani Metals	2451.80	28.34	17185.16	0.57	156.04	35.69	1191.69	22.69	21.51	14.94	12.03	1.50
25.	Elgi Equipments	487.90	39.69	15461.99	0.45	121.40	28.17	968.00	11.41	21.91	13.92	52.48	1.46

1 2 3 Next

Results per page

10 25 50

Search Query

You can customize the query below:

Query

Custom query example

Market capitalization > 500 AND Price to earning < 15 AND Return on capital employed > 22%

Detailed guide on creating screens

Only companies with Sep 2025 results