Originally posted by pip2
-
No problem pip!
Comment -
Great thread going here. I have just found the forum thanks to Nash13 and am going to use this thread to post my plays. I started a thread in the sports database forum but because my system is a combination of a large number of sdql trends and some personal model work I've done I couldn't just post sdql so was asked not to continue that thread.
Right now the system is in its first year but has shown profit in every year of the last 15 except for one year where it was down 0.2 units. Of course this is back testing not live results.
So far we are 2-0-1 ats. Winners with Washington oct 30 and heat nov 1 and a push last night on the seventy sixers. I bought down to 11 on that game hence the push.
I will be tracking leans as well and those are 2-0 with Dallas and golden state covering ats on nov 1.
Finally there are two picks tonight Suns-6.5 and Cavs -2. I bought down the Cavs to -2 here. Primary angles here are looking at away favourite value. Suns coming of the previous big road loss to Utah are primed for a bounce back and Cavs with some extra rest look good.Comment -
LeBron James againts TrialBlazers?Comment -
Thanks Pip, and now the ML is in favor of the Wizards due to heavy public action. I will take the Knicks in this gameOriginally posted by pip2Comment -
Good work Ronald!Originally posted by Ronald S.Comment -
Really like this play Sportsmind. Pelicans and Hornets coming off low scoring games against the defensive minded Grizzlies (both teams played Grizz lately) and also the ref crew on this game are over kings so far this season. Check out their history. I use the covers website for ref assignments and statsOriginally posted by SportsMindComment -
Only thing troubling to me is no plays in 2013...doesn't mean it's not going to hit though. Could be a very specific situation (not a bad thing) or it's over fitted.Originally posted by FortySixComment -
To me, if it was overfitted, it would be because of the "line>-6". But if you take that out completely, you still have a nice one: O/U:59-34-2 (4.06, 63.4%)Originally posted by JMonComment -
Play on a team previously scoring more than 108pts playing as an home favorite more than -5 vs an opp on more than 2.5 days of rest and the total is over 202.5...play on Nets -5....and this game is projected to go over the high total of 206
SU; 43-8
ATS; 31-19-1
SDQL; p
oints>108 and HF and line<-5.0 and o:rest>2.5 and total>202.5
Comment -
I can see that. It luckily hit but I didn't love it. Feel like it could use a couple tweaks to expand it, and then factor in the opposing team's offensive ability.Originally posted by pip2Comment -
Hey fellas,
So I have been a bit of a stalker lately and went through the entire thread and picked up most of the SDQL posted by all of you. Here are the ones that are active for NBA Wednesday. Will try and do this everyday if it helps? Or do you guys sign up to killersports and get the notifications when a saved trend re-appears?
This one is a play on the Nuggets @ Kings
H and line>-6 and p:AW and pp:AW and season>=2011
Under in Grizzlies @ Suns
team=Grizzlies and p:H and A and n:A and nn:A and nnn:H and season>=2011
Play against Nets vs Wolves
Cavs @ Jazzp:margin>=25 and line>p:line and season>=2013
p:ADL and p:ats margin>0 and op:AFL and op:margin<=-10
H and line>4 and total>=195 and rest<2 and p:margin>=-8 and season>=2012
Hope this helpsComment -
p:total>210 and p:AO and H and rest=0 and o:rest>0Comment -
It was the only one of 3 query bets that won for me yesterday. So I like it!Originally posted by SportsMindComment -
I think you first provided this one:Originally posted by hyahya
H and line > -6 and p:AW and pp:AW and season >= 2011
oops -- forty six already beat me to this one...Comment -
Thanks for sharing the fruits of your legwork fortysix. I did the same thing a few weeks ago, but I'm pretty sure I missed a bunch. I likeOriginally posted by FortySix
(p:ADL and p:ats margin>0 and op:AFL and op:margin<=-10) the best of these I think.Comment -
A little slow on this, which teams would you fade or go with or over/under, don't quite understand all the <,>=??, sorry just trying to figure this outComment -
A and P:ats margin<=-10 and P:season=season and P:H and season>2012Comment -
Frisky, as a lot of this is pretty theoretical, guys are discussing the merits of how useful each of these queries are because some of these queries are awesome, and other ones suck, and everything in between. There's a couple of different ways you could approach this. One would be to learn these queries to the point where you can see which one would work better and which one would work worse, and then go through the queries that are presented every day and figure out if you like them good enough to bet on them. Another method would be to just watch for jmon or mako to endorse a query and then jump on it.Originally posted by frisky
But even if you don't know the <,> and all that, you might get some basic use out this if you are able to cut and paste the posted queries into the killer sports (nba section) website and see the results. If the query applies to a game going on today, for instance, then at the bottom of the query you will see that game listed.Comment -
p:WAD and p:margin>=6 and HD and line<=6 and season>=2010Comment -
Thanks pipComment -
Thanks Jmon!Originally posted by JMonComment -
How do trends for a specific team the year before fare in general? For instance, Orlando being on the road last year heavily favored the under and an ATS loss (well, straight up loss too lol). Though tonight's game, they are a rare road favorite against Philly whom they beat and covered in the same situation last year.
4-37 (-9.88, 9.8%) 14-25-2 (-1.60, 35.9%) avg line: 8.3 12-29-0 (-2.78, 29.3%) avg total: 198.5
Also, is there a shortcut for "a cover"? I have just been doing ats margin > or < 0 but seems odd they have O and U for over and under the total but no shortcut for winning or losing ATS?Comment -
atsm <- needs to be uppercaseOriginally posted by ronald s.Comment -
Thanks again Jmon.
AD and p:H and rest = 0 and o:rest>0 and month = 11 and line < 4
This is the weaker version of the trend I posted yesterday. (p:A is the strong version)
The Raptors @ Celtics qualify as a game today. The line is currently at TOR +2 and ML +110
Still on the fence on whether I'll play it though. Line is moving in Boston's favor so might see if spread moves to 2.5
The Knicks would also qualify as a play under this trend if we don't restrict it to spreads under 4 (currently 4 now, opened at 1.5) but they too played their previous game at home. I like the Knicks better than Raptors in this spot as Detroit is just awful but it would be against a 2.5 point line move.
It's done quite well since 2000 though small sample size18-7 (4.04, 72.0%) 19-5-1 (7.18, 79.2%) avg line: 3.1 14-11-0 (0.98, 56.0%) avg total: 192.3 Comment -
I've made my way through half this thread after getting it referred to me by Nash13. All I have to say is WOW. Great work here guys, this is an amazing resource. I've been dabbling in SQDL for a few years here and there and am really trying to make a go of it now. My focus is on NBA as this is the sport I know well. As I said before in my first post in the thread, I've got a number of my own trends and some filtering that goes on that I was putting together and I thought I was a super-genius for that. Well turns out not...I was a bit concerned about sharing this hard to find and hidden "gems" but reading through the thread has shown me the power of sharing so I will be posting my specific trends and plays. The Cavs were on my picks with the following trend AF and p:AL and p:ats margin<0 and playoffs = 0 and season>=2006, with some additional angles relating to last nights blowout loss also to back this up. Another pick I have is Bulls tonight - 4.5 . For some reason this query won't paste into the window but the angle is a team that was previously outrebounded but won as a dog, is at home as a dog should be faded. The fundamentals aren't there for the team to cover.Comment -
^ Consigliere I'm happy you decided to share! That's what this thread is about helping, learning and sharing of what we all love to do.Comment -
Favoring TOR and MEM ML or ATS
A and -3 <= line <= 5 and p:H and p:margin > 10 and P:W and month != 3 and o:rest < 2 and 2011 <= season and D
bolComment -
Bulls
Unreal last three years.
HD and p:AW and points < 105 and 2011<=season and o:rest<2
Comment -
p:rebounds < po:rebounds and pOriginally posted by Consigliere
W and HD 123-281 (-4.97, 30.4%) 171-222-11 (-0.36, 43.5%) avg line: 4.6 212-186-6 (1.57, 53.3%) avg total: 193.3 Comment -
Only small sample but it was using the same SDQL for the Nuggets @ Kings game and I just put in there "HL" (Nuggets),
H and line>-6 and p:AW and pp:AW and op:HL and season>=2011Comment -
A and p:L and total>=200 and p:margin>-4 and opoints>100 and oppoints>100 and opppoints>100
Comment -
I tried to leave the following as wide open as possible. It involves a 4 games in 5 nights coming off a HFW. The big difference came when I put the total as greater than 200. It is certainly something to look into even if we have to work on it to make it better. It seems like the opposing teams that covered in the situations have been better teams than the Celtics.
10-36 (-7.35, 21.7%) 13-32-1 (-4.71, 28.9%) avg line: 2.6 24-22-0 (0.99, 52.2%) avg total: 208.4 Comment -
Scratch the above. The quality of the opposing team makes a big difference. When i put combos of op:L and opp:L, it changed the results drastically.Comment -
Crazy part here is that the total has been bet up to 210 from an opener of 205. Might just hope for a slow opening 5 mins and live bet the over trying to get a better line.Originally posted by hyahyaA and p:L and total>=200 and p:margin>-4 and opoints>100 and oppoints>100 and opppoints>100Comment -
Hi Hyahya, when I put this into the SDQL query it doesn't show any active games today...Originally posted by hyahyaComment
