calculator

[manpreet]

Hi guys
Ive looked every where for this specific type of calculator but kind find one, so would appreciate if someone can point me ij the right direction:

Its not a usual type of surebet but with revealing much is there a calc that will-
Back 2 bets; lets call them betA and bet B, if betA loses i want to back a third bet, betC (not a usual type of surebet but sort of works for me. So id like
BetA to cover betBs loses (two ways)
BetB to cover betA and betCs loses (three ways)
BetC to cover betAs and BetBs loses..and because its a little confusing below is a simple version:
BetA - backed at 2.0 with £50, £50 profit
betB - backed at 3.0 with £50, £100 profit
BetC - backed at 3.0 with £50, £100 profit
THE USUAL 3-WAYS CALC DOESNT WORK FOR THIS

[doubleback]

I'm slightly abbreviated at the moment and not too sure of your scenario or aim.

With that caveat firmly out the way I shall give a couple of postulations;

A) £50 @ 2

B) £50 @ 3

C) £50 @ 3

Average Odds;

(50*(2-1)) + (50*(3-1)) + (50*3-1) = 150 * (x-1)

or

250 = 150 * (x-1)

solve for x

(250/150) + 1 = x

2.66 = x = average odds


With average odds being < 3 [break even point] you will have some liability to manage, therefore;

BetA to cover betBs loses (two ways)
BetB to cover betA and betCs loses (three ways)
BetC to cover betAs and BetBs loses

is impossible without having liability on one of the three bets.

Arbing will also result in a loss.

Then there is using Bet (C) to cover Bet (A) & (B)

(Bet (A) Stake + Bet (B) Stake) / (Bet (C) Odds - 1)

50 + 50 / (3 - 1) = £50

[doubleback]

Carrying on with this a bit further, go to bed DB, go to bed ... !

Of course, the average odds calculation would, on first glance, be ...

(a + b + c) / iterations

therefore;

(2 + 3 + 3) / 3 = 2.66

Although the calculated average odds is the same as in my last post, the above calculation does not consider stakes/weighting.

Changing the stakes will alter average odds, e.g.,

Bet (A) £200 @ 2

Bet (B) £50 @ 3

Bet (C) £50 @ 3

(200*(2-1)) + (50*(3-1)) + (50*(3-1)) = 300 * (x-1)

(400 / 300) + 1 = 2.33



Finally, Bet (A) stake is dependent on Bet (A) winning or losing - Excel would call that a Circular Reference.

Hope that helps - goodnight!

[lcredd]

Did you get to bed eventually? Here is some bed time reading which definitely won't help: Unsolved Maths

[doubleback]

Yep, I had a mug of Ovaltine, donned my Spiderman Barrack Obama's, jumped in the sack and went out like a light!

[manpreet]

Thanks for your post db, i understand where your coming from, but its not a normal sort of surebet, its more like if betA flops i want betC to come in just incase betB doesnt work out. It sounds silly and it isnt even a surebet tbh because if betA flops betB should traditionally 100% work but betB only works 90% so just incase it lands on the 10% mark i wanted betC as an insurance. It does work im currently doing it but its hard to work out without a calculator and by the time i eventually get to a number the prices move(through trial and error, im not good at maths so havent worked out a formula). Its hard to explain without giving away the strategy...

[doubleback]

Have a look at this;



- only change the cells filled with yellow

- change the odds and the initial level of stake

- stake ratio is worked out and multiplied by the initial stake - thus giving the required stake size

- the bottom three rows show the results of the various scenarios;

profit from Bet (A) - Bet (B) stake ... so on and so forth ...

- enter ‘0’ in the Bet (C) Odds field to ignore Bet (C), however, when odds are entered for Bet (C) you will need to adjust Bet (B) somehow.


The Stake Ratio;

Bet (A) = 1 / (Bet (A) Odds - 1)

Bet (B) = (Bet (A) Stake Ratio) / (Bet (B) Odds - 1)) + (Bet (C) Stake Ratio) / (Bet (B) Odds - 1 ))

Bet (C) = ((Bet (A) Stake Ratio) + (Bet (B) Stake Ratio)) / (Bet (C) Odds - 1)


download sheet

You may have to turn Circular References off;

Click Excel orb [top left corner] >

Click Excel Options >

Click Formulas >

Make sure “Enable iterative calculation is ticked”.

[theprotrader]

Do you have a degree in Maths, db? I've noticed you seem to love all this kind of stuff.

[doubleback]

Sudoku black belt ...

[luckynumberslevin]

Yep, I had a mug of Ovaltine, donned my Spiderman Barrack Obama's, jumped in the sack and went out like a light!

I believe you db. By the way if you pop down to your local naff ware outlet they're offering a full set of batman ones. Do the maths, you know it makes sense. Count yourself lucky though, they only had Robins in my size Looks like I'll have to settle for Cran's cast offs.

[doubleback]

I believe you db. By the way if you pop down to your local naff ware outlet they're offering a full set of batman ones. Do the maths, you know it makes sense. Count yourself lucky though, they only had Robins in my size Looks like I'll have to settle for Cran's cast offs.

That's just too baaaaaaaaad!

[manpreet]

Db your a legend, thank you very much for this effort, you've probably saved me a lot off dollars. Haven't tried it yet but either way i'll be sure to let you know

[luckynumberslevin]

On a side note, I have lost my precious loved one who meant an awful lot to me a month or so ago. Yes my push bike has finally be laid to rest. I was going some, down a steep ingradient on the yorkshire pennines during a wet spell when the bike decided to forever understeer and head me into the nearest wall. Pissed off I inspect my legs to see them red raw with skin hanging down from the sides akin to bandages. So I grabbed my phone out of my back pocket only to realise that the phone shook within its hard shell case. Not a good sign since there seemed to be no life anywhere close. Pissed off even more I picked up the bike and slammed it several more times into the semi knocked down wall after which I had a long walk back to civilisation.
So if you're ever in the area of yorkshire and pass a dry stone wall with carbon fibre additions, lay a few flowers and say a little prayer. Let my loved one know that if she is to be replaced it will be for a better version. And failing that I could always come round and borrow that Chopper of yours.

[doubleback]

Db your a legend, thank you very much for this effort, you've probably saved me a lot off dollars. Haven't tried it yet but either way i'll be sure to let you know

Cheers. I think the sheet might need a bit of tweaking, but it will give you something to work with.

[doubleback]

On a side note, I have lost my precious loved one who meant an awful lot to me a month or so ago. Yes my push bike has finally be laid to rest. I was going some, down a steep ingradient on the yorkshire pennines during a wet spell when the bike decided to forever understeer and head me into the nearest wall. Pissed off I inspect my legs to see them red raw with skin hanging down from the sides akin to bandages. So I grabbed my phone out of my back pocket only to realise that the phone shook within its hard shell case. Not a good sign since there seemed to be no life anywhere close. Pissed off even more I picked up the bike and slammed it several more times into the semi knocked down wall after which I had a long walk back to civilisation.
So if you're ever in the area of yorkshire and pass a dry stone wall with carbon fibre additions, lay a few flowers and say a little prayer. Let my loved one know that if she is to be replaced it will be for a better version. And failing that I could always come round and borrow that Chopper of yours.

You wasn't wearing cycling shorts was you?!

Thank god you didn't crash in an urban area and have to walk home through crowded streets!