Trading Journal Spreadsheet | Excel Google Sheets Template | Day Trade Tracker | Crypto Forex Stocks

Track, analyze, and improve your trading performance with an automated Trading Journal Spreadsheet for Excel and Google Sheets. This day trading tracker combines a detailed trade log, interactive dashboard, performance analytics, and trading psychology tracking in one customizable template.

Designed for active traders, the journal helps you turn your trade history into clear performance insights across markets, strategies, timeframes, position types, and emotions.

SMART ANALYSIS

Go beyond simply recording trades. The built-in Smart Analysis section reviews your trading data and highlights important patterns in plain language, helping you identify areas such as:

• Your best-performing timeframe
• Your strongest trading strategy
• Emotional states affecting your results
• Long vs. Short position performance
• Market performance
• Your strongest trading periods

AUTOMATED TRADING DASHBOARD

Enter your trades and let the spreadsheet handle the calculations. The dashboard updates automatically as new data is added.

Track key trading metrics including:

• Total Trades
• Total Net PnL
• Win Rate
• Average Win
• Average Loss
• Profit Factor
• Today’s PnL

ADVANCED PERFORMANCE ANALYSIS

Analyze your trading results from multiple perspectives:

• Strategy Performance
• Timeframe Performance
• Market Type Performance
• Long vs. Short Performance
• Emotional Performance
• Monthly Profit and Loss
• Equity Curve

This makes it easier to see where your trading approach performs well and where results may need improvement.

DYNAMIC FILTERING

Use the interactive dashboard filters to analyze your results by:

• Month
• Market Type
• Instrument
• Position Type
• Strategy
• Emotions

Charts and performance metrics update automatically based on your selected filters.

DETAILED TRADE LOG

Record the information behind each trade, including:

• Trade Date
• Market Type
• Instrument
• Timeframe
• Position Type
• Strategy
• Position Size
• Entry Price
• Exit Price
• Lot Size
• Contract Size
• Exchange Rate
• Fees / Commission
• Emotions
• Notes

The spreadsheet automatically calculates Net PnL, PnL %, and Trade Result (Win/Loss) from your entries.

CUSTOMIZABLE SETTINGS

Customize the trading journal to match your own workflow. Define your preferred:

• Markets and instruments
• Trading strategies
• Timeframes
• Emotional states
• Account currency
• Initial capital

Your customized settings automatically populate the dropdown menus in the Trade Log for faster data entry.

MARKETS

Built for traders working across markets such as:

• Stocks
• Forex
• Cryptocurrency
• Indices
• Commodities

You can also customize the Market Type and Instrument lists based on the assets you trade.

TRADING PSYCHOLOGY TRACKER

Trading performance is not only about entries and exits. Record your emotional state for each trade and compare your results to identify how emotions may be influencing your performance.

EQUITY CURVE

Follow the development of your trading account visually with an automatically updated equity curve based on your recorded results.

COMPATIBILITY

• Microsoft Excel — Excel 2016 or later recommended
• Google Sheets
• Custom currency symbol support
• Instant digital download

WHO IS THIS FOR?

Suitable for:

• Day Traders
• Swing Traders
• Scalpers
• Forex Traders
• Crypto Traders
• Stock Traders

Whether you want a structured trade log, a trading performance tracker, or a complete Excel and Google Sheets trading dashboard, this template is designed to help you organize your trading data and understand your results more clearly.

DIGITAL PRODUCT

This is a digital download. No physical product will be shipped.