BACK_TO_LAY Bot help

[Sooty1307]

Hi, currently on my free 30 day trial and am getting my head around the Excel integration for automation. I have downloaded the BACK_TO_LAY bot from the forum which works, I just don't understand an element of it.

I understand all of the workings behind placing the SP bet, however I don't understand why the LAY bet triggers when "LAY" should only appear when the bet reference cell is blank (""). Once the Back bet is placed then the bet reference in column T is populated and I can't work out what clears it so the lay can be placed.

The bot is working fine so however it is doing it is great, but for my understanding before I take it live with more than one selection I would like to understand the lay element. Any help would be greatly appreciated.

Many thanks

[Captain Sensible]

Probably best give a link to to excel sheet as I can't see it in the sample sheets forum. I'd imagine it's probably using VBA to clear the trigger betting column by checking the bet ref column

[Sooty1307]

viewtopic.php?f=5&t=9571

It was the one posted here… could well be something in VBA, I have never used VBA but heard it talked about a fair bit on here. If you get a chance to take a glance and let me know that would be brilliant! It is working as it stands but for my own knowledge I’d like to know why/how the lay is triggering and what triggers the bet reference to clear.

Many thanks for the help

[Captain Sensible]

There's some VBA that clears the cells T5:X50 if cell AA1 is between 0 and 5

Code: Select all

If turnedInPlay And Range("AA1").Value >= 0 And Range("AA1").Value <= 5 Then Range("T5:X50").ClearContents

[Sooty1307]

Thank you very much for that, I think I need to get some more knowledge of VBA before I continue with Gruss. It seems an excellent and strong piece of kit, just a bit beyond my skills at the moment as I have never written anything in VBA.

Thanks again for the help

[Captain Sensible]

No worries, I only learnt VBA because of BA and the help of this forum. Looks a lot harder than it is to be honest. If you can write excel formulas you'd be able to learn VBA quite quick