Trading Journal Excel

Trading Journal Excel

Trading Journal Spreadsheet

What is a Trading Journal?

A trading journal is the book a trader writes about their own trading journey. A trading journal records decisions made in the market so you can see any errors in discipline, risk management, or process. If you can measure it, you can change it. If you are mindful of your behavior you can learn from your own errors and stop making the same mistakes over and over. Traders should be tracking their entries and exits along with their emotions, stress, and position sizing.

Trading Journal Template

Below is a list of the dynamics that should be documented on your trading journal:

  • Date trade opened.
  • Date trade closed.
  • Currency pair, stock, or futures contract.
  • Position size.
  • Direction of trade bet.
  • Entry price.
  • Stop loss.
  • Profit target.
  • Exit price.
  • Risk/reward ratio.
  • Win or loss.
  • Loss size and percentage.
  • Profit size and percentage.
  • Signal.
  • Comments documenting your emotions and any errors in decision making.

Record, learn, adjust, and grow as a trader.

Trading journal template excel free download:

Here is a link to a free trading journal template in Microsoft Excel: Trade Journal.zip  Source