Excel IF

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
leerudd
Posts: 28
Joined: Tue Dec 01, 2020 1:29 am

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
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

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.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”