HOW to STOP bets being placed during IN-play racing on Excel

[Bot2020]

Hi people

I'm need of some help, I have an automation rule that places one bet in guardian automation which essentially will trigger a single bet in excel, if it matches the 'P & L' Condition and of the specific odds (basically under or over 2.3 for a paticular horse), the formula is in every horse commands column (column L) and so far it has worked fine! the formula looks like this...

=IF(AND(C9>0,G9<2.3),"BACK",IF(AND(C9<0,G9>2.3),"LAY",""))


My issue is that it places a bet more then once, mostly that happening during in-play and I haven't found a way to limit the number of bets, I want to now stop any bets being placed during 'IN-play' as a solution to my problem.

...my question is what can I add to my formula to stop any bets being placed during 'IN-play' using this formula I've presented above.

[sa7med]

Hi people

I'm need of some help, I have an automation rule that places one bet in guardian automation which essentially will trigger a single bet in excel, if it matches the 'P & L' Condition and of the specific odds (basically under or over 2.3 for a paticular horse), the formula is in every horse commands column (column L) and so far it has worked fine! the formula looks like this...

=IF(AND(C9>0,G9<2.3),"BACK",IF(AND(C9<0,G9>2.3),"LAY",""))


My issue is that it places a bet more then once, mostly that happening during in-play and I haven't found a way to limit the number of bets, I want to now stop any bets being placed during 'IN-play' as a solution to my problem.

...my question is what can I add to my formula to stop any bets being placed during 'IN-play' using this formula I've presented above.

if you don't want it to trigger during inplay just add a condition to your formula that looks for the "in-play" cell. I think it's H1, ie (H1<>"in-play"), make sure you get the spelling and capitalization correct. if you want it to place a bet only once, you could check the matched bet volume cells to see if they are > 0.

[Bot2020]

Hi people

I'm need of some help, I have an automation rule that places one bet in guardian automation which essentially will trigger a single bet in excel, if it matches the 'P & L' Condition and of the specific odds (basically under or over 2.3 for a paticular horse), the formula is in every horse commands column (column L) and so far it has worked fine! the formula looks like this...

=IF(AND(C9>0,G9<2.3),"BACK",IF(AND(C9<0,G9>2.3),"LAY",""))


My issue is that it places a bet more then once, mostly that happening during in-play and I haven't found a way to limit the number of bets, I want to now stop any bets being placed during 'IN-play' as a solution to my problem.

...my question is what can I add to my formula to stop any bets being placed during 'IN-play' using this formula I've presented above.

if you don't want it to trigger during inplay just add a condition to your formula that looks for the "in-play" cell. I think it's H1, ie (H1<>"in-play"), make sure you get the spelling and capitalization correct. if you want it to place a bet only once, you could check the matched bet volume cells to see if they are > 0.

Hi sa7med, thanks for responding...

so essentially...

=IF(AND(C9>0,G9<2.3,H1<"in-play"),"BACK",IF(AND(C9<0,G9>2.3,H1<"in-play"),"LAY",""))

is that right?

[ShaunWhite]

...

=IF(AND(C9>0,G9<2.3,H1<"in-play"),"BACK",IF(AND(C9<0,G9>2.3,H1<"in-play"),"LAY",""))

is that right?

Use not equal rather than less than.

=IF(AND(C9>0,G9<2.3, H1 <> "in-play"),"BACK",IF(AND(C9<0,G9>2.3,H1<>"in-play"),"LAY",""))

And as sa7med said, check the text you are checking is exactly the same as what appears in H1. Eg "in-play" isn't the same as "In-play"

[Bot2020]

...

=IF(AND(C9>0,G9<2.3,H1<"in-play"),"BACK",IF(AND(C9<0,G9>2.3,H1<"in-play"),"LAY",""))

is that right?

Use not equal rather than less than.

=IF(AND(C9>0,G9<2.3, H1 <> "in-play"),"BACK",IF(AND(C9<0,G9>2.3,H1<>"in-play"),"LAY",""))

And as sa7med said, check the text you are checking is exactly the same as what appears in H1. Eg "in-play" isn't the same as "In-play"

RIGHT!... thanks for replying Shaun ...just checking it now! and just to ask you in the meanwhile what does this sign mean '<>' because usually id think that would be either 'greater' of 'less than' were in this instance Im using both!?

[ShaunWhite]

"<>" means "not equal to"
">=" means greater than or equal to
"<=" means less than or equal to
">" means greater than
"<" means less than

If in doubt Google "excel mathematical operators"

[Bot2020]

"<>" means "not equal to"
">=" means greater than or equal to
"<=" means less than or equal to
">" means greater than
"<" means less than

If in doubt Google "excel mathematical operators"

Hi Shaun, great thankyou for help it has worked, sorry for the late response,... overall i decided a different stratedgy to apply as the 'in-play' sometimes doesnt appear in the cell during in-play.

[ShaunWhite]

"<>" means "not equal to"
">=" means greater than or equal to
"<=" means less than or equal to
">" means greater than
"<" means less than

If in doubt Google "excel mathematical operators"

Hi Shaun, great thankyou for help it has worked, sorry for the late response,... overall i decided a different stratedgy to apply as the 'in-play' sometimes doesnt appear in the cell during in-play.

What sport are you using it on? 'In-play' should aways appear unless the market doesn't actually turn in-play such as in greyhound racing or aus horse place markets etc.

[Bot2020]

hi Shaun im using .... 'greyhound racing or aus horse place markets'... Yep!

[ShaunWhite]

hi Shaun im using .... 'greyhound racing or aus horse place markets'... Yep!

Those don't have an in running market so you don't have to worry about it, bets won't be accepted when the market is suspended.