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  Source

Trading Journal Excel

By Steve Burns

After a lifelong fascination with financial markets, Steve began investing in 1993 and trading his accounts in 1995. It was love at first trade. After more than 30 successful years in the markets, Steve now dedicates his time to helping traders improve their psychology and profitability. New Trader U offers an extensive blog resource with more than 4,000 original articles, online courses, and best-selling books covering various topics.