BACKSP Bets Being Cancelled

[GaryRussell]

Sorry, I don't know why I didn't notice before because you mentioned the fact that you are using the Place Bets example spreadsheet in your first post. I don't know how much you have modified this example, but if you haven't changed it much then this will be the cause of the problem.

The odds range you enter in the place bets spreadsheet is the range used to trigger the bet, it does not mean if the SP is between these prices then you will get matched. It means if the current back odds are in this range then trigger the bet requesting the current back odds. If it's being placed close to the off using the current best back odds then there is every chance that these odds will be more than the actual SP.

If you want all your bets to be matched then you could just change it to always insert 1.01 in column R when the bet is triggered so that you are saying the minimum SP odds you will accept are 1.01.

I assume column R currently contains something like the follow.

Code: Select all

=IF(AA5="BACKSP",AH5,AI5)

Change it as follows.

Code: Select all

=1.01

[jrarmstrong]

Gary, touch wood your'e suggestion has done the trick. 5/5 have placed successfully today so hopefully its sorted. Thanks again