Learn / Features

Free fundamental stock screener for NSE stocks with company pages

A free fundamental stock screener for NSE stocks: type queries like ROE > 20 AND P/E < 15, open a company page with peers, and export the results to Excel.

SuperCharting has a free fundamental stock screener for NSE stocks in its own side panel, called Fundamentals. You filter Indian companies by ratios such as P/E, ROE, ROCE, debt to equity and sales growth, search a company by name, and open a company page with key ratios, results, pros and cons and a peer comparison, right next to the chart. It is included on Essential, the free plan, with the same features as on the paid plans; you only need an account.

What the Fundamentals panel is

The panel sits on the widget bar on the right of the chart, as the Fundamentals button directly above Order Block. It is also in the Products menu at the bottom of the widget bar. It opens on the India market and keeps its own market setting, so changing it never changes the market of the Stock Screener in the Screeners panel.

At the top of the panel are three controls:

• Search a company by name or ticker: as you type, the table narrows to matching companies. Press Enter and the first match opens on its company page.
• New query: opens the query box described below.
• Export to Excel: downloads the rows on screen as a real .xlsx workbook, with every column of the table and the ratios your query used, plus an "About" sheet that records the screen name, the query, the market and the time of the export.

Clicking any row loads that stock on the active chart and opens its company page, so you read the numbers next to the price action.

Query screens: filter stocks by ratios

A query is a list of conditions joined with AND, typed in plain words: a ratio, a comparison and a number. Amounts such as market cap, sales, net profit and debt are in rupees crores on the India market.

The ratios you can use include Market cap, P/E, P/B, PEG, EV/EBITDA, ROE, ROCE, ROA, Dividend yield, Debt to equity, Current ratio, Interest coverage, OPM, NPM, Sales growth, Profit growth, Sales growth 5years, Profit growth 5years, YOY quarterly sales growth, Piotroski score, Graham number, Free float, RSI and returns over 1 month to 5 years. The full list is printed under the query box.

The panel checks a query before it closes the box, so a misspelt ratio shows an error instead of an empty table. Each ratio in your query is added to the table as a column, so you can sort by it.

Ready-made screens are one click away under the screen title (All stocks): Low P/E, high ROE; Growth stocks; High dividend yield; Debt free, high ROCE; Quarterly growers; Piotroski 8 and 9; and 5-year compounders. Screens you save appear in the same menu, up to 30 of them, saved to your account. For a deeper guide to the query language and column sets, see the stock screener page.

How to screen NSE stocks by fundamentals in SuperCharting

1. Sign in and open any chart, for example NSE:NIFTY on the daily timeframe.
2. Click Fundamentals on the widget bar on the right (above Order Block), or choose it from the Products menu.
3. Click New query. The Query screen box opens.
4. Type one condition per line, for example Debt to equity < 0.1, ROCE > 25 and Market cap > 500.
5. Click Run this query (or press Ctrl+Enter). To keep it, type a name and click Save and run instead.
6. Sort the table by a column, then click a company to open its page and its chart.
7. Click Export to Excel to take the list into a spreadsheet.

On a phone, open the More menu and pick Screener under Markets, set the market to India and tap the screen title (All stocks): the ready-made screens and Custom query… are there, and a tap on a row opens the same company page.

The company page

The company page opens over the table, with a row of section tabs that stays at the top while you scroll, ← Back to results to return, + Add to watchlist and its own Export to Excel. It shows:

• Key ratios: market cap, current price, 52-week high and low, stock P/E, book value, dividend yield, ROCE, ROE, debt to equity, PEG, margins, Piotroski score, Graham number, free float and more.
• Pros and cons: up to five strengths and five weaknesses written from the ratios by fixed rules, for example a high return on equity, almost no debt, or interest covered less than twice. The heading says it plainly: generated from the ratios, not advice.
• Earnings and growth: the latest and next result dates with estimates, sales and profit growth for the quarter, the year and five years, and the stock's own returns.
• Quarterly results and Profit & loss: up to 12 quarters and 12 years of sales, EBITDA, net profit, margins and EPS. Our guide to quarterly results explains how to read them.
• Balance sheet and Cash flow for the latest year, with the history of total assets, debt, free cash flow and capital spending.
• For NSE-listed stocks, the company's exchange filings: Shareholding pattern (promoters and public by quarter), Corporate actions, Board meetings, Announcements from the last four months, Concalls and investor presentations picked out of those announcements, and Annual reports, with links to the documents.
• Peer comparison: companies in the same industry with price, P/E, market cap, profit, sales, growth and ROCE, and a Median of N row under them when there are more than two peers. Click a peer and its page and chart open.

The company page's Export to Excel builds a workbook with sheets for key ratios, annual and quarterly lines, peers and, for NSE stocks, shareholding. For more on each section, see Indian stocks fundamentals.

Example: debt-free compounders in IT

Run the ready-made Debt free, high ROCE screen, then sort by Market cap. Open NSE:TCS: read its ROCE and debt to equity in Key ratios, check whether sales grew in each of the last 12 quarters, then scroll to Peer comparison to see NSE:INFY, NSE:HCLTECH and NSE:WIPRO next to it, with the Median row showing where the industry sits. Click + Add to watchlist for the ones you want to follow, and use watchlist alerts to hear when they move. The screen finds companies to study; it does not say what to buy.

What to know about the data

Ratios and statements are company data that arrive with a delay after each result, and they may be incomplete: a field shows a dash when the data has no value for it, and some smaller companies have few periods. The figures can differ slightly from the company's own filings. Line-by-line statements and the FII and DII split of public shareholding are not available. Always check an important number in the company's annual report or exchange filing before you rely on it.

Frequently asked questions

Is the fundamental screener free?

Yes. Fundamentals has no plan check: Essential, the free plan, gets the same panel, queries, company pages and Excel export as Plus, Premium or Ultimate. You need a signed-in account.

Does it cover BSE stocks and other countries?

The India market lists companies listed on NSE and BSE, each under its main listing, and the market menu also offers the US, UK, Germany, Japan, Canada and Australia, where amounts are in millions of the company's currency. The exchange filings section (shareholding, announcements, annual reports) is shown for NSE-listed stocks only.

Are the pros and cons a recommendation?

No. They are fixed rules over the ratios on the page, such as ROE above 18% or debt more than equity. They point you to things to check, not to a decision.

What does Export to Excel save?

An .xlsx file made in your browser. The panel's export holds the rows on screen with the screen's name and query; the company page's export holds that company's figures. Amounts in the panel's export are as the company data gives them, in rupees rather than crores, as its About sheet notes.