Calculate Stock Market Return Using FiFo Method

[pratiksathe.lhs]

Dear All, I am trying to create excel sheet to calculate return using FIFO method(First in First Out). This means stock purchased first will be sold first. I tried to create the attached file. Request to suggest corrections in the file.
I should be able to just copy past my transactions and excel should calculate what is the return using FIFO method.
Also one concept of opportunity cost is added. If I invest the same in Fixed return instruments then what shall be the return.

 

[vletm]

There are in two cells words return, which one You're trying to calculate?
Which one do You mean?
Suggestion ... something like with Your previous threads solution.