can someone make an excel spreadsheet for martingale ?

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! :-)
 
Upvote 0

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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.
 
Upvote 0
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 ;-)
 
Upvote 0
[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl22, width: 64"]stake[/TD]
[TD="class: xl22, width: 64"]dec odds[/TD]
[TD="class: xl22, width: 64"]result[/TD]
[TD="class: xl22, width: 64"]win[/TD]
[TD="class: xl22, width: 64"]lose[/TD]
[TD="class: xl22, width: 64"]overall[/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"]running loss[/TD]
[TD="class: xl22, width: 64"] [/TD]
[TD="class: xl22, width: 64"]NEXT stake[/TD]
[/TR]
[TR]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]win[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]"n/a"[/TD]
[/TR]
[TR]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"]7[/TD]
[TD="class: xl22"]win[/TD]
[TD="class: xl22"]7[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]11[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]1[/TD]
[/TR]
[TR]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"]3[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"]10[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]1[/TD]
[/TR]
[TR]
[TD="class: xl22"]1.5[/TD]
[TD="class: xl22"]5[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]1.5[/TD]
[TD="class: xl22"]8.5[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]2.5[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]1.625[/TD]
[/TR]
[TR]
[TD="class: xl22"]1.625[/TD]
[TD="class: xl22"]2[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]1.625[/TD]
[TD="class: xl22"]6.875[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]4.125[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]5.125[/TD]
[/TR]
[TR]
[TD="class: xl22"]5.125[/TD]
[TD="class: xl22"]3[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]5.125[/TD]
[TD="class: xl22"]1.75[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]9.25[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]5.625[/TD]
[/TR]
[TR]
[TD="class: xl22"]5.625[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]5.625[/TD]
[TD="class: xl22"]-3.875[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]14.875[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]5.958333[/TD]
[/TR]
[TR]
[TD="class: xl22"]6[/TD]
[TD="class: xl22"]2[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]6[/TD]
[TD="class: xl22"]-9.875[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]20.875[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]21.875[/TD]
[/TR]
[TR]
[TD="class: xl22"]21.9[/TD]
[TD="class: xl22"]2[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]21.9[/TD]
[TD="class: xl22"]-31.775[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]42.775[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]43.775[/TD]
[/TR]
[TR]
[TD="class: xl22"]44[/TD]
[TD="class: xl22"]3[/TD]
[TD="class: xl22"]win[/TD]
[TD="class: xl22"]132[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]100.225[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]1[/TD]
[/TR]
[TR]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]win[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]104.225[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]1[/TD]
[/TR]
[TR]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"]5[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"]103.225[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]1[/TD]
[/TR]
[TR]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"]2[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]1[/TD]
[TD="class: xl22"]102.225[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]2[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]3[/TD]
[/TR]
[TR]
[TD="class: xl22"]3[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]3[/TD]
[TD="class: xl22"]99.225[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]5[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]2.666667[/TD]
[/TR]
[TR]
[TD="class: xl22"]2.67[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]2.67[/TD]
[TD="class: xl22"]96.555[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]7.67[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]3.556667[/TD]
[/TR]
[TR]
[TD="class: xl22"]3.6[/TD]
[TD="class: xl22"]2[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]3.6[/TD]
[TD="class: xl22"]92.955[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]11.27[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]12.27[/TD]
[/TR]
[TR]
[TD="class: xl22"]12.5[/TD]
[TD="class: xl22"]2[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]12.5[/TD]
[TD="class: xl22"]80.455[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]23.77[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]24.77[/TD]
[/TR]
[TR]
[TD="class: xl22"]25[/TD]
[TD="class: xl22"]3[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]25[/TD]
[TD="class: xl22"]55.455[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]48.77[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]25.385[/TD]
[/TR]
[TR]
[TD="class: xl22"]26[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]26[/TD]
[TD="class: xl22"]29.455[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]74.77[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]25.92333[/TD]
[/TR]
[TR]
[TD="class: xl22"]26[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]26[/TD]
[TD="class: xl22"]3.455[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]100.77[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]34.59[/TD]
[/TR]
[TR]
[TD="class: xl22"]35[/TD]
[TD="class: xl22"]2[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]35[/TD]
[TD="class: xl22"]-31.545[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]135.77[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]136.77[/TD]
[/TR]
[TR]
[TD="class: xl22"]137[/TD]
[TD="class: xl22"]2[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]137[/TD]
[TD="class: xl22"]-168.545[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]272.77[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]273.77[/TD]
[/TR]
[TR]
[TD="class: xl22"]273[/TD]
[TD="class: xl22"]3[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]273[/TD]
[TD="class: xl22"]-441.545[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]545.77[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]273.885[/TD]
[/TR]
[TR]
[TD="class: xl22"]273[/TD]
[TD="class: xl22"]4[/TD]
[TD="class: xl22"]lose[/TD]
[TD="class: xl22"]0[/TD]
[TD="class: xl22"]273[/TD]
[TD="class: xl22"]-714.545[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]818.77[/TD]
[TD="class: xl22"] [/TD]
[TD="class: xl22"]273.9233[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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 ;-)
 
Upvote 0
[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl24, width: 64"]stake[/TD]
[TD="class: xl24, width: 64"]dec odds[/TD]
[TD="class: xl24, width: 64"]result[/TD]
[TD="class: xl24, width: 64"]win[/TD]
[TD="class: xl24, width: 64"]lose[/TD]
[TD="class: xl24, width: 64"]overall[/TD]
[TD="class: xl24, width: 64"] [/TD]
[TD="class: xl24, width: 64"] [/TD]
[TD="class: xl24, width: 64"] [/TD]
[TD="class: xl24, width: 64"]running loss[/TD]
[TD="class: xl24, width: 64"] [/TD]
[TD="class: xl24, width: 64"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.25[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]win[/TD]
[TD="class: xl24"]1[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]1[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.142857[/TD]
[TD="class: xl24"]7[/TD]
[TD="class: xl24"]win[/TD]
[TD="class: xl24"]1[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.33[/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-0.33[/TD]
[TD="class: xl24"]1.67[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]0.33[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.266[/TD]
[TD="class: xl24"]5[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-0.266[/TD]
[TD="class: xl24"]1.404[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]0.596[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.798[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-0.798[/TD]
[TD="class: xl24"]0.606[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]1.394[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.798[/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-0.798[/TD]
[TD="class: xl24"]-0.192[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]2.192[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.798[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-0.798[/TD]
[TD="class: xl24"]-0.99[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]2.99[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]1.995[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-1.995[/TD]
[TD="class: xl24"]-2.985[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]4.985[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]2.9925[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-2.9925[/TD]
[TD="class: xl24"]-5.9775[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]7.9775[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]2.9925[/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"]win[/TD]
[TD="class: xl24"]8.9775[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.25[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]win[/TD]
[TD="class: xl24"]1[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.2[/TD]
[TD="class: xl24"]5[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-0.2[/TD]
[TD="class: xl24"]3.8[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]0.2[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.6[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-0.6[/TD]
[TD="class: xl24"]3.2[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]0.8[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.45[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-0.45[/TD]
[TD="class: xl24"]2.75[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]1.25[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]0.5625[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-0.5625[/TD]
[TD="class: xl24"]2.1875[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]1.8125[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]1.40625[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-1.40625[/TD]
[TD="class: xl24"]0.78125[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]3.21875[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]2.109375[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-2.10938[/TD]
[TD="class: xl24"]-1.32813[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]5.328125[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]2.109375[/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-2.10938[/TD]
[TD="class: xl24"]-3.4375[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]7.4375[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]2.109375[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-2.10938[/TD]
[TD="class: xl24"]-5.54688[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]9.546875[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]2.636719[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-2.63672[/TD]
[TD="class: xl24"]-8.18359[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]12.18359[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]6.591797[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-6.5918[/TD]
[TD="class: xl24"]-14.7754[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]18.77539[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]9.887695[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-9.8877[/TD]
[TD="class: xl24"]-24.6631[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]28.66309[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]9.887695[/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-9.8877[/TD]
[TD="class: xl24"]-34.5508[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]38.55078[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD="class: xl24"]9.887695[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]lose[/TD]
[TD="class: xl24"]0[/TD]
[TD="class: xl24"]-9.8877[/TD]
[TD="class: xl24"]-44.4385[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"]48.43848[/TD]
[TD="class: xl24"] [/TD]
[TD="class: xl24"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]corrected decimal odds[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]does this look right ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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....
 
Upvote 0
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.....
 
Upvote 0
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.
 
Upvote 0
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

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.
 
Last edited by a moderator:
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,915
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top