Dow Drops 953 Points — How to Track Your Portfolio During a Market Crash

What Happened on June 10

Three factors collided to create the worst single-day drop in weeks:

• Iran conflict escalation. President Trump stated that Iran would "pay the price" for failing to reach a peace deal, threatening further military action. Oil prices jumped in response.
• Inflation hit 4.2% in May. The Consumer Price Index reading came in hotter than expected, dashing hopes for near-term Fed rate cuts. Core inflation also ticked up.
• VIX surged 10%. The fear index spiked as traders priced in geopolitical uncertainty and sticky inflation. Tech and cyclical stocks led the selloff.

A $7 billion share sale from Super Micro Computer intensified the tech rout, with chip stocks and AI-related names among the hardest hit.

Why Tracking Your Portfolio Matters Right Now

During a market selloff, the instinct is to log into every brokerage account — Fidelity, Schwab, Robinhood, Vanguard — and check balances one by one. This fragments your view and amplifies anxiety. Each login is another moment of seeing red numbers without context.

A consolidated portfolio view changes the equation. When you can see your total exposure across all accounts in one place, you can answer the questions that actually matter:

• Am I overexposed to tech stocks that led the selloff?
• Has my asset allocation drifted more than 5% from target?
• Are there tax-loss harvesting opportunities in my taxable accounts?
• How much cash do I have available across all brokerages to deploy?

How to Set Up Portfolio Tracking in Google Sheets

Instead of logging into 4 different brokerage apps, you can sync all your holdings into a single Google Sheet using InvestSheet:

1. Install InvestSheet from the Google Workspace Marketplace.
2. Connect your brokerages.InvestSheet uses secure OAuth — you log in through your brokerage's official website. Read-only access. No passwords stored.
3. Use custom formulas. Type =IVS_BROKERAGE("value") to see your total portfolio value across all connected accounts in one cell.
4. Filter by account. Need to see just your Fidelity Roth IRA? Use =IVS_BROKERAGE("value", "", "Fidelity", "Roth IRA")

Holdings auto-refresh every time you open the sheet. No manual data entry. No copy-paste from brokerage websites. Your spreadsheet becomes a live dashboard for your entire investment portfolio.

What Smart Investors Do During a Selloff

Warren Buffett famously said: "Be fearful when others are greedy, and greedy when others are fearful." Market selloffs create opportunities, but only if you have clarity on your positions. Here is a practical checklist for June 2026:

All of these steps require one thing: a complete, up-to-date picture of your holdings across every brokerage. The investors who panic are the ones who don't have that picture.

The Cost of Manual Tracking During Volatility

Let's be specific about what manual portfolio tracking looks like on a day like June 10:

• Log into Fidelity → note 15 positions → log out
• Log into Schwab → note 8 positions → log out
• Log into Robinhood → note 6 positions → log out
• Open Google Sheets → manually type each ticker, price, shares
• Calculate total value manually (price × shares)
• Calculate gain/loss manually (market value − cost basis)
• Repeat tomorrow if the market drops again

With automated tracking, steps 1-7 become: open the sheet.

At $7.99/month (annual plan), InvestSheet costs less than the time you spend manually updating spreadsheets — and it gives you answers when you need them most.

Frequently Asked Questions