I am trying to figure out how to set up a spreadsheet that can match stock trades using FIFO when there are sells of partial lots and multiple securities listed on the spreadsheet. I do not want a running total for each symbol. I am looking to determine profit and loss per lot sold, so there will be partial lots being sold and added to all day long. By the end of the year, there could be 50 thousand trades on the spreadsheet with some sold the same day and others added and sold months later in various lots. Any help would be greatly appreciated.
I have posted to 2 other boards and received no reply form either:
http://www.ozgrid.com/forum/showthread.php?t=201836
http://www.mrexcel.com/forum/excel-q...sing-fifo.html
Bookmarks