DEV Community

Cover image for Stop Staring at Spreadsheets: How a Proper Portfolio Visualizer Kept Me From Panic-Selling
Kevin Meneses González
Kevin Meneses González

Posted on • Originally published at Medium

Stop Staring at Spreadsheets: How a Proper Portfolio Visualizer Kept Me From Panic-Selling

In March 2020, I sold positions I should have held for years.

The market was collapsing. My broker app was a wall of red. My spreadsheet, half-updated as always, showed numbers I didn't trust. And without a clear picture of what I actually owned and what it was generating, I did what most retail investors do under pressure: I reacted.

Some of those positions recovered 80%, 100%, more. I wasn't there for it.

I made the same mistake again in early 2025 — different correction, same psychology, same incomplete information driving the decision.

The problem wasn't discipline. The problem was what I was looking at.


The Red/Green Trap

Broker apps are designed around price movement. Every interface puts the daily change front and center — green when you're up, red when you're down. The number that dominates your screen is the one most likely to trigger an emotional response.

That's not an accident. Engagement and activity are good for brokers. Calm, long-term holding is not.

When markets fall, every broker app in your pocket is screaming the same thing: your money is disappearing. And if that's the only signal you have — if you have no visibility on income, no view of long-term trajectory, no sense of what your portfolio actually generates — your brain fills in the rest with anxiety.

Staring at a spreadsheet during a correction is worse. The numbers are stale, the formulas are fragile, and there's no context. Just a column of values declining in real time with no counterweight.


What I Sold in 2020 (And What It Cost Me)

March 2020 was a 34% drawdown in 33 days. The fastest crash in market history.

I had positions across Degiro and Interactive Brokers. I had no consolidated view — just four separate apps showing four separate catastrophes with no way to see the full picture.

I sold. Not everything. But enough.

The positions I sold weren't bad positions. They were sound companies, held at reasonable valuations, paying dividends. But I couldn't see that in the moment. All I could see was red.

Some of those positions doubled in the 18 months that followed. The cost of that panic wasn't just the loss on the sale — it was missing the entire recovery.

In early 2025, another correction. This time I had more context, more visibility. I still felt the pull. But I also added to some positions instead of exiting. Not because my discipline had improved. Because what I was looking at had changed.


The Shift: From Capital Value to Cash Flow

The single most useful reframe for a long-term investor is this: your portfolio's job is not to be worth more tomorrow. It's to generate income that grows over time.

Price is volatile. Income is sticky.

A stock down 20% in a correction is still paying its dividend. If it's a company with a 30-year streak of increasing payments, the correction doesn't change the income thesis at all. The price will recover. The dividend, in most cases, keeps coming.

But you can only hold that perspective if you can see it. If your primary view is a red/green price chart, every correction feels like destruction. If your primary view is a dividend calendar showing $451 arriving this month regardless of what the market does — the emotional equation changes.

This is the behavioral shift that proper portfolio visualization enables. Not motivation. Not discipline. Just better information, presented in a way that maps to your actual strategy.


What a Portfolio Visualizer Actually Shows You

The difference between a broker dashboard and a proper portfolio visualizer isn't cosmetic. It's structural.

A broker dashboard shows you:

  • Today's price vs. yesterday's price
  • Your position's gain/loss since purchase
  • Account value (on their platform only)

A portfolio visualizer shows you:

  • Total net worth across all accounts, updated automatically
  • Asset allocation across every broker simultaneously
  • Income generated — actual dividends received and projected forward
  • Cash flow by month — what arrives when, declared vs. estimated
  • Performance in your base currency, adjusted for exchange rate movements

[Screenshot: Snowball Analytics portfolio overview — allocation donut chart across Funds, Stocks, Cash, Commodities]

The first view makes you feel exposed during corrections. The second gives you the global vision to stay in control.


The Dividend Calendar During a Correction

The most powerful view during a market downturn is not your portfolio value. It's your income schedule.

When prices are falling, this view answers the question that actually matters for a dividend investor: is my income stream intact?

$3,455.20 in projected annual income. $287.93 arriving every month. $9.47 every single day — whether the market is up, down, or sideways.

Look at the bar chart: June $405, August $311, September $404, December $406. The income pattern is visible a full year ahead. Not estimated loosely — projected from declared and scheduled payments, month by month.

None of that changes because the S&P dropped 8% this week.

Seeing that — really seeing it, with a 12-month forward view and specific monthly amounts — is what separates a strategic hold from a panic sell. The income calendar makes the abstract concept of "long-term investing" concrete and visible in a way that a price chart never can.


A Sense of Control vs. Reacting to Noise

There's a reason experienced investors talk about "sleeping well at night" as a portfolio objective. It's not a metaphor. It's a literal description of what good information architecture does for your decision-making.

When I have a global view of my full portfolio — allocation, performance, income, projections — I have a sense of control that no single broker app can provide. Not because the numbers are always good. But because I can see the full picture clearly enough to distinguish signal from noise.

A 5% correction in one position feels different when you can see it represents 2% of your total allocation and its dividend income is unaffected

Context doesn't eliminate volatility. But it eliminates the feeling that volatility is the whole story.


The Practical Test: What Are You Looking at When Markets Drop?

If the answer is your broker app — you're looking at the worst possible information for making a long-term decision. Designed for short-term reaction, updated in real time, stripped of all income context.

If the answer is a spreadsheet — you're looking at stale data you don't fully trust, with no income projection and no global allocation view.

If the answer is a consolidated portfolio view that shows your full allocation, your projected income for the next 12 months, and your performance in your actual base currency — you have what you need to make a rational decision under pressure.

The goal isn't to feel nothing during a correction. The goal is to have enough context that your response is strategic rather than reflexive.

That's what a proper portfolio visualizer does. Not motivation. Not courage. Just the right information, in one place, when you need it.

👉 Get a full view of your portfolio with Snowball Analytics


One Last Thing

I still think about those positions I sold in March 2020.

Not with regret — the decisions made sense given what I could see at the time. That's the point. The problem wasn't fear. The problem was incomplete information making fear the dominant input.

If I'd had a consolidated view showing my full allocation, a dividend calendar showing income arriving regardless of price, and a performance number I actually trusted — I might have held. I might have bought more.

You can't change past decisions. But you can change what you look at before you make the next one.

👉 Start visualizing your portfolio the right way


Looking for technical content for your company? I can help — LinkedIn · kevinmenesesgonzalez@gmail.com

Top comments (0)