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.
