can someone make an excel spreadsheet for martingale ?

[TheKid]

so . there is this video tutorial for a website that no longer exists
https://www.youtube.com/watch?v=F7Qd6D-b92s&t=18s

my question is , can someone replicate that site's sistem in excel .
It doenst seem preety hard , even if I might not now what am talking about .
I dont really work in excel .

thanks !

 

[withnail1973]

Hi all,

Sorry to revive an older thread...
I would like to make a spreadsheet just the like the above example, except I want to input an extra function.

According to above example (let's say the odds are fixed at 2 and your target profit is 1 euro) you bet 1 euro and lose 1 euro. The next bet would be 2 euro. If this also loses the next bet would be 4 euro, because you've previously lost 3 euro. If this also loses you've now lost 7 euro, so next bet would be 8 euro....and so on.

Instead of this I would like to add the original target profit to every bet on top of the loss recovery.

So same example, I lose 1 euro on the first bet. My next bet is then 3 euro (total target profit from 2 bets + 1 euro recovery). If this also loses I've now lost 4 euro. My next (3rd) bet is for 7 euro (total target from 3 bets + 4 euro recovery) and so on until (hopefully!) a winning bet comes along.

Is it possible to do this?

Also I think the above calculation for the odds is wrong. Decimal odds are actually 1 number lower. So if you bet 1 euro with odds of 5, you only win 4 euro, not 5. Decimal odds of 5 are the same as fractional odds of 4/1.

Any help much appreciated!

 

[oldbrewer]

bet 1, at 5/1 you get 5 plus your stake back

doubling up will kill you eg at roulette you hit the casino's maximum stake limit - as an academic exercise it is fun though.

 

[withnail1973]

bet 1, at 5/1 you get 5 plus your stake back

doubling up will kill you eg at roulette you hit the casino's maximum stake limit - as an academic exercise it is fun though.

Hi oldbrewer,

Yes, you'll get 5 back + stake when using fractional odds of 5/1, but when decimal odds are used like on most betting exchanges you'll win 4 euro + stake when decimal odds are shown as 5.0

https://sports.bwin.com/en/news/betting-guide/decimal-odds-v-fractional-odds

There are lots of markets in racing/football/tennis etc where a Martingale system will work, and there's also lots of modifications you can do to stop it spiralling out of control

 

[oldbrewer]

stake	dec odds	result	win	lose	overall				running loss		NEXT stake
1	4	win	4	0	4				0		"n/a"
1	7	win	7	0	11				0		1
1	3	lose	0	1	10				1		1
1.5	5	lose	0	1.5	8.5				2.5		1.625
1.625	2	lose	0	1.625	6.875				4.125		5.125
5.125	3	lose	0	5.125	1.75				9.25		5.625
5.625	4	lose	0	5.625	-3.875				14.875		5.958333
6	2	lose	0	6	-9.875				20.875		21.875
21.9	2	lose	0	21.9	-31.775				42.775		43.775
44	3	win	132	0	100.225				0		1
1	4	win	4	0	104.225				0		1
1	5	lose	0	1	103.225				1		1
1	2	lose	0	1	102.225				2		3
3	4	lose	0	3	99.225				5		2.666667
2.67	4	lose	0	2.67	96.555				7.67		3.556667
3.6	2	lose	0	3.6	92.955				11.27		12.27
12.5	2	lose	0	12.5	80.455				23.77		24.77
25	3	lose	0	25	55.455				48.77		25.385
26	4	lose	0	26	29.455				74.77		25.92333
26	4	lose	0	26	3.455				100.77		34.59
35	2	lose	0	35	-31.545				135.77		136.77
137	2	lose	0	137	-168.545				272.77		273.77
273	3	lose	0	273	-441.545				545.77		273.885
273	4	lose	0	273	-714.545				818.77		273.9233

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[withnail1973]

Thanks oldbrewer.

With the odds, the first race says odds of 4 to win 4, do you mean we win 3 + original stake 1? That would be correct.

I think we have our wires crossed and probably my fault for not being clear...
When I say original stake of 1 euro, I mean that the target profit is 1 euro, so the actual stake is always dependent on the odds.

If target profit is 1 euro and odds are 5, then our stake is 25 cents (25 x 4 to win 1 euro) so we then get 1.25 back in total.

If we'd have lost the bet we would be 25 cents down.
A normal martingale would now try to recover the 25 cents and win 1 euro.

What I want to do is recover the 25 cents + the target profit 1euro for the 1st race + win target profit 1 euro on the next race.
So if odds were again 5, the next bet would be a stake of 0.57 (rounded up) to win 2.25 (target profit 1st and present race + 25 cents running loss)
If we lost again our running loss would be 82 cents.
If next bet odds are again 5 then our stake would be 96 cents (rounded up) to win 3.82 (target profit 1 from 1st, 2nd and present race + 82 cents running loss)

Phew, I'm even confusing myself now

 

[oldbrewer]

stake	dec odds	result	win	lose	overall				running loss
0.25	4	win	1	0	1				0
0.142857	7	win	1	0	2				0
0.33	3	lose	0	-0.33	1.67				0.33
0.266	5	lose	0	-0.266	1.404				0.596
0.798	2	lose	0	-0.798	0.606				1.394
0.798	3	lose	0	-0.798	-0.192				2.192
0.798	4	lose	0	-0.798	-0.99				2.99
1.995	2	lose	0	-1.995	-2.985				4.985
2.9925	2	lose	0	-2.9925	-5.9775				7.9775
2.9925	3	win	8.9775	0	3				0
0.25	4	win	1	0	4				0
0.2	5	lose	0	-0.2	3.8				0.2
0.6	2	lose	0	-0.6	3.2				0.8
0.45	4	lose	0	-0.45	2.75				1.25
0.5625	4	lose	0	-0.5625	2.1875				1.8125
1.40625	2	lose	0	-1.40625	0.78125				3.21875
2.109375	2	lose	0	-2.10938	-1.32813				5.328125
2.109375	3	lose	0	-2.10938	-3.4375				7.4375
2.109375	4	lose	0	-2.10938	-5.54688				9.546875
2.636719	4	lose	0	-2.63672	-8.18359				12.18359
6.591797	2	lose	0	-6.5918	-14.7754				18.77539
9.887695	2	lose	0	-9.8877	-24.6631				28.66309
9.887695	3	lose	0	-9.8877	-34.5508				38.55078
9.887695	4	lose	0	-9.8877	-44.4385				48.43848
		corrected decimal odds
		does this look right ?

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[withnail1973]

Almost, but not quite
The 4th bet is shown as 0.266 x 5 to win 1,33 , but it should be trying to win 2,33.
It's trying to recover the running loss 33 cents + the target profit of 1 euro from the 3rd race + the target profit from the current (4th race).
Also the odds are still not quite right....sorry to keep moaning haha
1st bet is 0.25 x 4 to win 1, the calculation is correct but the way the odds are shown is not right, it should be shown as 5.
I know it doesn't sound logical but that's how they're presented on the betting exchanges and bookmaker sites (in Europe anyway, in UK they still use fractional mostly)
If you stake 1 euro @ odds of 5, the multiplication is 4. Stake 1 euro @ odds of 11, the multiplication is 10.
This needs to be included in the formula because if I have a spreadsheet where I paste in hundreds of decimal odds the calcs will be wrong.

I've attached a spreadsheet that I already have (it's in ods format) that may help.
The sheet shows calcs for a martingale for back betting and lay betting.

Oh no I haven't because I can't send attachments....

 

[oldbrewer]

Why try to win 1 every bet - better to keep going till you win 1 - you wont run out of money so fast - I am not going to spend any more time on this - if you need formulas for any of my cells tell me - I might be able to put it on google sheets and give open access to it but need to check the rules of the forum.....

 

[withnail1973]

Why try to win 1 every bet - better to keep going till you win 1 - you wont run out of money so fast - I am not going to spend any more time on this - if you need formulas for any of my cells tell me - I might be able to put it on google sheets and give open access to it but need to check the rules of the forum.....

OK thanks. I would like to see the formula, perhaps I can modify it further myself.
I wanted to try this because in some markets the losing runs are consistently short.

 

[klownzold]

Hello folks, not sure how I can send out a private message, as I would have sent it to oldbrewer since most of this sheet is their work, but would immensely appreciate some help with this sheet from anybody available as im not seeming to get something quite right with this spreadsheet when I add an COMMISSION % rate COLUMN.

Please feel free to take a look

mrexcel.xlsx

drive.google.com

The instructions (or rather the issue) is explained in the file. But as you can see when you open it up, the calculations when adding a commission rate is different to that if you were to work it out on a calculator. What is the reason for this being wrong? It seems to work ok if 0% is put in L2, but any other commission rate number, it does not reach the TARGET PROFIT amount. Well it does on the sheet, but on the calculator, its quite wrong.