StockTrader.com

Online stock trading education and reviews

  • Getting Started
  • Online Brokers
  • Free Stock Charts
  • Education
  • Trading Journals

My Trading Journal (Excel Spreadsheet)

Posted by Blain Reinkensmeyer | Last updated on Dec 27th, 2020 | Published Jan 19th, 2018

2021 UPDATE: Read my guide to the Best Trading Journals tips on how to successfully maintain your journal.

Trading Journal Spreadsheet Download

I’ve had quite a few requests for a copy of the spreadsheet I use for my trading journal. I uploaded it to the server so feel free to download a copy if you’re interested. It’s not the most elegant spreadsheet but it does what I need.

Here’s some details about the columns included:

  • Expectancy: An average of column K (R Multiple). This formula must be modified each day to include the latest rows.
  • Total P&L: Sum of Column J (P&L)
  • Trade #: Just used for some calculations later…
  • L/S: Long or Short
  • QTY: Number of shares
  • Bought: Purchase price
  • Sold: Selling price
  • Initial Risk: Dollars at risk based on the initial stop
  • Comm: Commission for both sides of the trade. I have it set to calculate based on the number of shares entered in column E.
  • P&L: The actual P&L, including commission
  • R Multiple: P&L divided by the Initial Risk
  • % Wins: This is calculated by dividing column R (Sum W/L) by column A (Trade #)
  • Comments: I use this to list errors made on the trade or anything else worth noting.
  • $ at Work: This gives me an idea of how much money was in the position. It’s simply QTY (column E) divided by Bought (purchase price). Note that this is not accurate for shorts but it’s close enough for government work. 🙂
  • % P&L: The percentage return for the trade. P&L divided by $ at Work. Again, not exact for shorts.
  • Initial % Risk: Just tells me how far my stop was from my entry in percentage terms.
  • W/L: Tells whether the trade was a winner (1) or a loser (0). This is used by the next column, Sum W/L.
  • Sum W/L: A running total of the W/L column. This is used in the % Wins column.

Have ideas for how I can improve the spreadsheet? Email me!

2021 UPDATE: Read my guide to the Best Trading Journals tips on how to successfully maintain your journal.

Read Next:

5 Best Free Stock Screeners for 2021Why Day Trading is a Loser’s Game5 Best Free Stock Chart Websites for 2021How to Read Stock Charts (2021 Ultimate Guide)5 Best Trading Journals and How to Journal Successfully41 Best Inverse ETFs (Short ETFs / Bear ETFs)

My name is Blain Reinkensmeyer, and I am the Founder of StockTrader.com. I placed my first stock trade when I was 14, and since then have made over 1,000 more. I am a Partner at Reink Media Group, which owns and operates investor.com, StockBrokers.com, and ForexBrokers.com.

Blain Reinkensmeyer  /  Founder  /  Connect with Me  >  

Popular

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

Why Day Trading is a Loser’s Game

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

5 Best Free Stock Chart Websites for 2021

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

5 Best Trading Journals and How to Journal Successfully

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

How to Read Stock Charts (2021 Ultimate Guide)

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

Sponsored: Commission-free equities & options + Best trading technology

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

How to Invest (2021 Beginners Guide)

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

5 Best Free Stock Screeners for 2021

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

25 Best Long ETFs (Bullish ETFs) in 2021

41 Best Inverse ETFs (Short ETFs / Bear ETFs)

10 Great Ways to Learn Stock Trading in 2021

  • linkedin
  • twitter
  • facebook
  • About
  • Contact
  • TERMS OF USE
  • Disclosures
  • Privacy Policy

StockTrader.com (Reink Media Group) is not an investment advisory service, or a registered investment advisor or broker-dealer and does not purport to tell or suggest which securities customers should buy or sell for themselves.  The analysts and employees or affiliates of StockTrader.com may hold positions in the stocks or industries discussed within the Website.  You understand and acknowledge that there is a very high degree of risk involved in trading securities.  StockTrader.com has advertising relationships with some of the offers listed on this website. While StockTrader.com makes a reasonable effort to keep any listed information updated, it does not and cannot guarantee the accuracy or applicability of any information in regard to your individual circumstances. Past performance is not indicative of future returns.

Back to Top

©2021 Reink Media Group LLC · All Rights Reserved