Coinflipping charts.

[Ramballah]

Hello everyone,

Today I want to make a sheet that contains all the information about coinflips. I am playing a game where coinflipping is a thing and i'm quite addicted to it. Now there is kind of a tactic to get good guesses at it and a big help would be tracking down information. However I dont want to spend hours putting in my information. I kinda want to just type in a short form of information and then excel sorts it out in the correct way.
For example:

			Number	Winstreak	Amount BET	Whats bet on	Win/Lose	What the coin landed on	Profits	Person
50 t	lose	me	1	-	50	Tails	Lose	Heads	$ -50	Me
5 h	win	shee	2	-	5	Heads	Win	Heads	-	Shee
50 t	win	me	3	1	50	Tails	Win	Tails	$ 50	Me
50 t	win	me	4	2	50	Tails	Win	Tails	$ 50	Me
600 h	win	me	5	3	600	Heads	Win	Heads	$ 600	Me
50 t	lose	me	6	-	50	Tails	Lose	Heads	$ -50	Me
250 t	win	me	7	1	250	Tails	Win	Tails	$ 250	Me
500 h	lose	me	8	-	500	Heads	Lose	Tails	$ -500	Me
500 h	lose	me	9	-	500	Heads	Lose	Tails	$ -500	Me
1000 h	lose	me	10	-	1000	Heads	Lose	Tails	$ -1,000	Me
1500 h	lose	me	11	-	1500	Heads	Lose	Tails	$ -1,500	Me
319 h	win	me	12	1	319	Heads	Win	Heads	$ 319	Me
100 t	win	me	13	2	100	Tails	Win	Tails	$ 100	Me
100 t	win	me	14	3	100	Tails	Win	Tails	$ 100	Me
200 h	win	me	15	4	200	Heads	Win	Heads	$ 200	Me
200 t	win	me	16	5	200	Tails	Win	Tails	$ 200	Me
100 h	win	me	17	6	100	Heads	Win	Heads	$ 100	Me
73 t	win	me	18	7	73	Tails	Win	Tails	$ 73	Me
100 t	win	me	19	8	100	Tails	Win	Tails	$ 100	Me
100 h	win	me	20	9	100	Heads	Win	Heads	$ 100	Me
100 t	win	me	21	10	100	Tails	Win	Tails	$ 100	Me
100 t	lose	me	22	-	100	Tails	Lose	Heads	$ -100	Me

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

Now this is a lot of information already so im going to give a quick rundown on what i want:
For everywin i want to add the winstreak record, but if i lose the winstreak gets reset. However i want to also have a highest winstreak cell somewhere. Now a win from someone else also shouldn't be counted because in this case we have the person Shee in there aswell. Also i want if i put Tails in there and i won, it will tell it was tails, but if i lost it would tell it was Heads. Now this information is kind of clusterbombed like this so i will also leave my Excel file in here. I'm not sure how to achieve these results on my alone. I'm not too familiar with VBA aswell.. So i would appreciate it if some of you people have solutions for me, or something to make it easier!
Many thanks!
Yours sincerely,
Ramballah

https://drive.google.com/open?id=1ZvhP2j3eohsrVw9NoNdXgUREl8xdOvUB
The thing is in sheet 2.

 

[Ramballah]

bump... pls help somone

 

[Ramballah]

bump... still need help

 

[Ramballah]

bump....