Firing bets at a set time plus more unwanted bets?

[rinconpaul]

In my Report column(L), I have a formula that fires Lay bets, to Take SP, at the official start time when the countdown timer reaches 00:00:00. That works fine BUT in the time between 00:00:00 and actual start , if things change on the attached worksheet and more Lay bets are generated, these instructions still pass onto the Bet Angel spreadsheet and it keeps placing new bets DESPITE the countdown timer having passed 00:00:00. I don't want that to happen as my strategies have been all based on data collected at the official start time.

Any ideas or remedies on how to prevent Bet Angel defying an IF function: ("=IF(AND(F$4=0,'Price Order'!Z9="LAY"),"LAY","")? F$4 being the countdown timer and 'Price Order'!Z9 being the cell that has turned to "LAY" on another worksheet.

[Euler]

In theory you should have error trapped it with that line. So I guess the next step is to break out the logic and try and figure why it's not working. Perhaps the function of time is not resolving to 0, that's my guess. You are comparing a time variable with a decimal value?

[PeterLe]

You could also add to the code to only fire a lay bet in when the number of unmatched bets (or matched bets =0)..that way it will only fire one bet in
Regards
Peter

[rinconpaul]

You know what Peter...that's the most common sense thing I've read on this forum all week! I just tried it. Unfortunately it double bet in that split second, which from reading posts seems to be an inherent defect in BA. Maybe I've got to tweak refresh rates or something?

I tell you what though, when or IF, I get this workbook up and running as a fully auto, "Bet, Copy & Clear" bot, I'll be putting it on the example spreadsheet page (as nothing on there even comes close) for every other newbie to benefit from without suffering the pain I'm going through with this Enigma Code, alias Bet Angel!