MyQuery

Companies with market cap more than 1500 cr

30 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 %	ROCE 3Yr %	ROCE 5Yr %
1.	P & G Hygiene	12854.00	50.48	41725.03	0.86	209.86	-0.96	1150.17	1.32	103.79	104.80	93.26
2.	Shilchar Tech.	3837.50	24.73	4390.18	0.33	45.94	40.36	171.28	31.19	71.30	66.64	47.20
3.	Swaraj Engines	3690.50	25.33	4483.91	2.83	49.68	9.38	504.04	8.57	56.21	54.36	52.13
4.	Gillette India	8207.50	46.60	26748.24	1.36	143.65	8.00	810.81	3.71	56.06	53.08	49.64
5.	Indian Energy Ex	134.36	26.64	11980.78	2.23	121.61	14.64	152.24	9.34	53.61	51.64	55.13
6.	HDFC AMC	2657.20	41.44	113810.13	1.69	718.06	24.47	1026.04	15.65	43.33	37.79	37.89
7.	Mazagon Dock	2494.50	43.11	100623.14	0.69	749.48	28.10	2929.24	6.25	43.19	40.00	32.78
8.	C D S L	1466.60	64.80	30651.94	0.85	139.94	-13.46	318.89	-1.05	41.96	37.49	36.59
9.	Oracle Fin.Serv.	7731.50	28.35	67277.12	3.43	546.10	-5.47	1788.80	6.86	40.60	38.42	37.60
10.	Bharat Electron	403.15	51.74	294693.73	0.60	1287.16	17.88	5792.09	25.78	38.88	34.47	31.67
11.	Cummins India	4482.10	53.91	124243.81	1.15	622.33	38.49	3170.27	26.38	36.32	32.65	27.23
12.	Hind.Aeronautics	4417.80	34.88	295451.42	0.91	1669.05	10.82	6628.61	10.92	33.88	34.43	31.98
13.	NBCC	122.67	49.59	33120.90	0.55	156.69	25.71	2910.20	18.99	33.17	30.70	26.25
14.	Steelcast	210.31	23.90	2128.34	0.68	23.21	74.64	106.65	41.54	32.94	38.45	30.48
15.	RPG LifeScience.	2312.50	34.31	3824.65	0.86	36.85	38.23	181.68	5.50	32.80	33.54	31.77
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 %	ROCE 3Yr %	ROCE 5Yr %
16.	Foseco India	4927.70	44.99	3714.14	0.51	16.49	3.50	150.72	7.08	31.34	30.24	24.98
17.	Clean Science	869.80	31.45	9243.93	0.69	64.64	-4.15	211.31	-7.34	29.26	34.68	42.24
18.	Disa India	12099.15	33.34	1759.46	1.65	12.23	-1.29	103.54	21.40	29.25	24.50	23.38
19.	Volt.Transform.	7877.00	24.25	7969.26	1.27	78.85	4.11	482.56	21.33	29.11	28.58	23.81
20.	Sika Interplant	926.35	57.17	1963.94	0.26	8.94	44.43	51.58	55.17	29.04	23.13	25.51
21.	Stylam Industrie	2207.80	29.94	3741.79	0.00	37.33	9.47	292.40	11.31	27.41	30.96	28.32
22.	Caplin Point Lab	1848.80	23.87	14053.04	0.32	160.23	18.08	534.04	10.54	25.85	26.21	26.95
23.	Bhansali Engg.	91.24	13.62	2270.58	4.38	40.45	-12.69	325.10	-11.40	25.34	22.97	42.39
24.	ICICI Lombard	1973.90	35.10	98309.07	0.63	819.54	18.10	6869.33	11.75	24.86	22.87	22.88
25.	Avanti Feeds	880.25	19.39	11993.02	1.02	168.80	34.88	1609.69	18.79	23.99	20.77	20.63

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 Sep 2025 results