MLB - Situation Plays - SDQL

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

    #211
    Originally posted by MarcM_Flynn
    what website do you get your stats from
    w/o linking a site as per sbr, just google sdql
    Comment
    • JMon
      SBR Hall of Famer
      • 12-11-09
      • 9800

      #212
      Originally posted by JMon
      Want to play against a conference AL road team ave 4.7 runs or less a game off two losses of 4 or more. Look how team=Royals do in this situation.

      A and 165>=line>=-125 and tA(runs)<=4.7 and conference=AL and p:margin<=-4 and pp:margin<=-4 and rest=0 and (SG=1 or SG=3) and conference=o:conference and month<9
      Comment
      • JR007
        SBR Hall of Famer
        • 02-21-10
        • 5279

        #213
        Originally posted by JMon
        I guess it depends on how well the situation had done in the past with a similar wind conditions. It appears to be more of a personal preference regarding a play or not.
        think that would be a tough find, thanks for the winners today JMon
        Comment
        • JMon
          SBR Hall of Famer
          • 12-11-09
          • 9800

          #214
          Originally posted by JR007
          think that would be a tough find, thanks for the winners today JMon
          across the street they have wind parameters per stadium..or at least they used too.
          Comment
          • Capper1124
            SBR MVP
            • 11-23-13
            • 1914

            #215
            Comment
            • MarcM_Flynn
              SBR Rookie
              • 04-09-14
              • 46

              #216
              Originally posted by JMon
              w/o linking a site as per sbr, just google sdql
              thanks
              Comment
              • Allsportscapper
                SBR Sharp
                • 12-12-13
                • 275

                #217
                how do i understand what the play is
                Comment
                • Roadkill86
                  SBR High Roller
                  • 02-18-13
                  • 138

                  #218
                  I think I'm getting the hang of this...
                  tA(runs) >= 3.7 and oA(runs) <= 3.8 and conference = AL and o:conference = AL and month=4 and SG=2 and -105 < line < 170 and season >= 2008
                  Last edited by Roadkill86; 04-15-14, 08:53 AM.
                  Comment
                  • nash13
                    SBR MVP
                    • 01-21-14
                    • 1122

                    #219
                    I had an interesting observation. Most of the plays we generate are based on Dog Wins. So these are predicting highly value on one side. As the averrages would show us that still Favs are winning too, reverse strategy would be to bet the games left out on the Favs to win.
                    I tried it with my MLB plays.
                    55 W - 32 L so far
                    +8.69 Units
                    on averrage odds of 1.75
                    Comment
                    • JR007
                      SBR Hall of Famer
                      • 02-21-10
                      • 5279

                      #220
                      Originally posted by nash13
                      I had an interesting observation. Most of the plays we generate are based on Dog Wins. So these are predicting highly value on one side. As the averrages would show us that still Favs are winning too, reverse strategy would be to bet the games left out on the Favs to win.
                      I tried it with my MLB plays.
                      55 W - 32 L so far
                      +8.69 Units
                      on averrage odds of 1.75
                      .....so do you think that the -150 and under would be not worth it
                      Last edited by JR007; 04-15-14, 12:39 PM.
                      Comment
                      • nash13
                        SBR MVP
                        • 01-21-14
                        • 1122

                        #221
                        no these are avg odds. some of them are higher some lower. mosty favs though.
                        Comment
                        • JMon
                          SBR Hall of Famer
                          • 12-11-09
                          • 9800

                          #222
                          Tuesday Night Over

                          A and 9 >= total >= 8.5 and tA(o:runs) <= 3.7 and conference = AL and day = Tuesday

                          Want a road AL team, with a total of 9-8.5; that allows less than 3.7 runs a game. High total, but allow less than 3.7, hmmm

                          gl if you chose to play
                          Comment
                          • Mako-SBR
                            SBR Sharp
                            • 10-15-13
                            • 492

                            #223
                            Originally posted by Roadkill86
                            I think I'm getting the hang of this...
                            tA(runs) >= 3.7 and oA(runs) <= 3.8 and conference = AL and o:conference = AL and month=4 and SG=2 and -105 < line < 170 and season >= 2008
                            Nice, any excuse to take a dog in April is a good one.

                            Originally posted by JMon
                            Tuesday Night Over

                            A and 9 >= total >= 8.5 and tA(o:runs) <= 3.7 and conference = AL and day = Tuesday

                            Want a road AL team, with a total of 9-8.5; that allows less than 3.7 runs a game. High total, but allow less than 3.7, hmmm

                            gl if you chose to play
                            Like this one as well buddy, thanks for sharing. MLB has been a learning experience thus far, first time I've ever bet the sport as I usually stick to NFL/NBA. If I see anything out there or piece anything together I'll post it in the thread asap.
                            Comment
                            • figue
                              SBR MVP
                              • 07-23-10
                              • 2524

                              #224
                              o:run line>170 and line>100 and season=2014 and month=4

                              st louis ,colorado.
                              Comment
                              • JMon
                                SBR Hall of Famer
                                • 12-11-09
                                • 9800

                                #225
                                Originally posted by Roadkill86
                                I think I'm getting the hang of this...
                                tA(runs) >= 3.7 and oA(runs) <= 3.8 and conference = AL and o:conference = AL and month=4 and SG=2 and -105 < line < 170 and season >= 2008
                                Comment
                                • JMon
                                  SBR Hall of Famer
                                  • 12-11-09
                                  • 9800

                                  #226
                                  Noticed some of my situations I post here are being saved in the KS database..I hope they are coming to good use
                                  Comment
                                  • Nick Nacho
                                    SBR High Roller
                                    • 04-14-14
                                    • 144

                                    #227
                                    What is SDQL-based research? How can I learn about this? I'm confused about this whole thing
                                    Comment
                                    • JMon
                                      SBR Hall of Famer
                                      • 12-11-09
                                      • 9800

                                      #228
                                      Contrarian fav; playing on a road AL fav, with a starter having a high season to date era; against a conference oppt.


                                      A and -110>line>-165 and conference=o:conference and 5.7>=STDSERA>=5.2 and conference=AL
                                      Last edited by JMon; 04-16-14, 07:58 AM.
                                      Comment
                                      • zert
                                        SBR MVP
                                        • 09-22-09
                                        • 1274

                                        #229
                                        Has anybody been tracking the plays they give out on their website?
                                        Comment
                                        • JMon
                                          SBR Hall of Famer
                                          • 12-11-09
                                          • 9800

                                          #230
                                          Check out how the Braves do since 2009 after scoring 8 or more runs in their past two games.

                                          team=Braves and p:runs>=8 and pp:runs>=8 and 2009<=season
                                          Comment
                                          • emceeaye
                                            SBR Wise Guy
                                            • 08-20-13
                                            • 704

                                            #231
                                            clarify correct terms of query

                                            Hi SDQL experts,
                                            I'm trying to create a query to determine how the diamondbacks do as a home favorite with a line of -130 or lower after a 5-game losing streak since 2004. Can someone please clarify if the below query correctly expesses the above criteria?

                                            HF and team=Diamondbacks and date>=20040801 and line<=-130 and streak>=-5.

                                            If not, what am I missing? When I say -130 or lower I'm trying to say "a favorite of -130 or better".

                                            Thanks in advance.
                                            Comment
                                            • TCU
                                              SBR Hustler
                                              • 01-09-12
                                              • 88

                                              #232
                                              Originally posted by JMon
                                              Check out how the Braves do since 2009 after scoring 8 or more runs in their past two games.

                                              team=Braves and p:runs>=8 and pp:runs>=8 and 2009<=season
                                              How do you get it to show run line ROI? It would've cashed 10/14.
                                              Comment
                                              • JMon
                                                SBR Hall of Famer
                                                • 12-11-09
                                                • 9800

                                                #233
                                                Originally posted by TCU
                                                How do you get it to show run line ROI? It would've cashed 10/14.
                                                I guess I'm not sure what you are asking all queries show a ML and RL ROI in MLB

                                                13-1 (3.64, 92.9%) avg line: -136.8 / 123.4 on / against: +$1,220 / -$1,240 ROI: +60.4% / -84.9%
                                                10-4 (2.36, 71.4%) avg line: 126.3 / -138.7 on / against: +$869 / -$959 ROI: +59.9% / -46.1%
                                                7-5-2 (0.29, 58.3%) avg total: 8.4 over / under: +$155 / -$265 ROI: +10.1% / -17.1%
                                                Comment
                                                • JMon
                                                  SBR Hall of Famer
                                                  • 12-11-09
                                                  • 9800

                                                  #234
                                                  Originally posted by emceeaye
                                                  Hi SDQL experts,
                                                  I'm trying to create a query to determine how the diamondbacks do as a home favorite with a line of -130 or lower after a 5-game losing streak since 2004. Can someone please clarify if the below query correctly expesses the above criteria?

                                                  HF and team=Diamondbacks and date>=20040801 and line<=-130 and streak>=-5.

                                                  If not, what am I missing? When I say -130 or lower I'm trying to say "a favorite of -130 or better".

                                                  Thanks in advance.
                                                  line<=-130 (is a fav of 130 or more)
                                                  line>=-130 (is a fav of no more than 130, but you may need to use the shortcut, F, if you don't want to capture the dogs). Note you have does this in your query by using, HF

                                                  If you want just a losing streak of 5, just use streak=-5, streak<=-5 would be a 5 or more game losing streak.
                                                  Comment
                                                  • 19th Hole
                                                    SBR Posting Legend
                                                    • 03-22-09
                                                    • 18923

                                                    #235
                                                    Originally posted by JMon
                                                    Contrarian fav; playing on a road AL fav, with a starter having a high season to date era; against a conference oppt.


                                                    A and -110>line>-165 and conference=o:conference and 5.7>=STDSERA>=5.2 and conference=AL
                                                    ~~~~~~~~~~~~~~~~~~~~~~~~``
                                                    JMON
                                                    This play comes up as Sept 27, 2013 when processed??
                                                    Did I do something wrong...

                                                    Thank you very much.
                                                    Comment
                                                    • JMon
                                                      SBR Hall of Famer
                                                      • 12-11-09
                                                      • 9800

                                                      #236
                                                      Originally posted by 19th Hole
                                                      ~~~~~~~~~~~~~~~~~~~~~~~~``
                                                      JMON
                                                      This play comes up as Sept 27, 2013 when processed??
                                                      Did I do something wrong...

                                                      Thank you very much.
                                                      it was on Tor, which was PPD.
                                                      Comment
                                                      • 19th Hole
                                                        SBR Posting Legend
                                                        • 03-22-09
                                                        • 18923

                                                        #237
                                                        Originally posted by JMon
                                                        it was on Tor, which was PPD.
                                                        Okay
                                                        Thank You...
                                                        Comment
                                                        • emceeaye
                                                          SBR Wise Guy
                                                          • 08-20-13
                                                          • 704

                                                          #238
                                                          Originally posted by JMon
                                                          line<=-130 (is a fav of 130 or more)
                                                          line>=-130 (is a fav of no more than 130, but you may need to use the shortcut, F, if you don't want to capture the dogs). Note you have does this in your query by using, HF

                                                          If you want just a losing streak of 5, just use streak=-5, streak<=-5 would be a 5 or more game losing streak.
                                                          Thanks for your help Jmon.

                                                          This one night be of some use:

                                                          HF and date>=20040801 and line>=-132 and streak<=-5 and o:streak=2

                                                          If I knew how to add the correct terms to express that the opponent's last 8 games were Away, I would add it to see if it adds any more predictive value.
                                                          Last edited by emceeaye; 04-16-14, 04:54 PM. Reason: correction
                                                          Comment
                                                          • nash13
                                                            SBR MVP
                                                            • 01-21-14
                                                            • 1122

                                                            #239
                                                            Originally posted by zert
                                                            Has anybody been tracking the plays they give out on their website?
                                                            i do in my google doc
                                                            Comment
                                                            • figue
                                                              SBR MVP
                                                              • 07-23-10
                                                              • 2524

                                                              #240
                                                              o:run line>170 and line>100 and season=2014 and month=4

                                                              oak sea atl pit
                                                              Comment
                                                              • zert
                                                                SBR MVP
                                                                • 09-22-09
                                                                • 1274

                                                                #241
                                                                Is it ok to look at your google document? Or is it some kind of private thing? thanks
                                                                Comment
                                                                • emceeaye
                                                                  SBR Wise Guy
                                                                  • 08-20-13
                                                                  • 704

                                                                  #242
                                                                  legitimate?

                                                                  SDQL experts,
                                                                  What do you think of the following query that was among the trends listed on that website?

                                                                  team=Royals and date>=20100709 and NGT and A and 6<=p:runs and p:NGT

                                                                  Although by surface examination it looks useful, when you remove the terms "team=Royals" and add that the team is an away favorite ("AF") instead of just playing away ("A"), the SU effect disappears. Based on intuition, doesn't it seem like having an away night game and coming off a night game in which the team scored at least 6 runs would yield the same effect regardless of the team? Why would this only be true of the Royals? Also, shouldn't the fact that Royals are the favorites interfere with the reliability of the query above?

                                                                  It would be great to get your thoughts on this.
                                                                  Comment
                                                                  • JR007
                                                                    SBR Hall of Famer
                                                                    • 02-21-10
                                                                    • 5279

                                                                    #243
                                                                    unders, unders, unders, on getaway games...no brainer on the Phillies today...they are in Colorado tomorrow night, fast paced game.....
                                                                    Comment
                                                                    • green7
                                                                      SBR High Roller
                                                                      • 10-21-10
                                                                      • 190

                                                                      #244
                                                                      HD and tA(W)<.42 and month<7 and C and division!=o:division and NGT and SG = 3

                                                                      SU: 34-30 (-0.23, 53.1%)
                                                                      avg line: 125.3 / -136.0
                                                                      on / against: +$1,272 / -$1,652
                                                                      ROI: +19.9% / -19.0%
                                                                      RL: 28-22 (0.68, 56.0%)
                                                                      avg line: -138.2 / 126.1
                                                                      on / against: -$199 / -$92
                                                                      ROI: -2.9% / -1.8%
                                                                      OU: 28-34-2 (0.14, 45.2%)
                                                                      avg total: 8.6
                                                                      over / under: -$880 / +$260
                                                                      ROI: -12.7% / +3.6%
                                                                      Comment
                                                                      • JMon
                                                                        SBR Hall of Famer
                                                                        • 12-11-09
                                                                        • 9800

                                                                        #245
                                                                        Originally posted by emceeaye
                                                                        SDQL experts,
                                                                        What do you think of the following query that was among the trends listed on that website?

                                                                        team=Royals and date>=20100709 and NGT and A and 6<=p:runs and p:NGT

                                                                        Although by surface examination it looks useful, when you remove the terms "team=Royals" and add that the team is an away favorite ("AF") instead of just playing away ("A"), the SU effect disappears. Based on intuition, doesn't it seem like having an away night game and coming off a night game in which the team scored at least 6 runs would yield the same effect regardless of the team? Why would this only be true of the Royals? Also, shouldn't the fact that Royals are the favorites interfere with the reliability of the query above?

                                                                        It would be great to get your thoughts on this.
                                                                        I would google "trend analysis" as one would see in investment/stock reason. Much of what sdql users do is exactly what trend analysis is; using past results to predict future outcomes. Perhaps no rhythm or reason, things trend; either short, intermediate or long. Finding a trend before it trends and stopping before it regresses it what is problematic and certainly takes an eye of practice to see. Thus becomes second nature if practiced enough. For example, on the trend you posted above, if you followed and won three times in the start of 2013, then lost two times; would it be wise to monitor the trend before playing it again? Your investment has paid off going 3-2. If it continues to lose...move on.

                                                                        Other sdql users use it merely on logic, and pay no attention to trending situations as what you posted. It's a personal preference. I use both and have success at both.
                                                                        Last edited by JMon; 04-17-14, 04:39 PM.
                                                                        Comment
                                                                        SBR Contests
                                                                        Collapse
                                                                        Top-Rated US Sportsbooks
                                                                        Collapse
                                                                        Working...