How to find the AvgPrice, Realized and UnRealized Pnl based First in First Out Transactions

Occasional Visitor

I have set of transactions from the Trades I have did. I would like to calculate the AvgPrice, Realized and UnRealized Pnl based on the First in First out Transactions. I have attached excel sheet with sample data set. Could some excel expert guide me. https://1drv.ms/u/s!Apd1qo0T_FSmgV6zbBGKYIq45k2V?e=EaIxyY 

0 Replies