13F Filings Tracker Excel: Q1 2026 Hedge Fund Holdings Dashboard

13F filings tracker excel - if that is what brought you here, the timing is perfect. The Q1 2026 quarterly 13F deadline closed on Friday, May 15, 2026, and the SEC EDGAR system is now packed with the freshly disclosed equity holdings of every institutional manager that crossed the $100M threshold last quarter. This guide shows you how to pull that data into Excel, build a consensus-picks dashboard around the most-watched hedge funds, and keep the whole thing alive with MarketXLS formulas instead of stale screenshots.

The download links for the two ready-to-use templates are at the bottom of the page. The rest of the post is the playbook: what 13F filings are, how to read them without falling into common traps, how to structure the dashboard, and how to wire up live fundamentals on every name that the smart-money set is leaning into.

Q1 2026 13F Snapshot - Top Tracked Managers

Here is a snapshot of the eight hedge funds tracked inside the workbook. Numbers reflect publicly disclosed long U.S. equity portfolios from each manager's most recent 13F-HR filing.

These are starting points. You can swap any of them out for a manager that matches your style (Tiger Cubs, quant shops, sector specialists) and the dashboard will recompute consensus on the fly.

Market Analysis - Why the May 2026 13F Window Matters

13F filings are always lagging. The deadline gives managers 45 calendar days after quarter end to file, which means the Q1 2026 filings disclosed last Friday reflect positions held as of March 31, 2026. Between then and now the market has moved through:

• The April 2026 tariff and trade headline cycle that pressured megacap exporters
• A May Federal Reserve meeting that left the policy rate unchanged but shifted the dot plot
• A run of Q1 earnings prints from the Magnificent 7 that revealed widely divergent capex trajectories
• A sharp narrowing in regional bank credit spreads as NIM guidance stabilized

That is a lot of price action between the filing snapshot and today. The right way to use 13Fs in May 2026 is not to "copy what Buffett did six weeks ago." It is to use the filings as a research starting list, then layer your own current valuation and earnings work on top. That is exactly what this workbook is built to do.

What a 13F Filing Actually Discloses (and What It Hides)

Before building anything, it is worth understanding the rules of the road. A Form 13F is required quarterly from any investment manager that exercises investment discretion over $100M or more of "13(f) securities," which generally means long U.S. equity positions, ADRs, and certain options and convertibles. The disclosure includes:

• Ticker, CUSIP, issuer name, and class
• Number of shares held at quarter end
• Market value of the position at quarter end
• Voting authority (sole, shared, none)
• Whether the position is a put or a call (column 4 designation)

Equally important is what 13Fs do not show:

• Short positions (this is the biggest blind spot)
• Cash balances or hedges
• International equity holdings (non-U.S. listed)
• Most derivatives outside listed options
• Private investments
• Positions added or sold after quarter end

A famous example: in any quarter where a fund discloses a large long position, you have no way of knowing from the 13F alone whether that long is naked, hedged with options, or paired with a short basket in the same sector. So a "Buffett bought X" headline can be accurate, while "the smart money is positioned long X" is much less so. Use the data responsibly.

The Approach - From Raw Filings to a Usable Dashboard

There are a few common workflows for working with 13F data:

1. One fund at a time. Pull a single manager's filing from SEC EDGAR, paste the positions into Excel, and slice by sector or size. Fine for following Buffett or Ackman in isolation, but useless for finding overlap.
2. Cross-manager overlap. Track 5-15 managers together, count how many own each ticker, and surface the consensus list. This is the highest-signal use of 13Fs and it is what professional copy-trading services charge thousands of dollars per year for.
3. Quarterly change tracking. Compare this quarter's holdings to last quarter to flag new positions, position adds, position trims, and full exits. This is the most labor-intensive workflow but the one that surfaces the most actionable ideas.

This workbook is built around workflow #2 with all of the infrastructure needed to extend it to #3. The matrix view in the Positions Matrix sheet shows you the overlap at a glance, the Consensus Picks sheet ranks tickers by the number of tracked managers holding them, and the Valuation Analysis sheet pulls live fundamentals on every consensus name so you can decide whether the price has run away from the thesis.

“

Educational note: This post and the linked templates are for research and learning. They are not investment advice. 13F overlap is one input among many and should never be treated as a buy or sell signal on its own.

MarketXLS Implementation - Live Fundamentals on Every 13F Name

The reason this dashboard is worth building in Excel instead of subscribing to yet another web app is that the moment a 13F drops, what you actually need is current data on the tickers in the filing, not the snapshot price from quarter end. MarketXLS turns Excel into a real-time financial data terminal, which means every cell in the Consensus Picks sheet can refresh on demand.

Here are the core formulas wired into the workbook:

=QM_Last("AAPL")              → Current Apple price (real-time)
=MarketCapitalization("AAPL") → Market capitalization in dollars
=PERatio("AAPL")              → Trailing P/E ratio
=DividendYield("AAPL")        → Annual dividend yield %
=Beta("AAPL")                 → Beta vs S&P 500
=Sector("AAPL")               → GICS sector classification
=Industry("AAPL")             → GICS industry classification
=Revenue("AAPL")              → Trailing revenue
=EarningsPerShare("AAPL")     → TTM earnings per share
=ReturnOnEquity("AAPL")       → ROE %
=OperatingMargin("AAPL")      → Operating margin %
=FiftyTwoWeekHigh("AAPL")     → 52-week high
=FiftyTwoWeekLow("AAPL")      → 52-week low
=SimpleMovingAverage("AAPL",50) → 50-day SMA
=RSI("AAPL")                  → 14-day RSI

Combine those with native Excel logic and you have a dashboard that does things web-only 13F trackers cannot:

=IF(QM_Last(A2) > FiftyTwoWeekHigh(A2)*0.95,
    "Within 5% of 52w high",
    "Below high")

=IF(AND(COUNTIF(positions_range, ">0") >= 4,
        PERatio(A2) < 20),
    "Consensus + cheap",
    "Watch")

=Revenue(A2) / MarketCapitalization(A2)

That last one is a quick price-to-sales sanity check on any name that just lit up the consensus list - a useful filter when megacaps appear in multiple manager portfolios and you want to separate "growth at a reasonable price" from "growth at any price."

The Template - What Is Inside the Workbook

The 13F Filings Tracker Excel template ships as two .xlsx files (sample and live) with the following six sheets:

Sheet 1: How To Use

A plain-English tutorial. Walks through each sheet, explains what 13Fs disclose and what they hide, lists every MarketXLS function used, and includes the customization steps for adding your own fund or ticker.

Sheet 2: Main Dashboard

A one-screen overview of every tracked manager:

• Fund name, lead PM, disclosed equity AUM in $M
• Number of disclosed positions in the workbook
• Largest holding ticker and dollar value
• Top-holding concentration as a percentage of the portfolio

It also includes a yellow input cell for the concentration alert threshold (default 25%). Any manager whose top holding exceeds that share of the disclosed book gets flagged - useful for separating concentrated activists like Ackman from diversified quant books.

The lower half of the dashboard runs a "live reference tickers" strip - eight of the most-held consensus names with =QM_Last, =MarketCapitalization, =Sector, =Beta, and =DividendYield so you have a fresh read on the marquee names without leaving the dashboard.

Sheet 3: Positions Matrix

A fund x ticker grid. Rows are the tracked managers, columns are every ticker in the consensus universe, cells show disclosed position values in $M. Green fill highlights any cell with a non-zero position, blank cells mean the manager has not disclosed that name (or it is below their reporting threshold).

At the bottom of the matrix two summary rows compute:

• =SUMIF(column, ">0") to aggregate total disclosed dollars per ticker
• =COUNTIF(column, ">0") to count how many of the tracked managers hold each name

These two rows are the engine of the consensus view.

Sheet 4: Consensus Picks

Sorted descending by the number of tracked funds holding each ticker. Color-coded:

• GREEN = held by 4 or more tracked funds (strong consensus)
• AMBER = held by exactly 3 tracked funds (moderate consensus)
• No fill = held by 2 (minimum to qualify for the list)

Each row pulls live fundamentals from MarketXLS:

=QM_Last("META")        → 580.40 (live)
=PERatio("META")        → 26.4 (live)
=DividendYield("META")  → 0.35% (live)

This is the sheet that answers the question "which names actually overlap across the smart money set" with current pricing context next to the consensus count.

Sheet 5: Valuation Analysis

A clean, screener-style table of every consensus name with:

• Last price (=QM_Last)
• Market cap (=MarketCapitalization)
• P/E (=PERatio)
• Revenue (=Revenue)
• EPS (=EarningsPerShare)
• ROE (=ReturnOnEquity)
• Operating margin (=OperatingMargin)

When a ticker appears on multiple manager 13Fs, this is the sheet where you sanity-check whether it still looks reasonable on quality and valuation, or whether the consensus has crowded the entry point.

Sheet 6: Sector Allocation

Aggregates the disclosed dollars across the entire tracker by GICS sector. Shows the share each sector represents, lists the underlying tickers per sector, and includes a written note on how to read the heatmap. In Q1 2026 the tracker tilts heavily to Information Technology, Communication Services, and Financials - which is itself useful intel for thinking about concentration risk.

How to Use the Workbook in a Real Research Process

Here is a practical workflow once you have the file open:

1. Start with the Consensus Picks sheet. Sort by # Funds Holding descending. The names with 4 or more holders are the "smart-money overlap" universe.
2. Cross-check valuation on Sheet 5. For each consensus name, look at the live P/E, ROE, and operating margin. Tag anything that looks expensive (very high P/E with deteriorating margins) for further work.
3. Drill into the Positions Matrix. Once you have a short list, scroll across to see which managers are involved. A name held by Ackman and Loeb is a different story than one held by Tiger Global and Coatue - the implied catalysts differ.
4. Layer your own work. Pull the issuer's most recent 10-Q, the earnings transcript, and any sell-side notes. The 13F gets you to a watchlist of about 10-15 names; your own work decides which of them go on a research list.
5. Refresh the workbook quarterly. After the next 13F deadline (August 14, 2026 for Q2 2026), open the template, refresh the positions matrix with the new filings, and recompute consensus. Names that drop off the list quarter over quarter can be just as interesting as the new entrants.

Common Pitfalls to Avoid

• The lag trap. Treating 13F snapshots as current positioning. A manager who held a stock on March 31 may have sold the entire position by April 15. Always check for amended filings (13F/A) or news of a position change before assuming it is still live.
• The size trap. A $50M position in a $300B megacap looks the same in dollar terms as a $50M position in a $5B small cap, but the conviction signal is wildly different. The Consensus Picks count helps, but always size the position relative to the fund's AUM.
• The shorting blind spot. 13Fs do not disclose shorts. A fund could be long Stock X and short Sector ETF Y as a pair trade - and you would only see the long. Treat consensus lists as one input, not the whole picture.
• The activist trap. When a name like CMG appears on Pershing Square's filing it carries an implicit activist catalyst that does not transfer to retail investors who copy the trade. Activists have access, leverage, and time horizons that you do not.

FAQ - 13F Filings Tracker Excel

Q: When is the next 13F deadline? Q2 2026 13F filings are due August 14, 2026 (45 days after the June 30, 2026 quarter end). After that, Q3 2026 filings are due November 14, 2026.

Q: Can I add my own hedge fund to the tracker? Yes. Insert a new row in the Positions Matrix sheet, type the fund name in column A, and fill in the disclosed position values across the ticker columns. The Consensus Picks, Sector Allocation, and Main Dashboard sheets will recompute automatically.

Q: Where do I get the raw 13F data? SEC EDGAR is the official source: https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&type=13F-HR. Most professional aggregators (Bloomberg, FactSet, WhaleWisdom, 13F.info) repackage the same EDGAR feed. The data is free and public.

Q: Do the MarketXLS formulas work in Google Sheets or only Excel? MarketXLS is an Excel add-in built for Microsoft Excel on Windows. Several functions also have Google Sheets-compatible equivalents through MarketXLS for Google Sheets, but the full feature set lives in the Excel version.

Q: Why are some hedge fund managers missing from the tracker? The eight in the default workbook are a starter set. Funds like Bridgewater, Renaissance Technologies, Citadel, and Millennium file 13Fs but their disclosed long equity books are a small fraction of their total AUM (they run heavy derivatives, futures, and short books that 13Fs do not capture). The tracker focuses on managers whose 13F disclosure is reasonably representative of their equity thinking.

Q: How do I track quarter-over-quarter changes? Save a copy of the workbook each quarter with the quarter in the filename (for example 13F_Tracker_Q1_2026.xlsx). Then use a simple comparison sheet with VLOOKUP or XLOOKUP against the prior quarter to flag new positions, adds, trims, and exits.

Q: Is the consensus picks list a buy recommendation? No. It is a research starting point. Use it to surface names worth investigating, not as a buy signal. Many academic studies have shown that simply copying 13F holdings underperforms the market net of frictions; the value is in using consensus overlap as a screening lens for your own work.

Download the Templates

Download the templates:

• - Pre-filled with Q1 2026 reference data
• - Live-updating formulas on every cell

Both files include the full six-sheet structure: How To Use, Main Dashboard, Positions Matrix, Consensus Picks, Valuation Analysis, and Sector Allocation. The live version requires a MarketXLS license to refresh data.

The Bottom Line

13F filings are one of the most underused free datasets in public markets. Every 45 days the SEC publishes a snapshot of what the largest institutional managers are holding, and the only thing standing between that data and a useful research workflow is some plumbing. This workbook is that plumbing.

The dashboard is not a copy-trade tool. It is a research lens. Use it to find names where the smart-money set is concentrated, layer your own current-quarter valuation work on top, and stay honest about what 13Fs do not disclose. Done that way, the quarterly filing cycle becomes a free source of high-quality watchlist candidates that you can run through MarketXLS to validate against live fundamentals.

To explore MarketXLS and the full library of 1,100+ Excel financial functions, visit marketxls.com. To see how the platform fits a specific research workflow, book a demo and walk through this template with the team.

Related reading on MarketXLS:

• Berkshire Hathaway Portfolio Tracker Excel - Single-manager deep dive
• Quality Compounders Screener Excel - Pair with the consensus list for quality screening
• Owner Earnings Calculator Excel - Buffett-style valuation work on any consensus name
• Magnificent 7 Valuation Dashboard Excel - Live valuation on the megacap names that dominate most 13F books