Market and ETFs

Fundamentals screener

Companies of the S&P 500 or the Nasdaq-100 with figures from their SEC filings, filterable by cash flow, earnings and share buybacks. Plus the outlook from the two most recent earnings releases, when they contain one.

New in version 0.3.25

At a glance

  • Market > Stock Fundamentals > Screener shows the companies of the S&P 500 or the Nasdaq-100 with figures from their quarterly and annual reports filed with the SEC, the US securities regulator. When a value is missing, the cell stays empty.
  • You filter in the header row of the table, for example by positive free cash flow, by profit or by whether a company bought back own shares in the last quarter.
  • The Outlook button shows the forecasts from the two most recent earnings press releases, when they contain an outlook. The AI menu lets you have them summarized and compared.
  • The figures are based on the published reports, valuation ratios such as P/E add the market price. Foliograph does not estimate missing values. The page gives no instruction to act and is not investment advice.

Quick start

You do not need to know every figure to use the screener. Every column has a filter in its header and every cell explains itself in the tooltip. The three examples show the way. Filters combine, Clear filters removes them all.

Which companies have positive free cash flow and a lower diluted share count than a year ago?

  1. In the header of the FCF yield column choose positive. The companies with cash left over after their investments remain.
  2. In the Shares 1Y column choose fewer shares. This keeps companies with a lower diluted share count than in the same quarter last year.
  3. A click on the FCF yield title sorts the list by that column.

The share count is an average over the quarter and also changes with the dilution from options and convertible bonds. Whether a company actually bought back shares is shown by the Buyback Q column with the filter Shares repurchased. Show it via Columns.

Where did insiders buy shares?

  1. In the Insiders 90D column choose purchases or 2 or more buyers in 30 days. Only someone with at least one reported purchase of USD 10,000 or more counts as a buyer.
  2. The cell tooltip names person, role, date and amount.

Insiders sell for many reasons, for example for taxes or under a plan set up in advance. Purchases with their own money are rarer. The purchase and sale codes in Form 4 do not tell whether a trade took place on or off the exchange.

Where is revenue growth against the year-ago quarter higher than one quarter before?

  1. In the Revenue YoY column choose accelerating. This also includes revenue that shrinks more slowly than before, for example -3% after -8%.
  2. Whether revenue grows is shown by the number in the column. The bars in Revenue 8Q show the last eight quarters, the tooltip lists the values.
  3. The column Accelerating in a row shows for how many quarters this has held. Show it via Columns.

A single company: type its symbol or name into the search field. The Outlook button at the end of the row shows what the company writes about the coming quarters in its latest press releases.

Reading the figures: ratios such as P/E differ widely between industries, a software maker and a power utility are hardly comparable. The Sector and Industry filters let you compare companies of the same industry. An empty cell means the value is missing or not meaningful for this company. The tooltip names the reason.

Figures in one sentence

Unless noted otherwise, the values are based on the last four reported quarters (TTM). Market cap is the newest price of the RSL ranking times the number of shares. After the end of the week that is the weekly close, during the week the price of the last RSL run. The companies report in dollars. Detailed explanations of the figures follow further down.

Valuation

Column What it shows Good to know
P/E Price/earnings: market cap divided by net income, that is how many dollars the market pays for one dollar of annual profit Empty with a loss. Depends strongly on industry and growth
P/S Price/sales: market cap divided by revenue Also for companies without a profit. Industries with high margins mostly have a higher P/S
P/B Price/book: market cap divided by the equity in the balance sheet Common above all for banks and insurers. Buybacks lower equity and so raise P/B
P/FCF Market cap divided by free cash flow Like P/E, but with the cash flow instead of the accounting profit
FCF yield Free cash flow in percent of market cap The inverse of P/FCF: 5% equals P/FCF 20
EV/EBIT Enterprise value divided by operating income Includes the debt and so makes companies with much and little debt comparable
P/FFO Market cap divided by simplified funds from operations Only for real estate companies (REITs), because depreciation on their properties lowers reported profit

Cash flow and profit

Column What it shows Good to know
Operating CF Cash coming in from the ongoing business Depends less on accounting choices than profit
Free CF Operating cash flow minus capital expenditure The cash left for dividends, buybacks, paying down debt or acquisitions
Net margin Net income in percent of revenue Gross margin and operating margin show the same at earlier stages of the income statement
EPS Earnings per share over the last four quarters, preferably the reported diluted figures With the same positive profit it also rises when only the share count falls
Revenue YoY Revenue of the last quarter against the same quarter one year earlier Comparing with the year-ago quarter reduces seasonal effects
SBC Share-based compensation for employees The part of pay the company gives in shares or options instead of cash. That spares cash flow but spreads profit over more shares. The FCF after SBC column subtracts reported share-based compensation from free cash flow
OCF / net income, accruals How far profit and cash flow lie apart When profit stays above cash flow for long, it rests on bookings rather than on cash received

Profitability and balance sheet

Column What it shows Good to know
ROE Return on equity: net income in percent of equity With little equity, for example after large buybacks, ROE is high even with a moderate profit
ROIC Return on invested capital: operating income after taxes relative to invested capital Relates operating results to the capital of both shareholders and lenders
Piotroski Foliograph variant after Piotroski: how many of nine conditions on profit, debt and efficiency are met Works with four quarters instead of fiscal years. The tooltip shows each condition
Net debt Financial debt minus cash and current investments at the end of the last quarter Negative means more cash than debt
Net debt / EBITDA Net debt against operating income before depreciation A common measure of debt: how many years of earnings the debt amounts to
Interest coverage Operating income divided by interest expense How many times operating income covers the interest

Payouts to shareholders

Column What it shows Good to know
Shareholder yield Dividends plus net buybacks in percent of market cap Counts both ways cash goes to the shareholders
Payout ratio Dividends in percent of net income Above 100% means the company pays out more than it earns
Buyback Q, Buybacks 12M Cash paid for repurchased own shares in the last quarter respectively in four quarters Buybacks / cap relates the sum to market cap
Shares 1Y Change of the diluted share count against one year earlier An average over the quarter that also moves with the dilution from options. Actual buybacks are in Buyback Q

Filings at the SEC

Term What it is Good to know
10-Q, 10-K Quarterly respectively annual report The main source of the financial figures in the screener
8-K Report of a material event, generally within four business days The Events column shows selected items, Outlook reads the earnings press releases
Form 4 An insider's report of purchases and sales of own shares Generally within two business days after the trade
TTM Trailing twelve months, the last four reported quarters Independent of the company's fiscal year

Data and updates

  • Companies: the same member lists as the RSL ranking, read from the latest NPORT-P filing of SPY respectively QQQ. The status line above the table shows the date of that filing.
  • Figures: from the XBRL data of the SEC (companyfacts), that is from the companies' 10-Q and 10-K reports. TWS is not needed.
  • First run: Load data fetches the figures of about 600 companies. It takes a few minutes and switches the automatic update on.
  • Afterwards: every six hours Foliograph reads the daily index of the SEC and only fetches the companies that filed a quarterly or annual report since. In addition every company is read again after 30 to 40 days. Update from EDGAR starts a run right away. The switch Update automatically turns the background runs off and on again.
  • Sector and industry: from IBKR once the RSL ranking has loaded the contract details. Without them the industry column shows the SIC industry of the SEC and the sector stays empty.

The columns

  • Quarter: end of the last reported quarter. The tooltip names the filing date and the form. New figures appear once the company has filed the report and Foliograph has read it. Depending on the company's filer category, the SEC requires the quarterly report within 40 to 45 days after the quarter end and the annual report within 60 to 90 days after the fiscal year end.
  • TTM: the last four reported quarters of the company, whatever its fiscal year. If one of the four consecutive quarters is missing, the value stays empty.
  • Operating CF, Free CF: from the cash-flow statement, free cash flow = operating cash flow minus capital expenditure.
  • Revenue YoY: revenue of the last quarter against the same quarter one year earlier. The filter accelerating shows companies whose growth rate is higher than in the quarter before. This also holds when revenue shrinks more slowly.
  • Backlog YoY: the reported remaining performance obligations against one year earlier, that is contracted performance for which revenue is still to be recognized. A backlog the company states itself may be defined differently. Mostly software, industrial and defense companies report it, for many others the cell stays empty.
  • Prepayments YoY: contract liabilities, that is customer prepayments and deferred revenue, against one year earlier.

Runs over several quarters

Most screeners compare a single point in time. Foliograph keeps up to twelve quarters per company and therefore also counts how many reported quarters in a row meet a condition. The count runs back from the newest quarter, the first quarter without the condition or without a reported value ends it. Fewer shares in a row is the exception.

  • Buybacks in a row: the company bought back own shares in the quarter.
  • FCF > 0 in a row: the free cash flow of the quarter is positive.
  • Margin higher in a row: the net margin is higher than in the same quarter one year earlier. Comparing with the year-ago quarter reduces seasonal effects.
  • Accelerating in a row: the revenue growth rate against the year-ago quarter is higher than in the quarter before.
  • Gross margin higher in a row: the gross margin is higher than in the same quarter one year earlier.
  • Fewer shares in a row: the company has fewer diluted shares than one year earlier. Foliograph skips a quarter without a reported diluted share count instead of ending the streak. This is usually the fourth fiscal quarter, because the annual report only contains the average over the whole year.

The filter in the header row shows companies with at least 2, 4 or 8 quarters. The columns Revenue 8Q, Free CF 8Q and Buybacks 8Q draw the last eight quarters as small bars, the oldest left. The tooltip lists the values. For series that are positive throughout, the bars start just below the lowest value so changes stay visible.

RSL rank

The column RSL rank takes the rank from the RSL ranking with your settings from there, plus the change against the week before. The filter shows the top 50, 100 or 250. Without loaded RSL data the column stays empty.

Quality, balance sheet and valuation

Most of these columns are hidden. Show them via Columns.

  • Piotroski: a Foliograph variant of the nine criteria from the study by Joseph Piotroski (Journal of Accounting Research, 2000). The cell shows how many of them the reported figures meet. The last four quarters are compared with the four quarters before: net income positive, operating cash flow positive, return on assets higher, operating cash flow above net income, debt in percent of assets lower, current ratio higher, no more shares, gross margin higher and revenue in percent of assets higher. Return on assets and asset turnover refer to total assets at the start of the period, as in the study, here the start of the four quarters. When the reported quarters do not reach back that far, the screener takes total assets at the end. Four points differ from the study: the study compares fiscal years instead of rolling quarters, long-term debt instead of all financial debt, checks new share issues instead of the share count and has no partial scores. The cell tooltip lists each criterion. When a figure is missing, the criterion counts as neither met nor unmet and the cell shows for example 6/7. Sorting puts 7/7 before 7/9. The number describes the filings and is not a rating of the stock.
  • ROE, ROIC: net income TTM in percent of average equity (last report and one year before, without a prior-year value the last report alone) respectively operating income after taxes in percent of invested capital (equity, minority interests and net debt at the end of the last quarter). Foliograph computes the taxes with the company's effective tax rate.
  • Interest coverage, net debt / EBITDA: operating income divided by interest expense, both TTM, and net debt against operating income plus depreciation and amortization. When a company reports no interest expense but only net interest (interest income minus interest expense), Foliograph uses a negative net interest as an approximation of interest expense.
  • Gross margin, operating margin: gross profit and operating income in percent of revenue, both TTM. When a company reports no gross profit, Foliograph uses revenue minus cost of revenue. Banks and insurers have no gross margin.
  • SBC / revenue, FCF after SBC, buybacks minus SBC: share-based compensation is the part of pay the company gives in shares or options instead of cash. That lowers profit, but no cash leaves the company. The cash-flow statement therefore adds the amount back to operating cash flow. In return new shares arise, over which profit is spread. FCF after SBC subtracts reported share-based compensation from free cash flow, as if it had been paid in cash. Buybacks minus SBC compares two dollar amounts: the buybacks at their purchase price and the compensation at its value when granted. How the share count changed overall is shown by the Shares 1Y column.
  • OCF / net income, accruals: how much operating cash flow comes with one dollar of net income, and the difference of net income and operating cash flow in percent of total assets at the end of the last quarter.
  • Net debt: financial debt minus cash and current investments at the end of the last quarter. Negative means more cash than debt. Leases count only when the company reports them together with its loans and bonds in one figure. This is mostly the case for finance leases, for example for machines. Rented stores, offices and warehouses (operating leases) never count. Companies with many rented branches therefore look less indebted than their fixed rent payments would suggest.
  • P/E, P/S, P/FCF, P/B, FCF yield, EV/EBIT, shareholder yield: the market capitalization (newest price of the RSL ranking times the shares outstanding) against net income, revenue and free cash flow TTM respectively against equity. EV/EBIT sets the enterprise value (market capitalization plus net debt, minority interests and preferred stock) against operating income. When a company reports no operating income, Foliograph uses pretax income plus interest expense. Shareholder yield adds dividends paid and net buybacks (buybacks minus proceeds from new shares). Without RSL prices these columns stay empty. A ratio such as P/E, P/FCF or EV/EBIT also stays empty when the figure it divides by is zero or negative. FCF yield and shareholder yield can be negative. The tooltip names the price and its date. The detail page uses the newest daily close and may therefore differ slightly.
  • Payout ratio: dividends paid in percent of net income, both TTM.
  • P/FFO (REITs only): market capitalization divided by simplified funds from operations: net income plus depreciation and impairments on real estate, minus gains from property sales. The FFO a REIT publishes itself may differ.
  • Banks and insurers: for companies with SIC code 6000 to 6499, operating cash flow and debt reflect deposits, loans and insurance reserves. Free cash flow, net debt, EV/EBIT, ROIC, interest coverage, accruals and the Piotroski score stay empty for them. P/E, P/B, ROE and payout ratio stay visible.

Insiders and events

Besides the figures of the reports, Foliograph reads the other SEC filings of the companies.

  • Insiders 90D: how many insiders bought and sold shares in the last 90 days, as "buyers / sellers". Insiders are board members and executives plus persons who beneficially own more than 10% of a registered class of shares. At foreign companies (foreign private issuers) only board members and executives report since March 2026, not the large shareholders. Whoever reports under equivalent rules of their home market, for example in Switzerland, files no Form 4 and is missing from the column. Trades subject to reporting are generally filed within two business days on Form 4. Only purchases (code P) and sales (code S) count. These include trades on the exchange but also off it, for example when an insider sells a block of shares directly to an investor or buys new shares directly from the company in a capital increase. The codes P and S do not tell the two cases apart. Awards, option exercises and shares withheld for taxes do not count. Only the table of shares is read, not the one for options and other derivatives. People are counted, not trades. Only someone with at least one reported purchase of USD 10,000 or more counts as a buyer. The threshold leaves out small purchases of a few shares. Purchases below it or without a price appear in the tooltip but do not count. If the same trade appears in several filings, for example from an insider and their holding company, it counts once. An amendment (4/A) replaces the trades of the same insider on the same day with the same code. If it only adds a missed row, the other rows of that day drop out. That is the smaller error than a trade counted twice. The tooltip lists each trade with date, person, role and amount. The note "10b5-1 plan" shows that the insider ticked the box for a trading plan set up in advance in the filing. The box applies to the whole filing, so all trades in it carry the note, even when only some followed the plan. The filter shows for example companies with two or more buyers in 30 days.
  • Events 90D: short words for filings of the last 90 days, each linking to the document. Amendments (8-K/A) do not appear.
    • Restatement (8-K item 4.02): the company states that earlier financial statements can no longer be relied upon and will be restated.
    • Auditor (4.01): change of the auditor.
    • Management (5.02): departure, election or appointment in the board or management. Companies also report changes to compensation plans under this item.
    • Cyber (1.05): material cybersecurity incident.
    • Impairment (2.06): material impairment of assets.
    • Bankruptcy (1.03): bankruptcy or receivership.
    • Listing (3.01): notice of an unmet listing rule, a delisting or a transfer to another exchange.
    • Late report (NT): the company announces that its quarterly or annual report will be filed late.

Foliograph reads the filings of a company again as soon as the SEC daily index lists a matching filing, otherwise once a week. Form 4 filings are read step by step, newest first. Right after the first load older filings are therefore still missing. Three dots (…) in the cell show that filings of the company are still pending, they follow with the next refreshes.

Share buybacks

Foliograph reads the amount the company paid for repurchased own shares per quarter from the cash-flow statement, when the company records it there. For the fourth quarter Foliograph subtracts the first nine months from the annual figure, because the annual report covers the whole year only. Shares withheld for the taxes of employee awards do not count as buybacks.

The column Buyback Q distinguishes five cases:

  • Amount: the company bought back shares in the last reported quarter.
  • 0: the company reported the item as 0.
  • n/r (not reported): the company reported the item before, the last report lacks it. Usually there was no buyback then, but that is not documented.
  • - (never reported): the item appears in no report. The company bought back no shares in the period covered or books them under a name of its own.
  • No data: the SEC data of the company contain no quarterly figures under US GAAP. This mainly affects foreign companies that report under IFRS or file only an annual report (Form 20-F or 40-F).

Buybacks 12M sums the reported amounts of the last four quarters. An asterisk shows that one of them was not reported. That quarter is then missing from the sum, so it counts as 0, also when sorting. Buybacks / cap relates the sum to the market capitalization. It needs the price of the RSL ranking, without RSL data the column stays empty.

Shares 1Y shows the change in the diluted share count against the same quarter one year earlier. Unlike the buyback amount it includes newly issued shares, for example from employee plans. When the share count stays flat despite high buybacks, newly issued shares or higher dilution can offset the buybacks. As the count is an average over the quarter and includes the dilution from options, this is no exact match.

Announced buyback programs and their remaining volume exist only as text in the reports and are therefore missing in the table.

Outlook from the press releases

Companies publish their outlook as text in the press release on the quarterly results (8-K with item 2.02, mostly exhibit 99.1). The SEC has no structured figures for it. The Outlook button reads the two most recent of these releases and shows the outlook paragraphs as quotes, each with a link to the document.

  • Some companies give their outlook only on the conference call with analysts. Then the window says that the release contains no outlook.
  • The AI menu hands the quotes to the AI, via your API access or as a prompt for ChatGPT, Claude, Perplexity or Grok. The default prompt summarizes the outlook and compares it with the outlook of the release before. You can change it under Settings > AI (AI analysis).
  • Web chats receive the prompt through the address. Foliograph shortens very long excerpts to 6000 characters for that, Copy Prompt always holds the whole text.

Data quality

A missing figure stays empty rather than being estimated. Hovering over an empty cell shows the reason in the tooltip, for example "Fewer than four reported quarters" after a spin-off or "Missing in the newest report" for debt. Foliograph checks two more cases:

  • Restated: when the newest report restates earlier quarters (for example after a spin-off), the older quarters exist only on the old basis. The 12-month sum stays empty until four quarters on the new basis are available. The bars show the values as reported.
  • Implausible quarter: a quarter that is obviously mislabeled in the SEC data (such as the whole year as one quarter) is left out.

The Data column shows the number of gaps per company (+ = completed values, a dot = only items not reported). A missing price and the figures left empty for banks do not count as a gap. The tooltip names the gaps and their cause, a click opens the overview for that company. The filter in the column header shows companies with or without gaps, with completed values or with items not reported.

The Data quality button above the table counts the companies with gaps and the companies with completed values. It opens an overview of every gap with company, figure and reason, filterable by reason. The gaps come first, items not reported last. Items a company does not report at all (such as gross profit at banks) are listed but do not count as a gap.

Completed values: when the processed SEC data (companyfacts) lacks a report, Foliograph reads it from the original filing. After a reorganization with a new CIK it takes over the history of the previous registrant. Such companies carry a + in the Data column (or, when it is hidden, next to the quarter), the tooltip and the overview name the filing with a link to the SEC.

Limits

  • The screener needs quarterly figures under US GAAP. Foreign issuers in the Nasdaq-100 that report under IFRS or file only an annual report (Form 20-F or 40-F) therefore show "No data".
  • Companies do not always name the same item the same way. Foliograph checks several common names per figure but does not recognize a company's own names.
  • Companies with several share classes (for example Meta or Fox) report the shares outstanding per class only. For the market capitalization Foliograph then reads the share counts per class from the cover page of the newest report and adds them up. A class that converts into several shares of the listed class counts accordingly (one Berkshire class A share as 1500 class B shares). When these counts are missing too, Foliograph uses the diluted share count of the last quarter. Both are approximations when the classes trade at different prices. The tooltip of the valuation figures points this out for these companies.
  • When a report is missing from the processed SEC data (companyfacts), Foliograph reads it directly from the filing. When a company makes a new holding company the registrant, Foliograph takes over the history of the previous registrant.
  • Newly spun-off companies and companies changing their fiscal year have TTM figures only once four consecutive quarters are available.
  • For banks and insurers the cash-flow and debt figures stay empty (see above). When a debt item is missing in the newest report, net debt stays empty instead of 0.
  • The member list comes from the latest published filing of the index ETF, later index changes are missing until the next filing.

Related

This page is also in the app under Help, in the language of the interface. Question not answered? Write to info@foliograph.ch or use the contact form.

Help

Try it with your own account

Test Foliograph free for 30 days with your IBKR account, no credit card. For Mac and Windows, your data stays on your computer.

Try for free

Click the image for full size