HomeSeparatorInsightsSeparatorFearless InvestorsSeparator
The Spreadsheet That Saved My Sanity
Tactical Tools & Investor Systems

The Spreadsheet That Saved My Sanity

How a simple dashboard gave me more clarity than any financial advisor ever did.

July 1, 2025
Neil Winward

Author:

Neil Winward

|

Founder and CEO

of

Dakota Ridge Capital

Book a free energy consultation

here
    The Spreadsheet That Saved My Sanity
    Join our Fearless Investor community

    How a simple dashboard gave me more clarity than any financial advisor ever did.

    Let’s be honest:

    Most of us didn’t get into investing to babysit our money.

    We got into it to build freedom. Wealth. Control.

    But somewhere along the way, we handed that control to someone else—usually an advisor charging 1% to do things we barely understand.

    For a while, I was okay with that.

    Until one day I realized:

    I couldn’t answer the most basic questions about my portfolio.

    • What’s my exposure to energy?
    • How much of my cash is earning yield?
    • How did I perform last quarter?

    I had no clue.

    I was rich in spreadsheets for everything—sales, taxes, planning. But when it came to my money?

    Crickets.

    The Turning Point

    After ditching my financial advisor, I set up a new account. Transferred assets. And for the first time in years, looked under the hood.

    It was a mess.

    I didn’t want fancy software.

    I didn't want Al-generated dashboards (although I constantly audition applicants for the position-and may be getting close).

    I just wanted something simple. So I opened Google Sheets.

    What My Spreadsheet Tracks (and Why)

    This dashboard isn’t complex. But it’s effective.

    Here’s what I include:

    1. Asset Allocation by Type

    • Hard Assets (Gold, Real Estate, Bitcoin)
    • Equities (Value vs. Growth)
    • Cash & Short-Term Debt
    • Trades or Alternatives

    → This shows me how exposed I am to each theme. Every time I update it, I learn something.

    2. Sector Breakdown

    • Energy
    • Tech
    • Healthcare
    • Financials
    • Utilities

    → Helps me see if I’m unintentionally overweighted. Especially important when chasing trends.

    3. Account Balances & Yield

    • Total cash balance
    • Yielding vs. non-yielding accounts
    • Broker, custodian, wallet info

    → Shows me if I’m leaving lazy money on the table.

    4. Performance (Monthly/Quarterly)

    • % change by asset class
    • Notes column for major wins/losses
    • Macro conditions during the period

    → This keeps me from overreacting to one bad day—or celebrating one lucky trade.

    5.  Investment Thesis Column

    For every major position, I write:

    • Why I bought it
    • What will trigger me to sell
    • What I believe that others don’t

    → It’s my personal guardrail against emotional decisions.

    Why This Matters

    Without a system, you’re flying blind.

    With one, you stop asking, “What’s going on with my money?”

    Because the answer is right in front of you—on your terms.

    You become your own CIO.

    You stop outsourcing thinking.

    You start making decisions with data, not vibes.

    Don’t Confuse Simplicity With Weakness

    People assume systems need to be sophisticated.

    In reality, the more successful the investor, the simpler their system.

    You don’t need Bloomberg terminals. You need clarity.

    This spreadsheet saved my sanity—not because it made me smarter…

    …but because it made me accountable.

    Want My Template?

    ✅ I share my exact dashboard, plus a walkthrough of how to use it, inside the Fearless Investor community.

    📞 Or if you’re sitting on lazy capital and don’t know how to shift toward real-world, high-conviction investments like energy…

    👉 Book a strategy call with Dakota Ridge Capital

    Agency Representative

    Your Energy Partners

    We help banks, family offices, HNWIs, non-profits-and developers in making strategic investments in clean energy projects that create tax credits to lower investors’ taxt liability while providing essential capital for developers.

    • Clean Energy Capital
    • Clean Energy Project Advisory
    • Clean Energy Tax Savings
    Book a Call

    Final Thought

    Don’t wait until the next market crash to realize you were flying blind.

    You don’t need another expert. You need a system.

    And yes—sometimes it starts with a spreadsheet.

    Click here to join our FI community.

    Help others learn, click to share
    This article is part of our
    Tactical Tools & Investor Systems
    series.
    View all →
      Neil Winward

      Neil Winward is the founding partner of Dakota Ridge Captial, helping investors, developers, banks, non-profits, and family offices unlock massive tax savings - on average of 7%- 10% - via clean energy investments by fully leveraging U.S. government incentives such the Inflation Reduction Act.

      BOOK A CALL

      READY TO TAKE ACTION ON YOUR ENERGY PROJECT? BOOK A COMPLIMENTARY, ZERO-OBLIGATION CONSULTATION TO SEE HOW WE CAN HELP YOU.

      Book Here
      Vectorvector
      Tactical Tools & Investor Systems
      3

      Timing: The Smartest Sounding Nonsense in Macro Investing

      Neil Winward

      Timing isn’t everything, but without it, you’re just guessing.

      Let’s talk about timing—the most slippery, seductive, and ultimately useless word in most macro commentary.

      If you’ve ever heard a macro analyst say something like:

      “We’re entering a stagflationary regime…”

      Or:

      “Gold is setting up for a major move…”

      But then fail to give any clear timeframe, you’re not alone.

      That’s not insight. That’s intellectual performance art.

      Let’s unpack why timing—when abused—is the biggest weasel word in investing, how to spot the difference between insightful and empty macro analysis, and who gives you something useful to work with.

      Trend Without Timing = Commentary Without Consequence

      Anyone can call a trend.

      • “Inflation is coming.”
      • “A crash is inevitable.”
      • “Oil will break out.”

      But without a timeframe? It’s worthless.

      Even a broken clock is right twice a day.

      Eventually, everything happens.

      So when someone says “gold is due to explode” without saying when, they’ve set up the perfect con:

      • If gold goes up tomorrow: “Told you so.”
      • If it goes down: “Just wait.”
      • If it does nothing: “It’s building energy.”

      That’s not forecasting. That’s marketing.

      It’s commentator fraud—a way to sound smart without being held accountable.

      Why This Happens (And How It Hurts You)

      Macro is seductive because it deals in big ideas.

      But big ideas without tactical timing are dangerous.

      Why?

      Because:

      • You move too early and sit through pain.
      • You move too late and miss the gain.
      • Or worst of all—you don’t move at all.

      Smart analysis without execution clarity leads to hesitation.

      And in markets, hesitation = decay.

      Following Is Harder (And More Useful) Than Predicting

      There’s a harsh truth many macro commentators don’t admit:

      Predicting trends is easier than trading them.

      • Saying inflation might spike is easier than positioning for it early—and surviving the pain if you’re wrong.
      • Saying the Fed will pivot eventually is easier than calling when, and what that means for your portfolio today.

      The people who provide actual value aren’t the ones who predict the future.

      They’re the ones who help you recognize when the future starts showing up.

      Think of it like surfing.

      “Surf’s up… sometime this week” is no help if you’re paddling out now.

      You need someone who can say, “Look at the swell—get ready to catch the next wave.”

      How to Sort the Helpful From the Headliners

      So how do you tell who’s legit—and who’s just performing macro theater?

      Here are a few filters that help:

      • Do they timestamp their calls?
        If they say “recession incoming,” do they specify Q3 2025—or just leave it vague?
      • Do they publish model portfolios or asset weightings?
        If they’re not willing to show how their view translates into action, skip them.
      • Do they show track record, not just soundbites?
        Many macro accounts go viral with “charts that scare you.” But few show what happened next.
      • Do they help you adapt—or just forecast?
        The best analysts help you respond, not just predict. They focus on risk management, positioning, and signals—not just grand theories.

      So How Do You Forecast Without Fooling Yourself?

      1. Follow Signals, Not Headlines

      Headlines are lagging indicators.

      Signals—like liquidity trends, rate movements, fiscal flows—tell you what’s coming.

      Learn which indicators have predictive power in your time horizon.

      Start simple:

      • Real yields → where gold is likely heading
      • ISM/PMI data → where cyclical sectors may go
      • Credit spreads → risk-on vs risk-off environment
      • Dollar strength → international risk appetite

      The more you track these over time, the more you’ll learn how markets react to them—not just what they say.

      2. Use “If–Then” Forecasting

      Stop asking “what will happen?”

      Start asking:

      “If X happens, then Y is likely.”

      Examples:

      • “If CPI comes in hot, then bond yields rise, and long-duration tech sells off.”
      • “If the Fed cuts while unemployment is low, gold likely rallies as real rates fall.”

      This gives you conditional clarity, not false certainty.

      3. Keep a Forecasting Journal

      Track what you thought would happen, when, and why.

      Then revisit it weekly or monthly.

      Ask:

      • Was I early or late?
      • Did I act or freeze?
      • Was my reasoning sound—even if the outcome wasn’t?

      This builds forecasting muscle over time.

      You stop being a passive consumer of macro narratives and become an active observer of your own decision-making.

      4. Use Time Windows, Not Dates

      No one knows the exact week things will flip.

      But you can estimate windows of risk/reward.

      Instead of saying, “There will be a recession in Q3,” say:

      “The window for rising recession risk opens between Q3 and Q4 if these conditions persist.”

      This way, you give yourself room to observe and act with flexibility—not panic when it doesn’t land on your calendar.

      5. Use Probabilities, Not Absolutes

      Markets run on odds, not certainties.

      Instead of “rates will fall,” say:

      “There’s a 70% chance the Fed cuts by September if unemployment ticks up again.”

      This mindset keeps you adaptive.

      You’ll adjust with new information rather than cling to a dead thesis.

      6. Plan With Frameworks, Act With Discipline

      The best investors don’t guess better.

      They react better.

      Build a framework that reflects your macro views—but implement it with predefined rules.

      • Rebalance when your asset weights drift 5-10%
      • Shift allocations if liquidity conditions or yield curves change
      • Reduce exposure when downside probability > upside payoff

      This lets you stay macro-aware without overtrading or overthinking.

      It’s Easy to Get Lost So Keep It Simple

      There are countless macro voices and data points. You can drown in them.

      What matters is how you use them.

      Don’t aim to be the most informed investor.

      Aim to be the most prepared.

      • Prepared to act when signals align
      • Prepared to wait when things are unclear
      • Prepared to review and revise when you’re wrong

      That’s what separates a strategist from a spectator.

      Final Thought: Time Is a Tool, Not a Trap

      The irony?

      Timing does matter.

      But only when used responsibly.

      • It matters when you rebalance.
      • It matters when macro signals shift.
      • It matters when risk/reward becomes asymmetric.

      But it’s useless when wielded as a vague shield for bad forecasting.

      The best investors don’t try to predict exactly when something will happen.

      They stay close to the signals.

      They track the data.

      They know that conviction plus patience beats prediction every time.

      📈 Want a portfolio that responds to macro signals instead of gambling on timing?

      Book a call with Dakota Ridge Capital

      Want to surround yourself with other clear-eyed investors?

      Join the Fearless Investor Community

      Read More
      IRA Broacher
      IRA Report To Smarter Investing
      Unlock the Opportunities of the Inflation Reduction Act!​ Are you ready to stay ahead in today's shifting economic landscape? Our comprehensive white paper breaks down the Inflation Reduction Act and reveals the key benefits, incentives, and strategies your business needs to capitalize on. Learn how to optimize your financial planning, leverage tax credits, and position your company for sustainable growth.
      Pre-order now to get the insights and actionable steps that can give your business a competitive edge.
      New Version Release Date: 12/10/2024
      Thank you! Your submission has been received!
      Oops! Something went wrong while submitting the form.
      Close icon