DEV Community

Otto
Otto

Posted on

I Tracked Every Trade in Notion for 30 Days — Here is What I Learned

I used to trade on vibes.

Good week? Genius. Bad week? "Market was weird." No real data, no patterns, no accountability.

Then I built a trading journal in Notion. Tracked every single trade for 30 days. What I found surprised me.

Why Most Traders Don't Journal

Be honest: have you ever kept a consistent trading journal?

Most people try once, give up in week two. The friction is too high. Spreadsheets feel like work. Apps cost money. You just want to trade.

But here's the thing: the journal is where the money is.

What I Tracked

Every trade got one row with:

  • Date + time (when did I enter?)
  • Asset (BTC, ETH, stocks — doesn't matter)
  • Direction (long/short)
  • Entry price / exit price
  • Position size + risk % (never more than 2% of portfolio)
  • Reason for entry — the important one
  • Emotional state (calm / anxious / FOMO / revenge)
  • Result (P&L in € and %)
  • Lesson — mandatory, even if positive

That last field — the lesson — is what changed everything.

What 30 Days of Data Revealed

After 30 days I had 47 trades logged. Here's what the data showed:

Pattern 1: My Tuesday trades were 40% worse than average.
No idea why. Maybe I check too much news Monday evening and trade noise on Tuesday.

Pattern 2: When I wrote "FOMO" in the emotional state field, I lost money 71% of the time.
Not 51%. 71%. That's not noise — that's a rule. If I feel FOMO, I don't trade.

Pattern 3: My best trades all had one thing in common.
The "reason for entry" was one clear sentence. My worst trades? The reason field had 3 lines of justification.

If you need to convince yourself, the trade isn't there.

The Notion Setup

I use a simple database with these views:

  1. All Trades — default table view, add new rows here
  2. P&L by Week — grouped by week, sum of results
  3. Win Rate by Asset — which coins/stocks actually work for me
  4. Emotional Audit — filter by emotional state to find my patterns
  5. Monthly Dashboard — charts for total P&L, win rate, average R/R

The key properties are all there. The setup takes maybe 2 hours if you're building from scratch.

The Psychological Shift

The journal changes how you trade before you open a position.

Knowing you'll have to write down your reason — and the emotional state — makes you pause. You start asking: would I be comfortable seeing this in my journal?

That pause has saved me from more bad trades than any indicator or strategy.

Want the Template?

Building the Notion database from scratch is doable but takes time to get right. I structured mine with all the properties, formulas for automatic P&L calculation, and the 5 views that actually matter.

👉 Trading Journal Pro — Notion Template (€19.99) — plug in your trades immediately, skip the setup.

Also: if the psychological patterns resonate — the FOMO, the revenge trades, the overconfidence after a good week — I wrote a full guide on trader psychology.

👉 La Psychologie du Trader (FR) — €12.99 — 35 pages on the mental game of trading.


The market doesn't care about your feelings. But your journal will show you where they're costing you money.

Start tracking.

Top comments (0)