Bet Angel - Spreadsheet / Excel chat : Excel Help

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

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.

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

Sat Aug 11, 2018 2:27 pm

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: 328
Joined: Thu Jan 26, 2017 11:52 am

Sat Aug 11, 2018 5:01 pm

Thanks sa7med
Will give it a try

StellaBot
Posts: 328
Joined: Thu Jan 26, 2017 11:52 am

Fri Aug 17, 2018 4:33 pm

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: 1748
Joined: Sun Jan 31, 2010 8:06 pm

Fri Aug 17, 2018 5:37 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: 328
Joined: Thu Jan 26, 2017 11:52 am

Fri Aug 17, 2018 7:23 pm

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: 328
Joined: Thu Jan 26, 2017 11:52 am

Fri Aug 17, 2018 7:41 pm

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,"")

User avatar
CallumPerry
Posts: 168
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Fri Aug 17, 2018 8:44 pm

=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: 328
Joined: Thu Jan 26, 2017 11:52 am

Fri Aug 17, 2018 9:38 pm

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”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest