2015 SDQL Baseball Thread

Alex Vaile · 06-12-15, 12:59 AM

Tomorrow's plays :

Play Under 8 - 115 Nats vs Brewers

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 ( bking )

Alex Vaile · 06-12-15, 01:05 AM

Play Cubs - 125

s:SIP = 8 and 0 < s:SRA < 3 and s:SSO > 3 and 0 < s:SWA < 5 and s:SHF < 34 and starter rest < 7 and 3 < s:SHA < 6 and (A or day != Saturday) and (A or SG < 4) and line < 147 and 2 < p:hits < 16 and op:margin > -9 and game number < 154 ( Bases )

ROI % 26

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)
( Bases )

ROI % 26

Alex Vaile · 06-12-15, 01:06 AM

Play Mets - 125

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)
( Bases )

ROI % 26

Alex Vaile · 06-12-15, 01:08 AM

Play Marlins - 130

H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month != 7 and month != 8) and 2008 <= season and SG > 1 and total > 6.5
( JMon )

ROI % 17

Alex Vaile · 06-12-15, 01:12 AM

Play Orioles + 105
Play Orioles Under 8 - 120

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 ( emceeaye )

Alex Vaile · 06-12-15, 01:14 AM

Play Indians + 125

(s:SPT + ss:SPT) > 222 and s:SPT > 96 and ss:SPT < 132 and 58 < sss:SPT < 123 and s:SHA < 8 and s:SRA < 6 and ss:SRA < 7 and sss:SRA < 6 and ss:SHA > 3 and 7 > s:SWA > 0 and ss:SWA < 6 and sss:SWA < 4 and starter rest < 9 and s:starter rest < 8 and s:SSO > 3 and 12 > ss:SSO > 2 and total < 11 and p:hits < 16 and 19 > pp:hits > 3 and 1 < ppp:hits < 22 and streak < 6 and ou streak > -5 and game number > 30 and 8 > os:SRA > 0 and 14 > o:starter rest > 4 and 23 > os:starter rest > 3 and 24.5 > (s:SIP + ss:SIP + sss:SIP) > 16 and (os:SIP + oss:SIP + osss:SIP) > 11.35 and o:streak < 5 and oA(hits, N=10) < 11 and tA(doubles, N=10) < 2.9 and tA(BPRA, N=10) < 2.5 and oA(BPRA, N=10) > .4
( Bases )

ROI % 32

escism · 06-12-15, 11:18 AM

Nice man! I'm loving it! What's your record looking like thus far this year?

Alex Vaile · 06-12-15, 11:50 AM

Originally posted by escism

Nice man! I'm loving it! What's your record looking like thus far this year?

Season to date : 135-128 + 4.39 units

Alex Vaile · 06-12-15, 06:57 PM

Play Under 7 -120 Royals 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 % 29

inZane · 06-12-15, 08:11 PM

Originally posted by Alex Vaile

Play Under 7 -120 Royals 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 % 29

Was on it before I saw this, good luck Alex and thanks again for your work...

LtDarsh · 06-12-15, 09:55 PM

Thanks for the Under in Royals game,

Alex Vaile · 06-13-15, 12:25 AM

Right on guys I'm glad u were able to cash on something.

Alex Vaile · 06-13-15, 12:27 AM

Today's results: 4-4 - .55 units
Season to date : 139-132 + 3.84 units

Orioles, Mets, Royals under and Marlins winners and Indians, Orioles under, Cubs, and Nats under losers!

Alex Vaile · 06-13-15, 12:58 AM

Saturday's plays:

Play Astros -138
Play Tigers - 105

H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month != 7 and month != 8) and 2008 <= season and SG > 1 and total > 6.5
( JMon )

ROI % 17

Alex Vaile · 06-13-15, 01:04 AM

Play Rockies + 125

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
( Bases )

ROI % 45

Alex Vaile · 06-13-15, 10:09 AM

Play Under 7.5 - 115 Reds 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 · 06-13-15, 10:24 AM

Play Mets RL - 1.5 + 155

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)

( Bases )

ROI % RL 17

and

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 % RL 19

Alex Vaile · 06-13-15, 10:30 AM

Play Orioles - 105

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

Alex Vaile · 06-14-15, 12:29 AM

Today's results: 2-4 - 2.43 units
Season to date : 141-136 + 1.41 units

Orioles and Cubs under winners and Rockies, Tigers, Astros and Mets RL losers.

Alex Vaile · 06-14-15, 01:28 AM

Sunday's plays:

Play Under 7.5 - 110 D-Backs vs Giants
Play Under 7 - 120 Padres vs Dodgers

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 · 06-14-15, 01:30 AM

Play Under 7 - 110 Athletics vs Angels

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

Alex Vaile · 06-14-15, 02:28 AM

Play Nationals RL - 1.5 + 110

175>=line>=125 and Sum(hits@team and season)/Sum(at bats@team and season)<=.250 and os:starter era<=3.7 and o:conference=NL and Average(starter hits@starter and season)<=5.5 and 2008<=season
(Jmon )

ROI % 9

Alex Vaile · 06-14-15, 12:42 PM

Play Reds + 141

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

Alex Vaile · 06-14-15, 04:59 PM

The Warriors are 0-11 ATS since the start of the 2010 NBA season at home when they are off a win and Steph Curry shot better than 50% from the arc in each of their last two games. The SDQL text is:

H and Stephen Curry

p:TPP>50 and Stephen Curry

:TPP>50 and p:W and season>=2010

Note that the Warriors have fallen short of the number by an average of 12.1 ppg in this spot and they are 0-4 ATS in this spot this season.

The Cavaliers are 7-0 ATS after a home game in which Lebron James scoring dropped by at least 15 points over his previous game and the Cavs are a perfect 10-0 in 2015 on the road after a game in which Lebron played more than 38 minutes and made fewer than ten free throws. The SDQL text is:

A and Lebron James

:minutes>38 and Lebron

:FTM<10 and date>=20150000

The Cavs won every game straight up, despite being the dog in five of the ten games.

In the history of our database there have only been three playoff games in which a team is at home off a 20-plus point win that evened the series at two games each. They were favored every time and they are 0-3 ATS and 1-2 straight up with the lone win by a single point in overtime.

Alex Vaile · 06-15-15, 12:23 AM

Today's results: 3-2 + 1 unit
Season to date: 144-138 + 2.41 units

Nats RL, Giants under, pads under winner and Reds and A's under losers.

Alex Vaile · 06-15-15, 10:44 AM

Today's plays:

Play Under 7 - 115 Nats 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

and

Play Under 8 - 110 Braves vs Red Sox

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 ( bking )

Alex Vaile · 06-15-15, 12:12 PM

Play Rockies + 170

team=Rockies and line>=170 and SG=1 and p:W and p:LOB>=18

team=Astros and H and p:H and SG=1 and po:BL=0 and date>=20120518

Houston is also 0-7 in the first game of a home series after shutting out their opponent at home and 0-8 SU as a FAVORITE in the first game of a home series after a home win. (MTI)

Alex Vaile · 06-15-15, 05:34 PM

Play White Sox + 170

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)

( Bases )

ROI % 25

Alex Vaile · 06-15-15, 06:35 PM

Originally posted by Alex Vaile

Play White Sox + 170

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)

( Bases )

ROI % 25

Wow looks terrible. Down 5 to 0 first inning.

Conqueror · 06-15-15, 06:37 PM

Originally posted by Alex Vaile

Wow looks terrible. Down 5 to 0 first inning.

Funny I did White Sox -1 (+247). That's already a loss right in the 1st inning.

Alex Vaile · 06-16-15, 07:45 AM

Originally posted by Conqueror

Funny I did White Sox -1 (+247). That's already a loss right in the 1st inning.

Ya that sucked!

Alex Vaile · 06-16-15, 07:49 AM

Yesterday's results : 1-2-1 -1 unit
Season to date : 145-140 +1.41 units

Braves under winners and White Sox and Rockies losers and Nats under push.

Alex Vaile · 06-16-15, 07:51 AM

Today's plays :

Play Braves + 140

month = 6 and F and o:streak = 1 and SG != 1 and -120 > line and os:SRA < 7 and oss:SRA < 9 and s:SRA < 8 and ss:SRA != 0 and site streak < 6 and p:margin > -4
( Bases )

ROI % 33

Alex Vaile · 06-16-15, 10:33 AM

Play Under 9 - 110 Dodgers vs Rangers

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 · 06-17-15, 01:15 AM

Today's results : 1-1 even
Season to date : 146-141 + 1.41 units

Rangers under winner and Braves losers