How I Cut My Emotional Trades by 80% Using a Google Sheets Investment Thesis Template

As a retail investor managing a 6-figure portfolio, I had a problem: I was making too many emotional decisions.
Buying the hype, selling the panic. My returns suffered.

The fix was brutal simplicity: force myself to write down my investment thesis before buying anything.

The 15-Question Litmus Test

Before any purchase, I now run through this checklist:

1. Business model in 5 lines
2. Competitive moat (Porter's 5 Forces)
3. Revenue growth trajectory
4. Profitability metrics
5. Debt and cash flow health
6. Insider behavior
7. Management quality
8. Valuation vs history
9. Catalysts with timelines
10. Exit strategy pre-defined
11. Risk factors identified
12. Opportunity cost considered
13. Conviction score

The Spreadsheet That Changed Everything

I built a Google Sheets template that automates this whole process. Four tabs:

• Thesis Builder (structured entry)
• Tracker Dashboard (win rate, alpha)
• Research Checklist (15-point system)
• Performance Log (benchmarked vs S&P 500)

The formulas calculate upside/downside automatically. Conditional formatting shows green for high-conviction ideas, red for risky ones.

After 12 months using this system: 82% win rate on exited positions, average 23% annualized return, and significantly less stress.

If you want to skip the 3 hours of building this yourself, I put the exact template on Gumroad for $25. Instant download, works in 5 minutes.

Grab it here: Investment Thesis Template

What system do you use to track your investment theses? Share in the comments!