I have a list of net returns per (stock) trade. Some of the trades had more than one trade per day. I want to locate the trades by date & add the total returns per date using macros so that it automatically finds the date with multiple trades & adds them up for a net total per date.
I can't seem to get the HTML Maker Excel Add-in to work for me. So I have just gave an example below of what I am working with.
(i.e.)
07/08/03 07:00 $62.36 $640.00
07/10/03 06:58 $62.08 $300.00
07/11/03 07:42 $62.65 $400.00
07/14/03 06:42 $63.50 $180.00
07/17/03 06:56 $61.89 $2,860.00
07/23/03 08:48 $64.36 $580.00
07/24/03 06:38 $64.96 $960.00
07/25/03 06:40 $65.38 ($920.00)
07/25/03 08:28 $65.33 $1,820.00
07/28/03 06:56 $66.22 $2,480.00
07/29/03 06:36 $68.64 ($1,860.00)
07/29/03 07:28 $68.37 ($580.00)
07/29/03 10:30 $68.45 ($20.00)
07/30/03 06:34 $68.90 ($380.00)
07/30/03 09:36 $69.95 ($2,500.00)
(Note: some days have only 1 & other days can have as much as 5-6 per date)
(*Note: there are three columns-1.)date/time....2.)sell price....3.)net profit/loss)
I want to identify the date in the first column & then get a net total per date.
If my explanation is not clear enough let me know. Thanks in advance for any input/help.