Variance Model Instructions

The Variance Model can be found here

The Variance Model is a Monte Carlo Analysis that can be used to:

  1. Review historical results to see how likely recorded profit has been under a sample size
  2. Test various stakes under a strategy to get an understanding of risk.

To use the model you will need to input:

(1) Avg Odds e.g. 15.81 in my example below

(2) Min and Max Odds Optional, default is 1.8 to 80

(3) Average EV e.g. 111% in my example

(4) Min and Max EV Optional, default is 100%-140%

(5) Bets Sample size; 471 in my example

(6) Simulations Default 100,000. Higher Simulations mean a higher accuracy, however will take longer to process

(7) Bank £10,000 in my example

(8) Staking strategy 1. Return x% = Return x% of your bankroll; 2. Win x% = level staking to win x% of your bankroll; 3. Kelly staking.

A Rolling staking strategy means that stakes will increase with winners relative to an increase in bankroll

(9) Max Stake  optional, default is £500.

Image

Clicking the Green “Calculate” button will run the Monte Carlo analysis and generate the graph. The blue probability distribution (left Y axis) shows the likely distribution of profit under the input variables. For example I can see that I will break even with £0 profit / loss 28% of the time using my strategy. Hovering the mouse over the line on the graph in the live model will present a pop up with the x and y-axis figures. The red probability distribution (right Y axis) line shows the same curve in a cumulative probability distribution.

If we have a set of results to compare on the graph we can input into the field “Your Results” to see which percentile the results sit on. Anything < 50% is below the average expectation, anything > 50% is above the average expectation. In my example I can see that my observed results of -£1000 sit on the 6.16 percentile, something we would expect to occur roughly 1 in 16 times. I can use this information to determine whether to continue with my strategy or whether to adjust my staking strategy or staking levels.