Excel Trade log/journal with Pyramiding, Partial exits, Scaling out and Trailing stop


Experienced member
1,372 215

Just thinking out loud really about how to keep a trade log spreadsheet neat and simple and not to long winded whilst still including - Partial exits, Trailing stops and Pyramiding.

Any ideas or examples would be appreciated.
Last edited:


Active member
216 21
I count the second I long or short a share to the second I'm flat again one trade.

So say I long 100 shares at $50, then another 100 at $51, then sell 50 at $50.50 then go flat at $51.20, I'd count that all as one trade and calculate the average execution price and exit price.
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock