2015 SDQL Baseball Thread

Alex Vaile · 05-29-15, 08:47 AM

Play Twins - 115

WP>12+o:WP and s:starter strike outs>=.81*so:hits and s:A and HF and season>=2010 and s:SRA<6 and tA(BPRA, N=6)<2 and s:SPT/s:SIP<=15 and s:SPT/so:at bats<3.9 (emceeaye)

Alex Vaile · 05-29-15, 08:53 AM

Giants - 144

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 )

Alex Vaile · 05-29-15, 08:58 AM

Play Tigers - 105
Play Tigers Under 8 -115

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

Alex Vaile · 05-29-15, 09:00 AM

Play Red Sox even

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 )

inZane · 05-29-15, 04:20 PM

Good luck, Alex. Thanks for the post.

What happened to Posey, was he a bad boy again?

2buckluck · 05-29-15, 04:37 PM

Originally posted by inZane

Good luck, Alex. Thanks for the post.

What happened to Posey, was he a bad boy again?

Yeah good job Alex!
Naw, I remember Posey said in the Dog of the Day thread he'd be busy with work for a week or 2 ...

Alex Vaile · 05-29-15, 05:03 PM

Lot of plays today.

I'll do what I can to keep the plays coming. Thanks and good luck to all!

melikman29 · 05-29-15, 08:24 PM

Don't you think your system creates too many plays a night? Anyway to be able to create a way of signifying by units what play is better than another?

Alex Vaile · 05-29-15, 11:24 PM

Originally posted by melikman29

Don't you think your system creates too many plays a night? Anyway to be able to create a way of signifying by units what play is better than another?

Everyday is different based on how many queries are active. Also u can learn about SDQL by taking the next step and running the queries for yourself after I post them. The ROI % is an indicator of strength of a query. The higher the % the more successful that query is. It's up to you how much to bet and on what. I have learned it's best to flat bet as the baseball season is long and there are many ups and downs along the way. I am not here to tell u how many units to bet. I post queries and plays and track them. Up to you to do the rest. Also you are welcome to contribute anytime. Best of luck!

Alex Vaile · 05-29-15, 11:24 PM

2 terrible endings for Twins and Astros.

Alex Vaile · 05-30-15, 01:11 AM

Today's results: 2-5 - 3.55 units
Season to date: 100-90 + 9.01 units

Giants and Tigers under winners and Astros, Tigers, Twins, Red Sox and Dodgers losers.

Alex Vaile · 05-30-15, 09:43 AM

Today's plays :

Play Royals - 108
Play White Sox + 165
Play D-Backs + 126
Play Rays + 129

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. Anything over 20 is great. Good luck.

Alex Vaile · 05-30-15, 09:47 AM

Play Under 8.5 -110 Rays vs Orioles

Also more support for Rays.
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

melikman29 · 05-30-15, 10:16 AM

Originally posted by Alex Vaile

Everyday is different based on how many queries are active. Also u can learn about SDQL by taking the next step and running the queries for yourself after I post them. The ROI % is an indicator of strength of a query. The higher the % the more successful that query is. It's up to you how much to bet and on what. I have learned it's best to flat bet as the baseball season is long and there are many ups and downs along the way. I am not here to tell u how many units to bet. I post queries and plays and track them. Up to you to do the rest. Also you are welcome to contribute anytime. Best of luck!

Thanks for the reply and good luck this season!

Alex Vaile · 05-30-15, 10:17 AM

Play Athletics - 125

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

Alex Vaile · 05-30-15, 10:30 AM

Play Twins -120

WP>12+o:WP and s:starter strike outs>=.81*so:hits and s:A and HF and season>=2010 and s:SRA<6 and tA(BPRA, N=6)<2 and s:SPT/s:SIP<=15 and s:SPT/so:at bats<3.9( emceeaye)

ROI 10 %

Alex Vaile · 05-31-15, 01:00 AM

Today's results: 4-2 + 2.3 units
Season to date: 104-92 + 11.31 units

Twins, Rays, Rays under, D-Backs winners and White Sox and A's losers with Royals postponed.

Alex Vaile · 05-31-15, 10:14 AM

Today's plays :

Play Twins + 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 % 29

Alex Vaile · 05-31-15, 10:22 AM

Play Rangers + 101

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 · 05-31-15, 10:25 AM

Play Royals - 108
Play Rays - 113

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 · 05-31-15, 10:26 PM

Today's results : 3-1 + 2.01 units
Season to date : 107-93 + 13.32 units

Rays, Twins and Rangers winners and Royals losers in 11.

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

Today's plays :

Play Braves + 105

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

Alex Vaile · 06-01-15, 07:57 AM

Play Rays + 137

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-01-15, 02:41 PM

Play Under 7 - 115 Rays 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 % 29

Alex Vaile · 06-01-15, 04:27 PM

Play Giants +119

team=Giants and os:QS and oss:QS and SG=1 and date>=20140822

team=Giants and -120<=line<=120 and 6<=po:runs and p:L and date>=20140916

and 8-0 when their line is within 20 cents of pickem and their starter has a worse ERA than the opponents starter, as is evident with this SDQL text:

team=Giants and -120<=line<=120 and STDSERA>o:STDSERA and date>=20141007 (MTI)

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

Yesterday's results : 1-3 - 2.15 units
Season to date : 108-96 + 11.17 units

Braves winners, Giants, Rays and Rays under losers.

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

Today's plays :

Play Astros - 140
Play Cubs - 135
Play Mets -114

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

birdsfan · 06-02-15, 04:18 PM

team = Cardinals and H and p:runs = 0 and SG = 2 and season >= 2006
SU: 5-5 (0.60, 50.0%) avg line: -150.5 / 136.8 on / against: -$240 / +$165 ROI: -16.4% / +16.4%
RL: 3-6 (-1.50, 33.3%) avg line: 152.3 / -168.4 on / against: -$155 / +$95 ROI: -17.2% / +6.1%
OU: 8-1-1 (2.35, 88.9%) avg total: 8.2 over / under: +$700 / -$760 ROI: +62.5% / -70.4%

Alex Vaile · 06-02-15, 04:41 PM

Play Red Sox RL - 1.5 + 110

H and -8 > (starter wins - starter losses + o:starter losses - o:starter wins) > -14 and day != Wednesday and day != Thursday and day != Friday and 6 > s:SRA > 0 and p:hits < 13 and total > 6.5 and (1.4 > STDSWHIP>1.1 or tA(runs) > 4.8) (Bases)

ROI % 17

I know the Twins are hot but this line is crazy. I figure Sox snap out of it today.

Alex Vaile · 06-03-15, 05:02 AM

Yesterday's results : 1-3 - 2.49 units
Season to date : 109-99 + 8.68 units

Astros winners and Mets, Cubs and Red Sox RL losers.

Alex Vaile · 06-03-15, 05:08 AM

Play As vs Tigers Under 8 - 120
Play Rays vs Angels Under 7.5 - 120

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

Alex Vaile · 06-03-15, 05:11 AM

Play Under 7 - 105 Brewers vs Cardinals

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

Play Under 8.5 - 120 White Sox vs Rangers

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

1 o and 7 u this season

Alex Vaile · 06-04-15, 09:41 AM

Yesterday's results : 1-3 - 2.45 units
Season to date : 110-102 + 6.23 units

A's under winner, White Sox Under, Cardinal under and Rays under losers. Rough week!

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

Today's plays :

Play Under 7 - 105 Reds vs Phillies

month = 6 and season > 2009 and F and (SG = 2 or SG = 3) and day != Sunday and 14 > p:hits > 3 and 10.01 > total > 6.49 and op:hits < 17 and pp:hits < 12 and opp:hits > 3 and ppp:hits > 2 and 9 > os:SSO > 0 and oss:SSO < 7 and 15 > streak > -4 and 5 > o:streak > -6 and 10.01 > p:total > 6.49 and o

u streak > -5 and 2 > (tA(runs) + oA(runs) - total) > -.6 and team!=Astros and team!=Brewers and o:team!=Rockies and o:team!=Red Sox and o:team!=Marlins (Bases)