Excel Help

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
stuffy
Posts: 24
Joined: Sat Oct 07, 2017 11:54 am

Good Evening
i am using the bet angel auto trade V2 sheet but struggling with a formula, can anyone assist?

i want to tell the sheet for example

IF, the price on the lay price is between say 3.5 and 3.9 to then back at 1.8. however, i can get this to work but i want it to do is to only do this, if this price range is at 5 minutes before KO

make sense?

Thanks
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

Set L9 to =if(AND(B9>3.5,B9<3.9,$F$4<=time(0,5,0)),"BACK","")
M9 =1.8
stuffy
Posts: 24
Joined: Sat Oct 07, 2017 11:54 am

Fantastic. thank you

i was so close, just struggled with getting the time bit
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

sa7med wrote:
Wed Apr 15, 2020 6:53 pm
Set L9 to =if(AND(B9>3.5,B9<3.9,$F$4<=time(0,5,0)),"BACK","")
M9 =1.8
Actually it's not B9 it's G9, my bad!
stuffy
Posts: 24
Joined: Sat Oct 07, 2017 11:54 am

How do i bets so they go inplay?

thanks
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”