Balanced distribution

[DaDee]

Hi guys,

I have been working on this the last week and its showing very positive results.

Attached is my 2 spreadsheets, the main one is my system, statistics test and the other is the 6 point divisor spreadsheet for bet calculation.

I am looking for help testing please as its pretty slow to test and I'm not the best with excel.

So here is how it works.


There are a number of tabs on the main spreadsheet at the bottom, each for a different EC,
There's HL, RB, EO I'm sure you know what they are then there is 2 ECs called ST1 and ST2 these are two different street selections.
Then there is TB, LR and Sides, these are 3 different EC sector selections. TB is the top and bottom sectors of the wheel where 34 is always a loss, LR is the left and right sectors of the wheel where 0 is always a loss just like the standard outside ECs.
The last one is another sector EC bet consisting of 4 sectors where 11 is always a loss.
Now the spreadsheet is not quite right as 0, 34 and 11 are not automatically calculated as a loss or ignored.....im useless with excel so someone can fix that if you like but I doesn't make a difference really.

[DaDee]

Ok so here is how I test a session. I paste in about 25 actuals in the HL tab, they will get auto copied to the other tabs.

You will notice that it will tell you to bet on some of the tabs. Note no betting occurs before the yellow line, that's 15 actuals.

You are looking for one of the ECs to be uneven for example 12 blacks and only 2 reds. The sheet will be telling you to bet red.
You select which EC to bet whichever triggers first.

In the example in the sheet attached you see that its telling you to bet on read after 14 actuals and  you see that some of the other ECs have triggered also but remember I said that no betting is to occur before the yellow line so in actual fact there is only one trigger here.
There is a later trigger but the first one is the one you bet on. So after the next red you start betting which comes on the 15th spin.
So following my explanation the first trigger is on the 15th spin telling you to now bet on red.

Ok, now here is the switch rather than betting on red here you actually bet on back to continue its domination, I noticed during testing that this is best. So you will see that it then goes rbbrb which is LWWLW

Put that in the divisor spreadsheet attached and you have 3 units. 3 units is my session target so end of session.

[DaDee]

Sorry here are the sheets, if testing please use your own actuals as I'm testing with the ones in the nums tab.

By the way some of you might remember me. I was on these forums a few years ago, Diarmaid 

[DaDee]

Now the last point to remember is the stop-loss per session, which happens extremely rarely.

You stop at -6, now I don't mean -6 units in the divisor sheet, I mean -6  L's as if you were flatbetting if you hit that then stop and retrack another session.
The divisor calculations carry over to the next session and the target of the next session is just to recover the loss. But you would also just stop at -6  L's when in recovery, I haven't seen this happen twice in a row YET.

[DaDee]

One more thing, sometimes you get more than one EC triggering on the same spin, to decide which one to bet on you look a the % distribution at the trigger points and you go with the one that has the most one sided %. So you would play the EC with the lowest %.

Sometimes this can also be the same on more than one tab so you look to which EC has slept the longest since the trigger. In my example red had slept for 3 spins before the trigger.
I have never seen this to be the same also on more than one of the tabs.

It seems complicated  but once you get going you will see that it is actually pretty simple.

Any questions just ask.

Cheers

[DaDee]

For Your Information, my testing is showing sessions averaging 25 spins and giving an average profit of 5 units per 60 spins.

That's a good return IMO, I would have no problem with making 10 units for about 2 hours at the wheel 

Cheers

[DaDee]

Here is another example just in case you are confused.
Sheets attached.

HL has triggered on spin 15 and you would be betting on High in this case from spin 16.
EO has also triggered on spin 15 and you would be betting on  Odd from spin 16.

Now to decide which one you look at the % distribution and go with the lowest at the trigger.
LH is 0.266 and EO is at 0.333 so you will be playing the LH and betting on high from spin 16 onwards.

[DaDee]

Lol forgot the sheets.

[DaDee]

Here is another example where the LR's trigger first and betting starts on L's from spin 16 onwards.

See in the sheets, this is a pretty bad session that doesn't happen much BUT it still wins 3 units.

You see in the divisor sheet it hits -5  losses early but didn't hit the stop-loss of -6

To be honest if I was playing this session for real I would have been happy to stop earlier in the session at break even but for testing purposes obviously I won't be doing that.

[DaDee]

Forgot the divisor sheet.

[DaDee]

When I'm testing I record the results in the testing tab on the main spreadsheet.

I record the following, result which is either 3 or 0, a 0 would be when you hit the stop loss and on to recovery in the next session.

Drawdown is the lowest point reached from the divisor sheet.

Big unit is the largest amount of units bet on any spin from the divisor sheet.

Tracker is which EC you were playing and spins is the number of spins played in that session including the initial spins where you were not betting.

This info is important as in the end you will know a safe bankroll to play with and also how much units you are making per spin.

[DaDee]

If someone can help making a more automated spreadsheet, please be my guest

[DaDee]

Hi guys,

Maybe someone can help me.

There is an error in the divisor sheet attached.

Notice that the divisor goes to 7 on the 6st spin after just one loss and it should have stayed at 6. Just like on the 2nd spin.

I haven't seen this error before, can someone fix it please. Pretty please

[DaDee]

Lol forgot sheet again, can someone see where the error is?

[MrG]

Hmmm, I don't see any attachments.