Screener Excel Template

By Marketcap

63 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.	Safari Inds.	1544.50	45.11	7567.36	0.19	37.47	-0.32	473.30	12.41	19.48	44.23	59.10	4.37
2.	Sonata Software	269.70	14.88	7563.06	1.63	130.50	42.65	2536.19	-3.10	30.58	20.41	16.03	3.73
3.	Castrol India	182.24	18.49	18025.77	4.80	242.18	3.74	1545.24	8.67	60.27	13.81	10.45	3.22
4.	LTM	4129.70	22.67	122495.71	1.82	1387.30	19.36	11291.70	15.56	29.60	27.88	22.79	3.22
5.	C D S L	1199.80	54.98	25075.82	1.04	79.79	-20.03	262.85	17.11	31.97	27.21	17.89	2.98
6.	Elantas Beck	9210.00	50.01	7301.40	0.08	31.08	-5.45	222.17	7.78	21.21	17.22	19.08	2.76
7.	Havells India	1209.70	44.86	75879.26	0.83	723.39	39.63	6705.20	2.47	24.90	16.59	10.75	2.73
8.	Bikaji Foods	664.45	63.73	16660.18	0.15	56.04	26.14	720.88	17.99	19.74	17.96	23.70	2.65
9.	Bosch	35210.00	44.18	103847.11	1.45	570.00	2.98	5565.70	13.34	21.54	15.57	19.29	2.44
10.	N S D L	812.40	42.79	16248.00	0.25	90.32	8.18	458.26	26.01	23.22	26.85	15.11	2.35
11.	Kajaria Ceramics	1061.30	32.51	16903.57	0.85	156.56	117.94	1373.35	12.40	23.27	11.68	10.72	2.32
12.	Blue Star	1662.50	61.39	34183.46	0.54	227.18	10.41	4072.06	1.32	21.17	23.81	49.44	2.31
13.	Redington	219.82	10.78	17184.97	3.09	287.58	61.68	33213.03	25.62	17.47	15.91	15.91	2.31
14.	Uno Minda	1079.10	51.20	62313.36	0.25	351.76	22.39	5336.41	17.85	19.70	25.26	42.91	2.19
15.	Indian Hotels Co	657.40	49.44	93576.43	0.49	645.43	14.48	2765.29	14.03	17.26	43.81	32.83	1.94
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.	ICICI Lombard	1801.00	32.40	89819.97	0.75	546.56	7.25	6824.79	12.78	23.52	17.29	13.48	1.91
17.	KFin Technolog.	831.50	40.69	14352.94	0.90	81.15	-1.11	347.33	22.86	30.48	22.02	49.53	1.88
18.	APL Apollo Tubes	1860.60	42.94	51661.12	0.31	354.35	20.89	6269.16	13.81	31.64	22.11	27.28	1.85
19.	Firstsour.Solu.	253.77	23.89	17942.25	2.17	205.24	27.72	2583.45	19.52	16.17	13.48	10.46	1.74
20.	DOMS Industries	2239.40	59.04	13590.55	0.14	58.20	17.13	603.98	18.72	24.33	42.01	83.99	1.74
21.	ERIS Lifescience	1385.90	30.39	19204.04	0.53	279.10	200.10	756.56	7.27	14.14	20.89	12.36	1.63
22.	Kirl. Brothers	1622.20	31.87	12881.72	0.43	112.10	-6.26	1415.10	10.44	20.81	10.81	20.39	1.62
23.	eClerx Services	1537.00	20.47	14455.60	0.03	189.65	24.45	1107.29	23.27	34.81	21.35	21.53	1.50
24.	Persistent Systems	5019.00	40.98	79174.73	0.70	529.26	33.73	4055.94	25.10	34.43	28.63	35.91	1.48
25.	Vesuvius India	475.45	37.03	9649.77	0.32	55.85	-5.83	499.85	3.66	21.34	21.60	34.38	1.44

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