Formula screener
Write the conditions a company must meet, with the names of figures from its filings. The address keeps your formula, columns and sort: bookmark it or send it.
The figures you can use
Names are not case-sensitive; each also answers to the other names shown. Click a name for its definition.
Size
- Market capUS$ millions
- Market value of all the company's shares, on the date shown with it. Also: market capitalisation, market capitalization, mcap, market value.
- Market cap agedays
- Days since the date of the market cap: outside the US, India, Taiwan and Russia many are months old. Also: market cap days old, days since market cap.
- RevenueUS$ millions
- Revenue of the latest fiscal year. Also: sales, turnover.
- Revenue TTMUS$ millions
- Revenue over the last twelve months (four quarters), where quarters are on file. Also: revenue last 12 months, sales ttm, trailing revenue.
- Net incomeUS$ millions
- Net income of the latest fiscal year. Also: profit, net profit, earnings.
- Net income TTMUS$ millions
- Net income over the last twelve months, where quarters are on file. Also: profit ttm, earnings ttm, trailing net income.
- Operating incomeUS$ millions
- Operating income of the latest fiscal year. Also: operating profit, ebit.
- Total assetsUS$ millions
- Total assets at the latest balance-sheet date. Also: assets.
- Total liabilitiesUS$ millions
- Total liabilities at the latest balance-sheet date. Also: liabilities.
- EquityUS$ millions
- Shareholders' equity (book value) at the latest balance-sheet date. Also: shareholders equity, shareholders' equity, book value, total equity.
- Employeescount
- People employed, as last reported. Also: staff, headcount, workforce.
- Revenue per employeeUS$
- Revenue divided by employees, in US dollars. Also: sales per employee.
- Profit per employeeUS$
- Net income divided by employees, in US dollars. Also: net income per employee.
- World rankcount
- Place among all companies by market cap (1 is the largest). Also: rank.
Valuation
- P/Emultiple · has medians
- Market value divided by net income over the last twelve months; profitable companies only. Also: pe, p/e ratio, pe ratio, price to earnings.
- Price to salesmultiple · has medians
- Market value divided by revenue over the last twelve months. Also: p/s, ps, price/sales, ps ratio.
- Price to bookmultiple · has medians
- Market value divided by shareholders' equity. Also: p/b, pb, price/book, pb ratio.
- Free cash flow yield% · has medians
- Free cash flow as a share of the market value. Also: fcf yield.
Profitability
- Gross margin% · has medians
- Gross profit as a share of revenue. Also: gpm.
- Operating margin% · has medians
- Operating income as a share of revenue. Also: opm, ebit margin, operating profit margin.
- Net margin% · has medians
- Net income as a share of revenue. Also: npm, net profit margin, profit margin.
- Return on equity% · has medians
- Net income as a share of shareholders' equity (the average of the start and the end of the year). Not given when equity is negative. Also: roe.
- Return on assets% · has medians
- Net income as a share of total assets (average of the year). Also: roa.
- Return on invested capital% · has medians
- Operating income after tax, as a share of debt plus equity less cash (average of the year). The tax rate is the year's own: income tax over pre-tax income. Also: roic, return on capital.
- Asset turnovermultiple · has medians
- Revenue divided by total assets (average of the year).
Growth
- Revenue growth% · has medians
- Revenue against the year before. Also: sales growth, revenue growth 1 year, sales growth 1 year.
- Revenue growth 3 years% · has medians
- The yearly rate that takes revenue of three years earlier to this year's. Also: revenue growth 3 years, sales growth 3 years, revenue cagr 3 years, revenue growth 3y.
- Revenue growth 5 years% · has medians
- The yearly rate that takes revenue of five years earlier to this year's. Also: revenue growth 5 years, sales growth 5 years, revenue cagr 5 years, revenue growth 5y.
- Net income growth% · has medians
- Net income against the year before. Only when both years were profitable. Also: profit growth, net profit growth, earnings growth.
- EPS growth% · has medians
- Diluted earnings per share against the year before. Only when both were positive. Also: eps growth.
Financial health
- Debt to equitymultiple · has medians
- Total debt divided by shareholders' equity. Not given when equity is negative. Also: d/e, debt/equity, de ratio, debt equity.
- Net debtUS$ millions · has medians
- Total debt less cash. Negative means more cash than debt.
- Net debt to EBITDAmultiple · has medians
- Debt less cash, divided by operating income plus depreciation and amortization: roughly the years of operating earnings needed to repay it. Also: net debt/ebitda, leverage.
- Interest covermultiple · has medians
- Operating income divided by the interest paid on debt. Also: interest coverage, times interest earned.
- Current ratiomultiple · has medians
- Assets due within a year divided by liabilities due within a year.
- Equity ratio% · has medians
- Shareholders' equity as a share of total assets. Also: equity share of assets.
Cash flow
- Free cash flowUS$ millions · has medians
- Cash from operations less capital spending. Also: fcf, free cashflow.
- Free cash flow margin% · has medians
- Free cash flow as a share of revenue. Also: fcf margin.
- Cash conversion% · has medians
- Cash from operations as a share of net income. Only when the year was profitable.
- Capital spending to revenue% · has medians
- Capital spending as a share of revenue. Also: capex to revenue, capex/revenue.
Shareholder returns
- Dividend yield% · has medians
- Dividends paid in the fiscal year as a share of today's market value. Also: yield, div yield.
- Buyback yield% · has medians
- Shares bought back in the fiscal year as a share of today's market value.
- Shareholder yield% · has medians
- Dividends plus buybacks as a share of today's market value.
- Dividend payout% · has medians
- Dividends paid as a share of net income. Only when the year was profitable. Also: payout ratio, dividend payout ratio.
- Share count change% · has medians
- Diluted shares against the year before. Negative: fewer shares. Also: change in share count, dilution, share count change.
Scores
- Fiscal yearyear
- The fiscal year the ratios and scores describe. Also: ratios year, year of figures.
- Piotroski F-scorepoints
- Nine pass-or-fail tests of profitability, cash, debt, liquidity and efficiency (0 to 9); blank unless all nine could be worked out. Also: f-score, f score, piotroski, piotroski score.
- Altman Z-scoremultiple
- Bankruptcy-risk score of working capital, retained earnings, operating income, market value and sales against assets; below 1.81 is the distress zone. Also: z-score, z score, altman, altman z.
- Scorecardpoints
- Checks passed of the company scorecard's thirty (valuation, growth, profitability, financial health, shareholder returns), of those that could be worked out. Also: scorecard passes, checks passed.
- Scorecard checks knowncount
- How many of the thirty scorecard checks could be worked out. Also: checks known.
- Valuation scorepoints
- Scorecard valuation checks passed (of six). Also: valuation checks.
- Growth scorepoints
- Scorecard growth checks passed (of six). Also: growth checks.
- Profitability scorepoints
- Scorecard profitability checks passed (of six). Also: profitability checks.
- Financial health scorepoints
- Scorecard financial-health checks passed (of six). Also: health score, financial health checks.
- Shareholder returns scorepoints
- Scorecard shareholder-return checks passed (of six). Also: returns score, shareholder returns checks.
Ownership and trading
- Short interest%
- Shares sold short as a share of shares outstanding, on FINRA's latest settlement date. Also: short interest %, shares short, short percent.
- Institutional ownership%
- Shares held by the institutions that report to the SEC on Form 13F, as a share of shares outstanding, at the latest quarter end. Also: institutional holding, held by institutions, institutions %.
- Institutional holderscount
- Institutions reporting a position on Form 13F at the latest quarter end. Also: number of institutions.
- Dividend growth yearscount
- Calendar years in a row the dividend per share rose (SEC filers). Also: dividend streak, years of dividend growth, dividend raises in a row.
- Insider buyingyes or no
- Three or more insiders bought within 30 days, 100,000 dollars or more together, in the last 90 days (SEC Form 4). Also: insider cluster buying, cluster buying, insiders buying.
Company
- Countryname
- Headquarters country. Also: headquarters country, hq country.
- Sectorname
- The company's sector.
- Industryname
- The company's industry.
- Regionname
- UN world region of the headquarters (Africa, Americas, Asia, Europe, Oceania). Also: world region.
- Sub-regionname
- UN world sub-region of the headquarters, e.g. Western Europe. Also: subregion, world subregion.
- Continentname
- Continent of the headquarters.
- Indexname
- Member of an index list: S&P 500, Nasdaq-100, Dow Jones, Nifty 50 and the others. Also: index member, member of.
- Foundedyear
- Year the company was founded. Also: founded year, year founded.
- IPO yearyear
- Year of the first listing. Also: listed since, year listed.
How formulas are read
Compare a figure with a number or with another figure: P/E < 15, Free cash flow / Market cap > 0.05.
Join conditions with AND and OR; AND binds first, and brackets group: ROE > 20 OR (ROIC > 15 AND Net margin > 10).
Compare with the company's peers: P/E < Industry median P/E. Sector and Country medians work the same way.
Names: Country = India, Sector IN (Technology, Healthcare), Index = "S&P 500". Yes-or-no figures stand alone: Insider buying.
Amounts are US dollars: write 2B, 500M or 1.5T. Percentages are plain numbers: 15 is 15%.
A company that lacks a figure your formula needs is left out rather than counted as zero. Ratios come from the newest fiscal year on file; most are worked out for companies whose statements the SEC or the EU's ESEF reports hold.