How can i add scaling in and out of trades into my trading journal on excel/Google Sheets

So i created very basic journal for myself… But it only works with linear trades. I don’t know how can i calculate avg entry price of a trade and sometimes i exit in pieces instead of full position. How can i add that to my google sheet? I saw one video in which he fixed it but ofc that template is paid. and i couldn’t find anything like it anywhere…
As you can see here. Its with timestamp. Below is my journal screenshot.
I made this only for intraday Stocks. you can use it if you like :slight_smile:


You can try using AnaStrat - www.anastrat.com

Think about trade analytics or trading journal, and I’m sure we’ll serve everything under it. You can start with a 30 day free trial.

Log in with kite, upload your tradebook and there you go!
We’re working on a seamless way to fetch your trades automatically. Shall update on it soon!

1 Like