question on the bet rule options in Excel

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
verycrispy
Posts: 18
Joined: Wed Jun 23, 2010 12:45 am

HI all,

IN the manual of betangel is a list of bet rule options:
OFFSET : X
FILL_KILL : TRUE
FILL_KILL : FALSE
KILL DELAY : X
BATCHES:X
STOP : X
STOP_PLACE : X
TRAILING_STOP : TRUE
TRAILING_STOP : FALSE
WITH_GREENING: TRUE
WITH_GREENING: FALSE
CLOSE_TRADE – This will close a position using net stake on selection at currently available price
GREEN – This will close a position by invoking the built-in greening routine within Bet Angel on the selection. Any profit or loss on the selection will be evenly spread across all selections.
CANCEL – This will cancel individual unmatched bets with the Betfair bet reference detailed in cell Rx
CANCEL_ALL
CANCEL_ALL_BACK
CANCEL_ALL_LAY
I tried to find it out on my own, but when I try to create such a rule, I always get a message.

What I want is:

If parameters are certain values, Back, wait 10 seconds, if it is not filled: cancel the bet.

The betangel manual is so broad explained for all the easy stuf, but just the somewhat more dificult stuf like these scripts it just sums up the different scripts without explaining what it all means. If someone could help me, that would be very nice

thanks in advance!
User avatar
Shamrock
Posts: 205
Joined: Thu Sep 30, 2010 11:41 am

Hi VC,
In the spreadsheet (L2), there is an example which is pretty easy to understand and tweek to get what you want.
You need to place the command inside an IF statement. If you are waiting for the value(Odds) in M9 to hit 2.40 then the command (placed in L9) would be
=IF(M9>=2.4,"BACK FILL_KILL:TRUE KILL_DELAY:10","")
What the above is saying, if the odds at M9 are greater than or equal to 2.40 then back with a fill kill of 10 seconds.
Remember to leave a space between commands (that caught me for a while), there are three commands above
BACK
FILL_KILL:TRUE
KILL_DELAY:10

Hopes this helps.
verycrispy
Posts: 18
Joined: Wed Jun 23, 2010 12:45 am

thanks a lot, it works!
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”