Hi,

I have a list of transactions, with dates, ticker symbols, share counts, prices, etc. that represent trading in a certain portfolio. The transactions are not all 100% buys or sells, sometimes a fraction of a certain stock is sold. I would like to return a list of currently-held securities as-of a certain date, along with the number of shares held.

So for example, I would like to turn

Date Ticker Action Shares
1/5/15 XOM Buy 200
1/5/15 PCP Buy 150
1/6/15 CVX Buy 100
2/5/15 PCP Sell 90
3/23/15 CVX Buy 100
4/6/15 JNJ Buy 45
4/22/15 JNJ Sell 45

into a neat table of...

Ticker Shares
XOM 200
PCP 60
CVX 200
(at time 8/1/15)

Is this do-able, and if so how?

Thanks!