Insider buying screener Excel - if that is what brought you to this page, you are looking for a way to find stocks where the people who run the company have meaningful skin in the game, and you want to do it inside a spreadsheet rather than a black-box web tool. This guide walks through the data, the screening logic, and a free downloadable Excel template that ranks any watchlist of tickers by insider ownership, valuation, quality, and momentum, using live MarketXLS formulas you can audit and tweak yourself.
May 2026 is a particularly useful moment to set this screener up. The Q1 2026 reporting cycle just wrapped, and corporate insider blackout windows (the SEC-defined quiet periods around earnings) have been closing one by one over the past three weeks. That means insider transaction activity has been picking up, and the conditions under which insider buying tends to occur (post-earnings clarity, fresh forward guidance, and updated cap-table information) are unusually rich right now.
What This Screener Solves
Most investors looking for an insider buying screener Excel template run into the same three problems:
- Form 4 data is fragmented. Real-time insider transaction filings live across multiple SEC EDGAR feeds. Aggregating them into Excel manually is painful and brittle.
- Raw transactions are noisy. A single $50,000 director purchase at a $500B company is statistically meaningless. Context matters.
- Conviction is multi-factor. Insider activity in isolation does not predict returns. It only matters in combination with valuation, balance sheet quality, and momentum.
The template below sidesteps the first problem by using standing insider ownership levels (a slow-moving but high-signal proxy) instead of trying to chase Form 4s in real time. It then layers on a weighted scoring model that combines alignment, value, quality, growth, and momentum factors so that a single Conviction Score column tells you where to focus.
Insider Buying Screener Excel: The Conviction Table
The header table below shows what the dashboard ranks (you will see this exact structure in the template's Main Dashboard sheet):
| Column | Source | What It Tells You |
|---|---|---|
| Insider % | SharePercentHeldByInsiders | Standing insider ownership as a percent of shares outstanding |
| Institutional % | SharePercentHeldByInstitutions | Smart-money concentration |
| Short % | ShortPercentage | Bearish positioning - a contrarian factor |
| P/E, P/B, EV/EBITDA | PERatio, PriceToBook, EnterpriseValueToEBITDA | Multi-angle valuation |
| ROE %, ROA % | ReturnOnEquity, ReturnOnAssets | Quality (real return on capital) |
| Debt / Equity | TotalDebtToEquity | Balance sheet risk |
| FCF Yield % | LeveredFreeCashFlow / MarketCapitalization | Cash-generative business test |
| Rev YoY %, EPS YoY % | QuarterlyRevenueGrowthYOY, QuarterlyEarningsGrowthYOY | Growth momentum |
| RSI(14) | RSI | Technical setup - oversold vs overbought |
| Distance from 52w High | QM_Last / FiftyTwoWeekHigh - 1 | Drawdown filter |
| Conviction Score (0-100) | Computed | Weighted result of all the above |
Everything in the rightmost column flows from the inputs above it. Edit a weight in the Conviction Scoring sheet, and the score recalculates instantly for every row.
Why Insider Ownership Is a Real Signal (and Where It Is Not)
The academic literature on insider activity is large and noisy, but a few patterns hold up across decades of data:
- Skin-in-the-game ownership matters more than transaction blips. Companies where founders or operating executives own 5 percent or more of the shares outstanding have, on average, demonstrated more disciplined capital allocation than the broad market over rolling 10-year windows. This is a structural fact about how the company is run, not a tradeable signal in itself.
- Cluster buying is what equity-research desks watch. When multiple insiders (typically three or more) buy at the same time, the information content is much higher than any single transaction.
- Open-market purchases > exercised options. A CEO writing a personal check on the open market is a meaningfully different signal from one exercising a pre-granted option.
- Selling is noisier than buying. Insiders sell for a hundred reasons (tax, diversification, divorce, philanthropy). Buying is usually for one reason: they think the stock is mispriced.
The screener in this post leans on the first bullet (standing ownership levels) because that data is reliably available through SharePercentHeldByInsiders and updates as the underlying 13F / proxy filings refresh. Direct Form 4 transaction data is not delivered as a MarketXLS formula today; the template is designed to surface the structural setup under which insider buying typically occurs, not to replace a real-time Form 4 feed.
How the Screener Works (Step by Step)
Step 1: Pull the data
The template opens with a 20-ticker example universe. Each row in the Main Dashboard runs about 18 MarketXLS formula calls. For the lead-off ticker:
=QM_Last("DELL")
=Sector("DELL")
=MarketCapitalization("DELL")/1000000000
=SharePercentHeldByInsiders("DELL")*100
=SharePercentHeldByInstitutions("DELL")*100
=ShortPercentage("DELL")*100
=PERatio("DELL")
=PriceToBook("DELL")
=EnterpriseValueToEBITDA("DELL")
=ReturnOnEquity("DELL")*100
=TotalDebtToEquity("DELL")
=LeveredFreeCashFlow("DELL")/MarketCapitalization("DELL")*100
=QuarterlyRevenueGrowthYOY("DELL")*100
=QuarterlyEarningsGrowthYOY("DELL")*100
=RSI("DELL")
=(QM_Last("DELL")/FiftyTwoWeekHigh("DELL")-1)*100
=Beta("DELL")
=DividendYield("DELL")*100
Replace the 20 example tickers with your own universe (an index constituent list, sector ETF holdings, a personal watchlist) and the formulas fan out automatically.
Step 2: Compute the Conviction Score
The score column applies these weighted rules:
| Rule | Points |
|---|---|
| Insider Ownership > 10% | 25 |
| Insider Ownership > 5% (partial credit if 10% is missed) | 15 |
| P/E < 20 | 10 |
| P/B < 3 | 10 |
| EV/EBITDA < 15 | 10 |
| ROE > 15% | 10 |
| FCF Yield > 5% | 15 |
| RSI(14) < 50 | 10 |
| Distance from 52w high > -10% | 10 |
| Maximum | 100 |
The IF-stack that drives the score lives in column T of the Main Dashboard sheet. You can edit the thresholds (replace B>5 with B>3, for example) and every row recalculates.
Step 3: Read the heatmap
The Comparison Heatmap sheet collapses every numeric column into a green / red pass / fail grid. Names with a long row of green are high-conviction candidates worth deeper diligence; names with a long row of red are low-conviction.
A Worked Example: Why DELL Surfaces
The example universe pre-filled in the sample workbook includes Dell Technologies because it illustrates the screener's logic well:
- Insider ownership over 40 percent. Michael Dell's holdings push the company well into "founder-aligned" territory, which is unusual for a $80B+ market cap name.
- Reasonable valuation. Trailing P/E in the high teens, EV/EBITDA around 13. Not deep value, but not stretched either.
- Quality test passes. Triple-digit ROE is artificially inflated by past buybacks shrinking the equity base, but ROA in the mid-single digits is still solid for a hardware OEM.
- Cash generation. FCF yield over 5 percent at current prices.
- Setup is benign. RSI around 47 and roughly 12 percent off the 52-week high. Not overbought, not in capitulation.
This is exactly the kind of structural picture that insider purchases tend to coincide with, even when no specific Form 4 has crossed the tape. The screener is designed to keep you focused on names with that shape rather than chasing a single transaction headline.
To be clear: nothing on this list is investment advice. The point is the methodology, not the tickers.
The MarketXLS Formulas Behind the Screen
Every column in the dashboard is sourced from a verified, documented MarketXLS function. The full inventory:
=QM_Last("AAPL") -- Current price
=Sector("AAPL") -- GICS sector
=MarketCapitalization("AAPL") -- Market cap in USD
=SharePercentHeldByInsiders("AAPL") -- Standing insider ownership (decimal)
=SharePercentHeldByInstitutions("AAPL")-- Institutional ownership (decimal)
=ShortPercentage("AAPL") -- % of float short (decimal)
=ShortRatio("AAPL") -- Days to cover
=SharesShort("AAPL") -- Shares sold short
=FloatShares("AAPL") -- Public float
=PERatio("AAPL") -- Trailing P/E
=PriceToBook("AAPL") -- P/B ratio
=EnterpriseValueToEBITDA("AAPL") -- EV/EBITDA
=ReturnOnEquity("AAPL") -- ROE (decimal)
=ReturnOnAssets("AAPL") -- ROA (decimal)
=TotalDebtToEquity("AAPL") -- Debt / equity
=LeveredFreeCashFlow("AAPL") -- Levered FCF in USD
=QuarterlyRevenueGrowthYOY("AAPL") -- Rev growth YoY (decimal)
=QuarterlyEarningsGrowthYOY("AAPL") -- EPS growth YoY (decimal)
=RSI("AAPL") -- 14-day RSI
=FiftyTwoWeekHigh("AAPL") -- 52-week high price
=Beta("AAPL") -- Beta vs market
=DividendYield("AAPL") -- Dividend yield (decimal)
These are not invented. They are pulled directly from the MarketXLS function library and verified at the time of this writing through the documentation tooling we use to ship every template.
Customizing the Screener for Your Universe
The most common ways readers adapt the template:
Small caps: Replace the example large caps with a Russell 2000 or microcap universe. Insider ownership signal is much stronger in small caps where founders are still operating the business. Drop the Insider % threshold from 5 to 3 (smaller floats mean smaller raw percentages still represent meaningful dollar exposure for executives).
Sector tilt: Banks and insurers show very low insider ownership by construction (regulatory limits and large institutional cap tables dominate). If you screen the financial sector, drop the insider threshold and lean more heavily on valuation (P/B < 1) and short interest (avoid names with > 5% short).
Founder-led only: Set the Insider % rule to 20 or 25 (instead of 10) to surface only names where a founder is still meaningfully invested. The list will be small but high-quality.
Post-earnings buyers: Combine this screener with the post-earnings drift analysis (see our post-earnings drift screener) to layer in a momentum dimension.
How This Screener Differs from a Form 4 Tracker
Worth being explicit about what this template is and is not.
| Question | This Template | A Real-Time Form 4 Tracker |
|---|---|---|
| Latency | Updates with quarterly filings / proxy data | Updates within hours of insider transactions |
| Signal source | Standing ownership levels | Discrete buy / sell events |
| Best use case | Structural alignment scoring | Trade-the-news execution |
| Inside Excel? | Yes, via MarketXLS formulas | Requires external data feed |
| Noise level | Low (ownership levels are slow-moving) | Medium-high (many false positives) |
| Best for | Long-horizon investors, advisors | Tactical traders |
If you need real-time Form 4 transaction data, you need to feed it into Excel from an external source (the SEC EDGAR feed, or a licensed insider-data provider). MarketXLS does not currently expose individual Form 4 line items as a function. The screener in this post is designed to be useful even without that intraday feed, by anchoring on the structural ownership picture.
Building the Screener From Scratch (if You Prefer)
If you want to build this screener cell by cell rather than open the downloadable template, here is the minimum viable version in five rows of Excel:
A1: Ticker B1: Insider % C1: P/E D1: ROE % E1: FCF Yield % F1: Conviction
A2: DELL B2: =SharePercentHeldByInsiders(A2)*100 C2: =PERatio(A2) D2: =ReturnOnEquity(A2)*100 E2: =LeveredFreeCashFlow(A2)/MarketCapitalization(A2)*100 F2: =IF(B2>10,25,IF(B2>5,15,0))+IF(C2<20,10,0)+IF(D2>15,10,0)+IF(E2>5,15,0)
That single row gives you a 60-point version of the score. Sort the table by column F descending, and you have your shortlist. The downloadable workbook adds momentum, growth, and balance-sheet factors on top of this core for the full 100-point version.
Download the Templates
Download the templates:
- - Pre-filled with example data so you can see the layout before connecting MarketXLS.
- - All cells are live
=SharePercentHeldByInsiders,=PERatio,=LeveredFreeCashFlow, etc. - opens fresh data every time you recalculate.
Both files include a How To Use sheet, Main Dashboard, Conviction Scoring (editable weights), Ownership and Float Detail, Quality and Value Filters, and a green / red Comparison Heatmap.
Walking Through the Six Sheets
1. How To Use
A page-long tutorial covering what each sheet does, how to interpret insider ownership levels, where the screener is and is not appropriate, and the disclaimers you should read before using the output for any real decision.
2. Main Dashboard
The 20-row, 20-column screener table described above. Yellow input cells in row 3 let you adjust the universe-wide thresholds (Min Insider %, Max P/E, Min ROE) without editing formulas. Frozen panes keep the headers visible as you scroll, alternating row colors keep the table readable, and a Conviction Score column on the far right ranks the entire list.
3. Conviction Scoring
The weighted scoring rule table. Each rule sits in its own row with a points column (yellow, editable) and a rationale column. Below the table is the interpretation guide (80+ = top tier, 60-79 = high conviction, etc.). Edit a weight here and the Main Dashboard's Conviction column recalculates.
4. Ownership and Float Detail
Drill-down view of who owns what. Insider %, institutional %, combined %, short %, short ratio (days to cover), shares short in millions, public float in millions, and an Insider Skin Score that doubles insider ownership and adds a 10-point bonus for low short interest. This is where you sanity-check the headline insider number before relying on it.
5. Quality and Value Filters
Side-by-side view of the value dimensions (P/E, P/B, EV/EBITDA), quality dimensions (ROE, ROA, Debt/Equity, FCF Yield), and growth dimensions (Rev YoY, EPS YoY). Three traffic-light columns on the right show whether each name passes the Value, Quality, and Growth tests independently. Names that pass all three with > 10% insider ownership are extremely rare and are the screener's purest output.
6. Comparison Heatmap
A green / red grid covering the eight pass / fail factors for every ticker, plus a Total Pass count. Use this sheet to make the screener visually scannable - a horizontal stripe of green tells you everything you need to know about which names to investigate first.
FAQ: Insider Buying Screener Excel
What is the best insider buying screener for Excel?
The best insider buying screener for Excel is one that combines standing insider ownership data with valuation, quality, and momentum filters, weights each factor sensibly, and exposes all of its logic to you so you can audit and tweak the output. That is exactly what the template above does, using SharePercentHeldByInsiders plus PERatio, PriceToBook, ReturnOnEquity, and LeveredFreeCashFlow from MarketXLS.
Can I see real-time Form 4 insider transactions in Excel?
Not through MarketXLS formulas directly today. MarketXLS exposes standing insider ownership (refreshed with the underlying filings) but does not currently expose individual Form 4 transactions as a callable function. To bring real-time transaction data into Excel, you would need to pull from the SEC EDGAR full-text feed or from a licensed insider data provider (Verity, InsiderInsights, etc.). The screener in this post is designed to be useful even without that intraday feed, by anchoring on the structural ownership picture.
What insider ownership percentage is considered high?
For a large-cap S&P 500 name, anything above 5 percent is considered high (most names sit below 1 percent). For mid caps, 10 percent and up is the founder-led zone. For small caps, 20 to 40 percent insider ownership is common when a founder is still operating the business. The template's default threshold is 5 percent for partial credit and 10 percent for the full weighted points.
How do I customize the conviction score weights?
Open the Conviction Scoring sheet. The yellow cells in column B are the editable weights for each rule. Change a number (for example, set the FCF Yield rule from 15 to 25 if you weigh cash flow more heavily), and the Conviction column on the Main Dashboard recalculates for every row. The maximum-possible-score cell in B15 updates automatically.
Does high insider ownership predict stock returns?
The honest answer is "sometimes, in combination with other factors." Decades of academic research suggests that high insider ownership is associated with better long-run capital allocation, but it is not a standalone tradeable signal. That is why this screener combines insider ownership with valuation, quality, and momentum rather than relying on the insider factor alone. Treat the Conviction Score as a research-prioritization tool, not a buy / sell trigger.
Why use MarketXLS for an insider screener instead of a web tool?
Three reasons. Auditability - every number in the screener traces to a documented MarketXLS function you can see in the cell formula bar. Customization - you can edit weights, add factors, change thresholds, or swap in your own ticker universe without waiting for a vendor to support it. Composability - the same workbook can be combined with other MarketXLS templates (post-earnings drift, dividend safety, sector valuation heatmaps) inside a single Excel environment. A web screener gives you a list. A spreadsheet gives you a research workspace.
The Bottom Line
An insider buying screener in Excel does not need to be a Form 4 ticker tape. The version in this template uses standing insider ownership as its anchor signal, layers on valuation, quality, growth, and momentum filters, and produces a single Conviction Score that ranks every ticker in your universe from 0 to 100. The whole thing fits inside a six-sheet Excel workbook, every cell is a live MarketXLS formula, and the scoring weights are yours to edit.
Run it against your watchlist. Sort by Conviction Score. Investigate the top five. That is the entire workflow.
If you want to see how the MarketXLS function library powers screens like this across every corner of the equity universe, visit marketxls.com or book a demo to see the platform in action.
