FIFO for stock trading

[TK2013]

Hi!

I have been doing this manually for a long time. I have tried several times googling to find if there is any way I can do this in an easier way, but with no success. If you guys know how to formulate this, help me.

I have attached a sample file. Please check that.

Snapshot of the file
FIFO_SAMPLE.png

For this sample file, I sorted the data manually by SCRIP, DATE, TIME. Normally the data won't be sorted this way. It's just DATE wise sorted not by scrip or time. I have posted a snapshot too to view the file right away. I want the numbers in COLUMN L. All the data will be in one sheet, this FIFO formula need to get the information from that sheet and do the calculation.

I will really appreciate some help to find a formula for this.

Thank you.

[TK2013]

BUMP...

Is this possible in excel without getting into macro and VB stuff?