Triggering Bets On-play Within Odds Range

[jrarmstrong]

Hi,

I am trying to adapt the Place Bets sheet to trigger bets in play. All is working fine except I cannot get the sheet to consistently fire positions when the current odds are within a specified odds range.

For example, if I set min odds of 4 and max odds of 6 often the current odds will fall within this range but no bet will be placed (matched or unmatched). I have set the sheet to refresh every 0.2 seconds and have not changed the vba code.

Is there something I need to do to ensure the bets trigger?

Thanks,

James

[brumbie]

I would be trying something like:

In cell Q5:

=IF(AND(E$2="In Play",F$2<>"Suspended"),IF(AND(O5>=4,O5<=6),"BACK"," ")," ")

[jrarmstrong]

Thanks brumbie. The issue is not with the trigger, that works fine. The issue seems to be with BA "reacting" to the price being within the range. Often it just doesn't react.

James