After the November 5 Selloff: Check Your Portfolio Before Your Next Move

On Thursday, November 5, 2026, the Nasdaq Composite closed at 24,315.00, down 5.52%; the S&P 500 finished at 7,353.73, down 4.36%; and the Dow ended at 51,523.06, down 3.44%, according to MarketWatch’s market data. These are one-session moves, not year-to-date returns.

A market headline cannot tell you how much risk sits inside your own collection of accounts. Before interpreting a red balance or reacting to someone else’s trade, build a consistent view of your holdings. This daily guide turns the news into four concrete checks you can run in Google Sheets.

1. Separate the reported story from your forecast

MarketWatch’s November 5 report linked the technology-led selling to concerns about the durability of the AI trade. That is a reported explanation of sentiment, not proof of what prices or business results will do next.

The differences between the indexes also matter: a broad market benchmark and a technology-heavy portfolio are different exposures. If your holdings moved differently from an index, first check the mix you actually own. Matching an index’s daily move is not a useful expectation for every portfolio.

Keep two short columns in your research notes: verified developments and questions still open. A change in guidance, a financing announcement, and a price decline should not automatically become the same conclusion. This makes it easier to revisit your reasoning when the next piece of information arrives.

2. Refresh and reconcile before measuring the damage

Bring connected holdings into one Google Sheet with InvestSheet. Start with the inputs it actually provides:

=IVS_BROKERAGE("value")
=IVS_BROKERAGE("costBasis")
=IVS_BROKERAGE("gainLoss")

These are connected holding value, cost basis, and unrealized gain or loss. Unrealized gain is measured against cost basis; it is not the amount gained or lost since yesterday. A position can remain above its purchase cost while losing value today.

Use the add-on’s Refresh workflow, check the data timing and account coverage, and reconcile against brokerage statements. Formula cells read stored holdings data, not a streaming exchange feed. Keep manually entered cash or missing accounts clearly labeled so that a partial total is not mistaken for your full balance sheet.

For a daily comparison, keep dated valuations on a consistent basis and track contributions, withdrawals, income, and trading activity. A deposit can lift account value without improving investment performance. If yesterday’s snapshot is missing, do not invent a daily return from today’s cost basis.

3. Find the same exposure hiding in different accounts

MarketWatch reported Nvidia fell 9.3% on Thursday. A move in one company can matter more than a broad index headline when it is repeated across several accounts.

Use =IVS_BROKERAGE("value", "NVDA") to review the value of direct holdings across connected accounts. Add a brokerage filter, such as =IVS_BROKERAGE("value", "NVDA", "Fidelity"), when checking where the position sits. These examples demonstrate aggregation, not a recommendation to own the stock.

Consider a hypothetical start-of-day portfolio worth $120,000 with $18,000 in direct Nvidia shares: the starting weight is 15%. Applying that day’s 9.3% decline to the starting position gives a $1,674 loss, or about 1.40 percentage points of the starting portfolio. That illustration holds share quantities constant and assumes no other price changes or cash flows.

Direct shares are only one layer. Check dated fund holdings for additional exposure, and calculate it separately. InvestSheet does not supply an allocation or fund-look-through attribute. Several account names or fund tickers do not, by themselves, establish diversification.

4. Finish with a decision record and a funding check

For each material position, write down its role, the information you still need, and whether its size remains consistent with your intended limits. Review money needed for near-term expenses separately from long-horizon investments. If you use borrowing, review the broker’s current margin requirements and your ability to meet them; a consolidated spreadsheet does not replace those account rules.

Save the review with a date and data source. You can start with our free manual holdings template and add supported brokerage syncing through InvestSheet. The useful outcome tonight is a portfolio you can explain: reconciled inputs, visible concentrations, and specific questions to investigate before your next move.

See the holdings behind the headline

Bring connected brokerage holdings into Google Sheets with InvestSheet, then build your own review around value, cost basis, and unrealized gains or losses. Refresh and reconcile your inputs before comparing accounts or making decisions.