1. #1331
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by FunkFreaker View Post
    Really enjoy the numbers here but what is the logic in this trend ? Really don't know if we can trust on that "tA(points)>=100" after only couple of games for Celts... they score 120 (home) and 90 (road).
    I don't like the general idea of betting on Boston vs. Dallas because if they got blown out by Houston, it seems logical the same thing would happen at Dallas. I ran the query for game number less than 10, and it was 8-4. But when I ran it for game number less than 5, it was 0-1.

  2. #1332
    dmitean
    dmitean's Avatar Become A Pro!
    Join Date: 03-30-11
    Posts: 364
    Betpoints: 3106

    Quote Originally Posted by hyahya View Post
    H and line > -6 and p:AW and pp:AW and season >= 2011
    I liked Pelicans regardless of this, but now I'm feeling a bit better, thanks

  3. #1333
    dmitean
    dmitean's Avatar Become A Pro!
    Join Date: 03-30-11
    Posts: 364
    Betpoints: 3106

    Quote Originally Posted by pip2 View Post
    Nice one coming up tomorrow courtesy of mako himself...

    AD and p:AL and p:margin<=-13 and tA(points)>=100 and o:WP>=60 and o:rest>0
    AD and p:AL and p:margin<=-13 and tA(points)>=100 and o:WP>=60 and o:rest>0 and line>8 and line<11 and season>2008

    If we look at lines closer to today's and recent years... it's not that great...

  4. #1334
    Ronald S.
    Ronald S.'s Avatar Become A Pro!
    Join Date: 07-02-13
    Posts: 344
    Betpoints: 101

    Hey guys I just started learning this sdql stuff. What do you think about this trend for tonight?

    AD and p:ADW and rest = 0 and o:rest = 1
    O/U: 119-168-6 (-2.39, 41.5%) avg total: 195.2

    AD and p:ADW and rest=0 and o:rest=1 and p:line>9
    O/U: 12-25-0 (-4.96, 32.4%) avg total: 194.7

    Kings/Nuggets 202
    Last edited by Ronald S.; 11-03-14 at 12:49 PM.

  5. #1335
    escism
    escism's Avatar Become A Pro!
    Join Date: 10-12-14
    Posts: 105
    Betpoints: 183

    Quote Originally Posted by dmitean View Post
    I liked Pelicans regardless of this, but now I'm feeling a bit better, thanks
    I was on them today as well. Feel good about with a few different situations leaning me that way.
    Last edited by escism; 11-03-14 at 01:17 PM.

  6. #1336
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    Quote Originally Posted by Ronald S. View Post
    Hey guys I just started learning this sdql stuff. What do you think about this trend for tonight?

    AD and p:ADW and rest = 0 and o:rest = 1
    O/U: 119-168-6 (-2.39, 41.5%) avg total: 195.2

    AD and p:ADW and rest=0 and o:rest=1 and p:line>9
    O/U: 12-25-0 (-4.96, 32.4%) avg total: 194.7

    Kings/Nuggets 202
    The query looks solid although I see this one going the other way. Total is down to 201 and Nuggs still playing at a top 5 pace but just not making shots. Nuggs also love to play extra fast when they have an opponent on a b2b. I really like the over here despite the trend outlined.

  7. #1337
    FlyinAir
    SDQL
    FlyinAir's Avatar Become A Pro!
    Join Date: 07-14-14
    Posts: 1,612
    Betpoints: 221

    Glad to see this back around

  8. #1338
    existential
    existential's Avatar SBR PRO
    Join Date: 07-21-14
    Posts: 2,963
    Betpoints: 168545

    where can you find statistics on pace? thanks

  9. #1339
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by hyahya View Post
    The query looks solid although I see this one going the other way. Total is down to 201 and Nuggs still playing at a top 5 pace but just not making shots. Nuggs also love to play extra fast when they have an opponent on a b2b. I really like the over here despite the trend outlined.
    It looks like it was pure gold from around 1998 to 2007, but has slipped a bit in more recent years:
    18 8-9-1 (-0.89, 47.1%) 199.3 season = 2006
    15 3-11-1 (-10.23, 21.4%) 199.6 season = 2007
    15 6-8-1 (-2.80, 42.9%) 193. season = 2008
    12 6-6-0 (1.25, 50.0%) 197.6 season = 2009
    14 6-7-1 (0.39, 46.2%) 202.0 season = 2010
    17 8-9-0 (-2.68, 47.1%) 193.0 season = 2011
    15 7-8-0 (-2.03, 46.7%) 198.4 season = 2012
    18 8-9-1 (2.83, 47.1%) 202.8 season = 2013

  10. #1340
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    p:margin>=25 and line>p:line and season>=2012

  11. #1341
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    AD and rest<2 and p:HW and p:dps>=15 and p:margin>=10 and season>=2006

  12. #1342
    Ronald S.
    Ronald S.'s Avatar Become A Pro!
    Join Date: 07-02-13
    Posts: 344
    Betpoints: 101

    thanks for the feeback guys. I did it again with total >199.5 and it is somewhat weaker but I think I will go with the under anyway along with SAC +7. Interestingly, Kings 1st 3 games have all gone under.

    AD and p:ADW and rest = 0 and o:rest = 1 and total > 199.5
    O/U: 36-53-4 (-1.81, 40.4%) avg total: 207.4

    and small sample size but pretty decent for 2013
    AD and p:ADW and rest = 0 and o:rest = 1 and total > 199.5 and season = 2013
    O/U: 2-8-1 (-8.09, 20.0%) avg total: 207.9

  13. #1343
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by nash13 View Post
    One of the easiest:
    HF and o:rest=0 and rest > 3

    O/U:83-48-5 (5.57, 63.4%) avg total: 196.8
    Nice on nash! Eliminate those end of the season games.

  14. #1344
    FortySix
    FortySix's Avatar Become A Pro!
    Join Date: 02-18-14
    Posts: 134
    Betpoints: 2308

    Hey fellas,

    Trying to figure out a play on the Kings @ Nugs over. 202 seems low for a Nugs home game and I think after their bad efforts against OKC the other night the Nuggets can get their offense moving in the right direction. Kings on a back to back as well, can't see them playing too much defense in the Mile High City. Does anyone have any SDQL to fit this play?

  15. #1345
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    The basis of this is fading a home fav that is poor at drawing fouls.

    H and tA(FTA)<=21 and month=11 and F and -8.5<=line<=-3 and 2002<=season and rest<4 and o:rest<3 and losses>0 and o:wins<7 and o:losses<9

  16. #1346
    Mako-SBR
    Mako-SBR's Avatar Become A Pro!
    Join Date: 10-15-13
    Posts: 492
    Betpoints: 3262

    Quote Originally Posted by pip2 View Post
    Nice one coming up tomorrow courtesy of mako himself...

    AD and p:AL and p:margin<=-13 and tA(points)>=100 and o:WP>=60 and o:rest>0
    Quote Originally Posted by FunkFreaker View Post
    Really enjoy the numbers here but what is the logic in this trend ? Really don't know if we can trust on that "tA(points)>=100" after only couple of games for Celts... they score 120 (home) and 90 (road).
    Agree Funk, this is a good scenario once teams have more games under their belts, am also not playing it yet.

    Actually I'm holding off until next Monday to start my NBA betting across the board for that same reason, the beginning of the season (and the end of the regular season for that matter) introduce too many variables for me to follow a query unless said query is specifically targeting those time frames.

    Hard to hold back, believe me, JMon and everyone else make it tough to resist!!

  17. #1347
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Sorry I didn't lay this down before, too busy. This might be worth saving for the future. To me it is interesting because today's game seems very counter intuitive. It is from a guy named Tom on the Google group and shows a decent chance the 76ers will cover vs. the Rockets...

    H and (line>10 or line<-15) and p:L and rest+p:rest+pp:rest>1 and rest<3 and playoffs=0 and p:line<=15
    Last edited by pip2; 11-03-14 at 07:18 PM.

  18. #1348
    SportsMind
    SportsMind's Avatar Become A Pro!
    Join Date: 11-03-14
    Posts: 32
    Betpoints: 213

    Really loving this thread, especially to confirm picks that you come to using other methods.

    HF and p:AD and p:margin<0 and p:fouls>25 and rest=0 and line>-6 and o:rest>0

    SU: 35-21 (2.38, 62.5%)
    ATS: 25-30-1 (-0.75, 45.5%) avg line: -3.1
    O/U: 37-18-1 (5.78, 67.3%) avg total: 195.6

    A quality team with no rest after a tough game in which they weren't expected to win, and they got into foul trouble. The next game they go home and play more loose on defense against a quality opponent who has rest.

    Feel free to criticize.
    Last edited by SportsMind; 11-04-14 at 04:31 AM.

  19. #1349
    FlyinAir
    SDQL
    FlyinAir's Avatar Become A Pro!
    Join Date: 07-14-14
    Posts: 1,612
    Betpoints: 221

    Not bad for your first post +1

  20. #1350
    SportsMind
    SportsMind's Avatar Become A Pro!
    Join Date: 11-03-14
    Posts: 32
    Betpoints: 213

    Quote Originally Posted by FlyinAir View Post
    Not bad for your first post +1
    Thanks!

    Updates to queries brought to you by Nash13. They are all similar but lead to one conclusion.

    AF and p:AFL and 1 <= rest <= 2 and season>2007

    AF and p:AFL and 1 <= rest <= 2 and season > 2007
    SU: 95-35 (6.70, 73.1%)
    ATS: 80-46-4 (1.59, 63.5%) avg line: -5.1
    O/U: 56-72-2 (-1.24, 43.8%) avg total: 197.1

    p:margin < -15 and AF and season > 2007 and total>199

    p:margin < -15 and AF and season > 2007 and total > 199
    SU: 45-14 (6.92, 76.3%)
    ATS: 42-17-0 (2.82, 71.2%) avg line: -4.1
    O/U: 29-29-1 (-0.42, 50.0%) avg total: 206.8

    AF and p:AFL and p:line >= -4 and season > 2007 and total>199

    AF and p:AFL and p:line >= -4 and season > 2007 and total > 199
    SU: 42-11 (7.74, 79.2%)
    ATS: 39-13-1 (2.91, 75.0%) avg line: -4.8
    O/U: 26-27-0 (-0.42, 49.1%) avg total: 206.6

  21. #1351
    FortySix
    FortySix's Avatar Become A Pro!
    Join Date: 02-18-14
    Posts: 134
    Betpoints: 2308

    AD and p:HWF and op:HWF and total >190

    Looking at Knicks ML

  22. #1352
    Ronald S.
    Ronald S.'s Avatar Become A Pro!
    Join Date: 07-02-13
    Posts: 344
    Betpoints: 101

    An interesting one I came across yesterday. No games fit this today but I like the underlying theory behind it... that b2b on the road maybe aren't so important early in the season. (Or at least, the books put more emphasis on it than it really is)

    AD and p:AD and rest = 0 and o:rest > 0 and month = 11 and line < 4

    SU: 32-17 (1.31, 65.3%)
    ATS: 37-12-0 (3.71, 75.5%) avg line: 2.4

    Interestingly though, you would expect it to fall off as the season progresses which it did in December:
    AD and p:AD and rest = 0 and o:rest > 0 and month = 12 and line < 4
    SU: 25-25 (-2.16, 50.0%)
    ATS: 28-22-0 (0.57, 56.0%) avg line: 2.7
    O/U: 21-28-1 (-3.06, 42.9%) avg total: 193.4

    But the ATS record for January is phenomenal!
    AD and p:AD and rest = 0 and o:rest > 0 and month = 1 and line < 4
    SU: 35-24 (1.95, 59.3%)
    ATS: 39-19-1 (4.23, 67.2%) avg line: 2.3
    O/U: 35-24-0 (4.96, 59.3%) avg total: 194.6
    February on and it was pretty much 50/50
    Last edited by Ronald S.; 11-04-14 at 07:03 AM.

  23. #1353
    Ronald S.
    Ronald S.'s Avatar Become A Pro!
    Join Date: 07-02-13
    Posts: 344
    Betpoints: 101

    And I just ran it again with no stipulations on the previous game and it follows the same trend as before! Phenomenal in November, and a slight uptick in January. Anyone have an idea why this is the case?

    AD and rest = 0 and o:rest > 0 and month = 11 and line < 4
    SU: 81-60 (-0.09, 57.4%)
    ATS: 93-46-2 (2.35, 66.9%) avg line: 2.4
    O/U: 69-67-5 (0.17, 50.7%) avg total: 194.0

    AD and rest = 0 and o:rest > 0 and month = 12 and line < 4
    SU: 56-78 (-2.53, 41.8%)
    ATS: 67-66-1 (0.06, 50.4%) avg line: 2.6
    O/U: 65-67-2 (-1.02, 49.2%) avg total: 194.1

    AD and rest = 0 and o:rest > 0 and month = 1 and line < 4
    SU: 73-83 (0.04, 46.8%)
    ATS: 85-67-4 (2.38, 55.9%) avg line: 2.3
    O/U: 87-68-1 (3.06, 56.1%) avg total: 194.0

    Needless to say, be on the lookout for short road dogs on a b2b in November. Tremendous value not just ATS but on the moneyline too!

  24. #1354
    Ronald S.
    Ronald S.'s Avatar Become A Pro!
    Join Date: 07-02-13
    Posts: 344
    Betpoints: 101

    One last thing on this trend... It is stronger when the previous game was also on the road, especially on the moneyline!

    AD and p:A and rest = 0 and o:rest > 0 and month = 11 and line < 4
    SU: 50-31 (0.38, 61.7%)
    ATS: 57-24-0 (2.78, 70.4%) avg line: 2.4

    AD and p:H and rest = 0 and o:rest > 0 and month = 11 and line < 4
    SU: 31-29 (-0.72, 51.7%)
    ATS: 36-22-2 (1.76, 62.1%) avg line: 2.5

  25. #1355
    Ronald S.
    Ronald S.'s Avatar Become A Pro!
    Join Date: 07-02-13
    Posts: 344
    Betpoints: 101

    Quote Originally Posted by FortySix View Post
    AD and p:HWF and op:HWF and total >190

    Looking at Knicks ML
    Not crazy about this one... Those include big underdogs too.

    AD and p:HWF and op:HWF and total >190 and line<4
    SU: 63-84 (-1.30, 42.9%)

    AD and p:HWF and op:HWF and total >190 and line<3
    SU: 36-40 (-0.41, 47.4%)

    Specifying line at 1 or 1.5 actually favors washington though small sample size.
    AD and p:HWF and op:HWF and total > 190 and line<2
    SU: 14-8 (1.00, 63.6%)

  26. #1356
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    This is one from a person named Samantha on the Google group, showing the Suns covering vs Lakers:

    AF and p:AL and p:steals < op:steals and p:rebounds < op:rebounds and season > 2008

  27. #1357
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by SportsMind View Post
    Really loving this thread, especially to confirm picks that you come to using other methods.

    HF and p:AD and p:margin<0 and p:fouls>25 and rest=0 and line>-6 and o:rest>0

    SU: 35-21 (2.38, 62.5%)
    ATS: 25-30-1 (-0.75, 45.5%) avg line: -3.1
    O/U: 37-18-1 (5.78, 67.3%) avg total: 195.6

    A quality team with no rest after a tough game in which they weren't expected to win, and they got into foul trouble. The next game they go home and play more loose on defense against a quality opponent who has rest.

    Feel free to criticize.
    Thanks, that looks great!

  28. #1358
    dmitean
    dmitean's Avatar Become A Pro!
    Join Date: 03-30-11
    Posts: 364
    Betpoints: 3106

    Quote Originally Posted by Ronald S. View Post
    And I just ran it again with no stipulations on the previous game and it follows the same trend as before! Phenomenal in November, and a slight uptick in January. Anyone have an idea why this is the case?
    Actually I think it makes a lot of sense and I was using similar logic, without running the numbers.

    The logic is simple. Public/ bookies always add a point or sometimes even two in B2B spots. But, in the beginning of the season, when the teams are still fresh, B2B has zero impact or at least very close to zero and shouldn't be part of the formula. On the other hand, in December/ January, fatigue starts to kick in and then, the numbers on the success rate go down...

  29. #1359
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    Can someone provide guidance on how I would be able to find the google group? Thanks.

  30. #1360
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by FortySix View Post
    AD and p:HWF and op:HWF and total >190

    Looking at Knicks ML
    Gees, the moneyline is -120, and you have a 600+ sample size giving NY a 71% to win straight up. That really does look inviting.

  31. #1361
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    the sportsdatabase forum on groups . google . com,

  32. #1362
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by hyahya View Post
    Can someone provide guidance on how I would be able to find the google group? Thanks.
    or from the killersports page there is a link at the bottom.

  33. #1363
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    Quote Originally Posted by pip2 View Post
    the sportsdatabase forum on groups . google . com,
    Thanks Pip2.

  34. #1364
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by Ronald S. View Post
    Not crazy about this one... Those include big underdogs too.

    AD and p:HWF and op:HWF and total >190 and line<4
    SU: 63-84 (-1.30, 42.9%)

    AD and p:HWF and op:HWF and total >190 and line<3
    SU: 36-40 (-0.41, 47.4%)

    Specifying line at 1 or 1.5 actually favors washington though small sample size.
    AD and p:HWF and op:HWF and total > 190 and line<2
    SU: 14-8 (1.00, 63.6%)
    Heh! Nice catch Ronald. I should have read it 10 minutes earlier!

  35. #1365
    Ronald S.
    Ronald S.'s Avatar Become A Pro!
    Join Date: 07-02-13
    Posts: 344
    Betpoints: 101

    Quote Originally Posted by dmitean View Post
    Actually I think it makes a lot of sense and I was using similar logic, without running the numbers.

    The logic is simple. Public/ bookies always add a point or sometimes even two in B2B spots. But, in the beginning of the season, when the teams are still fresh, B2B has zero impact or at least very close to zero and shouldn't be part of the formula. On the other hand, in December/ January, fatigue starts to kick in and then, the numbers on the success rate go down...
    Yep I said something similar in the post right before it but what I was wondering though was why it picked back up in january as opposed to continuing to fade like it did in december... (AD and p:AD was 39-19-1 in January though just AD was a bit more modest at 85-67-4 but still better than December)

First ... 36373839404142 ... Last
Top