Triggered Betting

[jamesfr]

I know very little about Excel so could some kind person please tell me step by step how to use triggered betting.

I want to back one or more horses in running but only if they hit a certain price.

I would prefer if possible to enter a price range to back at e.g between 4,5 and 5 so that I'm sure to be matched ,I would imagine just entering 5 runs the risk of the betting jumping from 5.4 to 4.9 and my bet not being taken.

I don't want it to kick in straight away and would like to manually activate the request as soon as the prices have settled after the off .

Thanks in advance for any replies

[jamesfr]

Ok think I have it ,I just need to enter

BACK in the trigger columns

The required stake in the Stake column

but how do I specify a price range in the odds column ? e.g between 4.5 and 5

[tkp]

Hi jamesfr

you use an IF statement to see if the price(s) you want has been acheived.

e.g.

if you want the trigger to fire at 4.5 then you would have something similar to

=IF(F5=4.5,"BACK","NOT HIT MY TARGET YET")

If you were to put this into the trigger cell you would find that the 1st time the BACK ODDS1 of runner 1 (which is in row 5) hit 4.5 the word BACK would apear in the cell.

So long as you have something in the ODDS cell of the right trigger cell and something in the STAKE cell this will fire off the order.

To do your price range the following is what you need:

=IF(AND(F5>=4.5,F5<=5),"BACK","NOT HIT MY TARGET YET")

Have a look at Gary's demo spreadsheets.

Also - do a search in Excel help for IF and AND you'll find some examples of how to use them.

Hope that helps.

tkp

[jamesfr]

Thanks TKP just th job

One more question ,if I want to set the trigger to kick in maybe 5 seconds after the off ,is there a way to set this up before the off ?

Or would I have to enter the instructions after the off

Is there a way to set everything up before a race and execute the bet, with one click, at a certain time in-play?

[mikeeboy]

Thanks TKP just th job

One more question ,if I want to set the trigger to kick in maybe 5 seconds after the off ,is there a way to set this up before the off ?

Or would I have to enter the instructions after the off

Is there a way to set everything up before a race and execute the bet, with one click, at a certain time in-play?

Well, yes, that's the whole point of triggered betting, you set it all up and then let it do its stuff, without any clicking.

[jamesfr]

Cheers Mike

A very helpful response

How do you stop the bet from executing straight away after you enter the formula and stake ?
Would it for carry over to in-running if placed before the off?

[tkp]

jamesfr

yes - you can trigger past a certain time....

you need to add in another IF formula somewhere that checks the time.....and the status of the race - i.e. IN-PLAY......then another that checks your price range....and then in the trigger cell use an if formula that checks when your time and in-play formual is true AND your price range formula is TRUE

so that the trigger only fires when both are true....

Again - have a look at Gary's example spreadsheets.

tkp

[jamesfr]

thanks again