I have just gone over the last six months of my quinelaa bets (up to 7 boxed) and they are showing a loss of 23%

I thought about using excel to make my bets using a $500 bank andd betting 1%. However, i'm struggling to write the formula as it needs to update to work out the next bet weather the bet won or lost.

Date
Venue
Race No.
Bet No.
Outlay
Amt Won
Profit.

Can someone help. I due to time out yet again. This will no. 25 in the last 39 days. Not sure how long this one will be. Most seem to last about 3 to 5 hours.