Skip to main content
Making Your First Trade

Keeping a Trade Log

Pomegra Learn

Keeping a Trade Log

A trade log is a simple spreadsheet that records every trade: when you bought, what you bought, how much you paid, why you bought it, and how long you intended to hold. It becomes invaluable for taxes, learning, and understanding your own behavior.

Key takeaways​

  • A trade log forces you to articulate your investment thesis before you buy, not after.
  • The log provides a record for capital gains taxes (purchase price, sale price, holding period).
  • By reviewing past trades, you spot patterns: emotional decisions, overtrading, successful timing.
  • A minimal log requires only five columns: date, ticker, quantity, price, and reason.
  • You can build it as a simple spreadsheet (Google Sheets, Excel) or use your broker's built-in tools.

Why keep a trade log?​

For a buy-and-hold investor who makes 2–3 trades per year, a trade log might seem like overkill. But even infrequent traders benefit:

  1. Forced articulation of your thesis. Before you buy, you write down why. This single act—writing a sentence—filters out impulsive purchases. If you cannot articulate a reason, you probably shouldn't buy.

  2. Tax reporting. When you sell, you need to know the original purchase price and date to calculate capital gains. A log eliminates the need to dig through broker statements from years past.

  3. Learning from mistakes. Did you sell winners too early? Hold losers too long? By reviewing your log, you notice patterns in your behavior and can correct them.

  4. Distinguishing good luck from good judgment. A trade that profits is not automatically a good trade. If you bought based on a coin flip and got lucky, the log reminds you that your process was unsound.

  5. Rebalancing documentation. When you rebalance your portfolio, a log clarifies why (e.g., "Annual rebalance per 60/40 rule" or "Tax loss harvest USD 200").

What to track in a minimal log​

At a minimum, log these five pieces of information:

  1. Date. The date you submitted the trade order (not the settlement date).
  2. Ticker. The security symbol (VTSAX, VOO, BND, etc.).
  3. Action. BUY or SELL.
  4. Quantity. Number of shares or dollar amount.
  5. Price. The price per share you paid (or received if selling). Your broker's confirmation will show this.

Optional but valuable additions:

  1. Commission/Spread. The total cost of the trade (commission + estimated spread).
  2. Account. Which account (taxable, Roth IRA, etc.).
  3. Reason. A brief note on why you traded (e.g., "Initial investment," "Rebalance," "Tax loss harvest," "Dividend reinvestment").
  4. Intended Hold Period. How long you expect to hold (e.g., "20 years," "Until rebalance," "Until next review").
  5. Notes. Any additional context (e.g., "Replaced VTV with VTSAX to reduce fees").

Example trade log​

Here is a simplified example in spreadsheet format:

Date       | Ticker | Action | Quantity | Price  | Reason                      | Account
-----------|--------|--------|----------|--------|-----------------------------|-----------
2024-03-15 | VTSAX  | BUY    | 19.04    | 262.43 | Initial Roth IRA deposit    | Roth IRA
2024-06-20 | VXUS   | BUY    | 25.5     | 107.82 | Rebalance 60/40             | Roth IRA
2024-09-10 | BND    | BUY    | 47.2     | 74.15  | Bond allocation (10%)       | Taxable
2025-01-15 | VTV    | SELL   | 10       | 189.23 | Tax loss harvest (loss $50) | Taxable
2025-01-15 | VTSAX  | BUY    | 3.8      | 267.50 | Tax loss harvest replacement| Taxable

A more detailed version:

Date       | Ticker | Action | Qty   | Price  | Commission | Account    | Reason                   | Hold Period | Notes
-----------|--------|--------|-------|--------|------------|------------|--------------------------|-------------|----
2024-03-15 | VTSAX  | BUY    | 19.04 | 262.43 | 0.00       | Roth IRA   | Initial contribution     | 25+ years   | Annual $7k limit
2024-04-20 | VTSAX  | BUY    | 5.1   | 258.90 | 0.00       | Roth IRA   | Monthly savings plan     | 25+ years   | $250/month
2024-06-20 | VXUS   | BUY    | 25.5  | 107.82 | 0.01       | Roth IRA   | Rebalance to 60/40 US/Int| 25+ years   | Adjust allocation
2024-09-10 | BND    | BUY    | 47.2  | 74.15  | 0.00       | Taxable    | Bond allocation (10%)    | 20+ years   | Taxable interest
2025-01-15 | VTV    | SELL   | 10    | 189.23 | 0.00       | Taxable    | Tax loss harvest         | 7 months    | Loss: $50
2025-01-15 | VTSAX  | BUY    | 3.8   | 267.50 | 0.00       | Taxable    | Tax loss replacement     | 20+ years   | Avoid wash-sale (VTI sub)

How to structure a trade log​

Option 1: Spreadsheet (Google Sheets, Excel)​

Pros:

  • Simple to set up.
  • Works offline.
  • Easy to sort and filter.

Cons:

  • Manual data entry (prone to transcription errors).
  • Needs backup (cloud or external drive).

How to start:

  1. Create a new Google Sheet or Excel workbook.
  2. Add column headers (Date, Ticker, Action, Quantity, Price, Reason, Account).
  3. After each trade, add a row with the details from your broker's confirmation.
  4. Optionally, add formulas to calculate total cost (Quantity × Price), gains/losses, or tax summaries.

Option 2: Broker's built-in tools​

Pros:

  • Data is automatically populated from your trades.
  • Integrated with your account.
  • No manual entry needed.

Cons:

  • Limited customization.
  • May not include reason or hold period.

Available tools:

  • Fidelity: "History" tab shows all trades. You can download as CSV.
  • Charles Schwab: "Positions" and "Trade History" show purchases and sales.
  • Vanguard: "Transaction History" lists all trades.
  • Interactive Brokers: "Account" → "Reports" → "Trades" for detailed trade logs.

Option 3: Portfolio tracking software​

Pros:

  • Automatic sync with brokers (many).
  • Performance calculation.
  • Tax reporting.

Cons:

  • May charge a fee.
  • Requires sharing broker credentials (security concern).
  • Overkill for a beginner.

Examples:

  • Sharesight: $4/month. Tracks trades, calculates capital gains, and generates tax reports.
  • Betterment: Built-in tracking for Betterment accounts.
  • Personal Capital: Free for basic tracking; paid tier for advanced features.

For a first-time investor, a simple Google Sheet is enough.

What to do with your trade log​

At tax time​

When you sell a security in a taxable account, you need to know:

  • Purchase date. For short-term (under 1 year) vs. long-term (over 1 year) capital gains tax rates.
  • Purchase price. To calculate the gain or loss.
  • Sale date and price. To calculate the gain or loss.

Your trade log provides all three. Total gain/loss = (Sale Price × Quantity) – (Purchase Price × Quantity) – Commissions.

Example:

  • Buy: 10 shares at $100 = $1,000.
  • Sell: 10 shares at $120 = $1,200.
  • Gain: $1,200 – $1,000 = $200.
  • If held over 1 year, this is a long-term capital gain (favorable tax rate).

Your tax software (TurboTax, H&R Block) will ask for these details. Having a trade log saves you hours of digging through broker statements.

At review time (quarterly or annually)​

Every 3–6 months, review your log and ask:

  1. Am I sticking to my plan? If you intended to buy-and-hold for 20 years, but you sold after 6 months, did something change in your thesis?
  2. Are my trades aligned with my goals? If your goal is to build a diversified portfolio, but you are buying individual stocks, are you in the right account?
  3. Am I noticing patterns? Do I sell winners too early? Do I hold losers too long? Do I overtrade?
  4. What would I do differently? Reflect on each trade: was it a good decision, even if it lost money?

Example: Learning from your log​

Suppose your log shows:

Date       | Ticker | Action | Reason              | Holding Period
-----------|--------|--------|---------------------|----------------
2023-06-15 | ARKK   | BUY    | Hot tech ETF (FOMO) | Sold 3 months later at loss
2023-10-20 | QQQ    | BUY    | Hot tech ETF (FOMO) | Sold 2 months later at loss
2024-02-10 | VOO    | BUY    | Boring S&P 500      | Still holding (up 8%)
2024-08-01 | VTSAX  | BUY    | Diversified US      | Still holding (up 3%)

Pattern: You buy trendy, hot funds on FOMO, sell them at losses, and your boring index fund holdings are up. Lesson: Stick to the boring strategy.

A trade log makes this pattern visible. Without it, you might keep repeating the same mistake.

Minimum viable log template​

If you want to start super simple, here is a one-page template:

TRADE LOG – [Your Name] – [Year]

Date     | Ticker | B/S | Qty    | Price | Account    | Why?
---------|--------|-----|--------|-------|------------|----
         |        |     |        |       |            |
         |        |     |        |       |            |
         |        |     |        |       |            |
         |        |     |        |       |            |

B = Buy, S = Sell

Print this, keep it on your desk, and handwrite entries as you trade. At year-end, transfer to a spreadsheet.

Process for documenting a trade​

Next​

Your trade is logged and documented. The final step is a post-trade checklist to ensure everything is in order: confirmation received, positions correct, and next steps clear.