i stay away tonight, good luck to all of you.
Hey guys, here's one I found that maybe can be added to the spreadsheet. It doesn't apply to any games today, but the sample size and win rate are pretty good and will hopefully pop up soon:
HD and P:L and p:HW and p:margin<4 and WP>17 and WP<47 and line>2
SU: 19-91 (-10.05, 17.3%) ATS: 27-83-0 (-4.30, 24.5%) avg line: 5.8
Don't see any logic behind this query, but good luck testing it!
nice work! Like it. Only two losing years, of which were juice, - last 19 years.Originally Posted by Cutler'sThumb
Hey guys, here's one I found that maybe can be added to the spreadsheet. It doesn't apply to any games today, but the sample size and win rate are pretty good and will hopefully pop up soon:
HD and P:L and p:HW and p:margin<4 and WP>17 and WP<47 and line>2
SU: 19-91 (-10.05, 17.3%) ATS: 27-83-0 (-4.30, 24.5%) avg line: 5.8
NBA SDQL 'BEST BET' 2014-15
11-22-14 - 12:10p PST
Play: NO (-3) over UTH, -110
SDQL:
AF and p:AFL and p:line>=-3 and line>=-9 and season>=2006
SDQL English:
Taking an away favorite here after they tripped and lost their last road game as a favorite against a team they were supposed to easily handle if they executed (previous line between -3 and -9). Works particularly well if the team was blown out/embarassed in that loss as the Pelicans were yesterday.
NBA SDQL 'BEST BET' 2014-15
11-22-14 - 4:18p EST
Play: NO (-2.5) over UTH, -107. Hate to tail the last BB again but that looks the strongest to me today.
SDQL:
AF and p:AFL and p:line>=-3 and line>=-9 and season>=2006
SDQL English:
Taking an away favorite here after they tripped and lost their last road game as a favorite against a team they were supposed to easily handle if they executed (previous line between -3 and -9). Works particularly well if the team was blown out/embarassed in that loss as the Pelicans were yesterday.
Spitball Queries after the dust settles
Sorry, I checked too early this morning, and barely scraped the surface as far as what queries would be available:
wsh covers vs mil from consigliere -- ATS:53-30-3 (1.44, 63.9%)
o:rest + op:rest + opp:rest < 2 and AF and playoffs = 0 and season >=2009
bkn/sa OVER From hyahya O/U:79-43-1 (4.35, 64.8%)
p:AW and op:AW and A and rest=0 and o:rest=0
ny covers vs phi from flyinair ATS:94-59-2 (1.53, 61.4%) O/U:59-94-2 (-3.44, 38.6%)
F and p:AL and p:margin <=-6.5 and WP >= o:WP and line <=-7.5 and total >=187 and total <=212 and season >=2006
ny covers vs phi From mako ATS: 58-33-1 (2.23, 63.7%)
F and p:AL and p:margin <=-8 and WP >=o:WP and line <=-10.5 and game number <=68 and total >=187 and total <=212 and season >=2006
no covers vs ut from nash ATS:290-224-8 (0.44, 56.4%)
A and F and p:A and p:L and total >= 198
no covers vs ut From S S ATS: 51-30-3 (1.40, 63.0%)
AF and p:AL and p:steals < op:steals and p:rebounds < op:rebounds and season > 2008
no covers vs ut from sportsmind -- ATS:43-19-0 (2.88, 69.4%)
p:margin < -15 and AF and season > 2007 and total > 199
no covers vs ut from sportsmind --ATS:39-15-1 (2.65, 72.2%)
AF and p:AFL and p:line >= -4 and season > 2007 and total > 199
no covers vs ut From Nash ATS:154-94-4 (2.03, 62.1%)
A and p:AFL and p:line >=-4 and season > 2007
no covers vs ut from consigliere sitpost #1390 -- ATS: 304-215-11 (0.57, 58.6%)
AF and p:AL and p:ats margin < 0 and playoffs = 0 and season >=2006
tor/cle UNDER from hyahya in sitpost 1663 O/U:9-32-0 (-11.44, 22.0%)
tA(points) > 101 and p:TPA > 25 and p:TPP < 30 and season > 2007 and p:FTA <25 and 210 >total> 200 and p:L and season
tor/cle UNDER FROM HYAHYA O/U:34-59-2 (-4.02, 36.6%)
H and total >=200 and tS(ou margin < -11,N=2)=2 and game number < 30
mia and hou cover vs orl and dal From pip ATS:140-212-7 (-1.75, 39.8%)
p:ou margin > 10 and rest < 1 and P:L and season > 2008
tor and wsh cover vs cle and mil From rcg O/U:303-392-12 (-1.43, 43.6%)
p:dps < -11 and op:dpa < -11 and rest <= 1 and o:rest <= 1
sac wsh and no cover and UNDER vs mn, mil, and ut pip --ATS:93-142-3 (-2.11, 39.6%)
season >= 2005 and HD and p:L and rest = 0 and game number > 10 and game number < 60
wsh covers vs mil From pip ATS:60-96-5 (-1.44, 38.5%)
Minimum(date@team and season,N=3) >= date - 4 and season > 2008 and 1.5 < line < 7.5
Last edited by pip2; 11-22-14 at 03:58 PM.
Okay, thank you. Your thread is most interesting. Thanks for sharing.Yes, that was before we didn't know links could not be posted. So yes, they are against the rules.
No Best Bet for me today. GL all
No best bet. CFB today.
No best bet for me today. Too much CFB.
Thanks cutler! I stashed that one away for a rainy day...Hey guys, here's one I found that maybe can be added to the spreadsheet. It doesn't apply to any games today, but the sample size and win rate are pretty good and will hopefully pop up soon:
HD and P:L and p:HW and p:margin<4 and WP>17 and WP<47 and line>2
SU: 19-91 (-10.05, 17.3%) ATS: 27-83-0 (-4.30, 24.5%) avg line: 5.8
Spitball Query Results
1-0: wsh covers vs mil from consigliere -- ATS:53-30-3 (1.44, 63.9%)
o:rest + op:rest + opp:rest < 2 and AF and playoffs = 0 and season >=2009
0-1: bkn/sa OVER From hyahya O/U:79-43-1 (4.35, 64.8%)
p:AW and op:AW and A and rest=0 and o:rest=0
0-1: ny covers vs phi from flyinair ATS:94-59-2 (1.53, 61.4%) O/U:59-94-2 (-3.44, 38.6%)
F and p:AL and p:margin <=-6.5 and WP >= o:WP and line <=-7.5 and total >=187 and total <=212 and season >=2006
0-1: ny covers vs phi From mako ATS: 58-33-1 (2.23, 63.7%)
F and p:AL and p:margin <=-8 and WP >=o:WP and line <=-10.5 and game number <=68 and total >=187 and total <=212 and season >=2006
1-0: no covers vs ut from nash ATS:290-224-8 (0.44, 56.4%)
A and F and p:A and p:L and total >= 198
1-0: no covers vs ut From S S ATS: 51-30-3 (1.40, 63.0%)
AF and p:AL and p:steals < op:steals and p:rebounds < op:rebounds and season > 2008
1-0: no covers vs ut from sportsmind -- ATS:43-19-0 (2.88, 69.4%)
p:margin < -15 and AF and season > 2007 and total > 199
1-0: no covers vs ut from sportsmind --ATS:39-15-1 (2.65, 72.2%)
AF and p:AFL and p:line >= -4 and season > 2007 and total > 199
1-0: no covers vs ut From Nash ATS:154-94-4 (2.03, 62.1%)
A and p:AFL and p:line >=-4 and season > 2007
1-0: no covers vs ut from consigliere sitpost #1390 -- ATS: 304-215-11 (0.57, 58.6%)
AF and p:AL and p:ats margin < 0 and playoffs = 0 and season >=2006
1-0: tor/cle UNDER from hyahya in sitpost 1663 O/U:9-32-0 (-11.44, 22.0%)
tA(points) > 101 and p:TPA > 25 and p:TPP < 30 and season > 2007 and p:FTA <25 and 210 >total> 200 and p:L and season
1-0: tor/cle UNDER FROM HYAHYA O/U:34-59-2 (-4.02, 36.6%)
H and total >=200 and tS(ou margin < -11,N=2)=2 and game number < 30
2-0: mia and hou cover vs orl and dal From pip ATS:140-212-7 (-1.75, 39.8%)
p:ou margin > 10 and rest < 1 and P:L and season > 2008
2-0: tor and wsh cover vs cle and mil From rcg O/U:303-392-12 (-1.43, 43.6%)
p:dps < -11 and op:dpa < -11 and rest <= 1 and o:rest <= 1
3-2-1: sac wsh and no cover and UNDER vs mn, mil, and ut -- pip --ATS:93-142-3 (-2.11, 39.6%)
season >= 2005 and HD and p:L and rest = 0 and game number > 10 and game number < 60
1-0: wsh covers vs mil From pip ATS:60-96-5 (-1.44, 38.5%)
Minimum(date@team and season,N=3) >= date - 4 and season > 2008 and 1.5 < line < 7.5
Total: 17-5-1
Last edited by pip2; 11-23-14 at 07:47 AM.
oops
Last edited by miczz14; 11-23-14 at 05:00 AM.
