Help with Consecutive Streak filter
-
Hi,
I am trying to do a filter that will find Home and Away teams who are playing one another who have a consecutive streak of match's that were over 2.5 goals. So teams with a streak of 2 consecutive match's over 2.5 goals doesn't matter whether they were done home or away.
How do i do that. -
@mark-uren Yes I see what you mean, I would say that this will be best dealt with by @Adam he's usually best to catch on the football stats software support thread here:
https://forum.betfairtradingcommunity.com/topic/222/football-software-and-ratings-support-thread
I am sure he will be able to look into this deeper as this is above my pay grade.
-
Hi Ryan,
Thanks for the video,
Appreciate it is programming but couldnt you use the Current Winning Streak stat and apply it in my instance to the Over 2.5 goals. I'm making it simplistic but i presume in your database you have a flag when there is a win for a team. Then a search is made to find if there are x number of flags in a row. And you have your selection.
If you had a flag for over 2.5 goals which i would imagine you do you could apply the same as current winning streak. -
@mark-uren You mean like this https://www.loom.com/share/ddaf5c27cc88457092dcf4a6d408155e
-
Yes, any team playing one another who has had 2 consecutive games where it was over 2.5 goals.
So A vs B was 3-0, A Vs C was 2-1, D vs E was 4-0, D vs F was 3-1, So if A vs D were playing it would be a selection