Forum Discussion
Caalculate Profiit and Loss column for multiple buy and sell entries of similar stock
- Jun 01, 2021
mohammed3786 Perhaps the attached sheet helps. I added a column to calculate the averages and changed some formulae. The changes in the TRADE JOURNAL are in the columns/cells with the yellow headers/background.
mohammed3786 Perhaps the attached sheet helps. I added a column to calculate the averages and changed some formulae. The changes in the TRADE JOURNAL are in the columns/cells with the yellow headers/background.
- mohammed3786Jun 01, 2021Copper Contributor
Hi Riny, thankyou for your reply and effort. i was studying the excel sheet and i understood what you have done, however i can you help me address the following query
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 ...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.
so now my overall position on steel authority of inida is -7530. with remaining 400 shares
is thr any way i can show this (-7530) maybe in a different column for every script where I stand ?
So for Steel authority of inida i stand at -7530 after three transactions ....similarly for every other stock..
my other query is ...is the any way I can show the open transactions in yellow and if I sell all the quantities of a particular stock i had...then the row wud automatically turn back to white?
yr input is highly appreciated. Thankyou very much Riny.- Riny_van_EekelenJun 02, 2021Platinum Contributor
mohammed3786 Please see the attached workbook. Added yet another column using two SUMIF functions in one formula. Not sure though it this really does what you want/need.