2015 SDQL Baseball Thread

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

Play Tigers - 105

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

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

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

Play Under 7 - 110 Orioles vs Astros

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)

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

Play Rays + 108

team=Rays and A and p:W and p:HR>=3 and date>=20130720

team=Rays and -120<=line<=120 and p:W and po:BL>0 and season>=2015

Seattle is 0-6 SU after a home loss in which they had a higher team-left-on-base than their opponent, scoring an average of 2.0 runs per game and 0-5 at HOME after a loss in which their starter went eight-plus innings. (MTI)

posey · 06-04-15, 01:56 PM

I am back from a heavy workload and some holidays.

Record: 33-25, +11.13 u.

6/4

Twins +133

.7 >= tA(W, N=10) >= .6 and streak = 1 and AD and oA(W, N=10) = .3
SU: 73-65, ROI: +19.8% / -18.8%

posey · 06-04-15, 02:08 PM

Phillies -103

.6 >= tA(W, N=10) >= .4 and streak = -2 and A and .3 >= oA(W, N=10) >= .2 and -125 <= line <= 125
SU: 45-73, ROI: -24.0% / +19.0%

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

Originally posted by Alex Vaile

Play Tigers - 105

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

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

That didn't go too well. Tigers terrible right now. 2 teams going in opposite directions

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

Originally posted by posey

I am back from a heavy workload and some holidays.

Record: 33-25, +11.13 u.

6/4

Twins +133

.7 >= tA(W, N=10) >= .6 and streak = 1 and AD and oA(W, N=10) = .3
SU: 73-65, ROI: +19.8% / -18.8%

Welcome back buddy!

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

Tonites NBA play. Warning these guys have been cold in the NBA playoffs.

Cleveland +6 over GOLDEN ST -- The Warriors are 0-7 ATS (-7.57 ppg) as a home favorite after a win as a home favorite and the league is a whole is 0-10 ATS in the playoffs off a win in which they scored fewer points than expected. The SDQL text is:

playoffs=1 and HF and p:dps<0 and p:W and date>=20150420

In the playoffs, NBA teams are 10-0 ATS on the road with two or more days of rest off a win in which at least 6 players scored 10 or more points. The SDQL text is:

playoffs=1 and A and rest>=2 and p:W and p

DS>=6 and date>=20120503 (MTI)

posey · 06-04-15, 02:45 PM

Mets RL +131

AF and C and .4 <= oA(W, N=10) <= .5 and .5 <= tA(W, N=10) <= .6 and SG = 1 and month > 4 and line < -120 and 7.5 < total < 10 and season > 2008
RL: 35-29, ROI: +19.2% / -18.8%

Thx, Alex!

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

Play Twins + 155

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 op:BPRA<4 (Bases)

ROI % 26

posey · 06-04-15, 02:59 PM

Cardinals +102

HF and oA(W, N=10) >= .7 and total < 8 and line > -116 and ou streak > 0 and day != Tuesday
SU: 17-28, ROI: -28.4% / +25.3%

That's it for today. BOL!

inZane · 06-04-15, 07:08 PM

Welcome back, posey. Nice hits today, Alex. I appreciate your time and posts...

posey · 06-05-15, 02:51 AM

Originally posted by posey

6/4

Twins +133 - W +1.33 u
Phillies -103 - L -1.00 u
Mets RL +131 - PUSH (Pitcher Change Dbacks) - +-0.00 u
Cardinals +102 - W - +1.02 u

Yesterday: 2-1, 1.35 u.

Overall Record: 35-26, +12.45 u.

posey · 06-05-15, 03:44 AM

Overall Record: 35-26, +12.45 u.

6/5

Mets @ Dbacks Under 9 +107

tA(hits, N=10) + tA(walks, N=10) >= 14 and .4 <= tA(W, N=10) <= .5 and HF and SG > 1 and p:runs < 5 and line > -150 and total > 7.5
OU: 27-47-2, ROI: -29.3% / +20.9%

posey · 06-05-15, 04:10 AM

Rangers @ Royals Under 8 -110

tA(hits, N=10) + tA(walks, N=10) <= 10 and HF and tA(W, N=10) < .5 and SG = 1 and line < -125 and total > 6.5 and NGT and 4 < month < 8
OU: 28-51-4, ROI: -29.4% / +22.0%

posey · 06-05-15, 04:25 AM

Giants @ Phillies Under 8 -105

C and streak = -5 and rest > 0 and A
OU: 9-18-3, ROI: -33.4% / +24.3%

posey · 06-05-15, 04:32 AM

Cards +111
Cards @ Dodgers Over 6.5 -130

streak > 0 and SG > 1 and AD and tA(W, N=10) > .7 and season > 2009 and p

u margin > 0 and line <= 120 and month < 9
SU: 23-17, ROI: +18.4% / -20.5%
OU: 24-14-2, ROI: +20.5% / -28.5%

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

Yesterday's results : 3-2 + 1.58 units
Season to date : 113-104 + 7.81 units

Twins, Rays and Houston under winners and Reds under and Tigers losers

Alex Vaile · 06-05-15, 09:22 AM

Today's plays :

Play Indians -128
Play Reds - 110

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

Alex Vaile · 06-05-15, 09:36 AM

Play Mariners even

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

ROI % 24

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

Play Twins -135
Play Twins Under 8 -105

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

ROI % 7.7 with 800 sample size

Alex Vaile · 06-05-15, 09:52 AM

Play Under 8.5 - 105 Tigers vs White Sox
Play Under 8 -105 Angels vs Yankees

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)

ROI % 52 only 18 game sample but on fire for unders and sides.

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

Originally posted by posey

Cards +111
Cards @ Dodgers Over 6.5 -130

streak > 0 and SG > 1 and AD and tA(W, N=10) > .7 and season > 2009 and p

u margin > 0 and line <= 120 and month < 9
SU: 23-17, ROI: +18.4% / -20.5%
OU: 24-14-2, ROI: +20.5% / -28.5%

I have a solid query pointing to under on this one.
I tailed your cards pick yesterday. Thanks!

Alex Vaile · 06-05-15, 10:18 AM

Originally posted by inZane

Welcome back, posey. Nice hits today, Alex. I appreciate your time and posts...

Here's to a winning day! Thanks!

acehole · 06-05-15, 11:58 AM

good thread here...thanks guys

nash13 · 06-05-15, 12:40 PM

Wanted to contribute here, been busy lately.
Here is one very nice trend active today:
D and p

and p:W and p:runs <= 3
Orioles 107
Rays -103
Cubs 112

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

Originally posted by nash13

Wanted to contribute here, been busy lately.
Here is one very nice trend active today:
D and p

and p:W and p:runs <= 3
Orioles 107
Rays -103
Cubs 112

Right on thanks Nash

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

Originally posted by Alex Vaile

Today's plays :

Play Indians -128
Play Reds - 110

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

Reds no play due to pitching change!

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

Today's results: 1-5 -4.73 units
Season to date : 114-109 + 3.08 units

White Sox under winner, Twins and Twins Under, Angels under, Mariners and Indians losers ouch.

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

Tomorrow's plays :

Play Athletics - 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 37 %

More support for A's:
team=Athletics and AD and p:L and p:errors>=3

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

Play Under 9 - 115 Astros vs Blue Jays

team=Blue Jays and HF and p:W and DAY and day=Saturday

10-30 over under

team=Astros and AD and p:L and DAY and day=Saturday

10-14 over under.

posey · 06-06-15, 03:16 AM

Originally posted by posey

6/5

Mets @ Dbacks Under 9 +107 - PUSH - +-0.00 u.
Rangers @ Royals Under 8 -110 - WIN - +0.91 u.
Giants @ Phillies Under 8 -105 - LOSS - -1.00 u.
Cards +111 - WIN - +1.11 u.
Cards @ Dodgers Over 6.5 -130 - LOSS - -1.00 u.

Yesterday's Record: 2-2, +0.02 u.

Overall Record: 37-28, +12.47 u.

posey · 06-06-15, 04:03 AM

Overall Record: 37-28, +12.47 u.

6/6

Angels @ Yankees Under 8 -117
p:LOB > 10 and p:runs > 6 and 0 > p:margin > -3 and SG > 1 and AD and total < 9 and line < 145 and month < 9 and C
OU: 7-21-2 (-1.43, 25.0%) avg total: 8.0 over / under: -$1,630 / +$1,355 ROI: -48.7% / +41.6%

po:BL = 0 and p:margin < 2 and p

u margin > 2 and SG > 1 and H and 140 > line > -150 and total < 9
OU: 5-18-2 (-1.70, 21.7%) avg total: 7.7 over / under: -$1,510 / +$1,285 ROI: -53.5% / +47.9%

posey · 06-06-15, 04:39 AM

Small sample, but devastating ROI.

Rays +157
Rays +RL -140
starter = Felix Hernandez and -140 > line > -200 and HF and p:HL and C
SU: 7-12 (-0.63, 36.8%) avg line: -165.7 / 154.6 on / against: -$1,286 / +$1,146 ROI: -40.9% / +60.3%
RL: 5-11 (-1.62, 31.2%) avg line: 134.2 / -147.0 on / against: -$436 / +$370 ROI: -27.2% / +15.7%

(I only play Rays +RL.)

posey · 06-06-15, 05:06 AM

Rangers @ Royals Under 8 -113
p:PU=1 and SG > 1 and D and p

and p:runs allowed < 1 and 10 > total > 7 and 200 > line and season > 2007 and (STDSERA > 3.5 or o:STDSERA > 3.5)
OU: 12-25-2 (-0.96, 32.4%) avg total: 8.4 over / under: -$1,485 / +$1,170 ROI: -35.2% / +26.8%

team = Royals and po:PU = 1 and SG > 1 and total < 8.5
OU: 2-9-2 (-1.88, 18.2%) avg total: 7.6 over / under: -$830 / +$685 ROI: -55.9% / +49.8%

team = Rangers and p:PU = 1 and SG > 1 and 6.5 < total < 10 and month > 4
OU: 8-17-0 (-1.24, 32.0%) avg total: 8.4 over / under: -$1,040 / +$815 ROI: -38.3% / +29.3%