Hi, I have four columns of data and would like to identify:
1-what is the first date a symbol was bought or sold
2-On what dates did the number of shares for that symbol = 0 (like if
we bought 1000 and sold a total of 1000 a few days later)
Does anybody have any thoughts on this? I am at a loss and would love
your input!

Date Symbol Action Shares
12/1/2005 BBB Sell -1200
12/1/2005 FFF Sell -1000
11/30/2005 BBB Buy 400
11/30/2005 AAA Sell -200
11/29/2005 GGG Sell -500
11/29/2005 CCC Sell -1000
11/28/2005 DDD Buy 700
11/28/2005 BBB Sell -200
11/25/2005 GGG Sell -500
11/23/2005 GGG Buy 1000
11/23/2005 FFF Buy 1000
11/23/2005 EEE Buy 1000
11/23/2005 DDD Sell -1000
11/22/2005 CCC Buy 1000
11/22/2005 BBB Buy 1000
11/22/2005 AAA Sell -1000


--
mcarrington
------------------------------------------------------------------------
mcarrington's Profile: http://www.excelforum.com/member.php...o&userid=21641
View this thread: http://www.excelforum.com/showthread...hreadid=492832