Needing some help with some conditional formatting for a punting strategy which outlines required bet????

[BDONNY]

Thanks in advance to any suggestions or help, I'm not overly familiar with the various commands and formulas that we can use in excel, and it has taken me half a day of high focus and reading to get this far, but I am hopeful that what I'm trying to achieve will be simple for anyone who is a regular user of excel and understands the formulas available.
In the below example I am aiming to simply profit $10 from each match the Lakers play, regardless of who they play or the available odds. My theory being that as long as I select a strong team it would be unlikely that they have a losing streak of too many in a row, therefor by aiming for the $10 profit from each match and if a match loses, the next bet has to allow for winning the previous lost bet including the expected $10 profit from the previous losing match as well as the expected $10 profit from the current match. If there is a considerable losing streak it would get out of hand fairly fast of course but i may play around with the aim per bet once i have the outlay of this spreadsheet sorted.

What I m needing help with is automatically formatting the figures in column A and also Column B so that if I was to adjust the actual odds in column B then the required bet would automatically update in column A. Ive used the 2-1 odds below to make it easy to get to this point, however odds will fluctuate each week, and my aim is to stake as much as required to profit $10 from each match regardless of the odds. Can someone explain how I would use "solver" to tell me the required stake if i were to adjust the odds of any given match??

I hope that makes sense, and would be most grateful if anyone can actually work that out.

 

[KRice]

Welcome to the MrExcel Board! You don't need Solver...in this case we can solve for the amount to bet analytically. In the sample worksheet below, your inputs are in blue. Set the Aim Per Bet, then input the Odds for an upcoming game. The amount to Bet will be calculated based on your Summary Balance up to that point, the expectation of what your summary balance should be if you had been successful in making the Aim Per Bet for each game up to that point, and the Odds of the upcoming game. Then after the game, enter W or L to compute your profit/loss and summary balance.

MrExcel_20220910.xlsx
	A	B	C	D	E	F	G
1							$ 10.00
2	BET	ODDS	W/L	POTENTIAL RETURN	ACTUAL PROFIT/LOSS	SUMMARY BALANCE	AIM PER BET
3	$ 10.00	2	W	$ 20.00	$ 10.00	$ 10.00
4	$ 10.00	2	W	$ 20.00	$ 10.00	$ 20.00
5	$ 10.00	2	L	$ 20.00	$ (10.00)	$ 10.00
6	$ 30.00	2	l	$ 60.00	$ (30.00)	$ (20.00)
7	$ 70.00	2	L	$ 140.00	$ (70.00)	$ (90.00)
8	$ 150.00	2	L	$ 300.00	$ (150.00)	$ (240.00)
9	$ 310.00	2	L	$ 620.00	$ (310.00)	$ (550.00)
10	$ 630.00	2	W	$ 1,260.00	$ 630.00	$ 80.00
Sheet1

Cell Formulas
Range	Formula
D3:D10	D3	=IF(B3="","",A3*B3)
E3:E10	E3	=IF(C3="","",(C3="W")*D3-A3)
F3:F10	F3	=IF(C3="","",SUM(E$3:E3))
A3:A10	A3	=IF(B3="","",(ROWS(A$3:A3)*$G$1-N(F2))/(B3-1))