2016 SDQL Plays

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bking79
    SBR Sharp
    • 04-17-15
    • 341

    #561
    alex can you look up Arizona
    Comment
    • Alex Vaile
      SBR MVP
      • 04-19-14
      • 3724

      #562
      Originally posted by bking79
      alex can you look up Arizona
      Sorry just saw this. Had a good solid query for under in this game.

      p:L and p:hits>7.5 and op:SO>5 and D and season>=2015 and o:STDSERA>4.05 and total>7.5

      And

      tA(doubles, N=10) < 1.9 and 8.9 < tA(hits, N=10) < 10.4 and .5 < tA(HR, N=10) < 1.3 and 1 < oA(doubles, N=10) < 1.7 and oA(hits, N=10) < 9.9 and oA(HR, N=10) < 1.1 and SG < 4 and 5 > SGS > 2 and p:HR < 3 and p:hits < 15 and 18 > pp:hits > 4 and 3 < ppp:hits < 16 and 3 < pppp:hits < 13 and ppppp:hits < 15 and pppppp:hits < 15 and ppppppp:hits > 6 and op:hits < 13 and s:SRA < 7 and s:SHRA < 2 and os:SRA < 8 and os:SPT < 122

      ROI 36% under damn wish I saw this I also have this pointing to over but small sample

      team = Padres and A and p: D and po:runs>=7 and date >= 20150731

      12/4 o/u in this spot
      Comment
      • Alex Vaile
        SBR MVP
        • 04-19-14
        • 3724

        #563
        Play Marlins +124

        team=Marlins and AD and p:L and pp:L and season>2014

        13-13 SU including 8-2 last 10 opportunities

        team=Braves and HF and p:W and pp:W and season>2014

        4-3 SU this spot.

        starter=Tom Koehler and AD and o:team=Braves

        1-3 SU but the 1 win was against Teheran
        Comment
        • Alex Vaile
          SBR MVP
          • 04-19-14
          • 3724

          #564
          Play Mets + 215

          team=Dodgers and line<=-140 and p:AD and po:BL=0 and p:W and date>=20090601

          Dodgers 0/9 SU in this spot
          Comment
          • Alex Vaile
            SBR MVP
            • 04-19-14
            • 3724

            #565
            Today's results: 6-4 + 2.11 units
            Season to date: 161-133-3 + 24.71 units

            Winners: Giants ML and RL, Angels over, Marlins ML, Royals ML and Brewers

            Losers: Marlins under, Orioles under, Mets and Pirates
            Comment
            • Alex Vaile
              SBR MVP
              • 04-19-14
              • 3724

              #566
              Monday:

              Play Over 8.5 -110 Yankees vs Blue Jays
              Play Over 8 + 100 Dodgers vs Cubs

              AD and tS(o:hits-starter hits + o:walks - starter walks) / tS(9-starter innings pitched) <= 1.15 and line <= 150 and month < 9 and rest < 2 and date>=20160509

              30/5 o/u in this spot
              Comment
              • Alex Vaile
                SBR MVP
                • 04-19-14
                • 3724

                #567
                Play Mets + 115

                team=White Sox and SG=1 and A and p:F and o:STDSERA>4 and date>=20120716

                White Sox 2-12 in this spot
                Comment
                • Alex Vaile
                  SBR MVP
                  • 04-19-14
                  • 3724

                  #568
                  Play Padres + 188

                  team=Padres and SG=1 and p:AD and po:SF and date>=20140912

                  Pads 12-3 SU in this spot
                  Comment
                  • Alex Vaile
                    SBR MVP
                    • 04-19-14
                    • 3724

                    #569
                    Play Royals -110
                    Play Yankees + 128

                    p:HL and p:hits > po:hits and 125 > line >= -160 and SG = 1 and rest = 0 and o:rest = 0 and 9 >= total >= 6.5

                    ROI 28%
                    Comment
                    • Alex Vaile
                      SBR MVP
                      • 04-19-14
                      • 3724

                      #570
                      Play Over 9.5 -105 Pirates vs Marlins

                      p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < ou streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

                      ROI 18% 900 game sample

                      And

                      team=Pirates and SG=1 and A and p:walks<=1 and
                      date>=20130705

                      Pirates 12/0/1 o/u in this spot
                      Comment
                      • Alex Vaile
                        SBR MVP
                        • 04-19-14
                        • 3724

                        #571
                        Play Reds +139

                        p:L and p:hits>7.5 and op:SO>5 and D and season>=2015 and o:STDSERA>4.05 and total>7.5

                        ROI 7%

                        And

                        team=Rockies and SG=1 and p:margin<=-5 and
                        date>=20130927

                        Rockies 0-13 SU in this spot
                        Comment
                        • Alex Vaile
                          SBR MVP
                          • 04-19-14
                          • 3724

                          #572
                          Play Twins vs Athletics Over 8.5 -120

                          team=Twins and D and 6<=o:starter rest<=7 and 20160415<=date

                          Twins 9/0 o/u in this spot
                          Comment
                          • lanyard90
                            SBR Rookie
                            • 05-30-16
                            • 26

                            #573
                            hey man, I would PM but I have to make 40 posts..lol anyway I was wondering how you learned how to use SDQL? I've been using it somewhat but I don't know exactly how to use it myself I just use some preset ones.
                            Comment
                            • Alex Vaile
                              SBR MVP
                              • 04-19-14
                              • 3724

                              #574
                              Originally posted by lanyard90
                              hey man, I would PM but I have to make 40 posts..lol anyway I was wondering how you learned how to use SDQL? I've been using it somewhat but I don't know exactly how to use it myself I just use some preset ones.
                              I learned by just watching what others were posting a few years back then I began researching some of what Dr. ED meyer has put out. I just began tinkering a little with simple situations gleaned from boxscores. All the parameters are then entered at another site. Check out the threads from the last couple years.
                              Comment
                              • lanyard90
                                SBR Rookie
                                • 05-30-16
                                • 26

                                #575
                                Alright thanks man, i'll be checking your thread often now, I just found it
                                Comment
                                • lanyard90
                                  SBR Rookie
                                  • 05-30-16
                                  • 26

                                  #576
                                  Also, do you know if you can use SDQL to find trends for Team Totals?
                                  Comment
                                  • Alex Vaile
                                    SBR MVP
                                    • 04-19-14
                                    • 3724

                                    #577
                                    Play Rangers + 155

                                    AD and (SG = 1 or SG = 3) and playoffs = 0 and streak > -4 and -8 < o:streak < 6 and -7 < p:margin < 10 and -10 < op:margin < 9 and p:runs < 13 and op:runs != 0 and p:hits > 1 and 3 < op:hits < 15 and op:doubles < 6 and p:triples < 3 and op:triples < 2 and p:SO > 3 and 2 < op:SO < 17 and 3 < p:ground balls < 21 and 2 < op:ground balls < 24 and p:fly balls < 16 and 2 < op:fly balls < 16 and op:BPRA < 9 and 1.5 < p:SIP < 8.1 and 1.9 < op:SIP < 8.5 and 33 < p:SPT < 116 and 48 < op:SPT < 111 and op:SHF < 34 and 27 < p:batters faced < 46 and 28 < op:batters faced < 57 and p:at bats + p:walks < 48 and op:at bats + op:walks < 46 and 0 < p:TLOB < 12 and 0 < op:TLOB < 13 and (14 > site streak > 5 or -1 > site streak > -12) and (1 < o:site streak < 10 or -11 < o:site streak < -5) and (conference = AL or o:conference = NL) and op:RMAX < 8 and op:R1 < 5 and op:R2 < 4 and op:R3 < 3 and p:errors < 3 and op:errors < 4 and os:SHA < 12 and os:SRA < 7 and 0 < os:SWA < 5 and s:SPT > 83 and starter rest < 12 and s:SIP > 4.9 and s:SHF > 21 and s:SSO < 10 and op:BL < 8 and 2 < p:PU < 7 and -39 < tS(margin, N=10) - oS(margin, N=10) < 32 and oS(HR, N=10) > 4 and 3 < tS(HR, N=10) < 19 and oS(doubles, N=10) < 29 and tS(hits, N=10) > 63 and 65 < oS(hits, N=10) < 105 and line < 225 and day != Sunday and oss:SHA < 11 and oss:SHRA < 3 and game number > 24 and tS(margin, N=20) - oS(margin, N=20) < 43 and tS(hits, N=20) - oS(hits, N=20) < 27

                                    ROI 41 500 game sample

                                    And

                                    starter rest - o:starter rest = 1 and (A or day != Monday) and (H or day != Friday) and 4 < starter rest < 11 and -2 < p:margin < 9 and -11 < op:margin < 8 and -10 < streak < 3 and -10 < o:streak < 6 and site streak < 8 and o:site streak < 8 and -29 < tS(margin, N=10) < 24 and -13 < oS(margin, N=10) < 15 and 15 < tS(hits, N=3) < 36 and tS(HR, N=10) < 14 and 18 < oS(hits, N=3) < 36 and 4 < oS(HR, N=10) < 17 and os:SSO < 10 and os:SWA < 5 and oS(margin, N=10) - tS(margin, N=10) > -15 and tS(hits, N=10) - oS(hits, N=10) > -23 and (game number > 139 or game number < 122)

                                    ROI 22% 700 game sample
                                    Comment
                                    • Alex Vaile
                                      SBR MVP
                                      • 04-19-14
                                      • 3724

                                      #578
                                      Originally posted by lanyard90
                                      Also, do you know if you can use SDQL to find trends for Team Totals?
                                      No i don't think so
                                      Comment
                                      • lanyard90
                                        SBR Rookie
                                        • 05-30-16
                                        • 26

                                        #579
                                        Originally posted by Alex Vaile
                                        No i don't think so

                                        alright thanks brother...& also thanks for posting the query text itself... its helpful.
                                        Comment
                                        • tecmoslayer
                                          SBR Wise Guy
                                          • 09-07-14
                                          • 528

                                          #580
                                          I am now 0-4 following your plays this season. Your system needs work.
                                          Originally posted by Alex Vaile
                                          Play Twins vs Athletics Over 8.5 -120

                                          team=Twins and D and 6<=o:starter rest<=7 and 20160415<=date

                                          Twins 9/0 o/u in this spot
                                          Comment
                                          • bking79
                                            SBR Sharp
                                            • 04-17-15
                                            • 341

                                            #581
                                            alex good one on rangers im 2-0 with boston an Oakland
                                            Comment
                                            • Alex Vaile
                                              SBR MVP
                                              • 04-19-14
                                              • 3724

                                              #582
                                              Originally posted by tecmoslayer
                                              I am now 0-4 following your plays this season. Your system needs work.
                                              Buddy you keep saying that. Look back at my plays. I don't claim to win them all but have been doing decent lately. Play them all or don't complain if one loses that you played. Up 25 units u should b able to find a winner. Did you play the Mets, Rangers or Reds? Didn't hear you complain about those.
                                              Comment
                                              • Alex Vaile
                                                SBR MVP
                                                • 04-19-14
                                                • 3724

                                                #583
                                                Play Angels - 105

                                                s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8

                                                ROI 25%

                                                And

                                                (s:SRA + ss:SRA)=3 and A and (month= 5 or month =7) and os:SRA<6 and oss:SRA>2 and line>-184

                                                ROI 15%
                                                Comment
                                                • Alex Vaile
                                                  SBR MVP
                                                  • 04-19-14
                                                  • 3724

                                                  #584
                                                  Today's results: 6-5 + 1.79 units
                                                  Season to date: 167-138-3 + 26.5 units

                                                  Winners: Pirates over, Angels, Rangers, Mets, Reds, Royals

                                                  Losers: Athletics over, Jays Over, Yankees, Cubs over, and Padres
                                                  Comment
                                                  • bking79
                                                    SBR Sharp
                                                    • 04-17-15
                                                    • 341

                                                    #585
                                                    alex leaning Astros today
                                                    Comment
                                                    • bking79
                                                      SBR Sharp
                                                      • 04-17-15
                                                      • 341

                                                      #586
                                                      8-9 (0.00, 47.1%) avg line: 100.3 / -111.2 on / against: -$155 / +$120 ROI: -7.4% / +5.4%
                                                      8-9 (0.26, 47.1%) avg line: -135.1 / 123.1 on / against: -$352 / +$245 ROI: -14.6% / +13.1%
                                                      0-17-0 (-3.38, 0.0%) avg total: 7.1
                                                      Comment
                                                      • bking79
                                                        SBR Sharp
                                                        • 04-17-15
                                                        • 341

                                                        #587
                                                        alex we gotta look into Phillies I like them tonight if yu could find somthin on that game
                                                        Comment
                                                        • Alex Vaile
                                                          SBR MVP
                                                          • 04-19-14
                                                          • 3724

                                                          #588
                                                          Tuesday:

                                                          Play Nationals vs Phillies Under 7 + 100

                                                          team = Nationals and A and oS:W and oS:season = season and p:A and date >= 20140916

                                                          Nats 0/17 o/u in this spot
                                                          Comment
                                                          • Alex Vaile
                                                            SBR MVP
                                                            • 04-19-14
                                                            • 3724

                                                            #589
                                                            Play Jays - 146

                                                            (s:SRA + ss:SRA)=3 and A and (month= 5 or month =7) and os:SRA<6 and oss:SRA>2 and line>-184

                                                            ROI 16%

                                                            And

                                                            H and -115 > line > -160 and DIV and game number > 10 and month < 7 and 1 >= tA(W, N=10) >= .7 and .7 >= oA(W, N=10) >= .5 and season > 2008 and 7.5 < total < 10 and p:W

                                                            ROI 25%
                                                            Comment
                                                            • Alex Vaile
                                                              SBR MVP
                                                              • 04-19-14
                                                              • 3724

                                                              #590
                                                              Play Miami -125

                                                              starter = Jose Fernandez and H and s:SSO > s:SHA and date >= 20130413

                                                              Marlins 22-0 in this spot
                                                              Comment
                                                              • Alex Vaile
                                                                SBR MVP
                                                                • 04-19-14
                                                                • 3724

                                                                #591
                                                                Originally posted by bking79
                                                                alex leaning Astros today
                                                                Nice one bking sorry I was at work but excellent call
                                                                Comment
                                                                • Alex Vaile
                                                                  SBR MVP
                                                                  • 04-19-14
                                                                  • 3724

                                                                  #592
                                                                  Originally posted by bking79
                                                                  8-9 (0.00, 47.1%) avg line: 100.3 / -111.2 on / against: -$155 / +$120 ROI: -7.4% / +5.4%
                                                                  8-9 (0.26, 47.1%) avg line: -135.1 / 123.1 on / against: -$352 / +$245 ROI: -14.6% / +13.1%
                                                                  0-17-0 (-3.38, 0.0%) avg total: 7.1
                                                                  Oops didn't see u had this too. Great one gotta play it
                                                                  Comment
                                                                  • Alex Vaile
                                                                    SBR MVP
                                                                    • 04-19-14
                                                                    • 3724

                                                                    #593
                                                                    Originally posted by bking79
                                                                    alex we gotta look into Phillies I like them tonight if yu could find somthin on that game
                                                                    starter rest - o:starter rest = 1 and (A or day != Monday) and (H or day != Friday) and 4 < starter rest < 11 and -2 < p:margin < 9 and -11 < op:margin < 8 and -10 < streak < 3 and -10 < o:streak < 6 and site streak < 8 and o:site streak < 8 and -29 < tS(margin, N=10) < 24 and -13 < oS(margin, N=10) < 15 and 15 < tS(hits, N=3) < 36 and tS(HR, N=10) < 14 and 18 < oS(hits, N=3) < 36 and 4 < oS(HR, N=10) < 17 and os:SSO < 10 and os:SWA < 5 and oS(margin, N=10) - tS(margin, N=10) > -15 and tS(hits, N=10) - oS(hits, N=10) > -23 and (game number > 139 or game number < 122)

                                                                    ROI 23% 600 game sample
                                                                    Comment
                                                                    • Alex Vaile
                                                                      SBR MVP
                                                                      • 04-19-14
                                                                      • 3724

                                                                      #594
                                                                      Play Orioles -120

                                                                      team=Orioles and line>=-140 and p:margin <=-5 and p:H and date>=20120729

                                                                      Orioles 25-0 SU in this spot
                                                                      Comment
                                                                      • Alex Vaile
                                                                        SBR MVP
                                                                        • 04-19-14
                                                                        • 3724

                                                                        #595
                                                                        Play Giants - 125

                                                                        WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and D and conference = NL and SG < 4 and line > 100 and month!= 9

                                                                        ROI 8% 960 game sample

                                                                        And

                                                                        team=Giants and p:SII<=2 and date>=20160511

                                                                        Giants 10-0 SU in this spot
                                                                        Comment
                                                                        SBR Contests
                                                                        Collapse
                                                                        Top-Rated US Sportsbooks
                                                                        Collapse
                                                                        Working...