NBA Stituational Bet, SDQL

Originally Posted by pip2

I wonder if away teams playing away on the 23rd of December are less preoccupied with home-xmas-related issues:

date in [20141223,20131223,20121223,20111223,2010 1223,20091223,20081223,20071223] and H

date in [20141223,20131223,20121223,20111223,2010 1223,20091223,20081223,20071223] and p:A and H

ATS:	7-17-0 (-5.31, 29.2%

This one has even better results with much logic - since players that just came home, have a lot more things they must do before the holidays, than those that already been few days at home...

date in [20141223,20131223,20121223,20111223,2010 1223,20091223,20081223,20071223] and p:H and A
And the other way around, players that were back home, finished the things they needed and now play on the road - do very well...

ATS:	17-8-0 (4.18, 68.0%)	avg line: 4.5

Originally Posted by dmitean

date in [20141223,20131223,20121223,20111223,2010 1223,20091223,20081223,20071223] and p:A and H

ATS:	7-17-0 (-5.31, 29.2%

This one has even better results with much logic - since players that just came home, have a lot more things they must do before the holidays, than those that already been few days at home...

date in [20141223,20131223,20121223,20111223,2010 1223,20091223,20081223,20071223] and p:H and A
And the other way around, players that were back home, finished the things they needed and now play on the road - do very well...

ATS:	17-8-0 (4.18, 68.0%)	avg line: 4.5

I like the real life aspect of this. It would make sense that this is at least a bit of a factor in the outcomes. As far as ATS trends go this is what I have active tonight...but I don't have all the trends from the spreadsheet into my automated excel tool yet.

NBA51	AD and (o:rest=0 or rest=1) and ats streak<0 and 0<o:ats line="" and="" streak<3="">=12 and season>=2006</o:ats>
NBA76	AD and WP < 50 and (o:rest=0 or rest=1) and ats streak < 0 and 0 < o:ats streak < 3
NBA107	HD and p:AW and p:points < 105 and 2011<=season and o:rest<2
NBA21	p:ou margin>10 and rest <1 and P:L and season>2008 and 11.5 > line > -10
NBA16	H and p:AW and pp:AW and season > 2008
NBA33	H and line > -6 and p:AW and pp:AW and season >= 2011
NBA63	p:margin >= 25 and line > p:line and season >= 2012
NBA133	H and p:HFL and p:line <= -8 and season >= 2002 and -10.5 <= line <= -4.5
NBA154	A and 9.5 >= line >= 3.5 and tA(points) >= 103 and p:M2 <= -15 and playoffs = 0
NBA16	H and p:AW and pp:AW and season > 2008
NBA26	A and P:ats margin <= -10 and P:season = season and P:H and season > 2012
NBA33	H and line > -6 and p:AW and pp:AW and season >= 2011
NBA156	D and P:HL and P:margin<-9 and p:HL and p:margin>-4 and month in [11,12,2,3,4] and season>=2006

195 33 Clippers +2183 76 Minny +14
171 Portland +6
171 Under in Oklahoma
156 Suns -1.5
133 Thunder -6
113 Under 191 in Miami
97 Over 191 in Miami
107 Under 193.5 in Indiana
107 Pelicans -2
54 33 Dallas +1.5
21 Wizards -3

Those are the ones that look good in my eyes. Obviously some of them point to opposite directions...

NBA Best Bet

12/23/14 3:15 PM EST

Miami/Philadelphia Under 191.5 -105 (5dimes)

p:ats margin >= 16 and op:ats margin >= 16 and H
O/U: 56-94-1 (-4.57, 37.3%) avg total: 194.8
p:ats margin >= 16 and op:ats margin >= 16 and H and rest = 1
O/U: 28-68-1 (-7.82, 29.2%) avg total: 194.0

Play the under when both teams covered the spread by a large margin in their previous games. Trend is even better when the home team is on 1 day of rest

NBA SDQL 'BEST BET' 2014-15


12:45pm pst Reduced Basketball 708 Cleveland Cavaliers -13½ -107* vs Minnesota Timberwolves

SDQL:

playoffs=0 and season > 2011 and game number > 7 and tA(FGM + TPM*0.5)/tA(FGA) > .467 and oA(o:points in the paint) > 47 and rest < 3 and day!=Wednesday and team not in [Nuggets,Jazz,Wizards,Celtics,Magic,Laker s]

SDQL: English

It never ends well when I use a new query without seeing it in action first, and it never ends well when I make any kind of bet relating to cle, but these new queries are where I get most of my kicks, so what the heck: since 2011 and excluding the playoffs, and after 7 games into the season, and if it isn't Wednesday, if the team has not had more than 2 days rest, and if the team is not in a short list of squirrel teams that have no concept of the meaning of consistency, play the team that has an average effective field goal percentage of more than .467 when it plays against a team that on average allows its opponents to score more than 47 points in the paint.

Originally Posted by pip2

NBA SDQL 'BEST BET' 2014-15


12:45pm pst Reduced Basketball 708 Cleveland Cavaliers -13½ -107* vs Minnesota Timberwolves

SDQL:

playoffs=0 and season > 2011 and game number > 7 and tA(FGM + TPM*0.5)/tA(FGA) > .467 and oA(ooints in the paint) > 47 and rest < 3 and day!=Wednesday and team not in [Nuggets,Jazz,Wizards,Celtics,Magic,Laker s]

SDQL: English

It never ends well when I use a new query without seeing it in action first, and it never ends well when I make any kind of bet relating to cle, but these new queries are where I get most of my kicks, so what the heck: since 2011 and excluding the playoffs, and after 7 games into the season, and if it isn't Wednesday, if the team has not had more than 2 days rest, and if the team is not in a short list of squirrel teams that have no concept of the meaning of consistency, play the team that has an average effective field goal percentage of more than .467 when it plays against a team that on average allows its opponents to score more than 47 points in the paint.

Nice query. One thing I noticed, however, is that it doesn't seem to like Tuesdays of all days:

day=Tuesday and playoffs=0 and H and game number > 7 and tA(FGM + TPM*0.5)/tA(FGA) > .467 and oA(ooints in the paint) > 47 and rest < 3 and day!=Wednesday and team not in [Nuggets,Jazz,Wizards,Celtics,Magic,Laker s]

Originally Posted by Heart

Yeah I'm nervous about putting $ on games this close to Christmas. Sample size around this time is small as well. I may layoff for several days.

Great job yesterday though, fellas!

Same, and was just wondering about the pre-Christmas effect last night and now see all the great insight from dmitean, Consig, pip on that exact topic. Always good stuff guys, nice!

Originally Posted by emceeaye

Nice query. One thing I noticed, however, is that it doesn't seem to like Tuesdays of all days:

day=Tuesday and playoffs=0 and H and game number > 7 and tA(FGM + TPM*0.5)/tA(FGA) > .467 and oA(o:points in the paint) > 47 and rest < 3 and day!=Wednesday and team not in [Nuggets,Jazz,Wizards,Celtics,Magic,Laker s]

I'm getting 12-7 on Tuesdays, so I'm not able to follow you thus far...

NBA SDQL 'BEST BET' 2014-15


527PM ET Timberwolves +13½ +100* vs Cavaliers

SDQL:

AD and (o:rest=0 or rest=1) and ats streak<0 and 0<o:ats streak<3 and line>=12 and season>=2006

SDQL: English

Play the road dog where the opponent is off a back to back or the team has one day of rest, is on a losing ATS streak and the opponent is on a winning ATS streak less but less than 3 and there is a big line over 12 on the game. There are plenty of weird angles on this game, the big KLove trade etc. The Twolves on these big lines have been about 50-50 where they have lost to the good scoring teams out west and the Cavs I don't think have covered any double digit lines this year except against the lowly Magic when Vucevic was injured. Its another when where you hold your nose and take the big dog. Going against my BB co-top dog pip2 on this one.

Originally Posted by pip2

I'm getting 12-7 on Tuesdays, so I'm not able to follow you thus far...

Maybe I should have said that it doesn't like Tuesdays as much... while 12-7 is a winning record, it is also not very compelling for Cleveland despite an admittedly small sample size of 19. Just to see if anything systematically is happening on Tuesdays, you can eliminate the season parameter and note a 31-39 record in favor of the other side, the lowest of any day of the week. Incidently, with the season parameter in place, at 12-7, it also has the lowest WP of any day of the week....just something I noticed, and since I'm anal like that, I would probably shy away from a play...It also lost its last 3 Tuesday games.

In any case, since 2011, it's clear that the parameters you have in place have a larger effect on the outcome than simply the day of the week, so in the long run looks great overall...just my two cents

GL

Originally Posted by emceeaye

Maybe I should have said that it doesn't like Tuesdays as much... while 12-7 is a winning record, it is also not very compelling for Cleveland despite an admittedly small sample size of 19. Just to see if anything systematically is happening on Tuesdays, you can eliminate the season parameter and note a 31-39 record in favor of the other side, the lowest of any day of the week. Incidently, with the season parameter in place, at 12-7, it also has the lowest WP of any day of the week....just something I noticed, and since I'm anal like that, I would probably shy away from a play...It also lost its last 3 Tuesday games.

In any case, since 2011, it's clear that the parameters you have in place have a larger effect on the outcome than simply the day of the week, so in the long run looks great overall...just my two cents

GL

Who knows? I wouldn't get too caught up with Tuesday performance because there are probably a million other reasons the query would not work anyway, especially since this is probably more of a day-before-Christmas Eve day than a Tuesday for the NBA. I kind of like it though because I didn't target the query for this game, and as
I was goofing around with the query in various ways, I couldn't help but notice that no matter what stuff I stuck in there or removed, it still seemed to catch this game and show an ATS win for cle. Like I said before, though, I'm probably going down on this one, but this is for fun, right?

NBA SDQL 'BEST BET' 2014-15

12-23-14 - 5:18p CT

SDQL: tS(W, N=10)>=8 and 49>=WP>=40 and o:WP>50 and total>=188

Play over a ave team on a hot streak winning 8 or 9 out their last 10 against a winning team.

Originally Posted by pip2

Who knows? I wouldn't get too caught up with Tuesday performance because there are probably a million other reasons the query would not work anyway, especially since this is probably more of a day-before-Christmas Eve day than a Tuesday for the NBA. I kind of like it though because I didn't target the query for this game, and as
I was goofing around with the query in various ways, I couldn't help but notice that no matter what stuff I stuck in there or removed, it still seemed to catch this game and show an ATS win for cle. Like I said before, though, I'm probably going down on this one, but this is for fun, right?

Yes, for fun... It better be or its not worth it to me

Good point... If it loses, we will never know why especially when considering the countless relevant variables that can affect the outcome, and ones that were not and/or cannot be included in this or any other query.

Now, if someone were to analyze these data for real, then we might be able to achieve a more powerful tool to more accurately predict the outcome (e.g., multiple regression in SPSS) ... Just so time consuming to research the least-cost-prohibitive way to get as much relevant data as possible, to organize it meaningfully, and then analyze....

Originally Posted by JMon

NBA SDQL 'BEST BET' 2014-15

12-23-14 - 5:18p CT

SDQL: tS(W, N=10)>=8 and 49>=WP>=40 and o:WP>50 and total>=188

Play over a ave team on a hot streak winning 8 or 9 out their last 10 against a winning team.

Unbelievable went to ot. Didn't look good all game. Thank goodness for that

NBA SDQL "Best Bet" 2014-15

Overall Group Record - 94-77-3 - 54.9% (+11.96) (max wagered -to win 1 unit)

Yesterday's recap 3-1 (+2.00)

Official Entries: Max 10 of 10: (no particular order)

1. JMon - 16-15-1 (+.50)

2. pip2 - 19-12 (+6.28)

3. nash13 - 7-4 (+2.82)

4. Ronald S. - 10-16 (-6.96)

5. hyahya - 6-5-1 (+.45)

6. Mako-SBR - 15-14 (-.40)

7. Heart - 7-1 (+5.92)

8. Consigliere - 11-6-1 (+4.65)

9. GolfAddict - 3-4 (-1.30)

10. Open Spot - let me know if any one wants it!