Progression Calculator

Hi Experts. Nice to be here.

May i ask for your help.
Please see the attached file.

The Questions i have/features that would be nice:

1. Reset always on a Win AND win must be <9,99
2. if possible profit is <9,99 the stake in the next row should go up.
3. After stake and W and <9,99 reset again

General question: Is it possible, that excel shifts rows? Dont think so. what i mean:
look at row 10 with the new stake. this should replace row 8 with the new values. Is that possible?

Thank you so much, Max

Try this formula in C3 and fill down.

=1+((36-MOD(SUM(B$2:B2),36))<10)

Does that give you what you need? I'm not understanding point 3 clearly, if the formula doesn't do as needed then a few more rows of data with manually entered results might be needed to explain more clearly.

Hi Jason, and greetings to the UK.

I am sorry. It doesnt work. I get the #Name? Error.

Regards,
Max

Did you change anything in the formula?
The formula works for me in your sample file without error.

Only other possiblity, do you have your language settings in something other than English? If so SUM and MOD might need to be translated.

Hi Jason,

yes sorry. It was the language problem.

Works so far. What doesnt work: If i change the value in C2 from 1 to 10 or anything else i want, the "Stake" in the following cells is wrong. And after the Win in Row 9 it does not go back to 1 in Column C. Maybe you can help here too THX

I think you need to explain more clearly.

The way I'm reading your criteria, you are creating a paradox. If profit <10 then increase stake, but if win and profit < 10 then reset, but profit is < 10 so will be increased again.
I'm not even convinced that Win and profit <10 is possible with the way you calculate win, loss, profit and win/loss. Should some of the criteria be > or = instead of < ?

Should the profit <10 criteria change if the starting stake is higher?

How much should the stake go up by? Increase by 1? Increase by starting stake? Something else?

Oh, you are right. Thank you for your patience.
As i read your Question i see that there is some info missing.


As soon as the profit is 10 or more (=>), the stake should you back to the starting stake.
That means if we put "10" in Cell C2 then go back to 10. If its 1 then back to 1.

The stake should go high enough, to cover all previous losses and to have a minimum profit of 10 or higher.
Then reset as wrote above.

I thought we need the w/l to create the formula. But you can leave it, if its not needed.
So independent from w/l the stake should go up to cover all previous losses AND a minimum profit of =<10.

If this is reached, then back to the stake that we choose in C2 and start again.

Big THX.

Max

Now I understand a bit clearer. Just to clarify one thing

Originally Posted by MaxVBA

So independent from w/l the stake should go up to cover all previous losses AND a minimum profit of =<10.

What should the increment of the stake be? Muliples of 1, or multiples of the starting stake?

I would say multiply of the starting stake.

And maybe important to you: the factor is 36 to 1.

Example:

If we start with 10 $ on 8 Numbers, thats 80.
We can play this 4 times with 10 $ to reach 320.

There is no win yet. We are down -320. So now we need to adjust the stake
to 12 $ to get a potential win on the next round.

12$ * 36 = 432 $ - 12*8 Bet amount = 96 - 320 losses before = 16 $ Profit.
Now back to 10 $.

Excel should calculate on its own, what stake is needed to get a minimum of =<10 and cover all previos losses and the actual bet (here 12*8).

And there is one more:

The Numbers to play are not always the same. Could start with 2, then 3, then 4 and go up to X. So that should be calculated too.

Thx, Max

Confused again quoting a few select lines from your previous post

Originally Posted by MaxVBA

I would say multiply of the starting stake.

start with 10 $

adjust the stake to 12 $

Now back to 10 $.

How do you get from 10 to 12 as a multiple of the starting stake? That would be increments of 1 $.

Last thing (I think), how is win decided? I can see it roughly in what you have, but need to be certain before starting.

Sorry for that.

1. 12 $ should be calculated by excel. Because it calculates, that we need to bet 12 $ to cover all losses
and get a profit of =<10 $.

We start with 8 Numbers to play. Stake we choose is 1.

So now our bet is 8*1 $ = 8 Dollar.
If we win, we have 1$*36 = 36 $ - 8 $ = 28 $ Profit

But what if we lose:

8*1$ = 8
we can lose 2 times playing 1 $.
8*1$ = 8
8*1$ = 8
= -16

Excel should now calculate:
Next spin possible win:

1*36= 36$
- 8*1$ = 8$
- previous loss -16
= 36-8-16= 12. =<10 ok.

Next spin lose:
8*1$ = 8
8*1$ = 8
8*1$ = 8
= -24

Excel now calculates how much must i increase the stake, to cover all previous losses if next spin is a win?

2$ Stake * 36 = 72 $
- 2 $ Stake, 8 Numbers = -16 $
-24 Previous losses
= 32 $

What would happen if this bet would lose?

we already have -24 from
8*1$ = 8
8*1$ = 8
8*1$ = 8

and -16 $ from
2 $ Stake, 8 Numbers = -16 $

Excel should calculate:

Are 2 $ still enough to cover losses and get me a win of 10?

2$ Stake * 36 = 72 $
- 2 $ Stake, 8 Numbers = -16 $
- 2 $ Stake, 8 Numbers = -16 $
-24 Previous losses
= 16 $ Reset

A win is always stake * 36 - numbers to play * stake.

Here with 10 $ Stake:

= 10*36=360
- 8*10=80
= 280

2. The W/L is an info we get from another sheet.
This calc should then get the Data from the other source.
It gets how many numbers to play too from that other sheet.

Regards
Max

Hi Max, just a quick reply out of courtesy to let you know that I haven't abandoned your thread.

Allowing for the current stake in the formula is proving challenging, given that the formula is needed to calculate the current stake.

I'm not going to be defeated though.

Originally Posted by jason.b75

Ok, think I have it.

Normally I would post everything in the thread for the benefit of others looking at the thread, given that there is currently nobody else looking, along with a setup that I don't know where to begin explaining, it is all in the workbook.

I've made a few additions and alterations. Column M conatins a list of parameters, opening stake, minimum profit, facter, etc. Column N contains notes on these parameters.

The numbers to bet in column B and the win/loss flag in column I use random number functions for testing the formulas, these just need to be substitutes for real data later. Once that is done, the 3 parameters commented as being for random testing will no longer be needed.

I've renamed your 'win amount' column as 'potential' and added a 'win' column with a different formula. The win, loss, and profit columns all show cumulative figures. The remaning columns show figures relating to that row only.

Finally, I've added some conditional formatting to highlight any rows if and where a win returns a profit below the threshold, which should only happen if one of the Maximum stake parameters comes onto play (these were an unintentional bi-product of making the formula work successfully,but could be useful).

The theory being that if you have consecutive losses resulting in a big negative on profit, that the formula will limit stakes in an attempt to reduce the deficit over multiple wins instead of trying to do it with one large bet.

To check the results with random numbers, press the f9 key to recalculate the random functions.

Have a look, see what you think.

Jason, i really really appreciate your hard work. Let me please test it. I will get back at you. For now, big thx!!!