2015 SDQL Baseball Thread

**Alex Vaile** · 07-09-15, 09:28 AM

Today's plays :

Play Tigers - 137

A and A(starter whip@starter and season, N=3)<2.50 and A(o:starter whip@o:starter and o:season, N=3)>=2.25 and 2012<=season and line<=160 and rest=0 and 9.5>=total>=8 and month!=8

( JMon )
ROI % 34

**Alex Vaile** · 07-09-15, 09:37 AM

Play Pirates + 100

team=Cardinals and -120<=line<=120 and p:SO>=p:hits and p:AW and date>=20120411 (0-12)

team=Cardinals and line>-150 and p:SO>=p:hits and p:AW and season=2015 (0-6)

team=Pirates and p:HW and p:QS and date>=20150511
(17-0)

Also Pirates 12 straight wins as home dog.

**escism** · 07-09-15, 02:16 PM

Just to preface this by saying I'm not a huge fan of betting against the streak. Obv if you're been following the Tigers O/U run you would know by now not to bet against this streak. That anomaly aside these are some interesting micro trends:

season=2015 and ou streak=-4 and H
season=2015 and ou streak=-4 and A

Not huge sample sizes, but what made me look into it was seeing how all of these chase systems are working in terms of doubling up the bets on the next streak blah blah. So I'm working through trying to see if there is great time to jump in on the streak and bet the opposite way or to ride the streak and try really capitalize on the ROI.

Just food for thought.

**escism** · 07-09-15, 05:13 PM

July & AL & Home
month=7 and league=AL and H and season>=2013 and team

month=7 and league=AL and A and season>=2013 and team

It's interesting to see how teams hit the Over or Under stride in July. That first trend shows Detroit doing great on the overs at home. Obviously their current streak helps boost that up too. There are some great ROIs out there though.

**Alex Vaile** · 07-10-15, 09:30 AM

Yesterday's results: 1-1 even
Season to date : 213-202 + 6.36 units

Tigers won and Pirates lost.

**Alex Vaile** · 07-10-15, 09:32 AM

Originally posted by escism

July & AL & Home
month=7 and league=AL and H and season>=2013 and team

month=7 and league=AL and A and season>=2013 and team

It's interesting to see how teams hit the Over or Under stride in July. That first trend shows Detroit doing great on the overs at home. Obviously their current streak helps boost that up too. There are some great ROIs out there though.

I looked at a bunch of these. Helped me to take Mariners Yesterday. Thanks excism I like the angle you're taking. Nice patterns developing. Tigers under cashed too and ai looked at the Twins tendencies in division.

**Alex Vaile** · 07-10-15, 09:41 AM

Today's plays :

Play Under 6 + 101 Phillies vs Giants

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

( Bases )
ROI % 40

**Alex Vaile** · 07-10-15, 10:01 AM

Play Rangers -123

conference=NL and o:conference=AL and A and 230>=line>-105 and month<8 and 9.5>=total>=7

( B1slickguy )
ROI % 8

**Alex Vaile** · 07-10-15, 10:05 AM

Play Yankees + 108

season = 2015 and team = Red Sox and division = o:division and H
( excism)

And

DIV and D and p:W and 40<=o:WP<48

ROI % 10

**Alex Vaile** · 07-10-15, 10:14 AM

Play Reds vs Marlins Under 7.5 - 120

season > 2008 and H and 10 > month > 5 and SG < 4 and 5 > streak > -5 and 1 > tA(HR) > .7 and s:SRA < 6 and p:hits < 11 and 16 > op:hits > 4 and sss:SRA < 4 and rest = 0 and p:home runs < 2 and os:SSO < 11 and oss:SSO < 10 and os:SHA < 11 and 2 < oss:SHA < 11 and p:IT < 6 and p:LOB < 21 and s:SPT < 122 and ss:SPT < 119 and team != Rockies and team != Athletics and o:team != Blue Jays and (p:errors + pp:errors + ppp:errors + pppp:errors + ppppp:errors + pppppp:errors) < 10 and (op:errors + opp:errors + oppp:errors + opppp:errors + oppppp:errors + opppppp:errors) < 8 and (p:temperature < 91 or p:temperature = Indoors)

( Bases )
ROI % 29

**Alex Vaile** · 07-10-15, 10:17 AM

Play Under 6.5 - 120 Cards vs Pirates
Play Under 8 - 105 Nationals vs Orioles

H and month > 5 and season>2009 and 1.2 > tA(BPRA) > .6 and 8>(s:SRA-os:SRA)>-4 and (p:hits + os:walks)<15 and month!=8 and s:SRA<6 and os:SRA<5 and 30.7>(p:SIP + pp:SIP + ppp:SIP + pppp:SIP)>18.7 and (op:SIP + opp:SIP + oppp:SIP + opppp:SIP)>19.4 and total>6.4 and p

u margin>-6.6 and streak<5 and o:streak<6 and -8 < o

u streak<4 and os:SPT<123 and team!=Twins and team!=Red Sox and o:team!=Indians and (s:SSO + ss:SSO + sss:SSO + ssss:SSO)>9 and (s:SSO + ss:SSO + sss:SSO)<26 and (os:SSO + oss:SSO + osss:SSO +ossss:SSO +osssss:SSO)>13 and (os:SSO + oss:SSO + osss:SSO +ossss:SSO)<31

( Bases )
ROI % 26

**Alex Vaile** · 07-10-15, 11:54 PM

Today's results : 4-2 + 1.88 units
Season to date : 217-204 + 8.24 units

Cincy under, Yankees, Rangers and Orioles under winners and Giants under and Pirates under both lost the 6 run totals.

**ShipItToDaddy** · 07-11-15, 12:02 AM

Good shit man!

**Alex Vaile** · 07-11-15, 10:44 AM

Today's plays :

Play Under 6.5 + 107 Cardinals vs Pirates

H and month > 5 and season>2009 and 1.2 > tA(BPRA) > .6 and 8>(s:SRA-os:SRA)>-4 and (p:hits + os:walks)<15 and month!=8 and s:SRA<6 and os:SRA<5 and 30.7>(p:SIP + pp:SIP + ppp:SIP + pppp:SIP)>18.7 and (op:SIP + opp:SIP + oppp:SIP + opppp:SIP)>19.4 and total>6.4 and p

u margin>-6.6 and streak<5 and o:streak<6 and -8 < o

u streak<4 and os:SPT<123 and team!=Twins and team!=Red Sox and o:team!=Indians and (s:SSO + ss:SSO + sss:SSO + ssss:SSO)>9 and (s:SSO + ss:SSO + sss:SSO)<26 and (os:SSO + oss:SSO + osss:SSO +ossss:SSO +osssss:SSO)>13 and (os:SSO + oss:SSO + osss:SSO +ossss:SSO)<31

( Bases )
ROI % 26

**Alex Vaile** · 07-11-15, 10:47 AM

Play Under 6.5 -110 Astros vs Rays

season > 2008 and H and 10 > month > 5 and SG < 4 and 5 > streak > -5 and 1 > tA(HR) > .7 and s:SRA < 6 and p:hits < 11 and 16 > op:hits > 4 and sss:SRA < 4 and rest = 0 and p:home runs < 2 and os:SSO < 11 and oss:SSO < 10 and os:SHA < 11 and 2 < oss:SHA < 11 and p:IT < 6 and p:LOB < 21 and s:SPT < 122 and ss:SPT < 119 and team != Rockies and team != Athletics and o:team != Blue Jays and (p:errors + pp:errors + ppp:errors + pppp:errors + ppppp:errors + pppppp:errors) < 10 and (op:errors + opp:errors + oppp:errors + opppp:errors + oppppp:errors + opppppp:errors) < 8 and (p:temperature < 91 or p:temperature = Indoors)

( Bases )
ROI % 29

**Alex Vaile** · 07-11-15, 10:50 AM

Play Angels - 105
Play Yankees + 134

DIV and D and p:W and 40<=o:WP<48

ROI % 11

**b1slickguy** · 07-11-15, 10:59 AM

Nice work this season, Alex!
Like today's under play. Have an under friendly ump, Vic Carapazza, behind the plate, too.
Good luck.

**Alex Vaile** · 07-11-15, 12:16 PM

Originally posted by b1slickguy

Nice work this season, Alex!
Like today's under play. Have an under friendly ump, Vic Carapazza, behind the plate, too.
Good luck.

Right on slick. Thanks. Ya Ive been using a lot of u and JMon and Bases queries but they stand up over time. Let's get it today brother.

**Alex Vaile** · 07-11-15, 12:20 PM

Play Rays - 101

s:SO > 9 and s:W and A and season > 2005 and -185<=line<=100 and conference = o:conference and starter rest < 10 and rest = 0 and SG<3 and month<9 and 10>=total>=7

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 % 16

**Alex Vaile** · 07-12-15, 12:22 AM

Todays results : 2-3 - 1.05 units
Season to date : 219-207 + 7.19 units

Rays and under winners and Pirates under, Yankees and Angels losers.

6 run totals 1 and 4 lately. Those are tough.

**Alex Vaile** · 07-12-15, 01:23 AM

Sunday's plays :

Play Rays + 105

180 >= line >= 100 and tA(runs) <= 4.2 and o:STDSERA <= 3.5 and o:conference = AL and (p:runs + po:runs) <= 3 and 2009 <= season and o:rest = 0 and total > 6.5

( JMon? )
ROI % 41

**Alex Vaile** · 07-12-15, 01:26 AM

Play Athletics + 112

p:errors = 0 and op:errors = 1 and (H or SG > 1) and SG < 5 and SGS > 2 and SGS - SG < 3 and (H or day != Saturday) and ((H and -215 < line < 142) or (A and -200 < line < 175)) and (conference = AL or o:conference = NL) and op:HR < 3 and p:runs > 2 and p:margin > -2 and 12 > pp:margin > -9 and streak < 5 and -7 < o:streak < 3 and p:SO < 14 and game number > 13 and -21 < tS(margin, N=10) < 29 and -30 < oS(margin, N=10) < 26 and s:SHA > 1 and s:SWA < 6 and s:SSO < 11 and s:SIP > 1.9 and s:SHF > 21 and s:SPT < 121 and 4 < starter rest < 17 and os:SRA < 7 and os:SWA < 6 and 20 < os:SHF < 33 and os:SIP < 8.1 and o:starter rest < 10 and op:runs < 9 and opp:runs < 13 and oppp:runs < 11 and oS(runs, N=10) > 21 and tS(HR, N=10) < 19 and tS(walks, N=10) > 16 and 42 < tS(SO, N=10) < 86 and site streak > -10 and o:site streak > -8 and op:SII < 5 and p:RMAX > 1 and oss:SHF > 13 and oss:SPT > 73 and -5 < tS(W, N=10) - oS(W, N=10) < 6 and -8 < tS(errors, N=10) - oS(errors, N=10) < 6 and opp:RMAX < 5

( Bases )
ROI % 26

And
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

( Bases )
ROI % 28

**Alex Vaile** · 07-12-15, 01:29 AM

Play Mets - 108

(so:R1 = 3 or so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

( Bases )
ROI % 28

**Alex Vaile** · 07-12-15, 01:36 AM

Play Under 6.5 - 117 Athletics vs Indians
Play Under 6.5 - 125 White Sox vs Cubs

season > 2008 and H and 10 > month > 5 and SG < 4 and 5 > streak > -5 and 1 > tA(HR) > .7 and s:SRA < 6 and p:hits < 11 and 16 > op:hits > 4 and sss:SRA < 4 and rest = 0 and p:home runs < 2 and os:SSO < 11 and oss:SSO < 10 and os:SHA < 11 and 2 < oss:SHA < 11 and p:IT < 6 and p:LOB < 21 and s:SPT < 122 and ss:SPT < 119 and team != Rockies and team != Athletics and o:team != Blue Jays and (p:errors + pp:errors + ppp:errors + pppp:errors + ppppp:errors + pppppp:errors) < 10 and (op:errors + opp:errors + oppp:errors + opppp:errors + oppppp:errors + opppppp:errors) < 8 and (p:temperature < 91 or p:temperature = Indoors)

( Bases )
ROI % 29

**Alex Vaile** · 07-12-15, 01:40 AM

Play Rangers -125

conference=NL and o:conference=AL and A and 230>=line>-105 and month<8 and 9.5>=total>=7

( B1slickguy )
ROI % 8

And

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

( Bases )
ROI %28

**Alex Vaile** · 07-12-15, 06:18 PM

Today's results : 5-1 + 3.92
Season to date : 224-208 + 11.11 units

Athletics and Athletics under, Rays, Cubs under, Mets winners and Rangers lost.

Nice weekend again. Let's keep rolling!

**MikeyD323** · 07-12-15, 06:33 PM

Well done. What are you coming up with for the night game?

**Alex Vaile** · 07-12-15, 06:38 PM

Originally posted by MikeyD323

Well done. What are you coming up with for the night game?

Thanks Mikey.
Well I was just looking it over. I have a query that is 21-11 over/under on Sundays 1 and 1 this season. Leaning over but not gonna post it. I've played under in the first 2 games of series and lost so I should chase under again right? Naw im taking Over. Line seems high for Pitt so idk on that but leaning over now its down to 6.5. Good luck however u play.

**Alex Vaile** · 07-12-15, 09:49 PM

Yep over in Pirates was the play. Cashed

**Alex Vaile** · 07-17-15, 03:21 AM

First play for Friday:

Play Under 7 - 115 Mets vs Cardinals

H and month > 5 and season>2009 and 1.2 > tA(BPRA) > .6 and 8>(s:SRA-os:SRA)>-4 and (p:hits + os:walks)<15 and month!=8 and s:SRA<6 and os:SRA<5 and 30.7>(p:SIP + pp:SIP + ppp:SIP + pppp:SIP)>18.7 and (op:SIP + opp:SIP + oppp:SIP + opppp:SIP)>19.4 and total>6.4 and p

u margin>-6.6 and streak<5 and o:streak<6 and -8 < o

u streak<4 and os:SPT<123 and team!=Twins and team!=Red Sox and o:team!=Indians and (s:SSO + ss:SSO + sss:SSO + ssss:SSO)>9 and (s:SSO + ss:SSO + sss:SSO)<26 and (os:SSO + oss:SSO + osss:SSO +ossss:SSO +osssss:SSO)>13 and (os:SSO + oss:SSO + osss:SSO +ossss:SSO)<31

( Bases )
ROI % 27

**Alex Vaile** · 07-17-15, 03:29 AM

Play Under 8 - 125 Red Sox vs Angels

tA(runs, N=10) - oA(runs, N=10) > 0.5 and tA(BPRA, N=10) - oA(BPRA, N=10) < -0.5 and STDSERA - o:STDSERA < -0.5 and playoffs = 0 and H and line > -145 and month > 4 and season>2014

ROI % 11

**Alex Vaile** · 07-17-15, 12:34 PM

Play Brewers - 122

HF and p:A and -7 < p:margin < 0 and tS(W, N=12) > 6 and 0 < s:SRA < 5 and season > 2008

ROI % 24

**Alex Vaile** · 07-17-15, 12:41 PM

Play Astros - 149

month = 7 and F and season > 2007 and -149 > line > -190 and s:SRA < 6 and ss:SRA < 7 and 2.5 > STDSWHIP > 1.1 and day != Monday and day != Tuesday and conference = o:conference and (p:hits + pp:hits) < 28 and WP < 59 and (starter wins - starter losses + o:starter losses - o:starter wins) > -2

( Bases )
ROI % 26

**Alex Vaile** · 07-17-15, 08:09 PM

Play Over 8.5 + 105 Giants vs Diamondbacks

season = 2015 and team = Diamondbacks and division = o:division and H

( excism )
ROI % 28

**Alex Vaile** · 07-18-15, 12:44 AM

Today's results: 5-0 + 5.05 units
Season to date : 229-208 + 16.16 units

Everyone won! Nice start to second half.

Brewers, Giants over, Cards under, Red Sox under and Astros all winners.