Hi Guys,
I could use some help if possible.
I want to automate a bet, both back and lay when a cell reaches a certain number or less or greater than that number. I also want it to fire another bet to green the first bet.
So if cell say a1 is =>0.96 then lay also adding a back bet 2 ticks bigger.
Then vice versa
So if cell say a1 is =<1.04 then back also adding a lay bet 2 ticks smaller.
Im also intersted if its possible to run this multiple times, I dont just want it to fire once.
Thanks in advance guys as my excel is average and im stumped
Excel IF
In column L for the bet rules (rows 9, 11, 13, etc) you could have the following
=IF(A1 >= 0.96, "LAY OFFSET:2 WITH_GREENING:TRUE", IF(A1<=1.04, "BACK OFFSET:2 WITH_GREENING:TRUE", ""))
Column M populate your odds
Column N populate your stake
There is code sample here for cleaning the status cell but as warned it will trigger the bet multiple times if you're constantly clearing
viewtopic.php?f=31&t=7181
You would probably want to add some form of conditions around number of bets matched, countdown, etc.
=IF(A1 >= 0.96, "LAY OFFSET:2 WITH_GREENING:TRUE", IF(A1<=1.04, "BACK OFFSET:2 WITH_GREENING:TRUE", ""))
Column M populate your odds
Column N populate your stake
There is code sample here for cleaning the status cell but as warned it will trigger the bet multiple times if you're constantly clearing
viewtopic.php?f=31&t=7181
You would probably want to add some form of conditions around number of bets matched, countdown, etc.