Software/Spreadsheet for recording trades

stillkicking

Member
55 15
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.

Enjoy!
 

Attachments

Last edited:

andysinclair

Newbie
7 0
I suggest building your own spreadsheet (or using a template, there are a lot on the internet). Then find a way to download your historic trade data into the sheet, ideally through some kind of Excel/API integration. Having your own spreadsheet means you can tweak it, add whatever performance metrics etc you like to really give you a good overview of how your trading is progressing.

I'm working on a template at the moment with an API integration. I can post it here when it's ready.
 

HobbyTrader

Junior member
16 0
I used to use a spreadsheet but am currently using https://www.stockportfolioorganizer.com and can highly recommend it. If you only want to track the current value a spreadsheet is free and fine for the task. But as soon as you start adding dividends etc it becomes to cumbersome.