Thanks for the info JB, but I have a little trouble reading these queries. I understand the SU and ATS obviusly, but tell me if I read this correctly.....
Teams at home or on the road with at least a 6 game losing streak, and giving at least 6 points, and since 2005?? thanks again.
I think he made a couple of mistakes with the query you requested
p:site=away
previous site was away
site=home
site for this game is home
-6<=t:line<0
line is between -1 and -6
I think you want t:line<=-6 to specify that the line is 6 or higher. You didn't specify an upper boundary, so not sure if you wanted between 6 and 10 for example, or don't care how big a favorite they are as long as it is 6.
p:streak<=-6
The team was on a losing streak of 6 games or more heading into their last game. I think you want streak<=-6
20051030<=date
The date of the game is later than or equal to 10/30/2005.
So, if I read your question correctly, what I think you want is actually
p:site=away and site=home and t:line<=-6 and streak<=-6 and 20051030<=date
SU: 9-1 (14.6)
ATS: 8-2-0 (7.2) avg line: -7.3
O/U: 5-5-0 (-3.0) avg total: 197.6
If you just want teams giving ANY points (1 or more)
p:site=away and site=home and t:line<=-1 and streak<=-6 and 20051030<=date
SU: 19-16 (2.6)
ATS: 18-17-0 (-1.7) avg line: -4.4
O/U: 21-14-0 (2.2) avg total: 196.5
continuing to add to this:
And, now that I see your original question didn't actually specify home or road, just teams on a 6 game or longer losing streak (you do realize that SAC has lost 7, right?) giving points
streak<=-6 and line<=-1 and 20051030<=date
SU: 44-26 (4.5)
ATS: 38-30-2 (0.3) avg line: -4.2
O/U: 37-31-2 (0.6) avg total: 197.5
Last edited: