Reverse Exposant ?

[btcsniper]

Hi guys,

I have this excel spreedsheet where I increase a Number X by factor Y to see after how bet I can do with X to tolerate let say 10 loses with a balance of 1000.

Ex:
x(bet) = 25
y(increment) = 2.5

x = 25, 62.5, 156.25, 390.6, 976.6
Wagger = 25, 87.5, 243.75, 634.4, 1610.9

So I know with 1000$ and this setting I can afford up to 4 loses in row.

Now I would like to have a formula where X will be adjusted to allow 10 loses in row and use the entire balance.

How would I do that ?

 

[Harry_the_cat]

Hi guys,

I have this excel spreedsheet where I increase a Number X by factor Y to see after how bet I can do with X to tolerate let say 10 loses with a balance of 1000.

Ex:
x(bet) = 25
y(increment) = 2.5

x = 25, 62.5, 156.25, 390.6, 976.6
Wagger = 25, 87.5, 243.75, 634.4, 1610.9

So I know with 1000$ and this setting I can afford up to 4 loses in row.

Now I would like to have a formula where X will be adjusted to allow 10 loses in row and use the entire balance.

How would I do that ?

I think this is what you mean:
X forms a geometric progression with a=25, and r=2.5.

Wager is the sum of a GP with a=X, r=2.5 and Wager = \(\displaystyle \frac{X(2.5^{10}-1)}{(2.5-1)}=1000\)

So,

\(\displaystyle X=\frac{1500}{2.5^{10}-1}= 0.1573\) (to 4 dec pl)

X	Wager
0.1573 0.39325 0.983125 2.457813 6.144531 15.36133 38.40332 96.0083 240.0208 600.0519	0.1573 0.55055 1.533675 3.991488 10.13602 25.49735 63.90067 159.909 399.9297 999.9816

 

[btcsniper]

How did you end up with this ?
So,

[FONT=MathJax_Math-italic]X[/FONT][FONT=MathJax_Main]=[/FONT][FONT=MathJax_Main]1500[/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]10[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main]=[/FONT][FONT=MathJax_Main]0.1573[/FONT]X=15002.510−1=0.1573 (to 4 dec pl)

Where do you get 1500 from ?

How you express this on excel:

[FONT=MathJax_Math-italic]X[FONT=MathJax_Main]([/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]10[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main])[/FONT][FONT=MathJax_Main]([/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main])[/FONT][FONT=MathJax_Main]=[/FONT][FONT=MathJax_Main]1000[/FONT][/FONT]

[FONT=MathJax_Math-italic]X[/FONT][FONT=MathJax_Main]([/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]10[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main])[/FONT][FONT=MathJax_Main]([/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main])[/FONT][FONT=MathJax_Main]=[/FONT][FONT=MathJax_Main]1000[/FONT]

 

[Harry_the_cat]

How did you end up with this ?
So,

[FONT=MathJax_Math-italic]X[/FONT][FONT=MathJax_Main]=[/FONT][FONT=MathJax_Main]1500[/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]10[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main]=[/FONT][FONT=MathJax_Main]0.1573[/FONT]X=15002.510−1=0.1573 (to 4 dec pl) ... not sure what you are doing here

Where do you get 1500 from ? ... I multiplied both sides of the equation by 2.5-1 =1.5

How you express this on excel:

[FONT=MathJax_Math-italic]X[FONT=MathJax_Main]([/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]10[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main])[/FONT][FONT=MathJax_Main]([/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main])[/FONT][FONT=MathJax_Main]=[/FONT][FONT=MathJax_Main]1000[/FONT][/FONT]

[FONT=MathJax_Math-italic]X[/FONT][FONT=MathJax_Main]([/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]10[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main])[/FONT][FONT=MathJax_Main]([/FONT][FONT=MathJax_Main]2.5[/FONT][FONT=MathJax_Main]−[/FONT][FONT=MathJax_Main]1[/FONT][FONT=MathJax_Main])[/FONT][FONT=MathJax_Main]=[/FONT][FONT=MathJax_Main]1000[/FONT]

I didn't use Excel to find X. I found X using the formula for the sum of a GP. Then I used the value of X to form the excel table.

 

[btcsniper]

Where did you get 1500 ?

1500 is for a 1000$ balance

If I win next round let say I have 1005$ how to recaculate X ?

I understand if I do 1500/2.5^10=X but where 1500 come from ?

Thank you so much for your time.

 

[Otis]

Where did you get 1500 ?

He solved the equation \(\displaystyle \frac{X(2.5^{10}-1)}{(2.5-1)}=1000\) for X.

Multiply each side by \(\displaystyle \frac{2.5-1}{2.5^{10}-1}\).

Then you will have \(\displaystyle (1000)(2.5 - 1)\) in the numerator. That's 1500.