Software/Spreadsheet for recording trades

Dec 4, 2018
I only trade stocks and I use Excel.

I created a spreadsheet that performs calculations for me. It's a work in progress but helps me keep track of my deposits, trades, days in play, profit/loss, trade type, etc.

I have attached the Excel file if anyone wants to try it out. It goes down 100 rows. After that you will have to copy and paste the formats and formulas.

I have filled in two lines so you can see how it works. Highlight and delete to remove those. The Trade Type will say Day until you add the sell date. If more than the same day it will change to Swing. Still working to get that to stay empty until sell date added.



Last edited:
Jul 20, 2015
Traders are great at disagreeing. They disagree on everything from trading strategies to ways of measuring profitability. But there’s one thing that all successful traders agree on, and that is maintaining a trading journal that records your trades.