-
Comment -
on a dog of line between 145 and 155 whose average shots on goal over its past 2 games is a little more than 10 for every 1 of its opponent's average goals over its last 2 games.
shots on goals is likely correlated with number of goals scored by that team, such that the higher the number of shots on goals, the higher the likelihood that they will score a goal. So, as the shots on goals increase for a team, the higher the likelihood that they will score more goals, and therfore win the game. But the predators aren't doing that much better than taking more than 11 shots on goal for every one goal that their opponents score (Blues) on average over the past 2 games. So, I'm not sure that this query accurately/completely captures the predators performance in terms of shots on goal on average over the past 2 games--In fact, anything less than .085 does not characterize the predators performance over their past 2 games...Comment -
my picks and non-picks for today so far...
Blues ML:
H and tS(W, N=10)>=8 and o:A and t:date - op3:date<=6 and op:A and opp:A and oppp:A and season>=2008
Canadiens ML:
HF and p:A and p:F and p:W and date>=20111022
...despite this one in favor of wild ML:
p:shots on goal > po:shots on goal and p:AL and A and 0<rest<3
going with canadiens due to injured main Wild star Parise + at least one query (above) pointing to Canadiens ML.
Senators ML:
p:HW and pp:HW and 60>=WP>=51 and game number<=42 and season>=2010
p:HW and po:goals=0 and WP>50 and season>=2009 and game number<42 and H
unders:
flyers/avalanche
Jets/senators
coyotes/islanders
rangers/maple leafs
can't locate queries (some Bases queries) at this time.
good luck!Comment -
I set up a spreadsheet, please shoot me a PM and i will give you rights to edit.
Comment -
i got your msg dew22. i have something to write you back about when i get 40 posts.Comment -
penalties do not necessarily mean it's a power play for the other team. Coincidental minors count as penalties, but there is no power play. Another penalty would be a misconduct (10 mins) which are usually paired with another penalty (minor or major). Although a team may be on the pp for their oppenent's minor or major penalty, they are not for the 10 min misconduct (which is counted as a penalty)
As far as I know, there is no query for actual power play percentage. The parameter "minutes power play" is for the total for all of the team's players minutes on the power play. So, for if a team was 0-1 on the pp and lets say that, the "minutes power play" for that game would be 10 since 5 guys on the team would on the ice for the 2 min power play.Last edited by otunj; 11-09-14, 02:31 PM.Comment -
my bets tonight.
rangers -183 1uComment -
That really would be invaluable Nash. What has been especially challenging for me is how to select a pick from conflicting queries. What I have been doing until now when there are conflicting queries is no-playing it. We really should be able to come up with some systematic approach to making a pick in these instances...like combining the queries into one, and hoping the sample size is big enough and pointing in one direction more than the other...Comment -
Thanks for your help zxq.
Yours is close to what I've come up with. If we want no more than 8 games in past 14 days, then this seems right:
t:date - p7:date <=14 and t:date - p8:date >=14
or if we want at least 8, then the follwing seems right:
t:date - p7:date <=14
Its hard o know for sure...I'm going to play around with it to determine the right terms to use by changing values (increasing number of games or decreasing number of games in that 14-day period) to see what it does to WP and ROI.Comment -
^ always remember each database it different. Parameters and human error is probable. It's best when you think you find an error in the database, to question the google group.. It might take time, but Joe is usually good about it.Comment -
just wanted to know if anyone wanted to post any sources of information they have or use for sports betting other than this site. any threads on different forums that talk query's for nhl? maybe some tools for calculations or spreadsheet type stuff? thoughts about when to steer away from sdql?Comment -
For all the regular guys around here, I finished uploading all the queries I got. If you are interested in posting yours or checking crosswise or just want to take a look, write me a PM with your Mailadress to get connection to.Comment -
4 active NHL trends so far for tonight, no contradictions.Comment -
To give some information, the trends i gathered are mostly League Wide general trends, no team trends at all.Comment -
hi Nash, here is my updated list of queries. I'd really love to see your list but you may have already sent me the link for it... But if you have updated it since the last link that you sent to me, then would be great to see it. By the way I'm only seeing two queries active today that are not contradictory....but then again I didn't get a chance to go through all of them yet...
SDQL NHL
F and month=11 and oS(W, N=6)>=4 and season>=2009 and streak=3
H and op:AW and op:division=opo:division and day=Saturday and season>=2009 and o:rest<=2 and rest<=2
po:goals=0 and p:HW and game number<=42 and WP>50 and season>=2009
H and p:margin>=3 and p:HW and 70>=WP>=60 and o:WP>50 and game number<=42
A and WP>50 and t:date-p7:date<14 and game number<=42 and o:WP>50 and season>=2009
po:goals=0 and p:HW and t:date-p7:date<14 or t:date-p8:date<14 or t:date-p9:date<14 or t:date-p10:date<14
HF and p:margin=-1 and op:goals>=3 and opp:goals>=3 and oppp:goals>=3 and opppp:goals>=3 and oppppp:goals>=3
site streak<=-4 and streak>=3 and WP>52 and o:WP<48 and season>=2009
A and op:goals>=5 and total<=5 and p:goals<=1
HF and -120>=line>=-170 and oP:L and oP:goals>=2 and o:division=opo:division and op
vertime=1 and op:margin>=1
H and p:goals >= 4 and opo:goals >= 4 and oppo:goals >= 4 and opppo:goals >= 4 and oppppo:goals >= 4
HD and line<=180 and WP<=30 and 30<=o:WP<=40 and o:streak<=-1 and game number<=42
***Under--H and tA(goals)<=2.49 and total=5.5 and p:goals>=3 and pp:goals>=3 and ppp:goals>=3
(Under--monitor)H and p:HW and p:margin >= 3 and total = 5.5 and game number <= 42 and 49 >= WP >= 40
HD and oA(goals)>=2.85 and op:margin>=2 and opp:margin>=2 and oppp:margin>=2 and opppp:margin>=2
p:shots on goal >= 35 and op:goals = 3 and playoffs = 0 and (site = away or (site = home and p:site = away)) and 0 >= rest - o:rest >=-2
Po:goals>=5 and A and p:HW and p:margin>=3 and season>=2009
F and p:HL and pp:HL and op:AL and opp:AL
H and total=5.5 and game number<=42 and p:division=po:division and p:L and 70>=WP>=60 and o:WP<50
H and season >= 2010 and tA(shots on goal) <= 29.5 and p:shots on goal <= 26 and pp:shots on goal <= 26 and ppp:shots on goal <= 26 and pppp:shots on goal <= 26 and ppppp:shots on goal <= 26
H and total<=5 and tA(power play goals/o
enalties)>=.16 and p:shots on goal>=30 and pp:shots on goal>=30 and ppp:shots on goal>=30 and pppp:shots on goal>=30 and ppppp:shots on goal>=30
p:HW and po:goals=0 and WP>50 and o:WP<50 and season>=2009 and game number<42
H and p:margin=-1 and p:AL and op:HW and opp:HW and op:margin>=2 and opp:margin>=2
A and ou streak<=-3 and tA(o:goals)<=2.2 and total=5.5
HF and tA(o:goals)>=3 and po:goals<=2 and ppo:goals<=2 and season>=2010
tA(shots on goal) >= 29 and tA(o:goals) <= 2.9 and p:shots on goal >= po:shots on goal + 6 and pp:shots on goal >= ppo:shots on goal + 6 and ppp:shots on goal >= pppo:shots on goal + 6 and pppp:shots on goal >= ppppo:shots on goal + 6 and ppppp:shots on goal >= pppppo:shots on goal + 6
H and (day = Saturday or day = Sunday) and o:rest > 0 and tA(assists) >= oA(assists) and tA(power play goals/oenalties) >= oA(power play goals/oenalties) and tA(shots on goal) >= oA(shots on goal) + 3 and p:shots on goal >= 26 and pp:shots on goal >= 25 and ppp:shots on goal >= 25 and tA(o:goals) <= 3.23 and season >= 2010
H and o:rest >= 1 and tA(assists) >= oA(assists) + 1 and tA(power play goals/oenalties) >= oA(power play goals/oenalties) + .01 and tA(shots on goal) >= oA(shots on goal) + 3 and p:shots on goal >= 27 and pp:shots on goal >= 27 and ppp:shots on goal >= 27 and season >= 2010
H and total<=5 and tA(power play goals/oenalties)>=.13 and p:shots on goal>=30 and pp:shots on goal>=30 and ppp:shots on goal>=30 and pppp:shots on goal>=30 and ppppp:shots on goal>=30
H and p:margin>=5 and opvertime=1 and season>=2006
H and po:goals>=3 and ppo:goals>=3 and op:goals>=4 and opp:goals>=4 and oppp:goals>=4 and season>=2009
*****(op:AW or op:HL) and season >= 2009 and oA(shots on goal) < opo:shots on goal -10 and o:streak != 2 and o:streak > -2 and op:margin >= -2 and o:rest != 2 and playoffs = 0 and line <= -125
*****(op:AW or op:HL) and season >= 2009 and oA(shots on goal) < opo:shots on goal -10 and o:streak != 2 and 2>=o:streak > -2 and op:margin >= -2 and o:rest != 2 and playoffs = 0 and line <= -125
WP>70 and tS(W, N=10)=8 and o:WP<=30
HF and p:margin=1 and pp:margin=1 and opo:margin>=3 and season>=2009
AF and 49>=o:WP>=40 and oS(W, N=5)=4
H and po:goals<=2 and ppo:goals<=2 and op:W and opvertime=1 and season>=2010
H and po:goals<=2 and ppo:goals<=2 and opvertime>=1 and op:W and rest<3 and o:rest<3 and season>=2010
HF and oA(o:goals)<=2.52 and opo:goals>=3 and oppo:goals>=3 and opppo:goals>=3 and season>=2008 and o:rest>=1
oA(p:goals-po:goals)>=.3 and opo:goals>=3 and oppo:goals>=3 and opppo:goals>=3 and H and -135<line<-110 and 2009<=season
HF and po:goals<=1 and ppo:goals<=1 and oA(period scores[0]) - oA(oeriod scores[0]) >=.25
A and -100>=line>=-150 and game number>=42 and ou streak<=-4 and tA(goals)>=3.0
HF and oA(o:goals)<=2.52 and opo:goals>=3 and oppo:goals>=3 and opppo:goals>=3 and season>=2007
A and total<=5.0 and p:goals<=1 and op:goals>=5 and season>=2009
po:goals<=2 and ppo:goals<=2 and pppo:goals<=2 and ppppo:goals<=2 and op:W and opp:W and op:margin>=2 and opp:margin>=2 and season>=2010
po:goals=0 and p:HW and A and season>=2010 and game number<=42 and p:margin>=2
p:margin>=2 and p:division=po:division and op:margin>=3 and op:division=opo:division and game number<42
HF and p:goals=2 and op:goals=3 and 4>pp:goals>1 and season>=2010
po:goals = 0 and op:goals = 0 and playoffs = 0 and p:goals >= opo:goals and o:conference = Western
HF and oA(o:goals)<=2.55 and opo:goals>=3 and oppo:goals>=3 and opppo:goals>=3 and season>=2011
A and total<=5 and p:goals<=1 and op:goals>=5 and season>=2010
F and oA(goals)>=2.8 and op:goals+opo:goals>=7 and opp:goals+oppo:goals>=7 and oppp:goals+opppo:goals>=7 and season>=2010
A and 12>tA(penalty minutes)>11 and penalty minutes>12 and o:rest<7 and (p:A and op:A or p:A and op:H) and playoffs=0 and season>=2010
AD and P:L and p:AW and p:margin=1 and season>=2007 and game number>=42
po:goals<=2 and ppo:goals<=2 and pppo:goals<=2 and ppppo:goals<=2 and op:margin>=2 and opp:margin>=2 and season>=2007 and game number<=42
AD and 150>=line>=100 and streak>=2 and 49>=WP>=40 and 49>=o:WP>=40 and season>=2008 and game number<=42
A and P:L and p:HL and P:goals=0 and season>=2009 and total=5.5
tA(oeriod scores[0]) - tA(period scores[0]) >=.29 and p:goals+po:goals>=8 and pp:goals+ppo:goals>=8 and ppp:goals+ppp:goals>=8 and game number<=42
tA(oeriod scores[0]) - tA(period scores[0]) >=.29 and p:goals+po:goals>=8 and pp:goals+ppo:goals>=8 and ppp:goals+ppp:goals>=8
H and -150<=line<=-100 and game number>=42 and tu streak>=2 and ou streak>=2 and tA(goals)>=2.9 and oA(goals)>=2.9 and season>=2008
HF and game number>=42 and op:shots on goal>=30 and opp:shots on goal>=30 and oppp:shots on goal>=30 and opppp:shots on goal>=30 and oppppp:shots on goal>=30 and tA(goals/shots on goal)<=.085
HF and game number>=42 and p:shots on goal>=30 and pp:shots on goal>=30 and ppp:shots on goal>=30 and pppp:shots on goal>=30 and ppppp:shots on goal>=30 and tA(goals/shots on goal)<=.085
AD and 150>=line>=100 and tA(o:goals)<=2.55 and po:goals<= 2 and ppo:goals<=2 and pppo:goals<=2 and ppppo:goals<=2 and pppppo:goals<=2 and season >= 2009
PP:margin<=-2 and P:margin<=-2 and p:margin=1 and A and p:AW
A and p:goals<=1 and op:goals>=5 and total<=5 and season>=2009
playoffs=0 and po:goals=0 and p:site=home and season>=2010 and HF and WP>50 and o:WP<50
p:HW and po:goals=0 and WP>50 and season>=2009 and game number<42 and H
po:goals<=2 and H and ppo:goals<=2 and opvertime=1 and op:W and season>=2009
p:margin=1 and pp:margin=1 and po:goals<=2 and ppo:goals<=2 and oA(o:goals)>=3.2 and season>=2009
A and P:margin<=-5 and p:HW and p:margin>=2
H and oA(goals)>=2.85 and game number>=42 and opo:goals>=3 and oppo:goals>=3 and opppo:goals>=3 and oppppo:goals>=3 and opppppo:goals>=3 and season>=2010
p:HW and pp:HW and 60>=WP>=51 and game number<=42 and season>=2010
total=5.5 and H and game number>=42 and tA(o:goals)>=2.85 and p:goals>=5 and pp:goals>=5
H and total=5.5 and p:goals>=4 and p:AW and P:margin=-1 and season>=2009
A and streak>=4 and 60>=WP>=51 and o:WP>50 and total<=6 and season>=2008
A and tS(W, N=10)>=8 and month=4 and -150<=line<=-100
H and tS(W, N=10)>=8 and o:A and t:date - op3:date<=6 and op:A and opp:A and oppp:A and season>=2008
A and -110>=line>=-150 and month=4 and p:AL
P:margin<=-5 and p:goals>=3 and A and season>=2009
P:margin<=-5 and p:margin>=3 and p:H and A and season>=2006
H and -110 >= line >= -200 and rest = 2 and o:rest >= 3 and total > 5 and month!= 11
HF and line>=-200 and rest=2 and o:rest>=3
AD and tA(goals@team and season and A)>=tA(goals@team and season and H)+1.02 and p:goals+pp:goals>=7 and season>=2007
HF and p:A and p:F and p:W and date>=20111022
H and ou streak<=-2 and ou streak>=5
A and -150<=line<=-100 and ou streak<=-4 and tA(goals)>=3 and game number>=42
D and P:W and tS(PP:L@team, N=4)=4 and p:H and p:goals>=3 and po:goals>=3 and season>=2008
HF and -170<=line>=-120 and ou streak<=-1 and ou streak>=3 and season>=2009
A and o:streak<=-6 and o:rest>=3
HF and p:margin = -1 and op:goals >= 3 and opp:goals >= 3 and oppp:goals >= 3 and opppp:goals >= 3 and oppppp:goals >= 3
HF and streak<=-3 and 60>=WP>=51 and game number>=43
D and 150 <= line >= 100 and tA(goals) - p:goals >= .65 and po:goals >= 3 and ppo:goals >= 3 and pppo:goals >= 3 and season >= 2009
D and 150 <= line >= 100 and tA(goals@team and season and 43<=game number<=84) - tA(goals@team and season and 1<=game number<=42) >= .3 and po:goals >= 3 and ppo:goals >= 3 and pppo:goals >= 3 and season >= 2008
HF and p:margin=-1 and op:HW and op:goals>=3 and opp:goals>=3
H and p:margin>=4 and op:margin<=-4 and season>2006
A and game number>=42 and tA(o:goals)<=2.4 and po:goals>=3 and ppo:goals>=3 and season>=2008
HF and game number>=30 and oA(period scores[0]) - tA(teriod scores[0]) >=.14 and po:goals <= 1 and ppo:goals <= 1
(14 - (rest) <= 5 or 14 - (rest + p:rest) <= 5 or 14 - (rest + p:rest + pp:rest) <= 5 or 14 - (rest + p:rest + pp:rest + ppp:rest) <= 5 or 14 - (rest + p:rest + pp:rest + ppp:rest + pppp:rest) <= 5) and p:goals = 0 and season >= 2010
pt:shots on goal / pt:goals <= 7.1 and Sum(W@team,N=3) = 2 and op:date = date -1 and HWP > o:HWP and season >= 2011
60>WP>51 and p:AW and pp:AW and ppp:AW and total=5.5 and 6>=month>=1
HF and p:HFW and p:margin>=4 and WP>42 and o:WP<46
*HF and p:HFW and p:goals>=6 and WP>45 and o:WP<44
*HF and site streak<=-4 and tS(W, N=4)>=2 and p:margin<=-1 and season>=1996 and WP>=48 and o:WP<=45
HF and site streak<=-4 and tS(W, N=4)>=2 and p:margin<=-1 and season>=1996 and WP>=48
p:shots on goal >= 35 and op:goals = 3 and playoffs = 0 and (site = away or (site = home and p:site = away)) and 0 >= rest - o:rest >= -2 and F
HF and tA(margin, N=2)>=3 and month>=10 and WP>=48 and season>=2012
AF and tS(L, N=7)>=5 and 49>=WP>=40 and o:WP<50 and rest>0
total=5.5 and po:goals>=3 and ppo:goals>=3 and pppo:goals>=3 and opo:goals>=5 and oppo:goals>=5 and season>=1996
D and streak > 3
AD and streak >5 and op:L
season >= 2012 and A(penalty minutes@team and season)[o:team and season -1] >=13 and month>=10 and team=Maple Leafs
tA(margin, N=4)<=-3 and streak<=-4 and 2>=oA(margin, N=4)>=1 and o:streak>=3
tA(margin, N=6)<=-3 and streak<=-4
H and tA(goals)>=2.85 and season>=2009 and opo:goals>=3 and oppo:goals>=3 and opppo:goals>=3 and oppppo:goals>=3 and opppppo:goals>=3 and game number>=42
pvertime = 1 and p:margin = -1 and day = Tuesday and o:rest<3 and p:goals<3 and line>-255 and op:margin>=2 and pp:L
---------++-----------..----_-_------------------------------.....
total = 5.5 and 14 < p:shots on goal < 32 and playoffs = 0 and day != Thursday and day != Friday and day != Sunday and rest < 4 and o:rest < 4 and rest + o:rest > 0 and 7 > streak > -4 and (game number < 38 or game number > 51) and ou streak < 5 and pu margin > -3 and 4.5 > opu margin > -3 and 43 > op:shots on goal > 19
season>2009 and 0>power play goals - opower play goals>-3 and day!=Tuesday and -4-6 and month!=2 and month!=5 and month!=6 and (A or day!=Sunday) and (215>line>-212 or line>249) and penalties<10 and openalties>1 and p:shots on goal - op:shots on goal<18 and op:shots on goal<43 and p:assists!=5 and 14>op:assists>1 and p:shifts>326 and 83>op:shifts -p:shifts>-75 and po:goals>0 and rest + o:rest<7
???(day=Monday or day=Tuesday) and total>5 and 10>p:goals + op:goals>3 and H and 7>streak>-4 and o:streak>-3 and (game number>72 or game number<66) and (game number>41 or 3
F and streak=-1 and o:streak<0 and day!=Monday and (H or rest<2) and (H or o:rest<2) and site streak>-3 and o:site streak!=2 and p:margin>-5 and P:margin>-4 and op:goals<4 and rest + o:rest>0 and game number<75
DA and total=5.5 and day!=Wednesday and day!=Friday and day!=Sunday and month<5 and (o:streak>-3 and 4>p:margin>-4) and p:goals<6 and line<245 and pp:goals>0 and 4>P:margin>-2
HF and op:margin<=-3 and season>=2009 and month=1
HF and op:margin<=-4 and season>=2009 and 2>=o:streak>-2
H and p:margin>=4 and opo:goals>=6 and season>=2007
total = 5.5 and p:goals + op:goals = 6 and p:goals - op:goals = 0 and day!=Monday and day!=Wednesday
total = 5.5 and H and ou streak = 1 and (2>streak>-3 or streak=4) and o:streak<3 and 4>site streak>-2 and day!=Wednesday and day!=Monday and day!=Friday
????total=5 and streak=-1 and -6
p:goals=2 and op:goals=3 and H and streak<3 and o:streak<3 and day!=Friday and op:margin<3 and 4>rest - o:rest>-3 and rest - o:rest!=-1 and 0
****total=5.5 and p:faceoffs won=33 and day!=Thursday and day!=Tuesday and 7>streak>-2 and P:margin>-4
*****tS(W, N=3) = 3.0 and oS(W, N=3) = 0.0 and day!=Saturday and P:margin>-2 and rest - o:rest!=-1
A and streak=1 and o:streak=-1 and p:margin<5 and 3>P:margin>-5 and day!=Sunday and day!=Wednesday and rest + o:rest>0 and playoffs=0 and line<147
3
***day = Tuesday and streak = 3 and total>5
AD and 0>streak>-3 and o:streak=-1 and 5>op:streak>0 and tS(W, N=3)=1 and 1106
***D and streak + o:streak=4 and 3>streak>0 and pvertime=0 and (month=11 or month<4) and line>102
****penalties = 5 and p:shots on goal = 26 and day!=Saturday and day!=Monday and season>=2010
****"HF and p:goals=2 and op:goals=3 and 4>pp:goals>1
AD and 10>penalties>5 and streak<4 and p:goals!=3 and 48>p:shots on goal>15 and day!=Sunday and day!=Monday and tS(W, N=5)<4 and 6>o:streak>-3 and p:margin>-4 and 4.5
pvertime>0 and p:L and A and day=Saturday and line<183 and streak>-4 and o:streak>-2 and op:margin>-3 and openalties!=6
???12>p:rest + rest + n:rest>8 and 0
month = 11 and o:rest = 1 and rest = 1 and total<6 and p:rest<3 and op:rest<3 and H and streak>-4 and site streak<2 and 5>o:site streak>-4
*******pvertime = 1 and p:margin = -1 and day = Tuesday and o:rest<3 and p:goals<3 and line>-255 and 3>o:streak>-4
(don’t know) p:short handed goals=0 and power play goals=0 and (day=Saturday or day=Sunday)
******4 < po:goals < 7 and p:FL and p:goals>0 and o:streak<4 and rest<5 and rest!=2 and (day=Saturday or day=Sunday or day=Monday)
******4 < po:goals < 7 and p:FL and p:goals>0 and o:streak<4 and rest<5 and rest!=2 and (day=Saturday or day=Sunday or day=Monday) and season>=2013
****A and 12 > tA(penalty minutes) > 11 and month<7 and streak!=-2 and o:streak!=-3 and day!=Saturday and 4>site streak>-4 and rest<8 and 9>oS(W, N=10)>1 and on:rest<4 and line<220
***A and game number <= 42 and 12 > tA(penalty minutes) > 11 and month < 7 and streak != -2 and o:streak != -3 and day != Saturday and 4 > site streak > -4 and rest < 8 and 9 > oS(W, N=10) > 1 and on:rest < 4 and line<220
rest = o:rest and AD and rest = 1 and (P:AD or P:HF) and WP <= 60 and (130 >= line > 115 or line > 150) and P:rest - oP:rest <= 1 and 5>streak>-7 and o:streak>-5 and p:rest<5 and day!=Tuesday and 6>o:site streak>-3 and on:rest<3
***p:streak>2 and p:margin<3 and site!=p:site and rest<3 and site streak>-5 and o:site streak<5 and p:rest<3 and pp:rest<6 and op:margin!=-3 and n:rest<4 and opo:goals>0 and (line<-275 or line>-219)
p:streak=-2 and p:margin<2 and site!=p:site and pp:margin!=-2 and ppp:margin>-6 and o:streak!=2 and o:streak!=1 and month!=5 and 6>site streak>-5 and n:rest<3 and on:rest<3
rest = o:rest and AD and rest = 1 and (P:AD or P:HF) and WP <= 60 and (130 >= line > 115 or line > 150) and P:rest - oP:rest <= 1
p:shots on goal > po:shots on goal and p:AL and A and 0<rest<3
A and 12 > tA(penalty minutes) > 11 and month != 11 and month != 12 and game number >= 5
(tS(goals) * 100 / tS(shots on goal)) + ((tS(o:shots on goal-o:goals) / tS(o:shots on goal)) * 100) > 100 and (oS(goals) * 100 / oS(shots on goal)) + ((oS(o:shots on goal-o:goals) / oS(o:shots on goal)) * 100) < 100 and tA(shots on goal) < oA(shots on goal) and (month!=1 and month!=6 and month!=4 and month!=11) and -180<line<140 and 60>=wins>=2 and o:losses<40 and game number>4
total = 5.5 and 14 < p:shots on goal < 32 and playoffs = 0 and day != Thursday and day != Friday and day != Sunday and rest < 4 and o:rest < 4 and rest + o:rest > 0 and 7 > streak > -4 and (game number < 38 or game number > 51) and ou streak < 5 and pu margin > -3 and 4.5 > opu margin > -3 and 43 > op:shots on goal > 19
season>2009 and 0>power play goals - opower play goals>-3 and day!=Tuesday and -4-6 and month!=2 and month!=5 and month!=6 and (A or day!=Sunday) and (215>line>-212 or line>249) and penalties<10 and openalties>1 and p:shots on goal - op:shots on goal<18 and op:shots on goal<43 and p:assists!=5 and 14>op:assists>1 and p:shifts>326 and 83>op:shifts -p:shifts>-75 and po:goals>0 and rest + o:rest<7
DA and total=5.5 and day!=Wednesday and day!=Friday and day!=Sunday and month<5 and (-3<streak<3 or streak=-5) and 5>o:streak>-3 and 4>p:margin>-4 and p:goals<6 and line<245 and pp:goals>0 and 4>P:margin>-2 and season = 2013
p:goals=2 and op:goals=3 and H and streak<3 and o:streak<3 and day!=Friday and op:margin<3 and 4>rest - o:rest>-3 and rest - o:rest!=-1 and 0<opp:goals<6 and line<141
total=5.5 and p:faceoffs won=33 and day!=Thursday and day!=Tuesday and 7>streak>-2 and P:margin>-4
tS(W, N=3) = 3.0 and oS(W, N=3) = 0.0 and day!=Saturday and P:margin>-2 and rest - o:rest!=-1
AD and 0>streak>-3 and o:streak=-1 and 5>op:streak>0 and tS(W, N=3)=1 and 1<oS(W, N=6)<4 and day!=Monday and day!=Thursday and line>106
p:short handed goals=0 and power play goals=0 and 0<op:short handed goals + oower play goals<3 and day=Saturday and rest<5 and o:rest<2 and streak=-1 and o:streak>-3
4 < po:goals < 7 and p:FL and p:goals>0 and o:streak<4 and rest<5 and rest!=2 and (day=Saturday or day=Sunday or day=Monday)
rest = o:rest and AD and rest = 1 and (P:AD or P:HF) and WP <= 60 and (130 >= line > 115 or line > 150) and P:rest - oP:rest <= 1 and 5>streak>-7 and o:streak>-5 and p:rest<5 and day!=Tuesday and 6>o:site streak>-3 and on:rest<3
p:streak>2 and p:margin<3 and site!=p:site and rest<3 and site streak>-5 and o:site streak<5 and p:rest<3 and pp:rest<6 and op:margin!=-3 and n:rest<4 and opo:goals>0 and (line<-275 or line>-219)
---------------------------------------------------------------------------------------------
Worksheet/rework:
H and p:AW and total<=5 and op:margin=1 and op:AW
Any road team with a total of 5.0 or less that's facing a division opponent, and is coming off a home shutout loss, has seen 61 of those 85-games (71.8%) go over the total during the last 18 seasons.
Any NHL team coming off a shutout loss, that's played 5-games or less in the last 14-days.
Any team playing in the 2nd half of the season who has a money line winning percentage of .510 to .600, and is coming off road wins in each of their previous 3-games, has seen 56 of those 82-games (68.3%) go under the total during the last 18 seasons.
Any team playing in the 2nd half of the season who has a money line winning percentage of .510 to .600, and is coming off road wins in each of their previous 3-games, has seen 56 of those 82-games (68.3%) go under the total during the last 18 seasons.
any road team with a total of 5.0 or less that's playing in the 2nd half of the season, and won their previous 2-games, while also having a money line win percentage of .600 to .700, versus an opponent who has a winning percentage of .510 to .600, has seen 69 of those 105-games (65.7%) go over the total during the last 18 seasons.
Any home favorite in the 2nd half of the season, versus an opponent with a 0.2 or better goal per game differential during the 1st period of contests on the season, and they allowed 1-goal or less in each of their previous 2-games, has gone 45-11 (80.4%) during the last 18 seasons.
Any money line road underdog of +100 to +200 playing in the 2nd half of the season, that converts on 17.5% or better of their power play chances, and they’ve had 30 shots or more on goal in each of their last 5-games, has gone 30-15 (66.7%) during the last 5 seasons. Bet Senators over Penguins for NHL picks.
Play against any road team versus the money line that allows 2.55 goals or less per game, and has allowed 3 or more goals in each of their previous 4 contests. By playing on the home team in this exact situation you would be 23-7 (76.7%) during the last 5 seasons.
Any road team with a total of 5.5 which has played 8 or more games in the last 14-days, and both teams in the contest have a money line win percentage of between .510 to .600, has seen 49 of those 68-games (72.1%) go under the total during the last 18 seasons.
A and total=5.5 and t:date-p8:date<=14 and p:goals = 0 and p9:date>14 and 60>=WP>=.51 and 60>=o:WP>=.51 and season >= 2011
Any road team in the 2nd half of the season that has a +0.65 or better goals per game differential, and they’ve seen a combined 7-goals or more scored in each of their previous 2-games, has gone over the total in 37 of 52-games (71.2%) during the last 5 seasons.
game number>=42 and A and tA(goals@team and season and A)>=tA(goals@team and season and H)+.65 and p:goals+pp:goals>=7 and season>=2007
home team versus an opponent that’s won 8 or more of their last 10-games, and that opponent will be playing their 4th road game in the last 7-days, has gone 28-11 (71.8%) against the money line during the last 5 seasons.
Any home team with a total of 5.5 playing in the 2nd half of the season that allows 2.85 or more goals per game, and they scored 5-goals or more in each of their previous 2-games, has seen 32 of those 41-games (78%) go under the total during the last 18 seasons.
A and ((opp:goals - op:goals) + (oppp:goals - opp:goals) + (opppp:goals - oppp:goals) + (oppppp:goals - opppp:goals) + (opppppp:goals - oppppp:goals) + (oppppppp:goals - opppppp:goals) + (opppppppp:goals - oppppppp:goals)) / 8 >= .4 and ((pp:goals - p:goals) + (ppp:goals - pp:goals) + (pppp:goals - ppp:goals) + (ppppp:goals - pppp:goals) + (pppppp:goals - ppppp:goals) + (ppppppp:goals - pppppp:goals) + (pppppppp:goals - ppppppp:goals)) / 8 <= -.4
H and (tA(goals@team and season and 20>game number>10)-tA(goals@team and season and 10>game number>0))+(tA(goals@team and season and 30>game number>20)-tA(goals@team and season and 20>game number>10))+(tA(goals@team and season and 40>game number>30)-tA(goals@team and season and 30>game number>20))+(tA(goals@team and season and 50>game number>40)-tA(goals@team and season and 40>game number>30))/4>((oA(goals@team and season and 20>game number>10)-oA(goals@team and season and 10>game number>0))+(oA(goals@team and season and 30>game number>20)-oA(goals@team and season and 20>game number>10))+(oA(goals@team and season and 40>game number>30)-oA(goals@team and season and 30>game number>20))+(oA(goals@team and season and 50>game number>40)-oA(goals@team and season and 40>game number>30))/4) +.5
H and (tA(goals@team and season and 84>game number>42)-tA(goals@team and season and 42>=game number>0))>(oA(goals@team and season and 84>game number>42)-oA(goals@team and season and 42>=game number>0))+.4
Any money line home favorite of between -120 to -170, that’s playing in the 2nd half of the season, versus an opponent that has a goal per game differential of +0.3 or better, and they allowed 3-goals or more in each of their last 3-games, has gone 26-4 (86.7%) since the beginning of the 2009-2010 year.
ROI too low--A and tA(o:goals)>=3.2 and po:goals>=3 and ppo:goals>=3 and pppo:goals>=3 and ppppo:goals>=3 and season>=2009
A and total>=6 and P:AL and P:season=season and p:goals=-1
season>=2010 and H and -100>=line>=-150 and (tS(W, N=8)=7 or tS(W, N=8)=6) and (t:date-p7:date<14 or t:date-p8:date<14 or t:date-p9:date<14 or t:date-p10:date<14)Last edited by emceeaye; 11-10-14, 11:03 AM.Comment -
@emceaaye
Holy mother of god, this is a huge list and it will take a while to adjust or crosscheck.
Shoot me a PM so you can join the force who are working on the google doc right now. I guess most of them are from here/bases and more, but will have a deeper look later.
If anyone wants to add plays or queries. Go for it. Keep the standard code I use and I can crosscheck later.Comment -
You got to be flking meComment -
Devils and Flames lost last night. Tuesday should be huge.Comment -
A LOT of trends active tonight. Maybe some of you can add together, I will be away for a few hours.Comment -
my bets tonight.
islanders -130 1u
coyotes -103 1uComment -
many are active today with few conflicts including yours above zxqwpdbg:
islanders ML 1 unit
coyotes ML 1 unit
Islanders/avalanche under 1 unit
Penguins/rangers under 1 unit
canadiens/jets under 1 unit
Lightning/Blackhawks under 1 unit
capitals ML 1 unit
Blackhawks ML 1 unit
Sabres ML 1 unit
Canadiens ML 1 unit
Devils/Wild over 1/2 unit
Panthers/Sharks over 1/2 unit
Blues/Sabres over 1/2 unit
Good luck tonight!Comment -
Me too bud, I have been up and down since starting with NHL sdql this season...There haven't been as many non-conflicting active results at one time as today--Id rather spread out over many plays rather than a few, but Im going a bit against my better judgement as I've been screwed in the past when I've made too many wagers in a night...Comment
