FIFO calculation

[JMattero]

Hello:
I am trying to develop a function for a personal
worksheet project I am workng on.

It would probably be easier to explain if I could post a
small sample worksheet here. Am I allowed to do that?

Anyway, what I have is a list of stock trades (both buys
and sells) for a series of dates. I need to "match off"
buys and sells in a FIFO method for each day's trades. At
the end of that day, I would like Excel to calculate the
profit & Loss on a FIFO basis, for all shares that
were "matched", and then the "unmatched" shares would be
added to the top of the next days trades. Therefore, at
the end of each day, I would have a P&L for the day, and
the amount of "unmatched" shares which would be going to
the next day.

Does anyone have any idea of how I would accomplish this?

If not, can anyone point me in the direction of a book or
website where I might be able to find the answer?

thanks in advance.

Jeff

 

[Bernard Liengme]

Sorry group for the ad!
My book "A Guide to MS Excel for Business and Management" has an example of
FIFO and LIFO as used in depreciation calculations. I expect the example
could be modified
Bernard