Very interesting piece of work. You need:
1) Formulas in second and third matricies that defined the odds and payouts that also include the variables listed in the top matrix
2) You need to define one cell that expresses the overall payout effectiveness
then you can use Solver with item 2 as the target and each element of matrix one as the list of variables
Solver will then optimize the bet sizes for the maximum payout based on the system of equations that you have established
Bookmarks