LAC x2
LAC/IND over
LAC/IND under x3
PHI/ATL under
WAS x4
WAS/ORL over x2
WAS/ORL under
BOS x2
BOS/CHA over
MIN x2
POR/MIN under
POR/MIN over
HOU/GS over
BOS/CHA over
NO/DAL over
170 2 Clippers -6.5
163 170 126 Under 199.5 in Indiana
108 Over 199.5 in Indiana
163 Under 194.5 in Orlando
106 Over 194.5 in Orlando
147 87 Over 204.5 in Charlotte
138 Warriors -11
16 Rockets +11
134 Mavs -7
132 Under 203.5 in Oakland
75 Over 203.5 in Oakland
131 100 Minny +11
113 Under 202.5 in Atlanta
104 33 16 13 3 Wizards -4.5
96 10 Celtics +2.5
87 Over 206 in Minny
59 Under 206 in Minny
87 Over in 209 Dallas
84 Hawks -13
Didn't have the time to go over them, don't know if any are good or bad. A bit short on time today.
If someone can put them in the file and go over them, to see which ones are good and which aren't, it would be great!
Check out the Washington ATS plays. Nothing else is that great IMO.Originally Posted by dmitean
Didn't have the time to go over them, don't know if any are good or bad. A bit short on time today.
If someone can put them in the file and go over them, to see which ones are good and which aren't, it would be great!
NBA SDQL 'Best Best' 2014-15
12-10-14 - 2:14p CT
Play LAC -6.5 -110
SDQL: H and 9.5 >= line >= 3.5 and p:margin <= -10 and op:points >= 100 and opp:points >= 100 and oppp:points >= 100 and 2009<=season and playoffs = 0 and o:rest<2
English: Since 2009, in reg season fade a home dog from 3.5 to 9.5 off a loss of 10 or more; against an oppt that scored 100pt or more three straight and is on less than 2 days rest.
where's Consigliere? I need a WINNER!!!!!
NBA SDQL 'Best Bet' 2014-15
12-10-14 - 12:30p PST
Play: LAC (-6.5) IND -110
SDQL:
H and 10.5>=line>=3 and p:HL and p:margin<=-12 and op:points>=101 and opp:points>=101 and oppp:points>=100 and playoffs=0 and o:rest<2 and month!=3 and season>=2006
English:
Fading a home team here that got beaten down like a dog in their last home game losing by 12 or more, against a hot offensive team scoring 100+ points in their last three straight games, getting between 3 and 10.5 points, in all months besides March.
Notes:
Nice query from JMon previously, simple, makes sense, and it's certainly not hard to go with the Clippers at this point after their recent performances. They are due for a let down though, wouldn't be surprised if it happens here despite the Clips being a good road team this season. BOL all!
PS - Hahaha, I see JMon just posted it also, that's funny...was my favorite query out of six being active on my sheet, thanks buddy, let's get it!
I don't know. I know that the query isn't based on Pacers weakness, but still... This is a very different team than it was last season and even all this season long, till their recent road trip.
It's only their second home game with their "true" team...
Hope you hit it!
I took LAC first quarter...
site=away and p:H and pp:A and ppp:A and pppp:A and ppppp:A and rest=0 and line>0
SU:25-104 (-9.02, 19.4%)ATS:52-74-3 (-1.74, 41.3%) avg line: 7.3O/U:52-76-1 (-3.71, 40.6%) avg total: 194.7
Nice one both for Under and Fade.
Interesting that if you do the same, but favorite, instead of dog, you get an Over trend:
site=away and p:H and pp:A and ppp:A and pppp:A and ppppp:A and rest=0 and line<0
SU:30-13 (5.21, 69.8%)ATS:21-21-1 (1.22, 50.0%) avg line: -4.0O/U:25-18-0 (2.05, 58.1%) avg total: 192.6
Also, this one is very nice:
conference = Western and o:conference = Western and p:H and pp:A and ppp:A and pppp:A and ppppp:A and line>0 and season>2008
SU:18-63 (-7.75, 22.2%)ATS:27-52-2 (-2.14, 34.2%) avg line: 5.6O/U:37-44-0 (-1.10, 45.7%) avg total: 203.6
And a variation of it:
conference = Western and o:conference = Western and site=home and p:H and pp:A and ppp:A and pppp:A and ppppp:A and season>2008
SU:57-42 (2.12, 57.6%)ATS:39-57-3 (-0.93, 40.6%) avg line: -3.1O/U:58-39-2 (1.92, 59.8%) avg total: 202.8
NBA SDQL 'Best Bet' 2014-15
Play: Wizards -5 -104
SDQL: conference = Eastern and o:conference = Eastern and site=home and p:A and pp:A and ppp:A and pppp:A and line>0 and season>2008
English:
Fading a home team off a long road trip, playing their first home game as a dog.
Notes: There is always a huge discussion, what game is the best to fade the team in, first game off a long trip of the second one. I honestly don't know, because all the players and coaches always claimed it's the first game, but playing with the queries, the answer is not that clear and obvious, but one thing is sure - it's a good idea to look for the right spots to fade such teams.
NBA Best Bet
12/10/14 4:45 PM EST
Boston +3 -105 (@Charlotte) (5dimes)
AD and ats streak >= 5 and season >= 2010
ATS: 53-29-1 (2.66, 64.6%) avg line: 5.9
AD and ats streak >= 5 and season >= 2010 and 2.5 <= line <= 8
ATS: 43-14-1 (3.43, 75.4%) avg line: 5.3
Play the away team as a small to moderate underdog who have covered the spread in their last 5+ games.
The Sixers are also a play under this query but they fall outside the 2.5-8 pt underdog range (they are +13).
Here's something else that also seems to support Boston
rest >= 4 and H and (month = 12 or month = 1) and season >= 2008
SU: 21-20 (-1.05, 51.2%) ATS: 11-29-1 (-5.27, 27.5%) avg line: -4.2 O/U: 24-15-2 (5.60, 61.5%) avg total: 200.9
NBA Best Bet
12/10/14 4:45 PM EST
Boston +3 -107 (@Charlotte) (Pinny)
H and Average(margin@team and season) <= -6 and p:W and p:margin < 5
Fade the home team that has been losing by more than 6 points on average, previously won their last game but by less than 5.
I have watched a few Celtics games recently and although there record is bad, they are playing competitively and are well coached. They have the offensive weapons to compete against mediocre teams and win easily on any given night. They can also compete well with most teams in the East when healthy. I see this as a SU win for Celtics, probably by 3 or 4 but I took the points on this since they really seem to have a hard time holding on to leads in the fourth quarter. When Jeff Green gets locked in on in the 4th their offense starts to sputter. The Hornets have talent but haven't seemed to be able to put it together. They play fairly disjointed ball and really haven't established themselves as a guard or inside oriented team.
Also playing the wiz, clips and rockets tonight. Love the Rockets and Warriors matchup from a fan perspective. Two pretty decent trends supporting Twolves tonight with no contradictions but they are 0-9 so far on the trends from a team perspective so just can't bring myself to pull the trigger on them. Also like the Hawks play on the trends and haven't decided if I'm going to throw something on them, lot of points and Philly is playing hard but Hawks are on fire right now...tough one. Probably end up passing...best bets you make are the ones you don't.
Last edited by Consigliere; 12-10-14 at 05:20 PM.
Forget all that. Celtics suck.NBA Best Bet
12/10/14 4:45 PM EST
Boston +3 -107 (@Charlotte) (Pinny)
H and Average(margin@team and season) <= -6 and p:W and p:margin < 5
Fade the home team that has been losing by more than 6 points on average, previously won their last game but by less than 5.
I have watched a few Celtics games recently and although there record is bad, they are playing competitively and are well coached. They have the offensive weapons to compete against mediocre teams and win easily on any given night. They can also compete well with most teams in the East when healthy. I see this as a SU win for Celtics, probably by 3 or 4 but I took the points on this since they really seem to have a hard time holding on to leads in the fourth quarter. When Jeff Green gets locked in on in the 4th their offense starts to sputter. The Hornets have talent but haven't seemed to be able to put it together. They play fairly disjointed ball and really haven't established themselves as a guard or inside oriented team.
Also playing the wiz, clips and rockets tonight. Love the Rockets and Warriors matchup from a fan perspective. Two pretty decent trends supporting Twolves tonight with no contradictions but they are 0-9 so far on the trends from a team perspective so just can't bring myself to pull the trigger on them. Also like the Hawks play on the trends and haven't decided if I'm going to throw something on them, lot of points and Philly is playing hard but Hawks are on fire right now...tough one. Probably end up passing...best bets you make are the ones you don't.
Wizards burned me for the second straight time, winning, but failing to cover...
One nice query that I found, trying to use the fact that West is so much stronger than the East. Far far far more storng than bookies and public realize.
conference = Western and o:conference = Eastern and WP>60 and o:WP>60 and playoffs=0 and season>2010
SU:52-44 (2.54, 54.2%)ATS:56-38-2 (2.06, 59.6%) avg line: -0.5O/U:43-50-3 (0.77, 46.2%) avg total: 196.1
When good teams with similar records meet, bet the one from the West. Good rule that should never be forgotten...
