Good day! I have an automatic clearing status in Excel and set the bet conditions with AA10=0,U10=0,AB10=0. But still bet twice at the same time.Could anyone please tell me how to avoid multiple bets after clearing status ?
Thank you so much.
how to avoid multiple bets after clearing status
Hi Guys,
Good day! I have an automatic clearing status in Excel and set the bet conditions with AA10=0,U10=0,AB10=0. But still bet twice at the same time.Could anyone please tell me how to avoid multiple bets after clearing status ?
Thank you so much.
Good day! I have an automatic clearing status in Excel and set the bet conditions with AA10=0,U10=0,AB10=0. But still bet twice at the same time.Could anyone please tell me how to avoid multiple bets after clearing status ?
Thank you so much.
The unmatched bet count is one way of doing it. Unless your code is clearing the cell many times per second. In which case the unmatched bet count may not get updated quickly enough and you will still get multiple bets firing.
I would add a routine that introduces a one second pause before the status cell is cleared. This would give the sheet enough time to update all the data.
I would add a routine that introduces a one second pause before the status cell is cleared. This would give the sheet enough time to update all the data.
Yes,6thSense,you are right. It still got the multiple bets after adding V10=0 into the bet condition.
As you said,you pause a one second to cleaning the status cell,if the status cell appeared "PLACED",that's ok. When the status cell appeared "ERROR", it should be missing the chance to bet .
As you said,you pause a one second to cleaning the status cell,if the status cell appeared "PLACED",that's ok. When the status cell appeared "ERROR", it should be missing the chance to bet .