Help Requested |Stocks Capital Gain_FIFO Method

[Vinay Singal]

Hello Excel Experts

I am trying to calculate the capital gain or in simple words the profit/loss for stocks i trade. The challenge is how can i calculate the profitability when i sell a stock on FIFO basis. I am attaching a sample worksheet with trades for a month. Any help on the calculation is highly appreciated.

Thanks a lot.

PS: Request for a non-macro solution so that i can move things in that case since i dont know coding, but if VBA provides a simple solution, am game for that.

 

[NARAYANK991]

Hi ,

Since an Excel pro need not necessarily be a finance pro or any other pro for that matter , can you work out at least one or two outputs and manually populate the cells in column S ?

Narayan