✨ Your Portfolio is fetched and updated from zerodha.
Stock Screener
FINANCIAL QUERY
List of Available Fields
Clear Query
And
ALTERNATE DATA QUERY
✨ Syntax has Changed!
Clear Query
Usage Guide
Step 1:
Step 1: Enter a Financial Query
Build an arithmetic equation using financial fields like Balance Sheet Items, P&L Items, Shareholding Items and Derived ratios. All the fields that can be queried are present in the dropdown.
Types of Financial data we recognise
Financials

Market Capitalization < 5000

Down from 52w high > 5%

10yr growth net sales > 30%

Ratios

5yr Avg ROCE > 30

Debt to equity ratio < 0.2

(free cash flow / net sales) >0.2

Shareholding

Latest quarter pledged holding > 85%

1yr Avg mutual fund holding > 15

Latest quarter fii holding > 25%

* For higher accuracy, please use values from the dropdown that appears while typing!
Step 2:
Step 2: Enter an Alternate Data Query
Filter companies based on the following five alternate data criteria:
Product

makes Chemicals

makes APIs

makes Tyres > 25

Location

revenue from China

revenue from USA

revenue from India > 5

Market Share

market share in Pharma

market share in India

market share in Auto Ancillary > 10

Raw Materials

uses Sulphur

uses Ethylyne

uses Steel

* For higher accuracy, please use values from the dropdown that appears while typing!
Sample Queries
Financial Query
Alternate Data Query
query 1

5yr avg roe > 15% and

Operating Profit Margin > 11% and

1yr Growth Net Profit > 19% and

3yr Growth Net Profit > 19%

market share > 20 and

revenue from India > 10

query 2

latest quarter mutual fund holding > last quarter mutual fund holding and

pe < 10 and

pe > 1

not revenue from financial services and

market share > 25

query 3

5yr avg roce > 15 and

Market Capitalization < 10000

makes chemicals and

market share > 20

Ideas Dashboard
Results
Timeline
Watchlist
Portfolio
Alerts
Stock Screener
Market
Raw Material