Customised sql

Considers inbetween low*1.30 and high*0.75 and Return on Equity 10% and Stock Cargr > 10%

34 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 %	Up %	Down %
1.	Shilchar Tech.	4601.00	32.03	5263.64	0.27	41.49	73.02	158.75	48.38	71.30	64.09	24.88
2.	Swaraj Engines	4011.60	28.21	4873.08	2.60	49.97	15.70	484.10	15.82	56.21	59.38	15.12
3.	Gillette India	10095.00	58.40	32899.61	1.11	145.69	25.63	706.72	9.51	56.06	36.20	12.26
4.	HDFC AMC	5463.00	44.87	116874.69	1.65	747.92	23.83	967.76	24.83	43.33	54.98	7.84
5.	Multi Comm. Exc.	7390.00	57.78	37687.79	0.41	203.19	83.19	373.21	59.24	42.86	67.64	18.92
6.	Frontier Springs	4757.45	44.19	1874.44	0.04	14.74	111.17	75.34	48.45	41.83	187.75	13.03
7.	Nippon Life Ind.	784.75	36.97	49914.96	2.29	396.12	19.19	606.61	20.13	40.69	72.08	11.62
8.	Dixon Technolog.	16690.00	117.70	100997.31	0.03	280.02	68.29	12835.66	95.08	39.81	38.83	12.85
9.	Indrapr.Medical	439.00	24.00	4024.44	1.03	51.46	14.94	365.06	4.94	39.01	42.88	23.25
10.	Cigniti Tech.	1629.40	17.46	4464.06	0.18	65.90	160.47	534.20	14.02	34.16	57.70	17.74
11.	Astrazeneca Phar	8460.50	100.02	21151.25	0.38	55.83	60.14	526.31	35.81	33.40	36.02	20.86
12.	RPG LifeScience.	2320.50	37.05	3837.88	0.86	26.29	-1.76	168.92	2.12	32.80	30.95	22.04
13.	Banco Products	576.55	19.06	8246.82	1.91	109.52	59.49	970.09	20.68	32.36	96.81	16.51
14.	Foseco India	6233.00	48.62	3980.68	0.40	21.53	16.38	157.25	25.79	31.34	94.48	6.75
15.	Kingfa Science	4174.50	32.92	5055.51	0.24	39.79	1.84	461.93	10.92	30.55	70.32	11.18
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 %	Up %	Down %
16.	Force Motors	19477.00	42.45	25663.41	0.21	176.36	52.40	2297.25	21.88	29.99	217.99	11.47
17.	Eicher Motors	6103.00	34.60	167391.86	1.15	1205.22	9.42	5041.84	14.77	29.81	35.62	2.66
18.	eClerx Services	4221.30	36.23	20695.07	0.02	141.55	26.94	934.56	19.52	27.97	99.49	9.02
19.	Fiem Industries	2100.70	26.24	5528.97	1.43	57.52	17.65	658.90	14.05	27.80	81.72	4.53
20.	ITD Cem	708.10	29.68	12164.28	0.28	137.21	36.96	2542.37	6.76	27.64	51.76	24.99
21.	SML ISUZU	4197.40	42.70	6073.64	0.43	66.96	44.34	845.89	13.39	27.14	308.15	11.54
22.	HBL Engineering	807.10	65.20	22372.40	0.12	143.35	81.69	601.77	15.70	26.30	99.63	3.34
23.	Gabriel India	1152.40	76.50	16553.53	0.41	55.67	8.82	984.55	13.92	26.14	197.78	4.38
24.	Caplin Point Lab	2098.60	28.23	15951.81	0.29	150.76	23.26	510.22	11.17	25.85	35.30	20.54
25.	Shriram Pistons	2512.60	21.09	11067.96	0.40	134.90	15.76	963.30	15.08	25.70	61.48	6.42

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