Login Search

NBA Stituational Bet, SDQL

Last Post
#3022

Default

Quote Originally Posted by nash13 View Post
NCAAB: tA(points@season) <= 63 and oA(o:points@season) <= 63 and site = away and game number >= 15 and p:points <= 65 and pp:points <= 65 and ppp:points <= 65 and pppp:points <= 65 and ppppp:points <= 65
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.
#3024

Default

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.
#3026

Default

Quote Originally Posted by Cutler'sThumb View Post
Three heavily supported plays tonight. We'll see if the jinx in 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)

I'm somewhat new here....what do the numbers in the parentheses mean?
#3030

Default

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.