Excel, Place second bet on same selection without CLEAR?

[larcy]

Been using triggered betting for some time now and familar with excel

Question, so when placing a bet using excel, one can have a formula that will put a BACK (or other trigger to bet) in column Q, the system will then place a BACK bet using the odds and stake in R and S, and will update column T with the bet reference when bet is succesfully placed

However what if one wanted to place a second bet on the same selection using the same line in the worksheet on the next refresh. Since use of BACK will require column T to be empty (otherwise it just won't place the bet), one needs to use a CLEAR trigger in column Q, and then another BACK trigger in column Q. THis means that you need to waste a refresh cycle to do the BACK to CLEAR to BACK. Ideally I'd like to miss out the CLEAR and just do a BACK, then on the next refresh do a BACK again.

So is there any way to have the BACK work regardless of the contents of column T, or alternatively to have column T cleared automatically without having to use the CLEAR trigger

[Captain Sensible]

If you're looking to place the same bet on the next refresh why not just double your stake in the first place. Unless you're trying to fire off a bunch of no liability bets it's hard to see why you'd want to fire off duplicate bets in a short space of time.

[larcy]

If you're looking to place the same bet on the next refresh why not just double your stake in the first place. Unless you're trying to fire off a bunch of no liability bets it's hard to see why you'd want to fire off duplicate bets in a short space of time.

Because at the time you place the first bet, you do not know if you are going to want to place the second bet, and if you do it may not be for the same stake or odds

[Captain Sensible]

You'd really need to start looking at using VBA to place your bets if you want to avoid using clear. The problem with formulas is they'd just contually place bets in a loop if they weren't stopped by the better in Col T and that can't be cleared until the server responds with a bet ref. VBA might seem complicated at first but it's not much harder than formulas and you have full control.

Only other option is use two sheets as BA will use the same refresh data if the refresh rate and market are the same.