Screener Excel Template

By Marketcap

49 results found: Showing page 1 of 2

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.	CRISIL	4132.00	36.00	30217.32	0.61	233.26	45.93	1057.66	30.06	32.55	12.99	14.40	4.97
2.	Safari Inds.	1675.50	48.93	8209.20	0.24	37.47	-0.32	473.30	12.41	19.48	44.23	59.10	4.74
3.	Sonata Software	297.40	16.40	8339.83	1.48	130.50	42.65	2536.19	-3.10	30.58	20.41	16.03	4.11
4.	Castrol India	185.80	18.85	18377.89	4.71	242.18	3.74	1545.24	8.67	60.27	13.81	10.45	3.28
5.	LTM	3832.50	21.03	113680.12	1.96	1387.30	19.36	11291.70	15.56	29.60	27.88	22.79	2.99
6.	N S D L	922.30	48.58	18446.00	0.22	90.32	8.18	458.26	26.01	23.22	26.85	15.11	2.67
7.	Havells India	1176.30	43.63	73784.22	0.85	723.39	39.63	6705.20	2.47	24.90	16.59	10.75	2.66
8.	Bikaji Foods	660.20	63.32	16553.62	0.19	56.04	26.14	720.88	17.99	19.74	17.96	23.70	2.64
9.	Blue Star	1668.30	61.61	34302.72	0.51	227.18	10.41	4072.06	1.32	21.17	23.81	49.44	2.32
10.	Uno Minda	1115.60	52.93	64422.24	0.24	351.76	22.39	5336.41	17.85	19.70	25.26	42.91	2.27
11.	KFin Technolog.	915.35	44.85	15819.78	1.31	81.15	-1.11	347.33	22.86	30.48	22.02	49.53	2.07
12.	APL Apollo Tubes	1871.60	43.19	51966.55	0.31	354.35	20.89	6269.16	13.81	31.64	22.11	27.28	1.86
13.	DOMS Industries	2274.10	59.96	13801.13	0.14	58.20	17.13	603.98	18.72	24.33	42.01	83.99	1.77
14.	Firstsour.Solu.	244.70	23.04	17300.98	2.25	205.24	27.72	2583.45	19.52	16.17	13.48	10.46	1.68
15.	KPIT Technologi.	760.05	30.79	20836.30	1.12	162.97	-33.38	1711.00	11.95	26.31	25.96	36.82	1.46
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.	Persistent Systems	4829.00	39.43	76177.48	0.72	529.26	33.73	4055.94	25.10	34.43	28.63	35.91	1.43
17.	Indiamart Inter.	2089.40	26.48	12566.31	1.44	50.20	-72.20	404.30	13.86	28.04	18.57	11.22	1.41
18.	Vesuvius India	464.90	36.20	9435.65	0.32	55.85	-5.83	499.85	3.66	21.34	21.60	34.38	1.40
19.	eClerx Services	1418.70	18.89	13342.98	0.04	189.65	24.45	1107.29	23.27	34.81	21.35	21.53	1.38
20.	Transport Corp.	948.05	15.94	7275.70	0.95	124.50	8.23	1323.80	12.30	19.54	11.90	23.80	1.28
21.	Gillette India	7828.50	38.99	25513.08	1.53	192.51	21.32	792.00	3.20	90.62	13.04	23.18	1.25
22.	Coforge	1463.30	38.31	62921.89	1.04	666.20	151.04	4450.50	30.05	23.50	28.60	28.45	1.24
23.	Lemon Tree Hotel	113.04	36.09	8955.55	0.00	116.45	9.57	416.40	10.01	13.95	41.83	31.63	1.23
24.	Mazagon Dock	2518.70	39.33	101599.32	0.69	674.16	108.79	3850.39	21.29	35.98	26.30	33.51	1.22
25.	Indian Energy Ex	122.78	23.11	10948.20	2.85	123.96	10.69	172.25	21.94	51.79	13.92	17.82	1.18

1 2 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