Trying to build a betting/wagering excel sheet.

[JokersLastLaugh]

Hey all I'm extremely new to excel and am attempting to make my first sheet. I'm trying to keep tracks of online sports bets I make. Below is my current template. It's super basic I know but right now I'm trying to find the formulas or whatever I need to get the data to work.


Untitled.png


The main things I'm trying to accomplish are:

If I put a W in the Win/Loss column I want the Gained/Lost to display the Win Return amount. W - Win Return.
If I put a L in the Win/Loss column I want the Gained/Lost to display the Wagered amount. L - Wagered Amount.
At the bottom I want the total to be all the Gained/Lost added up, to make +/- number.

I want all the totals for every day to be added and displayed in the Grand Total cell.

I want to make it so whenever I start a new day I don't have to reformat and reformula the cells. I want to type only in 4 cells; League, Bet, Wagered, Win Return. I might have to manually type in the date each time, I don't know. After the matches take place, I want to only type in the Win/Loss cell.

Are these things doable? Or perhaps suggestions of doing it a different way?

Thank you

[Crooza]

In g6 and drag down

=if(F6="","",if(F6="W",E6-D6,D6))
I'd not put the daily total under the individual wins and losses.

You could do this in another column or even in a pivot table

[JO505]

Something like this?