Excel Help

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Hi
Can anyone please explain where and how to put the (fill or kill:true false)
into a spreadsheet.
For example in L9
I have =IF(G9<4,"BACK","") which works perfectly.
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

StellaBot wrote:
Sat Aug 11, 2018 2:02 pm
Hi
Can anyone please explain where and how to put the (fill or kill:true false)
into a spreadsheet.
For example in L9
I have =IF(G9<4,"BACK","") which works perfectly.
=IF(G9<4,"BACK FILL_KILL:TRUE KILL_DELAY:x","") where x equals time in seconds
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Thanks sa7med
Will give it a try
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Cant seem to get this to work
eg if G9=3
=IF(G9<4,"BACK FILL_KILL:TRUEKILL_DELAY:10","")
When entered into L9 and press return, all of the above formula appears in L9
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

What do you mean all of the formula?

If G9 is 3 then that's less than 4 so the IF statement is true and it should display

Code: Select all

BACK FILL_KILL:TRUEKILL_DELAY:10
I'm assuming you've done a typo as there should be a space between TRUE AND KILL

Code: Select all

=IF(G9<4,"BACK FILL_KILL:TRUE KILL_DELAY:10","")
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Thanks SB
Seems to be working ok.

Just as an afterthought, what I do sometimes is log into practice mode
load up race/s into excel.
Log out. Keep excel open and manually change the BA spreadsheet
to see its effect on spreadsheet eg firing bets in etc
Makes it more leisurley to check its functionality.
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Another question please
does anyone know if
in the GY<4, part
=IF(G9<4,"BACK FILL_KILL:TRUEKILL_DELAY:10","")
can that be replaced by an if and then statement
e.g instead of G9<4,

EDIT

(AND(G9<4,AG9=x,"")
CallumPerry
Posts: 575
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

=IF(G9<4,"BACK FILL_KILL:TRUEKILL_DELAY:10","")

Becomes...

=IF(AND(G9<4,AG9=x),"BACK FILL_KILL:TRUEKILL_DELAY:10","")

Just replace the bold part of the first example with the extended parameters you wish to include, ensuring the whole thing is encased in brackets and the word AND is infront.

If you want to nest further IF's you need to do it like this...

=IF(A,"Outcome of A",IF(B,"Outcome of B",IF(C,"Outcome of C","")))

^Note how the brackets only close at the very end so keep a count of how many you need.

Which means: if A, do outcome of A else, if B, do outcome of B else, if C, do outcome of C else do nothing. You just keep adding them on like this. Hope that answers your question!
StellaBot
Posts: 818
Joined: Thu Jan 26, 2017 11:52 am

Thanks CP and all people above
Initial offline trials on 1 horse under 4/1 in each race worked
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”