• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate Stock Market Return Using FiFo Method


New Member
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.


  • EQUITY RETURN FIFO(3049).xlsm
    68.9 KB · Views: 3
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.