NCAAB:
p:field goals made/p:field goals attempted < 0.3 and p:H
Just fyi here's a cool little shortcut in sdql to compact the previous 5 games points <= 65. Feel free to use either way, I've just got a weird personality that requires short and efficient lol
tA(points@season)<=63 and oA(o:points@season)<=63 and A and (game number)>= 15 and tS(points<=65,N=5)=5
I will say the advantage of short hand like this allows you to explore more dynamically if desired, such as the team has scored 65 or less in 4 of the last 5 games in any order which is pretty cool. i.e.
tA(points@season)<=63 and oA(o:points@season)<=63 and A and (game number)>= 15 and tS(points<=65,N=5)=4
Last edited by Heart; 02-02-15 at 01:35 PM.
disregard this post
Last edited by Heart; 02-02-15 at 02:37 PM.
AD and p:H and pp:A and ppp:A and pppp:A and ppppp:A and season>2012
O/U:7-17-1 (-7.72, 29.2%) avg total: 202.0
If you go back longer - it still works fine.
Interesting that if you do this:
AF and p:H and pp:A and ppp:A and pppp:A and ppppp:A and season>2012
You get pretty nice query supporting the Over.
Three heavily supported plays tonight. We'll see if the jinx is on.
Celtics -1 (26,55,76,183,213,257)
Nuggets -8 (12,13,55,88,117,119,120,121,257)
Warriors -9 (19,24,110,129,173,256)
Last edited by Cutler'sThumb; 02-03-15 at 04:40 PM.
these are the rend numbers we collect which support the plays.
I'm on all 3 of those tonight myself, Cutler's Thumb.
Cards look brilliant tonight. Best of luck everyone.
Hey fellas, just a quick question. How do I do a query based on a team's average possessions per game? Is it possible? I know that we can find the average score of a team but can we find their average possession rate as well? I feel as though this would help immensely for totals plays.
Tonight I like the over in 76ers v Nuggets because 76ers totals have all gone under but thats against sides that don't get the same amount of possessions like the Nuggets get. Nuggets average around 99 per game (NBA.com stats helped me with that) and 76ers hit around 98 as well which is above the NBA average (96). The teams that 76ers have played lately play under the average pace apart from the T-Wolves which have the same pace as the Nuggets (98-99) per game so was wanting to see if I could add that into my query.
Thank you in advance fellas.