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

[Jason101]

Ello,

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.

 

[drtro]

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.