I thank JAnthony for helping guide my SDQL's. They both won though.
I thank JAnthony for helping guide my SDQL's. They both won though.
No problem, man!
Went 3-1 myself with my own finds for yesterday, left one total pick unposted, since it was only a 64% over trend, but played it anyway. Glad I stayed away from that PHX v. LAL game, these two teams are simply too unpredictable to draw any logical assumptions there.
Two tasty trends pointing on Kings tonight. Both situations were posted previously by JMon, if I'm not mistaking.
p:L and op:L and A and rest>=1 and 0<=line<=3 and P:margin>=5 and season>=2010
A and tA(o: points)>=103 and p:M2<=-10 and pp:M2<=-10 and o:rest<3 and rest<=3 and line<=14
Took the day off except had the bright idea to take the Suns while on my lunch break.
Should have taken a walk in the park instead.
I'm interested in querying the turnaround game with the Celtics and Bulls.
Do any of you professors at "Query University" have anything for that?
When running how individual teams who both are playing on no rest this year which happens with Bulls/Celts tomorrow.
team and season=2013 and rest=0 and o:rest=0.
Take a look at the totals.
Simple, but wow. Few other but I like these two the best.
19-1 record: team=Pacers and p:A and H and rest>=0 and season=2013
17-0 record: team=Pacers and p:A and H and rest>=0 and o:rest=1 and op:W and season>=2012
Green,
I played a turnaround situation earlier this year involving another team from the Central; the first game went over, and so did the second. But yet again the under is 26-11 at the United Center this season; 5-2 on the under when Bulls are playing on zero days rest.
Worth Monday Note: Damn!
Nuggets have allowed 100+points in seven straight games..and have allowed 100+points in 15 straight home games dating back to January.
po:team=o:team and p:HL and AD and division!=o:division and rest=0
SU: 6-8 (-4.21, 42.9%) ATS: 10-4-0 (2.57, 71.4%) avg line: 6.8 O/U: 10-4-0 (6.46, 71.4%) avg total: 192.0
FG Pct FT Pct 3s Pct BLKS O-RBND RBND Fouls AST TOvers Q1 Q2 Q3 Q4 Final Team 36.36 44.6 18.00 76.1 6.43 38.6 4.14 11.00 40.14 21.29 19.43 12.43 24.8 25.8 21.5 23.8 97.1 Opp 37.64 47.5 19.43 73.3 6.64 38.6 5.43 10.21 41.71 20.29 23.07 12.64 25.4 25.5 22.4 27.6 101.4
Date Link Day Season Team Opp Site Final Rest Line Total SUm ATSm OUm DPS DPA SUr ATSr OUr ot Feb 02, 1997 Sun 1996 Cavaliers Heat away 76-80 0&0 5.5 167.0 -4 1.5 -11.0 -4.8 -6.2 L W U False Jan 24, 1998 Sat 1997 Warriors Grizzlies away 96-107 0&0 6.5 184.0 -11 -4.5 19.0 7.2 11.8 L L O False Nov 24, 2001 Sat 2001 Pelicans Magic away 103-101 0&0 10.0 193.0 2 12.0 11.0 11.5 -0.5 W W O False Dec 03, 2003 Wed 2003 Magic Pelicans away 91-106 0&0 9.0 187.0 -15 -6.0 10.0 2.0 8.0 L L O 0 Jan 28, 2006 Sat 2005 Nuggets Clippers away 79-112 0&0 2.5 195.0 -33 -30.5 -4.0 -17.2 13.2 L L U 0 Feb 11, 2007 Sun 2006 Supersonics Kings away 114-103 0&0 4.5 207.5 11 15.5 9.5 12.5 -3.0 W W O 0 Apr 05, 2008 Sat 2007 Hawks Seventysixers away 92-85 0&0 5.0 204.5 7 12.0 -27.5 -7.8 -19.8 W W U 0 Nov 22, 2008 Sat 2008 Thunder Pelicans away 97-109 0&0 15.5 190.5 -12 3.5 15.5 9.5 6.0 L W O 0 Dec 27, 2008 Sat 2008 Nets Bobcats away 114-103 0&0 3.0 190.5 11 14.0 26.5 20.2 6.2 W W O 1 Dec 30, 2009 recap Wed 2009 Hawks Cavaliers away 101-106 0&0 6.5 193.0 -5 1.5 14.0 7.8 6.2 L W O 0 Nov 10, 2010 recap Wed 2010 Nets Cavaliers away 95-87 0&0 4.5 193.0 8 12.5 -11.0 0.8 -11.8 W W U 0 Jan 02, 2012 recap Mon 2011 Wizards Celtics away 92-100 0&0 11.0 187.5 -8 3.0 4.5 3.8 0.8 L W O 0 Nov 30, 2013 recap Sat 2013 Jazz Suns away 112-104 0&0 8.5 195.0 8 16.5 21.0 18.8 2.2 W W O 0 Feb 19, 2014 recap Wed 2013 Pistons Bobcats away 98-116 0&0 3.0 201.0 -18 -15.0 13.0 -1.0 14.0 L L O 0 Mar 31, 2014 recap Mon 2013 Celtics Bulls away 0&0 10.5 181.0
Wanted to ask your help if I can. I want to check, how different teams or more accurate - different styles of play, react to B2B games.
More precise - I believe that good defensive teams with poor offense should do better than good offensive teams with bad defense and that teams that play more in the paint and take mid range shots, will do better than teams that live and die by three point shooting.
Reason is that tired legs mean that shots from distance usually come off short, while playing in the paint - just about will and desire.
Also, on offense you can catch a good day or a bad day - and fatigue might have something to do with that. But teams that are proud of their defense (Pacers, Bulls, Memphis style of teams) - will bring their A game to defense no matter what.
FGP- means percentage of the field goals, but how do I write, keeping rival teams below certain points number? For example, Pacers allow their rivals only 91.7 points - how do I write it in SDQL?
Also, TPA means three pointers attempted, but when I try to put it in to query - it doesn't give me anything interesting - cause Memphis should be on the list, but it doesn't.
I write and TPA<15 for example and probably doing something wrong.
How do I write it correctly?
Some of the professors here should be able to help steer you in the right direction.
I can say that two bad teams playing back to back play high scoring games, because those that play or have played ball know that it's fun to play offense and a lot of work and not so fun to hustle back first, and then play defense.
Thibodeau for Bulls thinks you are breaking the rules if you are having fun, so his teams usually play low scoring games on back to backs.
tA(W)<.5 and oA(W)<.5 and rest=0 and o:rest=0 and HF and division!=o:division
Thanks for another few wins yesterday guys keep up the great work. This stuff is very hard but I am still trying to learn.
you would a summative here. see sdql dot com and look up summative heading. team=Pacers and tA(o: points)<=91.7
Defense allows below or equal to 91.7 a game.
You have to use a game reference to make it predictive, otherwise you are only seeing the actual game it happened.
Game Reference:
p => team's previous game
op => opp's previous game
P => previous match up
n => team's next game
on => opp's next game
N => next match up
so... p:TPA<15
shows the grizzles yesterday!
Yeah, thanks, for one game, I know, even several games. But how do we write seasons average of three points attempted?
Memphis are at season average of 14 three point attempts a game. How do I write it in SDQL?
Thanks. With your help I managed to do what I wanted. That didn't help me as far as betting goes, but I'm learning:
tA(o: points)<=92 and otA(o: points)<=98 and site=home and rest=0
This is something like what I wanted...
This is a bit different, but with actual result, though too small of a data to draw real conclusion:
tA(o: points)<=92 and site=home and rest=0 and p:L and p:site=away and 20121131<=date
Still 6 - 0 SU and 5 - 1 ATS.
Last edited by dmitean; 03-31-14 at 08:47 AM.