2015 SDQL Baseball Thread

[Alex Vaile]

Play Astros - 210
Play Astros RL - 110

team=Astros and HF and p:HR>=2 and date>=20150615

Astros 10 -0 in this spot
9-1 against the RL

[UNLV34]

Nice to have some company in here bud. Good finds!

Thanks Alex. Trying to learn from everyone here. We're all trying to make a dollar out of 0.15

[UNLV34]

Play Mets - 110

team=Pirates and -120<=line<=120 and SG=1 and p:margin>-8 and date>=20120824

( Dr.M )
ROI % 30

I like this today. After tweaking this game, I found this interesting:

team=Mets and SG = 1 and HF and p:W and o:team = Pirates and season >= 2006

Looks like the Mets are 5-0 in Game 1 as a HF against the Pirates since 2006 AND every game has gone OVER to date.

[Alex Vaile]

Play Athletics vs Orioles Under 8.5 - 120
Play Orioles - 177

Juicy but this query is 20-2 this season ML

A and line>135 and p:BL=0 and pp:BL=0 and SG<SGS and (p or pp) and date>=20130423

( Dr.M )
ROI % 9.6

[Alex Vaile]

I like this today. After tweaking this game, I found this interesting:

team=Mets and SG = 1 and HF and p:W and o:team = Pirates and season >= 2006

Looks like the Mets are 5-0 in Game 1 as a HF against the Pirates since 2006 AND every game has gone OVER to date.

Ya i noticed that as well. Nice tweak for Mets support!

[Alex Vaile]

Thanks Alex. Trying to learn from everyone here. We're all trying to make a dollar out of 0.15

Exactly.

[b1slickguy]

Fading Red Sox. Since the release of the Boston-set movie Good Will Hunting in 1997, the Red Sox have gone winless on Good Will Hunting star Ben Affleck’s birthday.
Good luck.

int(str(date)[4:])=815 and team=Red Sox

[Alex Vaile]

Fading Red Sox. Since the release of the Boston-set movie Good Will Hunting in 1997, the Red Sox have gone winless on Good Will Hunting star Ben Affleck’s birthday.
Good luck.

int(str(date)[4:])=815 and team=Red Sox

Thanks for the reminder slick!

[Alex Vaile]

Today's results : 4-5 -. 95 units
Season to date : 319-305 + 6.88 units

Astros ML and RL winners, Orioles and Giants winners and Jays RL and Jays over, Twins, Mets and Orioles under losers.

Jays almost had that one man crowd was jumping and the ump gave Miller some favorable pitches there in the 9th.

[Alex Vaile]

Saturday's plays:

Play Braves + 139

H and 5.7 >= ts:starter era >= 5.2 and conference = NL and o:conference = NL and Sum(o:starter hits + o:starter walks@o:starter and o:season) / Sum(o:starter innings pitched@o:starter and o:season and o:season = season) <= 1.25 and line <= 180 and SG < 3 and rest = 0 and 2008 <= season

( Jmon )
ROI % 31

[Alex Vaile]

Play Mets - 109
Play Mets RL + 200

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 % 23 ML
ROI % 15 RL

[Alex Vaile]

Play Under 8 - 110 Phillies vs Brewers
Play Under 7 - 109 Marlins vs Cardinals
Play Under 7.5 + 105 Pirates vs Mets

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

[Alex Vaile]

Play Giants + 101

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]

Play Over 6.5 - 120 Nationals vs Giants

team=Nationals and A and p:A and po:runs>=6 and date>=20140829

(SDQG )

Nats over 18 and 0 in this spot since last season.

[Alex Vaile]

Play Twins - 113

t:team=Indians and -120<=line<=120 and DIV and p:W and WP<o:WP and date>= 20120929

(SDQG )

Indians 0 and 13 in this spot.

[Alex Vaile]

Play White Sox + 107

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

[Alex Vaile]

Play Rangers + 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 )
ROI % 32

[wwtpglobal]

Great work AV...Thanks...

[Alex Vaile]

Today's results 5-6 - 1.02 units
Season to date: 324-311 + 5.86 units

Giants ML and over, Brewers Under, Twins and Rangers winners and Mets ML, RL and under, Cards under, White Sox and Braves losers.
Mets burned me in late innings 2 days in a row.

[Alex Vaile]

Great work AV...Thanks...

Thanks Global been close to good winning days but been giving it back since being up 17 units. Been a roller coaster. Nice to hit a few dogs.

[Alex Vaile]

Sunday's plays:

Play Yankees vs Blue jays Under 9 -120

season = 2015 and team = Blue Jays and division = o:division and H

( excism )
ROI % 26

[Alex Vaile]

Play Over 6.5 - 125 Nationals vs Giants

team=Nationals and A and p:A and po:runs>=6 and date>=20140829

( SDQG )

Now 19 and 0 on the season.

More support

p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < ou streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

( Bases )
ROI % 20

[Alex Vaile]

Play Over 8 - 110 Angels vs Royals

p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < ou streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

( Bases )
ROI % 20

[Alex Vaile]

Play Twins + 134

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

( excism )
ROI % 23

And

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

ROI % 10

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

[Alex Vaile]

Play Detroit vs Houston Over 8 - 105

line<=-155 and Sum(hits@team and season)/Sum(at bats@team and season)<=.265 and t:conference=AL and os:earned runs<=1 and total<9.5 and SG<4 and season=2015

(JMon)
ROI % 18 but is 4/0 over/ under on Sundays this season

[Alex Vaile]

Play Mariners + 102

team=Mariners and D and p:L and po:walks>=5 and date>=20140916

11-0 as a dog after a loss allowing 5 or more walks

team=Mariners and A and SG>1 and p:L and po:LOB>=18 and season>=2014

11-0 on road when opponent leaves more than 18 on base

team=Mariners and D and p:A and
p:margin<=-2 and date>=20140600

15-1 as a dog after a multiple run loss including 9-0 this season

(MTI)

[Alex Vaile]

Play Rockies - 105

team=Rockies and -120<=line<=120 and p:HL and p:BL>0 and date>=20140806

Rocks 10-0 in this spot

team=Rockies and H and LGS and DIV and o:WP>WP and line<170 and date>=20140709

(MTI)

Rocks 8-0 in this spot

[Alex Vaile]

Play Royals - 129

team=Royals and H and p:W and po:BL>0 and date>=20150707

7-0 after a comeback win this season

team=Angels and A and p:L and pp:L and op:W and opp:W and date>=20140928

Angels 0-10 when on a 2 game losing streak and opponent on a 2 game winning streak.

Lastly the Angels are 0-11 as a dog in the last game of a series after a loss in which they used five-plus pitchers, getting beat by an average of 3.73 runs per game.

(MTI)

[Alex Vaile]

Today's results 6-2 + 4.02 units
Season to date: 330-313 + 9.88 units

Seattle, Minnesota, Jays Under, Houston over, Royals and Rockies winners and Royals over and Giants over losers. Solid day!

[Alex Vaile]

Monday's plays:

Play Pirates - 203
Play Pirates RL + 105

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 % ML 25
ROI % RL 18

[Alex Vaile]

Play Padres - 152

t:team = Braves and AD and SG=1 and p:W and date>=20140429

(SDQG )

Braves 0 and 11 in this spot.

[Alex Vaile]

Play Over 7 + 102 Giants vs Cardinals
Play Giants RL - 165


starter=Michael Wacha and HF and SG = 1
starter = Christopher Heston and AD and SG=1
starter = Christopher Heston and AD
team=Giants and AD and p:W and season=2015
team=Cardinals and HF and p:L and p:margin>=-2 and season=2015

Giants tendencies are over and Cards tendencies under but I can't ignore Heston's away record and totals. Hope it hits!

[Alex Vaile]

Play Under 8 - 105 Marlins vs Brewers

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

[Alex Vaile]

Play Mariners + 124
Play Mariners vs Rangers Over 8.5 - 115

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

( Excism )
ROI % ML 30
ROI % o/u 18

[Alex Vaile]

Yesterday's results : 2-5-1 - 4.18 units
Season to date : 332-318 + 5.7 units

Giants RL and Pads won, Pirates game was a killer 3 unit loss and Mariners and over lost and Giants over lost. Sh t day!