I don't use Excel, but I do use linear & non linear programming solvers in python. One task that jumps to mind is solving the proper kelly bet sizes (or bet sizes which maximize expected profit) considering $ bet on each combination, track take, and your estimates for the combinations. I'm guessing you could do the same using Excel's solver. Obviously, this requires that you want to use kelly and that you have an odds line.
|