Use this to add additional powerful checks on other runners or selections parameters plus other options.
If you click this box a new window pops up.
There is some test data that can be used for testing the filter.
Variables that can be checked are in red highlight below.
Here you can add multiple scenarios that use formulas similar to excel.
E.g. You may have selected 3rd fav in the favourite box, but you also don't want to bet if it's in trap 2.
Runners(this).StallDraw <> 2
You can add these to the favourite selections or other strategy or you own individual selections.
Remember to click Add to System to apply to activate them.
To delete the formula click delete or highlight the forumula and delete key on PC.
There are a few pre-built formulas to show you how it works which you can also edit and save to your own
scenerio name.
Further examples:
You could be selecting the 1st fav to lay in the correct score market
but not if its 1-1 or only if it is 1-1.
Include (only if true)/exclude if soccer correct score is 1-1.
Runners(this).RunnerName = "1 - 1" or Runners(this).RunnerName <> "1 - 1"
Runners(this).SortPriority = 6 or Runners(this).SortPriority <> 6
BackPrice of Fav (Rank = 1)
Runners(MatchIndex("Rank", 1)).BackPrice
So you could say back price of fav > 3.00
Runners(MatchIndex("Rank", 1)).BackPrice > 3.0
BackPrice of 2nd Fav (Rank = 2)
Runners(MatchIndex("Rank", 2)).BackPrice
You might bet on trap 2 but only if Current runner is 1st Fav or not 1st fav
Runners(this).Rank = 1
Runners(this).Rank <> 1
2nd Fav higher than 1st Fav by 1.5
Runners(MatchIndex("Rank", 2)).BackPrice - Runners(MatchIndex("Rank", 1)).BackPrice >= 1.5
Check atleast one runner is greater than BSP of 23
Runners(FilterIndex("BSP", ">", 1, "BSP", "desc", 0)).BSP > 23
It's split into 3 components
FilterIndex("BSP", ">", 1, "BSP", "desc", 0)
return the Index of runner with BSP greater than 1, sorted by BSP descending and take the first index 0. (find index of highest BSP > 1)
Runners(FilterIndex("BSP", ">", 1, "BSP", "desc", 0)).BSP
returns BSP of runner with index returned by FilterIndex
Runners(FilterIndex("BSP", ">", 1, "BSP", "desc", 0)).BSP > 23
is BSP greater than 23
This ES2 will be true for runners with lowest BSP
Runners(this).BSP = Runners(FilterIndex("BSP", ">", 0, "BSP", "Asc", 0)).BSP
Runners(this).BSP - current runner BSP
= - equals Runners(FilterIndex("BSP", ">", 0, "BSP", "Asc", 0)).BSP - return first index (0) of runners with BSP > 0 ordered by BSP Ascending,
then get BSP of that runner index to return lowest BSP (fav)
Check that backprice for Fav < 2.9 AND any runner greater than BSP of 23
AND(Runners(MatchIndex("Rank", 1)).BackPrice < 2.9, Runners(FilterIndex("BSP", ">", 1, "BSP", "desc", 0)).BSP > 23)
Include (only if true)/exclude if Venue is Monmore.
Runners(this).Venue = "Monmore" or Runners(this).Venue <> "Monmore"
or only bet if venue is one of these
OR(Runners(this).Venue = "Aintree", Runners(this).Venue = "Ayr", Runners(this).Venue = "Bath")
ES2 has most of the Excel functions available so main text search will be
FIND - Finds one text value within another (case-sensitive)
SEARCH - Finds one text value within another (not case-sensitive)
Example: Only bet if MarketName does not contain Mdn
FIND("Mdn",Runners(this).MarketName,1) = -1 // Returns true if MarketName does not contain Mdn (case-sensitive)
Example: Only bet if MarketName does contain Mdn
FIND("Mdn",Runners(this).MarketName,1) > -1 // Returns true if MarketName does contain Mdn (case-sensitive)
SEARCH("mdn",Runners(this).MarketName) = -1 // Returns true if MarketName does not contain mdn (not case-sensitive)
SEARCH("mdn",Runners(this).MarketName) > -1 // Returns true if MarketName does contain mdn (not case-sensitive)
You can also simplify FIND and remove the last parameter 1, this sets where in the string to start searching. Omitting will start at on the first character.
FIND("Mdn",Runners(this).MarketName) = -1 // Returns true if MarketName does not contain Mdn (case-sensitive)
FIND("Mdn",Runners(this).MarketName) > -1 // Returns true if MarketName does contain Mdn (case-sensitive)
Only bet if Soccer Match eventname is Terengganu v Kedah
SEARCH("Terengganu v Kedah",Runners(this).Eventname) > -1
Check Away or Draw team price is not greater than 1.5
AND(Runners(MatchIndex("SortPriority",2)).BackPrice < 1.5, Runners(MatchIndex("SortPriority",3)).BackPrice < 1.5)
Current runner is lowest BackPrice with PercentageMoney > 28
FilterIndex("PercentageMoney", ">", 28, "BackPrice", "asc", 0) = this
PercentageMoney of 2nd + 3rd + 4th Fav > 1st Fav
Runners(MatchIndex("Rank", 2)).PercentageMoney + Runners(MatchIndex("Rank", 3)).PercentageMoney + Runners(MatchIndex("Rank", 4)).PercentageMoney > Runners(MatchIndex("Rank", 1)).PercentageMoney
Runner in stall 1 is fav % Money
Runners(FilterIndex("PercentageMoney", ">", 0, "PercentageMoney", "desc", 0)).StallDraw = 1
Runner in stall 2 is 2nd fav % Money
Runners(FilterIndex("PercentageMoney", ">", 0, "PercentageMoney", "desc", 1)).StallDraw = 2
Also
And(Runners(FilterIndex("PercentageMoney", ">", 0, "PercentageMoney", "desc", 0)).StallDraw = 1, Runners(this).StallDraw = 2)
cond1: Runners(FilterIndex("PercentageMoney", ">", 0, "PercentageMoney", "desc", 0)).StallDraw = 1
Top ranked runner by PercentageMoney is StallDraw 1
cond2: Runners(this).StallDraw = 2
Runner to bet on is StallDraw 2
cond3: AND(cond1, cond2)
This checks fav % is in stall 1 and venue =
And(Runners(FilterIndex("PercentageMoney", ">", 0, "PercentageMoney", "desc", 0)).StallDraw = 1, Runners(this).Venue = "Romford" )
If you want to select the runner with the highest back price (ie the least probability) this would work in ES2
Runners(this).BackPrice = Runners(FilterIndex("BackPrice", ">", 1.01, "BackPrice", "desc", 0)).BackPrice
FilterIndex("BackPrice", ">", 1.01, "BackPrice", "desc", 0) - return index of runner with BackPrice > 1.01 sorted descending by BackPrice at index 0 (ie return index of runner with highest back price)
Runners(FilterIndex("BackPrice", ">", 1.01, "BackPrice", "desc", 0)).BackPrice - return the back price of the runner with index returned above
Runners(this).BackPrice = Runners(FilterIndex("BackPrice", ">", 1.01, "BackPrice", "desc", 0)).BackPrice - current runner back price is same as back price above.
|