MLB 2018 - SDQL / Tracking / Picks

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • FUqer
    SBR MVP
    • 01-22-15
    • 3968

    #1
    MLB 2018 - SDQL / Tracking / Picks
    I'll be posting some SDQL queries again and tracking them throughout the season, along with tracking my personal plays and occasional model projections. I'm not a professional gambler and I keep to myself in my own threads, but I will be glad to answer any questions, discuss games and systems, and take any advice that is respectfully presented. I value integrity over anything else and always do my best to keep and display accurate tracking records. I hope everyone crushes those bookies this season, BOL!
  • 2daBank
    SBR Aristocracy
    • 01-26-09
    • 88966

    #2
    always enjoy this thread my dude!! Gl this season!
    Comment
    • FUqer
      SBR MVP
      • 01-22-15
      • 3968

      #3
      Originally posted by 2daBank
      always enjoy this thread my dude!! Gl this season!
      Thanks, u2 bro!
      Comment
      • FUqer
        SBR MVP
        • 01-22-15
        • 3968

        #4
        Starting the season off with some simple SDQL research. I realize it's technically still March, but most openers have been in April. I likely won't get into the heavier SDQL for at least a few days, maybe even not until NCAAB is completely done.
        This kind of stuff can be found with a simple query.

        starter = Chris Sale and A and month = 4
        starter = Chris Archer and H and month = 4
        --------------------------



        Graveman 5-7 team record in April, 1-5 at Home.
        Garrett Richards 9-9 team record in April, 5-6 on the Road.


        JA Happ 12-16 team record in April, 6-8 at Home.
        Luis Severino 2-6 team record in April, 1-3 on the Road.


        Julio Teheran 15-10 team record in April, 7-6 at Home.
        Aaron Nola 4-4 team record in April, 3-2 on the Road.


        Patrick Corbin 11-6 team record in April, 5-4 at Home.
        Jon Gray 4-1 team record in April, 2-0 on the Road.


        Clayton Kershaw 25-15 team record in April, 16-5 at Home.
        Ty Blach 0-2 team record in April, 0-0 on the Road.


        Felix Hernandez 36-25 team record in April, 17-13 at Home.
        Corey Kluber 8-14 team record in April, 4-9 on the Road.


        Noah Syndergaard 5-4 team record in April, 3-2 at Home.
        Carlos Martinez 10-3 team record in April, 4-2 on the Road.


        Dylan Bundy 4-1 team record in April, 3-0 at Home.
        Jake Odorizzi 8-10 team record in April, 2-6 on the Road.


        Clayton Richard 9-18 team record in April, 5-8 at Home.
        Chase Anderson 5-9 team record in April, 3-2 on the Road.


        Cole Hamels 25-26 team record in April, 13-16 at Home.
        Justin Verlander 30-26 team record in April, 15-12 on the Road.


        Chris Archer 12-10 team record in April, 8-4 at Home.
        Chris Sale 17-9 team record in April, 8-5 on the Road.
        Comment
        • FUqer
          SBR MVP
          • 01-22-15
          • 3968

          #5
          Pretty tight Total Projections for today. My gut likes the Under in the BOS/TB game though.


          MIL/SD = O8.0 (8.6) - +0.6

          MIN/BAL = U9.5 (8.9) - -0.6

          NYY/TOR = U8.5 (7.9) - -0.6

          PHI/ATL = O8.0 (8.5) - +0.5

          LAA/OAK = U9.0 (8.5) - -0.5

          CHW/KC = U9.5 (9.0) - -0.5

          STL/NYM = O7.0 (7.3) - +0.3

          BOS/TB = U7.0 (6.7) - -0.3

          CLE/SEA = U7.5 (7.2) - -0.3

          SF/LAD = O7.0 (7.1) - +0.1

          HOU/TEX = U9.5 (9.4) - -0.1

          CHC/MIA = O8.0 (8.1) - +0.1

          COL/ARI = 8.5 (8.5) - 0.0
          Comment
          • 2daBank
            SBR Aristocracy
            • 01-26-09
            • 88966

            #6
            I like the scrubbies over. Think they be good for 5-6 runs here, just hope marlins thin lineup can give us a few off Lester who not the fastest of starters.
            Comment
            • FUqer
              SBR MVP
              • 01-22-15
              • 3968

              #7
              Thursday 3/29/18 MLB Plays


              ¤ Cardinals +123
              ¤ Blue Jays +148
              __________________________
              Comment
              • 2daBank
                SBR Aristocracy
                • 01-26-09
                • 88966

                #8
                On them both (Jays ff as ya know)., good start for scrubbies over!

                I was all excited to play little draft kings today but was so pissed they split the games to where could only use Cubs/cards games in tourney separately then the 9 middle games. Kinda ****** me as that put everyone on happ! Lol
                Comment
                • FUqer
                  SBR MVP
                  • 01-22-15
                  • 3968

                  #9
                  Marlins are going to be so bad this year, lol, but so will my Pirates. I'll be rooting for the Indians again this year. Hoping the Cards are good to me again, one of my fav teams to play on.
                  Comment
                  • 2daBank
                    SBR Aristocracy
                    • 01-26-09
                    • 88966

                    #10
                    I was surprised they went urenas over straily to start season. Only think really interest me bout fish is that kid we sent over in ozuna trade, alcantera. He has some really electric stuff and I'd assume they Gina go ahead and let him play in bigs even tho he raw!
                    Comment
                    • OlDirtyBaztid
                      SBR Wise Guy
                      • 05-28-17
                      • 953

                      #11
                      Good luck this year, bro!!
                      Comment
                      • FUqer
                        SBR MVP
                        • 01-22-15
                        • 3968

                        #12
                        Originally posted by OlDirtyBaztid
                        Good luck this year, bro!!
                        u2 ODB!
                        Comment
                        • FUqer
                          SBR MVP
                          • 01-22-15
                          • 3968

                          #13
                          That was an ugly start for the Cards, hopefully Martinez can find his groove vs their bottom and they can get some wood on that 99 mph FB from Syndergaard, he's looking pretty good right now.
                          Comment
                          • FUqer
                            SBR MVP
                            • 01-22-15
                            • 3968

                            #14
                            LOL, Molina just crushed that.
                            Comment
                            • 2daBank
                              SBR Aristocracy
                              • 01-26-09
                              • 88966

                              #15
                              Originally posted by FUqer
                              LOL, Molina just crushed that.
                              Couldn't have come at better time a I was cussing matheny Like crazy for having carp at 3rd to get Martinez bat in lineup. Don't get e wrong I love our lineup w him in it but in this game vs Thor I just thought we be better served with our best defense out there!
                              Comment
                              • 2daBank
                                SBR Aristocracy
                                • 01-26-09
                                • 88966

                                #16
                                Jeez, I went for beer and Carlos walked another how many guys? We need Reyes back to be our ace! Weaver 2, then Carlos 3!!
                                Comment
                                • Regul8er
                                  SBR Posting Legend
                                  • 11-06-07
                                  • 10666

                                  #17
                                  Ya, Carlos will be lucky to get through 5 innings today........4 might be a struggle.

                                  Nothing worse then getting spotted a few runs, only to give them back the bottom half of the inning.
                                  Comment
                                  • 2daBank
                                    SBR Aristocracy
                                    • 01-26-09
                                    • 88966

                                    #18
                                    Originally posted by Regul8er
                                    Ya, Carlos will be lucky to get through 5 innings today........4 might be a struggle.

                                    Nothing worse then getting spotted a few runs, only to give them back the bottom half of the inning.
                                    Usually he settles down after the 1st but yea not getting deep been his biggest issue. I mean the kid still only in his age 26 season, lot of the best in the biz weren't thiught of as such at this point, his numbers thru this point compare incredibly favorable to scherzer, kluber currently, and couple HOF'er of the past. Problem is waino's rapid decline has made him billed our ace a little prematurely it appears. You woulda told me cards would plate 3 off Thor already I'd have bet more! Lol
                                    Comment
                                    • Regul8er
                                      SBR Posting Legend
                                      • 11-06-07
                                      • 10666

                                      #19
                                      Matheny kind of sh!t of pants here. Martinez was struggling bad, and pitch count climbing.....so he lets him stay him, and it burns.

                                      Wish they got him out tied.
                                      Comment
                                      • 2daBank
                                        SBR Aristocracy
                                        • 01-26-09
                                        • 88966

                                        #20
                                        Originally posted by Regul8er
                                        Matheny kind of sh!t of pants here. Martinez was struggling bad, and pitch count climbing.....so he lets him stay him, and it burns.

                                        Wish they got him out tied.
                                        Nothing new there, lol. But hell man it game 1. Need your so called ace to get you 5 innings or you end up behind the chains (so to speak) with your pen early on.
                                        Comment
                                        • Regul8er
                                          SBR Posting Legend
                                          • 11-06-07
                                          • 10666

                                          #21
                                          True.........I was just thinking with it being such a cold day, and the majority of pitches thrown in high stress situations, that he would have had a slightly quicker hook. Martinez just had no clue where anything was going today.....his best pitch might have been the one Cespesdes hit for a 2 out 2 rbi single in the 2nd.
                                          Comment
                                          • 2daBank
                                            SBR Aristocracy
                                            • 01-26-09
                                            • 88966

                                            #22
                                            Originally posted by Regul8er
                                            True.........I was just thinking with it being such a cold day, and the majority of pitches thrown in high stress situations, that he would have had a slightly quicker hook. Martinez just had no clue where anything was going today.....his best pitch might have been the one Cespesdes hit for a 2 out 2 rbi single in the 2nd.
                                            Missed that one i went on beer run after yadi homer. Well they done now. Thor still has another 2 innings in him. Broken bats killing us this inning.
                                            Comment
                                            • Regul8er
                                              SBR Posting Legend
                                              • 11-06-07
                                              • 10666

                                              #23
                                              Ya, I shut it down after the Roasrio hit.

                                              On the to next one.
                                              Comment
                                              • FUqer
                                                SBR MVP
                                                • 01-22-15
                                                • 3968

                                                #24
                                                You could tell where this one was headed, I was hoping the Mets would get down to a reasonable price live, but -145 was the best it got. I was going ask about the Cardinals BP, but I got an answer pretty quickly there. Just not their day all the way around.
                                                Comment
                                                • Regul8er
                                                  SBR Posting Legend
                                                  • 11-06-07
                                                  • 10666

                                                  #25
                                                  0-1 isnt gonna burn anyone.....sh!t, an 0-10 start shouldnt burn anyone either.

                                                  Lonngggggg....Lonnggggggg season! Get er going boys.
                                                  Comment
                                                  • 2daBank
                                                    SBR Aristocracy
                                                    • 01-26-09
                                                    • 88966

                                                    #26
                                                    Originally posted by FUqer
                                                    You could tell where this one was headed, I was hoping the Mets would get down to a reasonable price live, but -145 was the best it got. I was going ask about the Cardinals BP, but I got an answer pretty quickly there. Just not their day all the way around.
                                                    The cards pen actually has a ton of talent. Problem is most their best arms all have options so unfortunately that means lot of bowman, brebbia, Cecil early on, but they signed holland today and w him as closer we have a lot of talented arms for 7-8-9. My big concern was them blowing games early where these kids with great arms should be in but instead it matheny'a vets he loves so much. By end of year cards will have one of best pens in league imo.
                                                    Comment
                                                    • 2daBank
                                                      SBR Aristocracy
                                                      • 01-26-09
                                                      • 88966

                                                      #27
                                                      I will say shoot I guess I can live with shoddy defense w Martinez playing 1st and carp at 3rd, Jose 3 for 3 w a homer against Thor! He hits like that we can live w the d!
                                                      Comment
                                                      • 2daBank
                                                        SBR Aristocracy
                                                        • 01-26-09
                                                        • 88966

                                                        #28
                                                        You catch the Meyers kid there? Kid has powerful stuff!
                                                        Comment
                                                        • hotcross
                                                          SBR Hall of Famer
                                                          • 08-04-17
                                                          • 7934

                                                          #29
                                                          Originally posted by FUqer
                                                          MLB 2018 - SDQL / Tracking / Picks
                                                          GOOD LUCK

                                                          will be watching thread, subscribed
                                                          Comment
                                                          • RangeFinder
                                                            SBR Hall of Famer
                                                            • 10-27-16
                                                            • 8041

                                                            #30
                                                            Originally posted by FUqer
                                                            I'll be posting some SDQL queries again and tracking them throughout the season, along with tracking my personal plays and occasional model projections. I'm not a professional gambler and I keep to myself in my own threads, but I will be glad to answer any questions, discuss games and systems, and take any advice that is respectfully presented. I value integrity over anything else and always do my best to keep and display accurate tracking records. I hope everyone crushes those bookies this season, BOL!
                                                            Are you able to query lefties as underdogs on opening day? Thank you.
                                                            Comment
                                                            • FUqer
                                                              SBR MVP
                                                              • 01-22-15
                                                              • 3968

                                                              #31
                                                              Originally posted by RangeFinder
                                                              Are you able to query lefties as underdogs on opening day? Thank you.
                                                              There was only 3 games the last two official opening days, not sure about before that. I started to do some opening day research until I seen that and gave up on it. There were no left handed underdogs last year on opening day. You would need to find the dates of opening days and just replace the date in the query below. It wouldn't take a whole lot of time to go back a bit, but I don't have much time right now to do it, or else I would of looked it up for you, GL.

                                                              date=20170402 and D and STL
                                                              Comment
                                                              • FUqer
                                                                SBR MVP
                                                                • 01-22-15
                                                                • 3968

                                                                #32
                                                                Thursday 3/29/18 MLB Results

                                                                0-2 for -2.00

                                                                LOSS - ¤ Cardinals +123
                                                                LOSS - ¤ Blue Jays +148

                                                                __________________________
                                                                Season = 0-2 for -2.00
                                                                ___________________________

                                                                ML = 0-2 for -2.00
                                                                (Dogs = 0-2 for -2.00)
                                                                (Favs = 0-0 for +0.00)

                                                                RL = 0-0 for +0.00

                                                                O/U = 0-0 for +0.00
                                                                (Overs = 0-0 for +0.00)
                                                                (Unders = 0-0 for +0.00)


                                                                __________________________
                                                                Recent Results

                                                                3/29 = 0-2 for -2.00
                                                                ______________________________
                                                                Comment
                                                                • FUqer
                                                                  SBR MVP
                                                                  • 01-22-15
                                                                  • 3968

                                                                  #33
                                                                  Originally posted by FUqer
                                                                  Pretty tight Total Projections for today. My gut likes the Under in the BOS/TB game though.


                                                                  MIL/SD = O8.0 (8.6) - +0.6

                                                                  MIN/BAL = U9.5 (8.9) - -0.6

                                                                  NYY/TOR = U8.5 (7.9) - -0.6

                                                                  PHI/ATL = O8.0 (8.5) - +0.5


                                                                  LAA/OAK = U9.0 (8.5) - -0.5

                                                                  CHW/KC = U9.5 (9.0) - -0.5


                                                                  STL/NYM = O7.0 (7.3) - +0.3

                                                                  BOS/TB = U7.0 (6.7) - -0.3

                                                                  CLE/SEA = U7.5 (7.2) - -0.3

                                                                  SF/LAD = O7.0 (7.1) - +0.1

                                                                  HOU/TEX = U9.5 (9.4) - -0.1

                                                                  CHC/MIA = O8.0 (8.1) - +0.1

                                                                  COL/ARI = 8.5 (8.5) - 0.0
                                                                  TOTALS - (Overall = 7-5) (Overs = 3-2) Unders = 4-3)
                                                                  Comment
                                                                  • FUqer
                                                                    SBR MVP
                                                                    • 01-22-15
                                                                    • 3968

                                                                    #34
                                                                    Friday's Total Projections


                                                                    (Overall = 7-5) (Overs = 3-2) Unders = 4-3)


                                                                    HOU@TEX U9.5 (8.3) -1.2

                                                                    COL@ARI O8.5 (9.6) +1.1

                                                                    CHC@MIA U8.5 (8.0) -0.5

                                                                    PIT@DET U9.5 (9.0) -0.5

                                                                    SF@LAD U7.5 (7.1) -0.4

                                                                    PHI@ATL O9.0 (9.4) +0.4

                                                                    NYY@TOR U9.0 (8.6) -0.4

                                                                    BOS@TB U7.5 (7.3) -0.2

                                                                    WAS@CIN U8.5 (8.4) -0.1

                                                                    MIL@SD (8.8)

                                                                    LAA@OAK (7.8)
                                                                    Comment
                                                                    • FUqer
                                                                      SBR MVP
                                                                      • 01-22-15
                                                                      • 3968

                                                                      #35
                                                                      SDQL 3/30

                                                                      ALL = Yesterday 0-0 (Total 0-0)
                                                                      SU = Yesterday 0-0 (Total 0-0)
                                                                      OU = Yesterday 0-0 (Total 0-0)


                                                                      ---------------------------------
                                                                      SU


                                                                      PLAY
                                                                      : Giants = +14.3 ROI (95-98)
                                                                      AD and p:AW and SG=2 and division=o:division and day!=Saturday and day!=Sunday and p:runs<5 and op:runs<3 and NGT

                                                                      PLAY
                                                                      : Dodgers = ML = +32.4% ROI (33-12) RL = +48.6% ROI (27-18)
                                                                      HF and WP<50 and o:WP>50 and date>=20170618 and conference=NL
                                                                      -----------------------------------
                                                                      OU


                                                                      UNDER
                                                                      : Giants/Dodgers +4.9% ROI (99-82-11)
                                                                      AD and p:AW and SG=2 and division=o:division and day!=Saturday and day!=Sunday and p:runs<5 and op:runs<3 and NGT


                                                                      UNDER
                                                                      : Giants/Dodgers +25.1% ROI (29-15-1)
                                                                      HF and WP<50 and o:WP>50 and date>=20170618 and conference=NL
                                                                      __________________________
                                                                      SDQL PLAYS

                                                                      SU


                                                                      None

                                                                      OU


                                                                      Giants/Dodgers Under 7.5 -115
                                                                      ___________________________________

                                                                      I did a little SDQL work this morning just to check and not very much for the day. GLA!
                                                                      Comment
                                                                      SBR Contests
                                                                      Collapse
                                                                      Top-Rated US Sportsbooks
                                                                      Collapse
                                                                      Working...