More than one back bet

[Ryan1uk]

Hi,

My spreadsheets seem to be making BACK bets more than once. I have had up to 4 BACK bets on one single horse. I have Guardian open with all the day's racing and refresh interval 10 seconds.

I scrape horses into 'Runners' spreadsheet then have the 'Bet Angel' spreadsheet search 'Runners' and if there is a match it places the 'BACK' bet. This is the code I use

=IFERROR(IF(AG$1<=0.2,VLOOKUP(B11,Runners!D$2:J$278,7,FALSE),""),"")

AG1 =SUM(AA:AA)

I have attached the workbook if that's any help.

Thanks for your time and any help much appreciated.

[Ryan1uk]

Anyone? Please