this loss of (-832.5 in S13) is a part of the -8362.5.( this -832.5 is realised out of -8362.5).i hope I'm making sense. In the excel attached i have tweaked a little to show the "SELL "action p/l as realised P/L in the S column.lets consider the three transactions on rows 8,10 n 13.the idea is the first two buy transactions of Steel authority of India gives me a loss of ((-3100-5262.5=-8362.5).now when i SELL Steel authority of India in the 13th row. i was studying the excel sheet and i understood what you have done, however i can you help me address the following query Your assistance is greatly Riny, thankyou for your reply and effort. My ultimate goal is to calculate the my current profit or loss (based on individual transactions) hope i make sense. Feel free to edit the excel sheet if needed.
#STOCK PROFIT CALCULATOR EXCEL HOW TO#
i only enter my exit price and exit quantity.to calculate the P/L the buy price shud be the average of all the entry prices of that particular stock before corresponding to the buy quantities.May be i wud need to segregate my P/L by realised and unrealized.can anybody please help me out in how to go about it. but when I'm selling (SELL) In line 13, I'm afraid this logic will not work. The are multiple "buy" stocks initially and if you can see the in column Q i was able to calculate the current profit and loss by subtracting my entry price from the live current trading price * quantity. how do I get the profit/ loss (for that particular sell quantity) based of on multiple buy of that stock before.įor example in my below attached excel on sheet - "TRADE JOURNAL " comprising multiple quantities.and I'm calculating the profit/ loss by subtracting my entry point from the actual live market price.(*quantity)īut my issue is when Im selling a particular stock. I have multiple buy entries of one stock. i am currently working on a work system for my trading and I'm stuck at this point.
0 kommentar(er)
