Excel Sheet For Calculation Of Profit By FiFo Method

[pratiksathe.lhs]

Hello, I have tried to create excel for calculating profit of particular stock using fifo method. But the results are not coming as expected. Need your help to suggest excel file or formula.
FIFO cost =SUMPRODUCT((-SUMIF(B$2:B7,"<0")>SUMIF(OFFSET(B$1,,,ROW(B$1:B6)),">0"))*(-SUMIF(B$2:B7,"<0")-SUMIF(OFFSET(B$1,,,ROW(B$1:B6)),">0"))*(C$2:C7-N(+C$1:C6)))-SUM(E$1:E6)
FIFO Gain =IF(B7>0,0,-B7*C7-E7)
Alpha return= Capital Gain rate- Bank rate

 

[vletm]

pratiksathe.lhs​

What are expected results?
What are results, which You get with some data?
Did You explain somewhere - what is FIFO?

 

[pratiksathe.lhs]

Sir, I want to calculate profit on shares using FIFO (first in first out) method. Share purchased first can be sold first. Calculations given by all stock brokers are usually present on Average cost method. I have attached one excel working where I tried to calculate but its not working. I have also given sample of expected results.
Outcomes- 1. Absolute Return on shares using FIFO method.
2. Alpha return on shares using FIFO method.
3. Annualized return for each stock sold.
4. FIFO cost of holdings.
Thanks in advance for support..!!

 

[vletm]

pratiksathe.lhs​

Sure that You explained something which should be clear for You ...
I gotta guess many things and I could offer something like this green range.

 

[vletm]

... or something like below could show more ... ?

 

[pratiksathe.lhs]

Thank you for reply. Attached detailed sheet.

 

[vletm]

pratiksathe.lhs​

Your above file has different details than Your original thread as well as Your #3 reply file.
This seems to be different case now.
You should open a new thread for that.