Calculate Biggest Profit & Loss Day

[vegaaltair]

So I have a range of bets that I would like to summarize by having a cell display the most amount of money won and another showing money loss on a single day and for it to constantly calculate the biggest amount. What would be the best approach for this?

The data is formatted like below.

Date	Selection	Bet Type	Stake	Odds	Win	At Risk	Payout	Profit / Loss
14-Jan-15	One With Bling	Winner	20	6	Y	20	120	100
14-Jan-15	One With Bling	Place	160	2.25	Y	160	360	200
15-Jan-15	Dance Mindy Dance	Winner	77	2.3	N	77	0	-77
15-Jan-15	Zilch	Place	59	4.4	Y	0	200.6	200.6

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody></tbody>

 

[oldbrewer]

=max(a1:a10) finds the biggest number, min the smallest

 

[vegaaltair]

Yeh I need to somehow figure out the max profit from winning bets but have the formula stop adding when the date changes which is my problem everything seems to get more difficult when you use dates.

 

[oldbrewer]

				1	8	-20	33	21
01/01/2014	1	7		13	15	-30	44	22
01/01/2014	1	13		12	-10	-40	55	23
01/01/2014	1	12
02/01/2014	2	8
02/01/2014	2	15
02/01/2014	2	-10
03/01/2014	3	-20
03/01/2014	3	-30
03/01/2014	3	-40
04/01/2014	4	33
04/01/2014	4	44
04/01/2014	4	55
05/01/2014	5	21
05/01/2014	5	22
05/01/2014	5	23
				1	2	3	4	5
				01/01/2014	02/01/2014	03/01/2014	04/01/2014	05/01/2014
			max	13	15	-20	55	23
			min	1	-10	-40	33	21
				this macro groups your results into days
				and for each day lists all the amounts
				the lower table merely lists the min and max amount for each day
				Dim n(6, 15)
				n(1, 1) = Cells(2, 2)
				Sum = 2
				x = 1
				Count = 1
				25 Sum = Sum + 1: If Sum > 16 Then GoTo 100
				If Cells(Sum, 2) = Cells(Sum - 1, 2) Then Count = Count + 1: n(x, Count) = Cells(Sum, 3): GoTo 25
				x = x + 1: Count = 1: n(x, Count) = Cells(Sum, 3): GoTo 25
				100 colnum = 5
				For k = 1 To x
				For p = 1 To 15
				Cells(p, colnum) = n(k, p)
				Next p
				colnum = colnum + 1
				Next k
				150 End Sub

<colgroup><col><col span="3"><col><col><col><col><col><col span="6"></colgroup><tbody>
</tbody>