1. #1
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    SDQL for Wednesday 5/17/17

    SDQL 5/17

    ALL = Yesterday 4-4 (Total 130-110)
    SU = Yesterday 3-1 (Total 71-56)
    RL = Yesterday 0-0 (Total 17-20)
    OU = Yesterday 1-3 (Total 42-34)
    ---------------------------------

    SU

    FADE: The Orioles are 0-16 SU since May 11, 2013 in not the first game of a series off a road game in which they played extra innings.


    team = Orioles and p:A and p:X and SG > 1 and date >= 20130511



    FADE: The Giants are 0-14 SU as a dog off a home game in which they did not draw a walk and it is not a series opener.


    team = Giants and SG > 1 and D and p:H and p:walks = 0 and date >= 20050528



    FADE: The Giants are 1-15 SU since August 1st 2014 as a dog of more than 130 in the last game of the series.


    team = Giants and line>130 and LGS and date >= 20140800



    FADE: The Phillies are 0-12 SU since Sep 11, 2016 on the road after their opponent scored first last game.


    team=Phillies and A and po:SF>0 and date>=20160911



    FADE: The Phillies were 1-16 SU as a 130-plus dog after they had six or fewer hits and it is not a series opener.


    team = Phillies and SG > 1 and line>=130 and p:hits <= 6 and season >= 2016



    FADE: The Twins 0-10 SU at Home since 4/24/16 after losing their previous 2 games


    team=Twins and streak=-2 and H and date>=20160424



    PLAY: The Braves are 18-3 SU when they have scored 8 or more runs in back to back games since 2009.


    team=Braves and p:runs>=8 and pp:runs>=8 and 2009<=season



    PLAY: The Astros (528-365 +10.6% ROI)


    (p:margin = Maximum(margin@date)[date-1] and p:date=date-1 and p:margin>1 and SG<4 and conference=AL and op:runs<8 and line<200) and (p:BL = Maximum(BL@date)[date-1] and p:date=date-1 and p:margin>1 and SG<4 and conference=AL and op:runs<8 and line<200)



    FADE: The Marlins are 1-19 SU as a dog of more than 135 in the last game of a series after a game in which they did not hit a home run.


    team = Marlins and line>135 and p:HR = 0 and LGS and season >= 2014



    PLAY: The Marlins (60-41 +33.5% ROI)


    league=NL and o:league=AL and H and oA(runs)>tA(runs) and STDSERA<=4 and D and month!=(7 or 8) and o:STDSERA<=4



    PLAY: The Marlins (854-1125 +7.6% ROI)


    playoffs=0 and D and 120<=line<=200 and WP<=60 and o:WP>=60 and 8.5<=total<=11



    PLAY: The Red Sox (65-61 (ROI +18.3%)


    o:conference = NL and conference = AL and AD and month < 8 and 9.5 >= total >= 7 and p:W and series game=2



    PLAY: The Cubs and Pirates (964-576 +11.9% ROI)


    H and (s:SO + os:SO) > 18 and s:SHRA != 2 and p:runs != 3 and op:runs < 9 and os:fly balls > 3 and os:fly balls != 6 and o:team != Cubs and (p:walks + op:walks) < 13 and op:triples < 2 and p:doubles < 5 and 17 > op:hits > 2 and (tA(at bats@team,N=6)<36.5 or tA(at bats@team,N=6)>36.7) and tA(o:at bats@team,N=6)>31 and (tA(SHF,N=8)<26.3 or tA(SHF,N=8)>26.5)



    ------------

    RL

    PLAY: The Reds are 12-0 RL as a 130-plus dog off a game as a dog when they suffered a walk off loss in their starters last start.


    team = Reds and 130 <= line and p and so:WOW and date >= 20070415



    FADE: The Diamondbacks are 1-17 RL as a favorite off a home win in which their opponent left fewer than ten men on base.


    team = Diamondbacks and F and po:LOB < 10 and p:HW and date >= 20130714



    PLAY: The White Sox are 19-3 RL as a road dog after they hit multiple home runs and it is not a series opener.


    team = White Sox and SG > 1 and A and D and p:HR > 1 and date >= 20150604



    ------------

    OU

    OVER
    : The Indians are 11-0 OU in Josh Tomlins career when he starts as a favorite and he threw over 100 pitches in his last start.


    team = Indians and starter = Josh Tomlin and F and s:SPT>100



    OVER: The Diamondbacks are 10-0 OU when Patrick Corbin starts when their opponent is on a 3+ loss streak since Sep 22, 2012.


    team=Diamondbacks and starter=Patrick Corbin and o:streak<=-3 and date>=20120922



    UNDER: The Red Sox are 1-15 OU as a dog after they hit more home runs than their opponent.


    team = Red Sox and D and p:HR > po:HR and date >= 20160417



    OVER: Teams on 3 or more str8 Overs.
    (Red Sox, Indians, Athletics, Rays, Astros)


    date>=20170420 and p:O and p2:O and p3:O



    UNDER: White Sox/Angels (287-196 +12.9% ROI)


    H and REG and 6.5<=total<=8 and total/2<=STDSERA<=5.25 and total/2<=o:STDSERA<=5.25 and 1.25<=STDSWHIP<=1.55 and 1.25<=o:STDSWHIP<=1.55 and season>=2007



    UNDER: Reds/Cubs (160-80 +26.5% ROI)


    STR and o:STR and s:margin = -1 and s:streak = 2 and s:biggest lead < 3 and s:errors < 2 and -9 < p:M8 < 3 and p:M8 != -2 and -4 < p:M1 < 3



    ________________

    SU

    Tigers
    Dodgers
    Rangers
    Rockies
    Braves
    Red Sox
    Cubs
    Pirates

    RL
    Reds +1.5
    Mets +1.5
    White Sox +1.5
    Dodgers -1.5
    Nationals +1.5


    OU

    Rays/Indians Over
    Mets/D-Backs Over
    Athletics/Mariners Over
    Astros/Marlins Over
    White Sox/Angels Under
    Reds/Cubs Under
    ___________________________________

    wow, I had a lot tonight, still got it done in an hour.
    Last edited by FUqer; 05-17-17 at 12:15 PM. Reason: Added Dodgers and Nationals RL

  2. #2
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Added: Dodgers and Nationals RL


    PLAY: The Dodgers are 10-0 SU+RL since Jul 01, 2012 when Clayton Kershaw starts as a 140+ favorite when their opponent is on a 3+ win streak.

    team=Dodgers and starter=Clayton Kershaw and line<=-140 and o:streak>=3 and date>=20120701



    FADE: The Pirates are 0-11 RL since Aug 20, 2016 as a favorite off a home game in which they scored in at most two separate innings.

    team=Pirates and F and p:H and p:SII <= 2 and date>=20160820

  3. #3
    2daBank
    2daBank's Avatar Become A Pro!
    Join Date: 01-26-09
    Posts: 88,966
    Betpoints: 90

    Speaking of dbags this runs contrary to your play but I saw somewhere a incredibly unbelievable stat that since 2012 dbags average less than 3rpg at home in daytime with roof open.. very hard to believe that considering how much they score at home and how that park plays when the roof open!!

    Figured if anyone could verify such a thing you would be the guy to ask... I would still lean over cause that only way to ever play total in zona with roof open.. gl today.

  4. #4
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Quote Originally Posted by 2daBank View Post
    Speaking of dbags this runs contrary to your play but I saw somewhere a incredibly unbelievable stat that since 2012 dbags average less than 3rpg at home in daytime with roof open.. very hard to believe that considering how much they score at home and how that park plays when the roof open!!

    Figured if anyone could verify such a thing you would be the guy to ask... I would still lean over cause that only way to ever play total in zona with roof open.. gl today.
    It took me a minute to figure it out, cuz I'm not sure about roof queries, so I checked the indoor day games since 2012 and matched with them with the total day games.

    During the day since 2012 D-Backs are 50-57 and average 4.20 runs.
    During the day with the roof closed, they are 43-49 and average 4.28 runs.
    So in the Day when it's open they are 7-8 and probably average around 4.00.

  5. #5
    barryt
    barryt's Avatar Become A Pro!
    Join Date: 01-23-13
    Posts: 237
    Betpoints: 1843

    Quote Originally Posted by FUqer View Post
    Added: Dodgers and Nationals RL


    PLAY: The Dodgers are 10-0 SU+RL since Jul 01, 2012 when Clayton Kershaw starts as a 140+ favorite when their opponent is on a 3+ win streak.

    team=Dodgers and starter=Clayton Kershaw and line<=-140 and o:streak>=3 and date>=20120701



    FADE: The Pirates are 0-11 RL since Aug 20, 2016 as a favorite off a home game in which they scored in at most two separate innings.

    team=Pirates and F and p:H and p:SII <= 2 and date>=20160820
    I dunno about these small sample too good to be true trends . In any 50/50 proposition, there will be runs of 10 or more of repeating results . I did this query from 20100330 and it's actually positive betting ON Pirates

    team = Pirates and F and p:H and p:SII <= 2 and date > 20100330
    SU: 109-66 (0.77, 62.3%) avg line: -144.1 / 132.8 on / against: +$1,713 / -$2,393 ROI: +6.8% / -13.7%
    RL: 71-104 (-0.69, 40.6%) avg line: 152.2 / -166.0 on / against: +$146 / -$1,090 ROI: +0.8% / -3.7%
    OU: 77-88-10 (0.07, 46.7%) avg total: 7.7 over / under: -$1,805 / +$342 ROI: -9.4% / +1.8%

  6. #6
    2daBank
    2daBank's Avatar Become A Pro!
    Join Date: 01-26-09
    Posts: 88,966
    Betpoints: 90

    Quote Originally Posted by FUqer View Post
    It took me a minute to figure it out, cuz I'm not sure about roof queries, so I checked the indoor day games since 2012 and matched with them with the total day games.

    During the day since 2012 D-Backs are 50-57 and average 4.20 runs.
    During the day with the roof closed, they are 43-49 and average 4.28 runs.
    So in the Day when it's open they are 7-8 and probably average around 4.00.
    Thanks for effort. No clue where this guy got roughly 2.6 per game in such spots? Who knows, shocking you can't believe everything you read on the interweb! Lol

  7. #7
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Quote Originally Posted by barryt View Post
    I dunno about these small sample too good to be true trends . In any 50/50 proposition, there will be runs of 10 or more of repeating results . I did this query from 20100330 and it's actually positive betting ON Pirates

    team = Pirates and F and p:H and p:SII <= 2 and date > 20100330
    SU: 109-66 (0.77, 62.3%) avg line: -144.1 / 132.8 on / against: +$1,713 / -$2,393 ROI: +6.8% / -13.7%
    RL: 71-104 (-0.69, 40.6%) avg line: 152.2 / -166.0 on / against: +$146 / -$1,090 ROI: +0.8% / -3.7%
    OU: 77-88-10 (0.07, 46.7%) avg total: 7.7 over / under: -$1,805 / +$342 ROI: -9.4% / +1.8%

    I agree, which is why there are very few that I play blindly, the ones I do are mostly the larger sample sized ones. I actually played the Pirates -1 today.

  8. #8
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Reds and Cubs would be a great one, if it weren't for the wind in Chicago. Dodgers could be 30-0 in a spot, if they are -300, I'm not playing them, etc...

  9. #9
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Quote Originally Posted by barryt View Post
    I dunno about these small sample too good to be true trends . In any 50/50 proposition, there will be runs of 10 or more of repeating results . I did this query from 20100330 and it's actually positive betting ON Pirates

    team = Pirates and F and p:H and p:SII <= 2 and date > 20100330
    SU: 109-66 (0.77, 62.3%) avg line: -144.1 / 132.8 on / against: +$1,713 / -$2,393 ROI: +6.8% / -13.7%
    RL: 71-104 (-0.69, 40.6%) avg line: 152.2 / -166.0 on / against: +$146 / -$1,090 ROI: +0.8% / -3.7%
    OU: 77-88-10 (0.07, 46.7%) avg total: 7.7 over / under: -$1,805 / +$342 ROI: -9.4% / +1.8%
    I also think for some of them you have to take into account that they are geared for more recent outcomes. The one I posted is from Aug 2016, still a lot of the same team for the Pirates, you went back to 2010, and they had a lot of different members.

    You can add teams to the general SDQL and see how those specific teams do in that in spot or you can remove a team and see how the spot does for all teams. I don't have the time to break these down even further everyday in this thread, I just post them and let people mess with them. I don't play everyone and sometimes I go against ones that I posted.

Top