-
Comment -
and this
p:shots on goal > po:shots on goal and p:AL and A and 0 <rest < 3 and season
do you have some others?
PS:formating problems, to see the query hit on reply with quote.Comment -
Looks right to me. You didn't cover the win %, it needs to be 60>=WP>=51 and 25<= o:WP <=40 (that's how I read it anyway). Didn't change anything anyway. I also check the streak parameter by subbing p:L to see if it was working and it is. Perhaps a bad last 8 years....lol.---can't see that happening though and maintaining a 78% clip.Comment -
Nice! This thread got busy, time to catch up.Comment -
Oilers ML
Not sure who posted this but it points to Oilers ML tonight.
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
Nice record, 42-14 and ROI, 24%
Add month=10, and team is 7-1 in this situation. Also a possible play on the under, ou record 1-7.Comment -
Ross Benjamin situation, 3/28/14
Any home team in the 2nd half of the season that's facing an opponent that averages 2.85 or more goals per game, and that opponent has allowed 3-goals or more in each of their last 5-games, has gone 33-13 (71.7%) versus the money line in the last 5 seasons.
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
WP and ROI good.Comment -
In previous game, the team scored 1 goal for every 7 attempts or better. They have won 2 of their past 3 games. Their current opponent's last game was yesterday, so no rest for them. This team, which is the Oilers, has a better home win % than that of their opponent. We are looking at results since and including 2011.Comment -
Gotcha thanks. Interesting play. We'll see if it pays off tonight.Comment -
To make things shorter:
p:shots on goal / p:goals <= 7.1 and Sum(W@team,N=3) = 2 and o:rest = 0 and HWP > o:HWP and season >= 2011
1) don't need "pt:"..."p:" suffices
2) o:rest=0 ----- opponent had zero rest
itll save you time doing queries in long run.
Also, I'll freakin bet against hurricanes every day the way they are playing nowComment -
I was pretty sure o:rest=0 would suffice too, but just wanted to double check... That's interesting. I ran a situation earlier that makes me want to pick the Canes. Not a ton of data, but it's interesting. I figured the Canes have to win eventually right and the Oilers aren't that great, so I wanted to see how the Oilers play against a team that has a streak of -5 or more. t:team=Oilers and HF and o:streak<-5. They're 0-4 in that situation which was interesting me to. So I put 1U on the Canes just incase...Comment -
Right, I use "p:" instead of "pt", and "rest=0" instead of "date-p:date..." when I make my own queries, but since it was already saved in my query list that way, it was actually faster to just copy and paste it.
Great, so circumstantial support and your gut instinct support the play.
Comment -
Interesting and I like your thought process. What is concerning though is that all of those games occurred last year or earlier, so oilers were to some extent a different team back then. Also, since there is no effect when you eliminate the team specificity from the query, now relying more on the premise that the effect in your query is related to something exclusive to the Oilers in particular and not characteristic of teams in general, the prediction is even less reliable given what was stated above. Also, and maybe even more importantly, the extremely small sample size is a liability here.
Not saying it won't win for you though.
Good luck!Last edited by emceeaye; 10-24-14, 05:52 PM.Comment -
canadiens ML
Ross Benjamin's pick today...tweaked a bit to more closely match his stated win % for it:
p:margin=1 and pp:margin=1 and po:goals<=2 and ppo:goals<=2 and oA(o:goals)>=3.1Comment -
hello everyone. i am zxqwpdbg, but you can call me zxq.
i am new to this forum and have been waiting patiently for someone to make a nhl situational plays thread.
i started sports betting two weeks ago and only have intentions of betting hockey. prior to this i have been trying to teach myself sdql for the last few months getting ideas from other situational plays threads.
although i wasn't going to sign up and was just going to be silently reading the posts. i have decided that i would like to be a member of this forum and help contribute where i can.
i would like to start tonight.
i am going to email sportsdatabase tonight and see if they will add the conference parameter for the nhl if i donate $100.
also here is a query i wrote last week that has multiple plays for tonight.
playoffs=0 and po:goals=0 and p:site=home and season>=2010Comment -
Welcome.
Nice job.
I hope you dont' mind, but I tweaked your query a bit to get a better WP.
playoffs=0 and po:goals=0 and p:site=home and season>=2010 and HF and WP>50 and o:WP<50
Add season>=2013, and watch the WP increase to 15-0.
Thanks zxq, I'm going to play the senators ML tonight, which is suggested by the queries.Last edited by emceeaye; 10-25-14, 02:33 PM.Comment -
Ross Benjamin post 3/17/2014:
Any road team with a total of 5.0 or less that scored 1-goal or less in their previous game, versus an opponent that scored 5 or more goals in their previous game, has seen 27 of those 36-games (75%) go under the total in the last 5 seasons.
Not active today though.
A and p:goals<=1 and op:goals>=5 and total<=5 and season>=2009Comment -
playoffs=0 and po:goals=0 and p:site=home and season>=2010
on this play.
i have a strong trend which intend to take new jersey. so in these cases it is kind of a point of trust in each query.
this is it
A and 12 > tA(penalty minutes) > 11 and month != 11 and month != 12 and game number >= 5Comment -
Ross post on 3/13/2014:
Any road team that’s playing with same season double revenge stemming from a pair of losses by 2-goals or more, and they’re coming off a road 1-goal win, has gone under the total in 65 of those 97-games (67%) in the last 18 seasons
Although Ross suggests the under with this situation, the WP in favor of the home team shows an even better WP and a very good ROI.
However, I don't think the 2 losses that brought on this double revenge game happened this season as he stated for his situation if I'm understanding it correctly:
PP:margin<=-2 and P:margin<=-2 and p:margin=1 and A and p:AW
SU: 19-50 (-1.17, 27.5%) avg line: 144.8 / -158.3 on / against: -$2,399 / +$2,129 ROI: -33.6% / +19.2%
OU: 28-40-1 (-0.04, 41.2%) avg total: 5.4Last edited by emceeaye; 10-25-14, 08:41 PM.Comment -
thank you for the warm welcome, you two. i also don't mind you tweaking my query at all. i actually encourage it.
i emailed sportsdatabase like i said and for $100 they said they would add in the conference parameter. after i give him the money and a little bit of time to add it in, i expect the parameter should be in by the end of next week.Comment -
hmm what about the divisions? the problem here is that the division structure changed last year. this may make things harder to analyze.Comment -
i would like to have those to. but they wanted an extra $300 for them. i can't afford that right now. however if i make some overtime this winter i will definitely kick in some more support because i am hoping for that parameter as well.
about the division changes. i am sure sportsdatabase is aware of them and they might be able to work around it. maybe we can filter between new alignment and old alignment as an extra feature. we will have to see.Comment -
was just thinking i should explain my query for anyone who is wondering.
playoffs=0 and po:goals=0 and p:site=home and season>=2010
in a season game, off a shutout win at home since 2010
here is the tweaked version from emc.
playoffs=0 and po:goals=0 and p:site=home and HF and WP>50 and o:WP<50 and season>=2013
in a season game, off a shutout win at home. the current game is a home favourite with winning percentage greater than 50 and opponent's winning percentage less than 50 since 2013.
nash's query.
A and 12 > tA(penalty minutes) > 11 and month != 11 and month != 12 and game number >= 5
an away game, with team's average season to date penalty minutes per game between 11 and 12. excluding the months november, december and excluding team's first 4 games of every season.
i like this query nash, i am gonna play around with later and see if i can tweak it myself.
let me know if i got those query's nailed down.Comment -
12.2% Yield on over 1000 picks vs 14.5% Yield on 340 picks
look at is this way
playoffs=0 and po:goals=0 and p:site=home and season>=2010 and A and 12 > tA(penalty minutes) > 11 and month != 11 and month != 12 and game number >= 5
if both queries are true, we are fine, but that's like 1 in a million
playoffs=0 and po:goals=0 and p:site=home and season>=2010 and (A and 12 > tA(penalty minutes) > 11 and month != 11 and month != 12 and game number >= 5)=False
1 st query true and 2nd query false excludes the new jersey game from yesterday, but yield and profit stay nearly the same
seems like you don't miss much of the profit if you cross-query the two.
A and 12 > tA(penalty minutes) > 11 and month != 11 and month != 12 and game number >= 5 and (playoffs=0 and po:goals=0 and p:site=home and season>=2010)=False
there you get the jersey game backComment -
jets ML?
This one active on Jets today:
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
Thoughts?Comment -
so the true/false query parameter is used to find out what game to bet on if two queries are suggesting different plays? what other uses does the true/false query parameter have?
i played around with the "12>tA(penalty minutes)>11" a little while ago, let me know what you think.
A and 12>tA(penalty minutes)>11 and p
enalty minutes>12 and o:rest<7 and (p:A and op:A or p:A and op:H) and playoffs=0
an away game with a teams season to date average of 11-12 penalty minutes per game. off a game where they had more penalty minutes then there season to date average. opponent is playing on no more than a week of rest. teams previous game was away and opponent's previous game was away or teams previous game was away and opponent's previous game was home.Comment -
the question is: what is more important to you?so the true/false query parameter is used to find out what game to bet on if two queries are suggesting different plays? what other uses does the true/false query parameter have?
i played around with the "12>tA(penalty minutes)>11" a little while ago, let me know what you think.
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
an away game with a teams season to date average of 11-12 penalty minutes per game. off a game where they had more penalty minutes then there season to date average. opponent is playing on no more than a week of rest. teams previous game was away and opponent's previous game was away or teams previous game was away and opponent's previous game was home.
do you want to have fewer picks and a high yield?
or is it all about having the most profit no matter how?
i prefer a mixture of both.
your tweak is good, every past season ended in profit. but the first one did that too. so i would use what you more like.
as for true and false queries. this is a good tool to determine if cross queries are contradicting each other.Comment -
"losing record against the money line" terms
Is there a difference between a team having a "losing record" and a team having a "losing record against the money line"? If so, can someone please tell me the SDQL to express the latter as I'm trying to translate a bunch of Ross Benjamin situations into SDQL?
Thank you in advance.Comment
