Datewise Balancing Problem
 

I have a large data to handle, but cant manage to get the balancing done
autometically

here is the sample data

i have purchases on different dates and sales on different dates and have to
balance as FIRST IN FIRST OUT basis

like here are the purchases

DATE SCRIP QTY RATE
08/13/2007 OGDC 10,000 120
08/14/2007 OGDC 12,000 121
08/15/2007 OGDC 15,000 119
08/16/2007 OGDC 14,000 122

here are the sales data


DATE SCRIP QTY RATE
08/20/2007 OGDC 5,000 125
08/21/2007 OGDC 8,000 124
08/22/2007 OGDC 7,000 123
08/23/2007 OGDC 4,000 124

wat i need to do is to balance the purchases under FIFO method, data is
large and entered into the sheet thorough a downloaded file

required result is as follows



DATE SCRIP PUR PUR SOLD SOLD BALANCE
QTY RATE QTY RATE QTY
08/13/2007 OGDC 10,000 120 5000 125 5000
5000 124 0
08/14/2007 OGDC 12,000 121 3000 124 9000
7000 123 2000
2000 124 0
08/15/2007 OGDC 15,000 119 2000 124 13000
08/16/2007 OGDC 14,000 122


I have to calculate borrowing cost accumulated on daily basis for the
holding qty on specific rate, I need to calculate how much qty i have on
every date and where the quantity becomes zero.
data is large and have almost 200 transactions daily including both sale and
purchase

any help please !