Excel formula for “correct scoreâ€

[taylormadev]

Can someone provide a formula for excel to trigger this bet for me

I am betting on “correct score” for soccer. 1 minute from kick off I want to place a lay bet on 0:0 if odds are 16.5 or less. My liability would be 100% of my bank

Sometimes I have 6 bets a day. I bet on both the 0:0 or the unquoted “correct score” but don’t know which bet I will take until I do my research for the day

I am thinking if I get the formula for the bet in BOLD I should be able to work out the rest

Also if I were to have 6 bets for the day with different “correct score” at different times throughout the day can I set up 6 different worksheets for each bet which would then be triggered at the appropriate times?

Thanks in advance

[Captain Sensible]

No need for 6 different sheets, just load your 6 markets in the quick pick list (drag drop or press q to add it to the list) and set auto select markets to go to the market one minute before the off.

For your 0-0 lays as the trigger will always be in the same place on the sheet just use some formula like these in the following cells assuming you're sending the info to cell A1 and you're taking the odds on offer

Q5 (trigger cell)

=IF(AND(D2<0.000694,E2="Not In Play",H5<=16.5),"LAY","")

D2 contains the time till the off, 0.000694 is 1 minute, E2 has market info ( dont want to send bets if the market is suspended or in play). H5<=16.5 just checks the odds are in your range

R5 (Odds column)

Just put +H5 if you want to take the odds on offer

S5 (stake colum)

Put in =ROUNDDOWN(I2/H5,2)

That'll just take the current balance I2 and work out your stake using the current odds and round it down to 2 decimal places.

Just mess around with small stakes until you're sure everythings working how you want it. I transfer cash into the australian wallet if I want to limit my available cash/stakes without withdrawing to my bank.

Just add as many extra conditions/criteria in the formulas you can think of to protect your balance, only takes one badly coded trigger to wipe out your bank whereas missing a couple of matches to get things working properly isn't going to make much difference to your profits in the long run

[taylormadev]

Thank you very much Captain Sensible for your reply

Will try it out and see how I go

[taylormadev]

By the way

I am guessing that formula was for if ALL games were "cs" 0:0

If the games were to alternative from 0:0, unquoted, 0:0, unquoted, 0:0, unquoted, how could I automate this sequence?

[Spike]

You sure this is a good idea? Kinda doesn't sound like one...... You couldn't have asked for a better answer from the cap'n- but I would just say take care that you load the right markets or you'll be betting on all sorts of things.

[Ian]

For how many consecutive matches to you propose to risk your whole bank ?

[Captain Sensible]

By the way

I am guessing that formula was for if ALL games were "cs" 0:0

If the games were to alternative from 0:0, unquoted, 0:0, unquoted, 0:0, unquoted, how could I automate this sequence?

A lot depends on how competent you are with excel easiest way would be just to set up two tabs with one for unquoted one for 0-0. If you're fine with excel just put your selections and scores on a separate sheet and use vlookup to decide which score you're betting on , there's a thread

http://gruss-software.co.uk/forum/viewt ... t&start=15

that went through the setup of backing/laying different horses at certain odds etc that'd be just as easy to use for correct scores and give you that added protection of making sure your bets were only fired on selection you wanted.

I'd echo other posters comments about risking your bank on this method as by it's very nature it'll fail as you'll hit a loss sooner or later. Not only will that clear your bank but it'll also most likely mean you'll have no funds betting any remaining matches which will probably go your way.

Consider using 5% of the bank and change the stake column

=ROUNDDOWN((I2*.05)/H5,2)

I'd also add other conditions to the trigger to ensure it'll only act on 0 - 0's

=IF(AND(D2<0.000694,E2="Not In Play",H5<=16.5,A5="0 - 0"),"LAY","")


With triggered betting it's easy to click on markets without remembering they're linked to an excel sheet and you could end up firing bets on alsorts of markets.