A team whose scored 100+ points in each of their last 6 games over the last two seasons are 50-23 (68.5%) straight up when playing their next game at home. Knicks fall under this tonight
Collected a decent amount of queries from this thread for anyone who wants to copy them down. There will be smilies to translate:
AD and WP<50 and o:WP>50 and ats streak<0 and o:ats streak>0 and on:H and 10<=game number<=60 and season>=2009
(F or AD) and WP>62 and o:WP>35 and P:FL and p:AW and pp:AW and game number>=25
H and line>-6 and p:AW and pp:AW and season>=2011
H and total>205 and p:HL and po:P3-p:P3 + po:P4-p:P4>14 and season>=2010
HD and total>205 and p:ADW and p:line>=4 and rest>0 and season >= 2005
A and P:ats margin <=-10 and P:season=season and P:H and season > 2012
line <=-11 and pooints <=80 and opo
H and p:margin<-9.5 and op:margin<-9.5 and opp:margin<-9.5 and oppp:margin<-9.5 and opppp:margin<-9.5
H and total>=201 and n:A and p:ADL and pp:ADL and season>=2011
HD and p:AL and P:AL and P:margin<=-30 and rest<=2 and line<8.5
HF and WP>=72 and game number>=25 and p:LF and line<=-9.5 and total>=187.5 and o:rest<3
P:AL and op:margin>10 and p:HW and 65>WP>o:WP and -10<=line<=-5 and H
H and total>199 and 99>tA(o
rest=0 and p:W and pvertime>0
tS(W, N=10)>=8 and AF and line>=-5 and o:rest=0 and rest>o:rest
tA(o
AF and p:HW and pp:HW and p:margin>8 and pp:margin>8 and division!=o:division and line<-4 and season>=2006
P:FL and 75>=WP>=60 and 75>=o:WP>=60 and total>=200 and o:rest>0 and season>=2009
F and p:AL and p:margin<=-8 and WP>=o:WP and line<=-10.5 and game number<=68 and total>=187 and total<=212 and season>=2006
AF and -3<=ats streak<=-1 and 1<=o:ats streak<=2 and 1<= rest<=2 and season>2010
H and 9>=line>=3.5 and tS(L, N=4)=3 and 7-(rest+p:rest+pp:rest+ppp:rest)=5
rest=0 and p:rest=1 and pp:rest=0
H and season > 2009 and line > 5 and p:margin < -15 and op:margin > 5 and p:A and pp:A
-9.5<=line<=-3.5 and tA(points)>=102 and 102>=oA(o
Raptors on a back to back off an overtime game.Originally Posted by JAnthony
I like the chances of a team being a bit underrated by bookies, because of recent poor performance:
p:ats margin<0 and 10<=p:line<=13 and 11<=line<=13
Principle mostly the same:
p:L and pp:L and -1<=line<=1 and rest=0 and o:WP<43 and A
Points Awarded:
b1slickguy gave Noleafclover 2 Betpoint(s) for this post.
OLY gave Noleafclover 1 Betpoint(s) for this post.
cool Noleaf, but it would have been a lot cooler if you have gave credit to whom posted each query.
Yeah, but b2b is a part of the query, and a single OT for an NBA players won't make that much of an impact on the next game, because, let's be honest, those are 5 mins with a lot of time outs usually.
Raptors on a back to back off an overtime game.
From 2012<=season there were only 4 dogs in this situation. Ave line was -8.2, probably with a -300+ ML. I know at -250, one needs to hit at 71.43% to break even. Your situation at 68.5% SU winners, would be a losing one.A team whose scored 100+ points in each of their last 6 games over the last two seasons are 50-23 (68.5%) straight up when playing their next game at home. Knicks fall under this tonight
From 2012<=season there were only 4 dogs in this situation. Ave line was -8.2, probably with a -300+ ML. I know at -250, one needs to hit at 71.43% to break even. Your situation at 68.5% SU winners, would be a losing one.
That made it confusing, but- nyk it almost a favorite and nowhere near an 8.5 dog
Thanks for responding!
I get that the previous DPS result being higher means they overperformed offensively but that doesn't seem to only include weaker offensive teams, which I think you were going for. Even a top-scoring team like the blazers or clippers might score 15+ over their expected. Maybe we should include a parameter for team average between 92 and 98 or something like that and see if that makes a difference. I'd have to look up how to do that...I know it involves brackets.Good Qs!
For #1, it's the dps result in that previous game being so much higher than was expected from the team (see the KillerSports dot com NBA SDQL Manual .pdf for more information on dps, or for the lurkers trying to learn, any info about SDQL queries. I'd link it but SBR doesn't allow external links so Google it).
Okay, I will try to tinker with it when I have some time. I was just curious if you had a theory for including home/away or won/loss. Since you ran it with previous game on road and next game at home, I didn't understand the logic of limiting it that way. I would think some momentum could be lost if coming back from a road trip as opposed to consecutive home games. But the numbers for each year with your query were very good.For #2, momentum is the general answer, but all of the various permutations you're suggesting can be explored in SDQL itself with a little effort if you're interested. Run a variety of scenarios and report your results back to us, you may improve that query considerably.
I'm not sure where you got 8.5 dog out of my replyThat made it confusing, but- nyk it almost a favorite and nowhere near an 8.5 dog
Hey fellas,
Isnt' there a certain SDQL query that someone in here psoted before about a team getting beaten by 25+ points on the road (Lakers @ Spurs) to then covering at home when the line is bigger than -10?
winner thereI like the chances of a team being a bit underrated by bookies, because of recent poor performance:
p:ats margin<0 and 10<=p:line<=13 and 11<=line<=13
A team whose scored 100+ points in each of their last 6 games over the last two seasons are 50-23 (68.5%) straight up when playing their next game at home. Knicks fall under this tonight
winner there
Spurs 4q
Under 31tt -115 pts 2*
Lak 4q
+4.5 -115 1*
Woah my bad thought this was my thread
bucks winnerI'm on this one today, but only a half unit as it's a scenario that's overfit and based off of ATS streaks and happens to feature pretty spectacularly shitty teams...all three of which aren't things I like to play on, but it's been winning so why not.
Plus it works for the Under as well as the Spread pick for more action. Can't remember where it came from, looks like a cofaga special though:
AD and (o:rest=0 or rest=1) and ats streak<0 and 0 < o: ats streak < 3 and line > = 12 and season>=2006
Nice, great job Leaf, this will help others who have entered the thread late or are a bit lost have a more complete base to experiment with.Collected a decent amount of queries from this thread for anyone who wants to copy them down. There will be smilies to translate:
AD and WP<50 and o:WP>50 and ats streak<0 and o:ats streak>0 and on:H and 10<=game number<=60 and season>=2009
(F or AD) and WP>62 and o:WP>35 and P:FL and p:AW and pp:AW and game number>=25
H and line>-6 and p:AW and pp:AW and season>=2011
H and total>205 and p:HL and po:P3-p:P3 + po:P4-p:P4>14 and season>=2010
HD and total>205 and p:ADW and p:line>=4 and rest>0 and season >= 2005
A and P:ats margin <=-10 and P:season=season and P:H and season > 2012
line <=-11 and po:points <=80 and opo:points >=110
H and p:margin<-9.5 and op:margin<-9.5 and opp:margin<-9.5 and oppp:margin<-9.5 and opppp:margin<-9.5
H and total>=201 and n:A and p:ADL and pp:ADL and season>=2011
HD and p:AL and P:AL and P:margin<=-30 and rest<=2 and line<8.5
HF and WP>=72 and game number>=25 and p:LF and line<=-9.5 and total>=187.5 and o:rest<3
P:AL and op:margin>10 and p:HW and 65>WP>o:WP and -10<=line<=-5 and H
H and total>199 and 99>tA(o:points)>91 and 103>oA(o:points)>97 and game number > 41 and p:margin>9 and pp:margin>9
rest=0 and p:W and p:overtime>0
tS(W, N=10)>=8 and AF and line>=-5 and o:rest=0 and rest>o:rest
tA(op:oints)<94 and op:points>100 and opp:points>100 and oppp:points>100 and opppp:points>100 and HD and 185
AF and p:HW and pp:HW and p:margin>8 and pp:margin>8 and division!=o:division and line<-4 and season>=2006
P:FL and 75>=WP>=60 and 75>=o:WP>=60 and total>=200 and o:rest>0 and season>=2009
F and p:AL and p:margin<=-8 and WP>=o:WP and line<=-10.5 and game number<=68 and total>=187 and total<=212 and season>=2006
AF and -3<=ats streak<=-1 and 1<=o:ats streak<=2 and 1<= rest<=2 and season>2010
H and 9>=line>=3.5 and tS(L, N=4)=3 and 7-(rest+p:rest+pp:rest+ppp:rest)=5
rest=0 and p:rest=1 and pp:rest=0
H and season > 2009 and line > 5 and p:margin < -15 and op:margin > 5 and p:A and pp:A
-9.5<=line<=-3.5 and tA(points)>=102 and 102>=oA(o:points)>=98 and wins+losses>=42 and p:points+po:points>=205 and pp:points+ppo:points>=205 and ppp:points+pppo:points>=205 and pppp:points+ppppo:points>=205
I took out the smilies in them so they're now formatted to be used through cut/paste more easily.
Lot of money in that list...:an_dance:
This one likes the rockets cause the wolves won in overtime last night:
rest=0 and p:W and p: overtime>0
This one likes the wolves to get revenge:
A and P:ats margin <=-10 and P:season=season and P:H and season > 2012
But the revenge is for a 2nd meeting, so it may be rockets have their number. One of the wolves' greatest strength is their rebounding, where the Rockets are also strong. But missing Dwight, the wolves may get their revenge for the first 2. It's a pass for me, but those are the sdqls.
