NBA Stituational Bet, SDQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JMon
    SBR Hall of Famer
    • 12-11-09
    • 9800

    #1506
    OKC/SAC - favoring SAC

    Here we want to fade a bad home team that is outscored by nine or more on the season; against an oppt that has give up 100 or more three straight.. Note line parameter can be removed (wanted to show short line) as well as rest parameters added. Permission to add to google doc if wanted.

    SDQL
    H and -3<=line<=3 and tA(points-ooints)<=-9 and opooints>=100 and oppooints>=100 and opppooints>=100
    Comment
    • nash13
      SBR MVP
      • 01-21-14
      • 1122

      #1507
      I can repeat again. If anyone is not ok with that document, I can delete it. Don't want to be disrespectful to the hard work of others. I finished transferring the MLB trends i had. If there are more or less to do, please let me know. If anyone like to contribute, join.
      Comment
      • Consigliere
        SBR High Roller
        • 02-10-13
        • 126

        #1508
        Originally posted by JMon
        OKC/SAC - favoring SAC

        Here we want to fade a bad home team that is outscored by nine or more on the season; against an oppt that has give up 100 or more three straight.. Note line parameter can be removed (wanted to show short line) as well as rest parameters added. Permission to add to google doc if wanted.

        SDQL
        H and -3<=line<=3 and tA(points-ooints)<=-9 and opooints>=100 and oppooints>=100 and opppooints>=100
        Looks good...I am on it
        Comment
        • Consigliere
          SBR High Roller
          • 02-10-13
          • 126

          #1509
          Originally posted by nash13
          I can repeat again. If anyone is not ok with that document, I can delete it. Don't want to be disrespectful to the hard work of others. I finished transferring the MLB trends i had. If there are more or less to do, please let me know. If anyone like to contribute, join.
          I will ill put everything I have in tomorrow.
          Comment
          • nash13
            SBR MVP
            • 01-21-14
            • 1122

            #1510
            Originally posted by Consigliere
            I will ill put everything I have in tomorrow.
            No hurry. I just want to check if everyone is ok with it.
            If you need access, PM me your mailers please.
            Comment
            • Ronald S.
              SBR Sharp
              • 07-02-13
              • 344

              #1511
              Warriors +1

              Warriors look like a possible play today using the trend I posted earlier about short road dogs on a b2b in November. You might want to watch the lines however as right now they are +1 but they could be a favorite by tip off. I think I will play it regardless as I really like the way this golden state team has looked so far this year


              51-31 (0.59, 62.2%)
              58-24-0 (2.98, 70.7%) avg line: 2.4
              36-41-5 (-1.38, 46.8%) avg total: 194.1
              23-14 (-0.59, 62.2%)
              26-11-0 (1.82, 70.3%) avg line: 2.4
              15-19-3 (0.09, 44.1%) avg total: 192.4
              Comment
              • Ronald S.
                SBR Sharp
                • 07-02-13
                • 344

                #1512
                Originally posted by SportsMind
                I was bored and attempting to come up with the best query (even if I have to narrow it down). Focusing on football tomorrow but I can't wait to get to work on the NBA. The following is bizarre, especially considering the other months are "normal". Perhaps something is behind it and we will get a play this season. It looks like 10 opps. each year in 2012 and 2013.

                A and p:W and pp:W and ppp:W and pppp:W and ppppp:W and rest = 0 and season > 2008 and line > -8.5 and ...
                19 1-17-1 (-5.61, 5.6%) -0.3 12-7-0 (6.03, 63.2%) 198.3 6-13 (-5.32, 31.6%) month = 12
                22 1-20-1 (-8.30, 4.8%) -0.1 8-12-2 (-5.86, 40.0%) 194.9 3-19 (-8.23, 13.6%) month = 1
                Wow. Really good stuff! So 2-37-2 in December and January since 2009... Even removing the line parameter gave 3-18-1 in December and 2-20-1 in January... I think I would have to play any games that fall under this trend just on principle!
                Last edited by Ronald S.; 11-09-14, 12:47 PM.
                Comment
                • pip2
                  SBR Wise Guy
                  • 10-21-12
                  • 543

                  #1513
                  Originally posted by SportsMind
                  I was bored and attempting to come up with the best query (even if I have to narrow it down). Focusing on football tomorrow but I can't wait to get to work on the NBA. The following is bizarre, especially considering the other months are "normal". Perhaps something is behind it and we will get a play this season. It looks like 10 opps. each year in 2012 and 2013.

                  A and p:W and pp:W and ppp:W and pppp:W and ppppp:W and rest = 0 and season > 2008 and line > -8.5 and ...
                  19 1-17-1 (-5.61, 5.6%) -0.3 12-7-0 (6.03, 63.2%) 198.3 6-13 (-5.32, 31.6%) month = 12
                  22 1-20-1 (-8.30, 4.8%) -0.1 8-12-2 (-5.86, 40.0%) 194.9 3-19 (-8.23, 13.6%) month = 1
                  That's pretty slick! Put together, it looks like an easy 7 or 8 units over two months:
                  A and p:W and pp:W and ppp:W and pppp:W and ppppp:W and rest = 0 and season > 2008 and (month = 1 or month =12) and line > -8.5

                  Thanks sportsmind!
                  Comment
                  • dmitean
                    SBR Sharp
                    • 03-30-11
                    • 364

                    #1514
                    Originally posted by nash13
                    I set up a spreadsheet, please shoot me a PM and i will give you rights to edit.

                    https://docs.google.com/spreadsheets...it?usp=sharing
                    As I understand, it's just a collection of all queries combined in one file. It won't allow us to see which ones will apply daily, correct?
                    We will have to go through each query daily to see if it fits, right?
                    Comment
                    • JMon
                      SBR Hall of Famer
                      • 12-11-09
                      • 9800

                      #1515
                      Originally posted by Ronald S.
                      Warriors look like a possible play today using the trend I posted earlier about short road dogs on a b2b in November. You might want to watch the lines however as right now they are +1 but they could be a favorite by tip off. I think I will play it regardless as I really like the way this golden state team has looked so far this year


                      51-31 (0.59, 62.2%)
                      58-24-0 (2.98, 70.7%) avg line: 2.4
                      36-41-5 (-1.38, 46.8%) avg total: 194.1
                      23-14 (-0.59, 62.2%)
                      26-11-0 (1.82, 70.3%) avg line: 2.4
                      15-19-3 (0.09, 44.1%) avg total: 192.4
                      I'll play it with you!
                      Comment
                      • dmitean
                        SBR Sharp
                        • 03-30-11
                        • 364

                        #1516
                        I think it's very hard to fit what is going on in Oklahoma in any trend.
                        A contender, that plays without half the roster and two of their star players, still need to get wins.
                        Wouldn't go near it as far as trends go.

                        I would try Under and Oklahoma here to be honest, regardless of the trends.
                        Comment
                        • pip2
                          SBR Wise Guy
                          • 10-21-12
                          • 543

                          #1517
                          Originally posted by Ronald S.
                          Wow. Really good stuff! So 2-37-2 in December and January since 2009... Even removing the line parameter gave 3-18-1 in December and 2-20-1 in January... I think I would have to play any games that fall under this trend just on principle!
                          Ronald, I wish you luck on this. Here is the reason I am not tailing you: I took the rest parameters out because its still early in the season and I wanted to get some sample size back to play with, and then I added in the stipulation that the previous win was a big win vs a team with a very strong record:

                          AD and p:A and month = 11 and line < 4 and po:WP>80

                          The ATS for that is 24-26, I think.

                          Who knows? Good luck and let's see what happens...
                          Last edited by pip2; 11-09-14, 02:21 PM.
                          Comment
                          • nash13
                            SBR MVP
                            • 01-21-14
                            • 1122

                            #1518
                            Originally posted by dmitean
                            As I understand, it's just a collection of all queries combined in one file. It won't allow us to see which ones will apply daily, correct?
                            We will have to go through each query daily to see if it fits, right?
                            yes the decision is still your own, otherwise you can use the very good service of killersports. for MLB, NFL and NBA you can store queries and they will pop up when they are active.
                            Comment
                            • pip2
                              SBR Wise Guy
                              • 10-21-12
                              • 543

                              #1519
                              Here are the 4 that popped up for me today:

                              jmon showing that den covers vs por -- ATS: 97-49-2 (3.32, 66.4%) only 52% for game number < 10
                              A and tA(ooints)>=103 and p:M2<=-10 and pp:M2<=-10

                              from hiyahya showing U in mia vs dal 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

                              jmon orl covers vs bkn and mia covers vs dal ATS:14-36-0 (-5.22, 28.0%)
                              H and tA(FTA)<=21 and month=11 and F and -8.5<=line<=-3 and 2008<=season and rest<4 and o:rest<3 and losses>0 and o:wins<7 and o:losses<9

                              from Ronald showing gs covers vs phx ATS:58-24-0 (2.98, 70.7%)
                              AD and p:A and rest = 0 and o:rest>0 and month = 11 and line < 4
                              Last edited by pip2; 11-09-14, 06:15 PM. Reason: reversed the orl/bkn result
                              Comment
                              • nash13
                                SBR MVP
                                • 01-21-14
                                • 1122

                                #1520
                                NHL, NBA, MLB, NCAAB and NCAAF is complete from my side. These are not all mine, these are the ones i collected from here, google groups and some are my own. I can not remember who contributed each one of them, so if you know or want to edit, join me.
                                Comment
                                • FlyinAir
                                  SBR MVP
                                  • 07-14-14
                                  • 1612

                                  #1521
                                  Originally posted by nash13
                                  NHL, NBA, MLB, NCAAB and NCAAF is complete from my side. These are not all mine, these are the ones i collected from here, google groups and some are my own. I can not remember who contributed each one of them, so if you know or want to edit, join me.

                                  I've been backtracking every single code posted on this thread starting from page 1, I'm on 22 or something like that now.
                                  Comment
                                  • JMon
                                    SBR Hall of Famer
                                    • 12-11-09
                                    • 9800

                                    #1522
                                    Originally posted by nash13
                                    I can repeat again. If anyone is not ok with that document, I can delete it. Don't want to be disrespectful to the hard work of others. I finished transferring the MLB trends i had. If there are more or less to do, please let me know. If anyone like to contribute, join.
                                    You have a good thing...I would have it...contributors see only and if contributors don't contribute they get booted. A lot of piggy backers reaping the benefits off the hard work we do. Simply saying, they have no desire to learn, just copy and paste. Just my thoughts. No different than what we have here, but at least they have to work for it.

                                    I wanted to see, other than a collection of data, but an organization of queries for the days card- simply as that.
                                    Last edited by JMon; 11-09-14, 06:12 PM.
                                    Comment
                                    • FortySix
                                      SBR High Roller
                                      • 02-18-14
                                      • 134

                                      #1523
                                      I like this play going against the Heat

                                      AD and line>7 and rest=0 and p: points>100 and op: points>100 and p:HFW and total >203
                                      Comment
                                      • JMon
                                        SBR Hall of Famer
                                        • 12-11-09
                                        • 9800

                                        #1524
                                        Originally posted by FortySix
                                        I like this play going against the Heat

                                        AD and line>7 and rest=0 and p: points>100 and op: points>100 and p:HFW and total >203
                                        Nice one 46....

                                        Keep in mind there is no need for spaces (anymore) if you do the editing...I showed you how!
                                        Comment
                                        • nash13
                                          SBR MVP
                                          • 01-21-14
                                          • 1122

                                          #1525
                                          Originally posted by JMon
                                          You have a good thing...I would have it...contributors see only and if contributors don't contribute they get booted. A lot of piggy backers reaping the benefits off the hard work we do. Simply saying, they have no desire to learn, just copy and paste. Just my thoughts. No different than what we have here, but at least they have to work for it.

                                          I wanted to see, other than a collection of data, but an organization of queries for the days card- simply as that.
                                          I can see that. And I am thinking about closing the spreadsheet for now, because the argument is valid. Contribution is not only about sharing and searching for queries. It is about productive discussion and a process of working together. It's not like wanting money for that, just dedication. I guess I will switch the spreadsheet.
                                          Comment
                                          • nash13
                                            SBR MVP
                                            • 01-21-14
                                            • 1122

                                            #1526
                                            Spreadsheet is locked, I will give access to people who are willing to contribute.
                                            I guess like this it is fair to people like JMon, Mako, EMC and others.
                                            Comment
                                            • JMon
                                              SBR Hall of Famer
                                              • 12-11-09
                                              • 9800

                                              #1527
                                              Originally posted by nash13
                                              Spreadsheet is locked, I will give access to people who are willing to contribute.
                                              I guess like this it is fair to people like JMon, Mako, EMC and others.
                                              Your contributors will sign up! (there are a bunch of them in these thread that are good).. Let's get something on the daily card....every day!
                                              Last edited by JMon; 11-09-14, 08:48 PM.
                                              Comment
                                              • pip2
                                                SBR Wise Guy
                                                • 10-21-12
                                                • 543

                                                #1528
                                                Originally posted by pip2
                                                Here are the 4 that popped up for me today:

                                                jmon showing that den covers vs por -- ATS: 97-49-2 (3.32, 66.4%) only 52% for game number < 10
                                                A and tA(ooints)>=103 and p:M2<=-10 and pp:M2<=-10

                                                from hiyahya showing U in mia vs dal 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

                                                jmon orl covers vs bkn and mia covers vs dal ATS:14-36-0 (-5.22, 28.0%)
                                                H and tA(FTA)<=21 and month=11 and F and -8.5<=line<=-3 and 2008<=season and rest<4 and o:rest<3 and losses>0 and o:wins<7 and o:losses<9

                                                from Ronald showing gs covers vs phx ATS:58-24-0 (2.98, 70.7%)
                                                AD and p:A and rest = 0 and o:rest>0 and month = 11 and line < 4
                                                den vs por loss
                                                U mia/dal win
                                                orl vs bkn win
                                                mia vs dal win
                                                gs vs phx loss

                                                I played jmon's 2-game query and hiyahya's, and would have been 3-0 except I transposed orl and bkn somewhere along the line. Still 2-1 is nice compared to the last 3 or 4 days for me!
                                                Last edited by pip2; 11-10-14, 12:14 AM.
                                                Comment
                                                • hyahya
                                                  SBR High Roller
                                                  • 03-08-14
                                                  • 165

                                                  #1529
                                                  P:game number=game number - 1 and H and P:ALDO and season>2007 and game number<30

                                                  Tried to work off the first term but nothing really compelling. The more interesting result involves the playoffs:

                                                  P:game number=game number - 1 and H and P:ALDU and season>2007 and playoffs=1
                                                  Comment
                                                  • FlyinAir
                                                    SBR MVP
                                                    • 07-14-14
                                                    • 1612

                                                    #1530
                                                    Worth the read..

                                                    Luis Scola is 23-5 life time when coming off a game scoring less than 6.5 points, then playing at home vs opp under 50 wp
                                                    Roy Hibbert is 20-8 life time when coming off a game scoring less than 6.5 points, then playing at home vs opp under 50 wp

                                                    Scola and Hibbert play for the same team

                                                    Roy Hibbert : p : points<6.5 and H and o:WP<50
                                                    Comment
                                                    • FortySix
                                                      SBR High Roller
                                                      • 02-18-14
                                                      • 134

                                                      #1531
                                                      For the over in Hawks @ Knicks

                                                      team=Hawks and points>100 and ppoints>100 and opoints<100 and total>194 and season>2011
                                                      Comment
                                                      • FlyinAir
                                                        SBR MVP
                                                        • 07-14-14
                                                        • 1612

                                                        #1532
                                                        Also came up with,

                                                        A reason take a look at Atlanta over Knicks
                                                        HD and WP < 50 and pppp:H and ppp:AL and pp:AL and p:AL and H and P: points < 100 and Po: points > 100
                                                        P:L and P:margin < 5 and p:L and pp:L and ppp:L and HD and season >2011

                                                        Showing Melo coming off b2b 19+pts games playing as a dog (add HD)
                                                        Carmelo Anthony: p : points>18.5 and pp:L and p: points>18.5 and p:L and D and season > 2011

                                                        Is Pop resting his players vs lac? (You can put rest>0.5 too)
                                                        team=Spurs and A and rest=1 and o:team=Clippers and o:rest=1
                                                        Comment
                                                        • FortySix
                                                          SBR High Roller
                                                          • 02-18-14
                                                          • 134

                                                          #1533
                                                          Pelicans ATS vs the Cavs

                                                          AD and line<7 and p:AW and op:AW and total>200 and points>98 and opoints>105
                                                          Comment
                                                          • nash13
                                                            SBR MVP
                                                            • 01-21-14
                                                            • 1122

                                                            #1534
                                                            For all the regular guys around here, I finished uploading all the queries I got. If you are interested in posting yours or checking crosswise or just want to take a look, write me a PM with your Mailadress to get connection to.
                                                            Comment
                                                            • nash13
                                                              SBR MVP
                                                              • 01-21-14
                                                              • 1122

                                                              #1535
                                                              I select the games for the plays card from the queries I got right now.
                                                              1 trend active (NBA39*) on the Spurs/Clippers game.
                                                              1 trend active (NBA67*) on the Pelicans/Cavaliers game
                                                              If you want to add your plays and trends, join the spreadsheet
                                                              Last edited by nash13; 11-10-14, 09:06 AM.
                                                              Comment
                                                              • nash13
                                                                SBR MVP
                                                                • 01-21-14
                                                                • 1122

                                                                #1536
                                                                To sum it up 4 active trends on NBA
                                                                NBA39
                                                                NBA67
                                                                NBA57
                                                                NBA66
                                                                And 4 active trends on NHL in the spreadsheet.

                                                                NHL25
                                                                NHL33
                                                                NHL42
                                                                NHL63
                                                                No contradictions so far.
                                                                Comment
                                                                • nash13
                                                                  SBR MVP
                                                                  • 01-21-14
                                                                  • 1122

                                                                  #1537
                                                                  To give some information, the trends i gathered are mostly League Wide general trends, no team trends at all.
                                                                  Comment
                                                                  • hyahya
                                                                    SBR High Roller
                                                                    • 03-08-14
                                                                    • 165

                                                                    #1538
                                                                    Great work Nash. FYI, I believe NBA57 and NBA66 are the same query.
                                                                    Comment
                                                                    • pip2
                                                                      SBR Wise Guy
                                                                      • 10-21-12
                                                                      • 543

                                                                      #1539
                                                                      OK, this is what I have on the menu today....

                                                                      from jmon sa cover vs lac ATS: 12-44-2 (-5.59, 21.4%) P:L and Pooints >= 110 and op:FL and op:division = opo:division and 2009 <= season

                                                                      zeeman21 ATS: 308-228-9 (0.71, 57.5%) showing atl covers vs ny site=away and line < 0 and 0 < p:margin and p:streak<=-2 and 19951030 <= date

                                                                      from Ronald in sitpost #1404 ATS: 63-41-2 (2.69, 60.6%) sa covers vx lac -- works better 2nd half of season -- A and p:L and total>=200 and p:margin>-4 and opoints>100 and oppoints>100 and opppoints>100

                                                                      ut covers vs ind from Ronald in sitpost #1389 ATS: 37-12-0 (3.71, 75.5%) AD and p:AD and rest = 0 and o:rest > 0 and month = 11 and line < 4

                                                                      ny covers vs atl from Ronald in sitpost #1472 -- ATS:71-40-2 (2.42, 64.0%) HD and rest = 1 and p:rest = 0 and p:A and pp:A and season >= 2009
                                                                      Last edited by pip2; 11-10-14, 09:51 AM.
                                                                      Comment
                                                                      • nash13
                                                                        SBR MVP
                                                                        • 01-21-14
                                                                        • 1122

                                                                        #1540
                                                                        Ok I will take a look.
                                                                        Comment
                                                                        SBR Contests
                                                                        Collapse
                                                                        Top-Rated US Sportsbooks
                                                                        Collapse
                                                                        Working...