Excel Automation - Avoiding More Than One Bet

[alnomes1]

Hi all,

I have set up excel automation which is selecting a horse to lay at specific conditions.

I only want to trigger one bet per race but sometimes the condition can arise more than once and trigger a second bet.

I have it set that only one bet per horse can get triggered but my spreadsheet currently enters two bets into the market, instead of the intended one per market, when more than one horse qualifies.

Is there a safeguard or rule in Guardian that I can set up to avoid multiple bets or do I integrate the rules onto my excel spreadsheet?

Thanks for any assistance.

[Aberdeentrad]

I’d be interested to hear if there is a way to do this in guardian, I did look at potentially unlinking sheets or something once bets were placed.

What I did in the end for a similar issue was use a log sheet - assuming you are using a macro or similar to place the bets I used a bet log which in my case avoided additional bets being placed on the same horse but could set it up to log markets.