Screener Excel Template

By Marketcap

56 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.	Berger Paints	459.85	47.86	53624.42	0.83	271.35	5.10	2983.97	0.30	24.90	12.64	12.58	3.86
2.	Clean Science	794.35	31.05	8437.97	0.76	51.90	-29.97	185.49	-19.90	29.26	17.08	15.92	3.64
3.	Dr Lal Pathlabs	1411.70	43.14	23665.44	0.85	91.40	14.61	659.80	10.57	28.88	13.09	16.69	3.51
4.	LTM	4380.60	24.05	129928.97	1.48	1387.30	19.36	11291.70	15.56	29.60	27.88	22.78	3.43
5.	Castrol India	183.81	18.66	18186.98	4.76	242.18	3.74	1545.24	8.67	60.27	13.81	10.45	3.25
6.	Pidilite Inds.	1392.60	61.26	141786.05	0.72	623.84	12.64	3709.91	10.12	29.84	12.49	12.63	3.08
7.	C D S L	1324.60	58.13	27684.14	0.94	132.95	2.48	304.36	9.43	41.96	36.89	37.81	3.02
8.	N S D L	885.95	47.51	17719.00	0.23	89.67	4.44	359.63	-0.81	23.57	34.22	21.33	2.85
9.	Havells India	1272.20	46.28	79834.07	0.79	723.39	39.63	6705.20	2.47	24.92	16.59	11.19	2.69
10.	eClerx Services	1449.10	20.36	13622.90	0.03	191.81	40.06	1070.33	25.36	27.97	18.55	19.96	2.58
11.	Rainbow Child.	1241.90	48.93	12606.60	0.24	73.90	5.59	445.45	11.90	18.69	16.08	33.66	2.46
12.	Tata Technolog.	569.80	35.25	23146.59	1.47	6.64	-21.70	1365.73	3.67	25.80	12.63	21.37	2.24
13.	SKF India	1742.40	23.91	8598.26	0.83	61.99	-14.54	576.64	3.21	28.82	11.60	16.57	1.88
14.	ICICI Lombard	1771.80	31.83	88237.26	0.71	546.56	7.25	6824.79	12.78	23.52	17.29	13.48	1.87
15.	Bikaji Foods	672.75	67.65	16884.42	0.15	62.17	117.64	790.01	10.51	18.16	19.53	28.79	1.82
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.	KFin Technolog.	954.50	46.59	16464.48	0.79	91.99	8.39	370.87	27.88	32.75	19.38	134.47	1.61
17.	Inventurus Knowl	1521.80	39.35	26104.61	0.00	183.33	41.37	814.95	24.01	27.20	38.17	28.66	1.58
18.	Uno Minda	1129.70	56.36	65239.99	0.20	300.48	27.58	5018.06	19.93	18.83	21.94	40.73	1.43
19.	Persistent Systems	4803.50	39.17	75683.31	0.73	529.26	33.73	4055.94	25.10	34.43	28.63	35.91	1.42
20.	Global Health	1137.55	54.12	30650.17	0.04	95.03	-13.19	1121.05	18.83	19.74	19.73	70.15	1.41
21.	Narayana Hrudaya	1757.00	43.46	35875.14	0.26	126.79	-12.82	2151.17	61.19	20.75	11.88	43.49	1.39
22.	P I Industries	3097.60	34.45	47022.89	0.52	311.30	-39.61	1375.70	-27.63	22.86	18.83	29.53	1.36
23.	Poly Medicure	1511.70	43.46	15324.06	0.23	70.81	-10.98	493.66	16.37	20.08	19.44	28.38	1.30
24.	Transport Corp.	941.80	16.08	7204.29	0.96	115.80	13.68	1248.80	8.87	20.52	10.57	22.20	1.30
25.	Indian Energy Ex	125.94	23.71	11229.97	2.78	123.96	10.69	172.25	21.94	51.79	13.92	17.82	1.21

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 Mar 2026 results