Screener

486 companies · every ratio sourced from the company's own NSE filing. Update the cache with python manage.py refresh_market_data. Looking to browse the whole universe instead of filtering it? See Browse all companies.

Sector

ROE >

Debt/Equity <

Preset screen

Custom formula Metric names & syntax

Clear

ℹ A custom screen is a filter you defined. StockProof computes the metrics and reports which companies satisfy the condition you wrote — it does not assess, endorse or rank the strategy behind it, and a company appearing in these results is not a recommendation to buy or sell. Companies missing an input your formula needs are listed separately as “couldn't be judged”, never counted as non-matches.

Write a condition using the metric names below, the comparisons > < >= <= == !=, the words and / or / not, parentheses, and arithmetic + - * /. Names and keywords are case-insensitive. Up to 500 characters.

Examples: roe > 15 and debt_to_equity < 1 and pe < 20 · P/E < 20 or (dividend_yield > 3 and D/E < 0.5) · rsi < 30 and delivery_percent > 50 · not (market_cap < 5000)

Percentages are typed as percentages — roe > 15 means 15%, matching the “ROE >” filter above and the table's own “15.00%”. Market cap is in crore, so market_cap > 50000 means ₹50,000 Cr. Comparisons can't be chained: write pe > 1 and pe < 20, not 1 < pe < 20.

Valuation & fundamentals (latest filing + price snapshot)

Type this	Metric	Unit	What it is
pe · P/E · pe_ratio · price_to_earnings	P/E	ratio	Price / Diluted EPS from the latest filing.
roe · return_on_equity	ROE	percent	Net Income / Shareholder Equity, in percent.
debt_to_equity · D/E · de · debt_equity	Debt/Equity	ratio	Total debt / shareholder equity.
current_ratio	Current Ratio	ratio	Current assets / current liabilities.
roce · return_on_capital_employed	ROCE	percent	Return on capital employed, in percent.
dividend_yield · div_yield	Dividend Yield	percent	Dividend per share / price, in percent.
market_cap · mcap · marketcap	Market Cap	crore	Price x diluted shares outstanding, in CRORE (50000 means Rs 50,000 Cr).
pb · P/B · price_to_book	P/B	ratio	Price / book value per share.
ev_ebitda · EV/EBITDA	EV/EBITDA	ratio	Enterprise value / EBITDA.
earnings_yield	Earnings Yield	percent	EBIT / enterprise value, in percent.
price · close	Price	rupees	Latest stored price snapshot, in rupees.

Price & volume technicals (stored daily history)

Type this	Metric	Unit	What it is
rsi · rsi_14	RSI (14-day)	0-100	Wilder's 14-day Relative Strength Index.
week52_high · high_52w	52-Week High	rupees	Highest intraday high in the trailing 52 weeks.
week52_low · low_52w	52-Week Low	rupees	Lowest intraday low in the trailing 52 weeks.
pct_below_52w_high · off_52w_high	% Below 52W High	percent	How far the latest close sits BELOW the 52-week high, in percent (0 = at the high).
pct_above_52w_low · off_52w_low	% Above 52W Low	percent	How far the latest close sits ABOVE the 52-week low, in percent (0 = at the low).
delivery_percent · delivery_pct	Delivery %	percent	Trailing 20-day average NSE delivery percentage (already in percent points).
macd · macd_line	MACD Line	rupees	12/26-day EMA difference (Appel).
macd_signal	MACD Signal	rupees	9-day EMA of the MACD line.
macd_histogram · macd_hist	MACD Histogram	rupees	MACD line minus signal line.
bb_upper	Bollinger Upper	rupees	20-day SMA + 2 population std dev.
bb_middle	Bollinger Middle	rupees	20-day simple moving average.
bb_lower	Bollinger Lower	rupees	20-day SMA - 2 population std dev.
bb_percent_b · percent_b	Bollinger %B	ratio	Position of the close within the bands: 0 at the lower band, 1 at the upper.
bb_bandwidth	Bollinger Bandwidth	ratio	(upper - lower) / middle -- Bollinger's relative volatility measure.
stoch_k · stochastic_k	Stochastic %K	0-100	Lane's 14-day Fast Stochastic %K.
stoch_d · stochastic_d	Stochastic %D	0-100	3-day simple moving average of %K.
mfi · mfi_14	MFI (14-day)	0-100	14-day Money Flow Index (volume-weighted RSI).
atr	ATR (14-day)	rupees	Wilder's 14-day Average True Range, in rupees.
atr_percent · atr_pct	ATR % of Price	percent	ATR as a percentage of the latest close.
adx	ADX (14-day)	0-100	Wilder's Average Directional Index.
plus_di	+DI	0-100	Wilder's positive directional indicator.
minus_di	-DI	0-100	Wilder's negative directional indicator.
dma_50 · sma_50	50-DMA	rupees	50-day simple moving average of the close.
dma_200 · sma_200	200-DMA	rupees	200-day simple moving average of the close.
volume	Volume (latest day)	shares	Traded quantity on the latest stored trading day.

Growth (stored multi-year annual history)

Type this	Metric	Unit	What it is
revenue_cagr_3y	3y Revenue CAGR	percent	Compound annual revenue growth over ~3 stored years, in percent.
revenue_cagr_5y	5y Revenue CAGR	percent	Compound annual revenue growth over ~5 stored years, in percent.
profit_cagr_3y	3y Net Profit CAGR	percent	Compound annual net-profit growth over ~3 stored years, in percent.
profit_cagr_5y	5y Net Profit CAGR	percent	Compound annual net-profit growth over ~5 stored years, in percent.

Piotroski F-Score — 9-criteria profitability, leverage, and efficiency composite.

1 result Extract this table (respects filters): CSV · XLSX

Ticker

Company

Sector

Trend

F-Score

Piotroski F-Score

Criteria

Watchlist

MGL.NS

Mahanagar Gas Ltd.

Oil Gas & Consumable Fuels

5/9

5 of 9 criteria met

9 criteria

✓ Met Positive net income	Net Profit 2026-03-31: ₹8,411,440,000	ProfitOrLossAttributableToOwnersOfParent (2026-03-31)
✓ Met Positive operating cash flow	CFO 2026-03-31: ₹11,622,900,000	CashFlowsFromUsedInOperatingActivities (2026-03-31)
✗ Not met Return on assets improved YoY	ROA 2025-03-31 → 2026-03-31: 12.58% → 9.37%	Net Profit ÷ Total Assets, 2025-03-31 & 2026-03-31
✓ Met Operating cash flow exceeds net income	CFO ₹11,622,900,000 vs Net Profit ₹8,411,440,000 (2026-03-31)	CashFlowsFromUsedInOperatingActivities vs ProfitOrLossAttributableToOwnersOfParent (2026-03-31)
✗ Not met Leverage (Debt/Assets) decreased YoY	2025-03-31 → 2026-03-31: 0.00% → 0.00%	Total Debt ÷ Total Assets, 2025-03-31 & 2026-03-31
✗ Not met Current ratio improved YoY	2025-03-31 → 2026-03-31: 1.04 → 0.94	Total Current Assets ÷ Total Current Liabilities, 2025-03-31 & 2026-03-31
✓ Met No new shares issued	Equity Share Capital 2025-03-31 → 2026-03-31: ₹987,800,000 → ₹987,800,000	EquityShareCapital, 2025-03-31 & 2026-03-31
✗ Not met Operating margin (EBIT/Revenue) improved YoY	2025-03-31 → 2026-03-31: 17.35% → 12.80%	(ProfitBeforeExceptionalItemsAndTax + FinanceCosts) ÷ Revenue from Operations, 2025-03-31 & 2026-03-31
✓ Met Asset turnover improved YoY	2025-03-31 → 2026-03-31: 0.96 → 1.01	Revenue from Operations ÷ Total Assets, 2025-03-31 & 2026-03-31