Overview
For decades, Warren Buffett’s investment decisions at Berkshire Hathaway have been treated as a barometer for the broader stock market. When Buffett sold more than he bought—quarter after quarter—it often signaled that he saw few bargains. That 13-quarter streak of net selling, which ran from the end of 2022 through the first quarter of 2025, pushed Berkshire’s cash hoard from $129 billion to an eye-watering $373 billion. It was a message: most stocks were too expensive. Now, with Greg Abel at the helm (and Buffett still advising), the first quarter of 2026 reportedly saw some significant purchases that may have broken the streak. This tutorial will teach you how to analyze Berkshire Hathaway’s cash and portfolio moves as a market indicator, and what Abel’s shift might mean for investors.
Prerequisites
- Basic understanding of financial statements (balance sheet, income statement).
- Familiarity with SEC filings, particularly Form 13F (quarterly holdings) and Berkshire’s 10-Q / 10-K.
- Access to a spreadsheet program (Excel, Google Sheets) or a programming environment (Python with pandas) to calculate net sales.
- Optional: A data source for historical Berkshire cash and equity portfolio data (e.g., SEC EDGAR, Yahoo Finance).
Step-by-Step Instructions
Step 1: Gather Berkshire’s Quarterly Cash and Portfolio Data
Every quarter, Berkshire Hathaway reports its cash, cash equivalents, and equity holdings in its 10-Q or 10-K. You also need the total value of the equity portfolio at the start and end of each quarter. To replicate the 13-quarter streak analysis, pull data from Q4 2022 through Q1 2026. For example:
- Cash balance: Consolidated cash plus short-term investments (T-bills).
- Equity portfolio value: Market value of stocks held (from 13F filings).
You can find this in the “Investments” and “Cash and Cash Equivalents” line items. A simple Python script using yfinance or pandas-datareader can automate retrieval, but be aware that 13F data lags by 45 days. For a manual approach, download the 13F from SEC EDGAR and copy the total value.
Step 2: Calculate Net Stock Purchases (or Sales)
Net purchases = change in equity portfolio value – change in market valuation (i.e., from price moves) + dividends received. A simpler proxy: compare the quarter-end equity value to the quarter-start value adjusted for the S&P 500’s return. Or use the official cash flow statement where “Purchases of investments” and “Sales of investments” are stated. For example:
# Pseudocode for net sales in a quarter
beginning_portfolio = 300e9 # start of quarter
ending_portfolio = 290e9 # after price changes
sp500_return = 0.02 # 2% gain
adjusted_start = beginning_portfolio * (1 + sp500_return)
net_sales = adjusted_start - ending_portfolio # positive means sold more than bought
In practice, use the official numbers from Berkshire’s “Investments—Purchases” and “Investments—Sales” in the cash flow statement. For the 13 quarters of Buffett’s streak, net sales were positive each quarter.
Step 3: Identify the 13-Quarter Streak and Cash Pile Growth
Plot the net sales and cash balance over time. From Q4 2022 to Q4 2025, you should see net sales positive every quarter, with the cash pile rising from $129B to $373B. This indicates that Buffett was consistently reducing his equity exposure, which many interpreted as a bearish signal. The key insight: the ratio of cash to equity holdings grew, reflecting a lack of conviction in market valuations.
Step 4: Analyze Greg Abel’s Q1 2026 Moves
On the most recent 13F (Q1 2026), look for any new positions or large increases in existing ones. According to the original report, Abel made “a few big purchases” that broke the streak. To confirm, calculate net purchases as above. If net purchases turn positive, that’s a shift. Compare the purchases to Berkshire’s typical buy size (e.g., $5B+ for a meaningful position). Check the sectors: were they value stocks like energy or financials, or growth like tech? That choice reveals Abel’s (and Buffett’s) sentiment.
Step 5: Interpret the Turning Point for the Stock Market
Berkshire’s cash-to-equity ratio often peaks near market bottoms (e.g., 2009) and troughs near tops (e.g., 2007). The reversal from net selling to net buying could mean they see undervalued opportunities. But be cautious: the purchases may be defensive (e.g., buying back Berkshire stock if it’s cheap) or opportunistic (picking up a distressed asset). Tutorial step: build a simple model comparing Berkshire’s cash ratio to the S&P 500’s forward P/E. If the ratio drops and the market is down, it’s a bullish signal.
Common Mistakes
- Ignoring cash from operations: Berkshire’s insurance and railroad businesses generate billions in operating cash. Not all cash increase comes from selling stocks. Always separate operating cash flow from portfolio activity.
- Assuming selling always means bearish: Buffett sometimes sells to raise cash for a future acquisition (e.g., the 2023 purchase of Pilot Travel Centers). The streak was notable because no major purchases materialized.
- Using only 13F data without timing: 13F reports what was held at quarter end. Large purchases could have been made early in the quarter and sold later. Cross-check with cash flow statements for accuracy.
- Overinterpreting a single quarter: Greg Abel’s Q1 2026 purchases may be an anomaly. Wait for two consecutive quarters of net buying to confirm a trend.
- Ignoring the Buffett effect: The market often reacts to Berkshire’s moves, so by the time you analyze, prices may have adjusted. Use this tutorial for long-term signals, not short-term trades.
Summary
Berkshire Hathaway’s 13-quarter selling streak—now potentially broken by Greg Abel—offers a textbook example of how to use insider behavior as a market signal. By tracking quarterly cash and net portfolio changes, you can gauge when a legendary investor sees overvaluation. The shift from selling to buying in early 2026 may hint at a market turning point, but due diligence requires analyzing the purchases, adjusting for cash flow, and observing follow‑up quarters. Use this guide to build your own dashboard and stay ahead of the crowd.