I'm sharing my spreadsheet that I have developed to help me track my TradeBooks and visually show me what I might be doing wrong. I am no excel expert, I'm actually terrible at it, but I have been working on this for awhile. I'm sharing for anyone else to use as their own. Make adjustments that suit you, or use them the same as I do.
TradeBookTracker.xlsx
This is an example of what it looks like once you start putting trades in.
I have a tab for each TradeBook I have, long and short separated.
I use the Sharpe,Accuracy,Rs tab for all trades for the day. So if I had 4 Mountain Passes and 2 Parabolics, the first tab would have all of them added together.
Below is the template I use for each individual trade review. I actually print every trade and put it in a 3 ring binder. I have a binder for each TradeBook with a long and short tab in each.
Templates - Microsoft OneNote Online (live.com)
Here is a screenshot of my OneNote review page, again, each TradeBook has it's own tab.
Like I said, I'm terrible with this stuff, so I hope I shared this properly for all to be able to use.
Feel free to ask any questions, or let me know what you have changed.
I would like charts added like running P&L, but I couldn't figure it out.
I would also like the top line to scroll down when I move down the page so I know what the columns are.
You can just delete the indicators and put in the ones you use with your TradeBook.
All feedback is appreciated and welcomed.
EDIT, I updated with a link that is not editable, you will need to save a copy to use it.