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

A 13F filings tracker in Excel is a workbook that lists the disclosed U.S. equity holdings of several hedge funds side by side, counts how many funds own each ticker, and pulls current price and valuation data next to each name. The Q1 2026 13F deadline was May 15, 2026, so the filings show positions as of March 31, 2026. This guide explains what 13Fs disclose and hide, how the six-sheet workbook is structured, and which MarketXLS formulas (such as =QM_Last, =PERatio, and =MarketCapitalization) add current data to each consensus name.

See it in actionMarketXLS video

The full MarketXLS demo

Watch full demoBook a demo

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

Email address

Download free workbook

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos +

IntroductionHistorical DataOptions DataUse-cases

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 shows where several managers agree, which a single filing cannot show.
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

MarketXLS adds current prices and fundamentals to every ticker in the 13F workbook, so you compare today's valuation with the quarter-end snapshot in the filing. The formulas below refresh when Excel recalculates. Quote speed depends on your plan: the Standard plan's stock quotes are 15-minute delayed, and the Advanced and Business plans include real-time streaming.

Here are the core formulas wired into the workbook:

=QM_Last("AAPL")              → Current Apple price (delay depends on plan)
=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

Formula documentation: QM_Last, MarketCapitalization, PERatio, DividendYield, Beta, Sector, Industry, Revenue, EarningsPerShare, ReturnOnEquity, OperatingMargin, FiftyTwoWeekHigh, FiftyTwoWeekLow, SimpleMovingAverage, 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)

Formula documentation: QM_Last, FiftyTwoWeekHigh, PERatio, Revenue, MarketCapitalization

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)

Formula documentation: QM_Last, PERatio, DividendYield

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 on Mac, Excel for the web, or Google Sheets? Yes, with platform differences. Excel on Windows uses the desktop add-in (=Last("AAPL")). Excel on Mac and Excel for the web use the Microsoft 365 add-in, where formulas take the mxls. prefix (=mxls.Last("AAPL")). A Google Sheets add-on is also available. Some functions differ by platform, so check /formulas.

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. Filings are 45 days old when published, so copying them trades on stale positions; 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 a free public dataset. Within 45 days of each quarter end 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,000+ 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 earnings dashboard - Live valuation on the megacap names that dominate most 13F books