2015 SDQL Baseball Thread

Alex Vaile · 06-22-15, 07:56 AM

Yesterday's results: 1-2 - 1.35 units
Season to date : 161-156 + .42 units

Nationals winner and Red Sox under and Arizona under losers.

Alex Vaile · 06-22-15, 05:04 PM

Today's plays:

Play Rays - 117

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

(Bases)
ROI % 24

inZane · 06-22-15, 05:07 PM

Good luck, Alex, thanks for the posts...

Alex Vaile · 06-22-15, 05:10 PM

Play Dodgers RL - 1.5 - 120

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.7

Alex Vaile · 06-22-15, 05:14 PM

Play Over 7.5 -110 Astros 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 % 26 but fading it today

Normally an under query this one has gone over 11 out of last 12 games so over it is!

Alex Vaile · 06-22-15, 05:14 PM

Originally posted by inZane

Good luck, Alex, thanks for the posts...

Right on inzane. Good luck today!

inZane · 06-22-15, 05:31 PM

I like a lot of overs tonight; Stros, Chubs, Tribe, Rays, and Yanks. Hopefully, hit 4 out of 5...

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

Play Tigers + 127

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

ROI % 11

Alex Vaile · 06-22-15, 07:48 PM

Originally posted by inZane

I like a lot of overs tonight; Stros, Chubs, Tribe, Rays, and Yanks. Hopefully, hit 4 out of 5...

You are well on your way Yankees rays and Indians looking good

Alex Vaile · 06-23-15, 07:46 AM

Yesterday's results : 1-3 - 2.2 units
Season to date : 162-159 -1.8 units

Detroit winners and Dodgers RL, Angels over and Rays losers.

Alex Vaile · 06-23-15, 07:55 AM

Today's plays :

Play Padres + 175

(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

I have 2 queries favoring Giants but I'm going with Dog today.

Alex Vaile · 06-23-15, 07:59 AM

Play Yankees - 1.5 -125

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

ROI % 18

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

Play Marlins + 133 (2 unit play)

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 )

ROI % 14 this query has won 11 in a row.

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

Play Orioles + 104
Play Twins + 105
Play Tigers + 102

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

ROI % 11

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

Play Blue Jays + 142

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-24-15, 05:00 AM

Yesterday's results : 3-4 - 1.44 units
Season to date : 165-163 -3.24 units

Padres, Orioles, Tigers winners and Marlins 2 unit, Yankees RL, Jays and Twins losers.

Alex Vaile · 06-24-15, 05:37 AM

Today's plays :

Play Mariners - 104

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

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

Play Tigers + 155

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

Play Under 8 - 105 Tigers vs Indians

team=Indians and HF and p:L and pp:L and SG=3 and SGS=3 and DAY

team=Tigers and AD and p:W and pp:W and SG=3 and SGS = 3 and DAY

team=Indians and HF and p:L and p:margin>= -4 and DAY

These teams been scoring lots of runs but have a tendency to go under in Day games. Also no Miggy for Tigers maybe that helps.

Alex Vaile · 06-24-15, 10:36 AM

Play Padres + 116

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

Alex Vaile · 06-24-15, 10:37 AM

Play Orioles + 133

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

ROI % 11

Alex Vaile · 06-24-15, 10:38 AM

Play Padres vs Giants Under 7 - 110

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 · 06-24-15, 10:47 AM

Play Phillies + 131

Sum(hits@team and season)/Sum(at bats@team and season)<=.250 and conference=NL and p:runs>=8 and pp:runs>=8 and 2006<=season and 150>=line>=-250 and SG<4

(JMon)

ROI % 41

Alex Vaile · 06-24-15, 03:25 PM

Play Rockies -120

1.8 > tA(runs, N=10) - oA(runs, N=10) > -.2 and H and tA(hits, N=10) - oA(hits, N=10) < 2.2 and 3 < s:SRA < 8 and s:SWA < 6 and os:SRA < 7 and 15 > op:hits > 9 and 1.7 > oA(HR, N=10) > .6 and SG < 3 and line < 115 and os:SPT > 75 and 4 < starter rest < 7 and o:starter rest < 7 and day != Saturday and tA(doubles, N=10) < 2.8 and tA(SO, N=10) > 5.4 and STDSWHIP > 1.04

ROI % 32

Alex Vaile · 06-25-15, 09:29 AM

Yesterday's results : 1-7 - 5.29 units
Season to date : 166-170 - 8.53 units

Giants under winner and the rest losers. Gotta turn this around. Too many plays. Gonna b more selective get back in the positive.

Alex Vaile · 06-25-15, 09:32 AM

First play :

Play Under 7 -125 Padres vs Giants

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)

Play Giants - 124

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

And

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

Alex Vaile · 06-25-15, 09:35 AM

Play Arizona + 106

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

And

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

JMon · 06-25-15, 10:02 AM

Cardinals are 9-23 since 08 trying to close out a three game series on the road.

A and p:W and pp:W and SG=SGS=SG=3 and team=Cardinals and 2008<=season

Alex Vaile · 06-25-15, 10:39 AM

Play Cubs -132

s:SSO = 2 and 5.4 > s:SIP > 4.9 and 11 > s:SHA > 4 and s:SWA < 4 and 20 < s:SHF < 26 and 4 < starter rest < 7 and (A or SG != 2) and day != Saturday and day != Tuesday and starter wins != 1 and starter wins - starter losses > -7 and op:margin > -8

( Bases )
ROI % 28

Alex Vaile · 06-25-15, 10:40 AM

Originally posted by JMon

Cardinals are 9-23 since 08 trying to close out a three game series on the road.

A and p:W and pp:W and SG=SGS=SG=3 and team=Cardinals and 2008<=season

What's up JMon. Nice to see u over here!

Alex Vaile · 06-26-15, 09:50 AM

Yesterday's results : 1-3 - 2.57 units
Season to date : 167-173 - 11.1 units

Giants win and everything else lost.
cubs
dbacks
Giants under

Alex Vaile · 06-26-15, 09:53 AM

Today's plays :

Play Houston - 104

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

Alex Vaile · 06-26-15, 09:56 AM

Play D-Backs + 132

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

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

Alex Vaile · 06-26-15, 09:59 AM

No play on Rays. A lot of conflicting info.

Alex Vaile · 06-26-15, 10:01 AM

Play Cardinals - 116

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

Alex Vaile · 06-26-15, 10:42 AM

Play White Sox + 141

starter=Anibal Sanchez and HF and o:team=White Sox and NGT
starter =Jose Quintana and AD and o:team=Tigers and NGT
starter=Anibal Sanchez and HF and season>=2014
starter=Jose Quintana and AD and season>=2014 and NGT
team=Tigers and HF and SG=2 and p:HFL

I have a query supporting Tigers thats profitable but gonna go against it here as I think White Sox can win in Detroit. Line pretty high and Sanchez either lights oit or hittable. Im saying hittable tonite.