Find tennis matches where the favorite lost the first set, but won the entire match.
This analysis can be used to bet the favorite to loose the first set, but in the entire match win. There is typically much higher odds on such a bet then on standard favorite winning in the match bet. We can find a players who although being favorite of the match has usually a slow start and lose the first set.
This task is solved in the window List of odds the best. Here we can set the period that we want to analyze. On the figure there are matches from the previous week.
To analyze the favorites in tennis, it is necessary to have favorites stated as the first in all matches in the windonw List of odds. By default, the home player is stated the way as it is done by the the selected betting company.
To do this it is necessary to create a simple filter. We will create it using the button with the red arrow at the bottom left part of the window. In following pictures there are shown setting for such a filter:
We must activate an item for a favorite to be stated as the first player (= "home") in matches in section Settings.
In section Tennis we will define that we are looking only tennis matches of both men and women, singles and only just in tournaments with a prize money at least 50 000 USD.
In the last section we will use this time - Odds may be defined what should be a odds on tip 1, it means on the player stated as the first, which means in our case on the favorite.
After using this filter in the window Offer will appear the following matches:
Then we need to check the results of the first sets. To do so we need to activate the Filter / Columns section:
.. we need to activate the columns GH1 and GA1 which are the results of the first part of the game = the result of the first sets in this case.
The whole filter looks like this then:
.. and applying it at the Offer window:
We can also activate the Filter / Conditions section and set the conditions for showing only matches where guests (= outsiders) won the first set, but not the whole match:
The whole filter looks like this:
And after applying it at the Offer window:
So we have displayed the matches we wanted to find. However, it would be good to know which part of all matches where the favourite player lost the first set the favourite player finally won. So we will not filter the matches using the Filter / Conditions section. But we will add new columns into Filter / Columns section:
... using the PLUS button on the bottom left, we created two new columns. The "1st Away" will have a value corresponding to the result of the "less" function, so it will be 0 or 1 depending on whether the guests have won the first set (= 1, because in that case GH1 is less than GA1).
The second new "tot Home" column is the result of the "bigger" function and gets 1 if the home team wins the match; otherwise it has a value of 0.
The Offer window looks like this now:
Now we will return back to the Filter / Columns section once again:
.. we will create another new item (= column): "1stA + tH", meaning "1st Set Away, Total Home". This column will have a value corresponding to the result of the AND (not zero) function, that is, it will be 1 if the two columns being compared are nonzero; otherwise it will be 0. This column will be 1 if the match meets our specifications.
So we get another new column at the Offer window:
In order to get the number of matches meeting our condition and to get the frequency of this phenomenon, activate the two aggregation functions: SUM and AVERAGE using the right mouse button on the footer of the match list (if the footer is not visible by using the right mouse button menu at the Offer window). Calculation of the value will then be displayed in the footer:
.. so we can see that the favourites loosing first set won the whole matches just in 10% of the past matches.