I am sharing a simple spreadsheet that I’ve been using for analyzing my breakout trades. Once you have defined your strategy, for every trade setup you can enter the stop and target size and also record it as a win or a loss. The spreadsheet then calculates a few summary stats.
The layout lets you enter a primary and secondary trade each day (in my case I was taking a second breakout in the opposite direction). You can use this to log your actual trades (you'd have to add commissions) or you can simply use it as a statistical analysis tool. I left data populated in the cells to help you understand how they are used. Disclaimer: This is no way, shape, or form is a recommendation or advice of any kind. I am simply sharing a spreadsheet that was requested by our users.
Tips:
This is a Read Only Google spreadsheet but you can make a copy for your own use
You can use this for any instrument - you just have to enter the tick value (in dollars) for your instrument
Ignores slippage and commission - just measures price action
White cells are for data input, shaded cell are formulas
Feel free to modify to your own use
Here is the link to the spreadsheet:
https://docs.google.com/spreadsheets/d/1sx4DVWmUBreIi2CuuMQBDSkY-m77CUN9ZklVTPeXIFo/edit?usp=sharing