MLB - Situation Plays - SDQL

JMon · 08-12-14, 06:29 PM

Originally posted by emceeaye

Yes, it keeps doing that when I post unfortunately...I added some spaces and it is visible now in original post...what do you think?

I think the angels win, but juicy

Alex Vaile · 08-12-14, 07:29 PM

Originally posted by emceeaye

Here's an interleague game query favoring Indians and Angels. Despite WP, I'm skeptical of Angels due to CJ Wilson's horrible recent performances...

playoffs==0 and conference==NL and o:conference==AL and (site=='away' and -105 < line) and line > 154 and SG = 1

I totally agree with your assessment of Wilson. Hes just not been good

Alex Vaile · 08-12-14, 07:30 PM

A lot of great info in here guys. Good luck to all!

Alex Vaile · 08-13-14, 05:13 AM

Originally posted by Alex Vaile

I totally agree with your assessment of Wilson. Hes just not been good

Well I guess he was good enough tonight for the win I take it back.

Alex Vaile · 08-13-14, 05:15 AM

3 and 0 for +3.05 units
75 and 62 overall
+ 8.31 units.

inZane · 08-13-14, 07:32 AM

Great job, Alex. Good luck, today...

Alex Vaile · 08-13-14, 10:05 AM

Originally posted by inZane

Great job, Alex. Good luck, today...

Thanks. U as well. Im gonna start going through these games here.

emceeaye · 08-13-14, 10:35 AM

high WP query pointing to white Sox RL

Here's a query favoring White Sox RL, a team playing on the road that won first game of a series by less than 3 runs. In that game the opponent led by no more than 2. The starter in this 2nd game of the series allowed at least 5 combined hits and walks in his last start. However when you remove the hits + walks allowed in last start term, the WP isn't affected significantly. When you add that it is a 2-game series, and/or in August, and/or that the team won specifically by 1 run, then the the WP goes up but sample size gets smaller.

streak = 1 and A and SG=2 and day = Wednesday and playoffs = 0 and line > 107 and p:margin<3 and s:SHA + s:SWA > 5 and op:BL < 3

Add in that the previous game went into extra innings, and the WP goes down a little but WP still good.

JMon · 08-13-14, 11:01 AM

Originally posted by emceeaye

Here's a query favoring White Sox RL, a team playing on the road that won first game of a series by less than 3 runs. In that game the opponent led by no more than 2. The starter in this 2nd game of the series allowed at least 5 combined hits and walks in his last start. However when you remove the hits + walks allowed in last start term, the WP isn't affected significantly. When you add that it is a 2-game series, and/or in August, and/or that the team won specifically by 1 run, then the the WP goes up but sample size gets smaller.

streak = 1 and A and SG=2 and day = Wednesday and playoffs = 0 and line > 107 and p:margin<3 and s:SHA + s:SWA > 5 and op:BL < 3

like it! liked them on ml, but crossed it off due to conflict, but I'll play RL with you.

JMon · 08-13-14, 11:08 AM

Originally posted by JMon

Play Cubs

SDQL is

Average(runs@team and season) <= 4.3 and p:runs < 5 and pp:runs < 5 and ppp:runs < 5 and pppp:runs < 5 and line >= -105 and conference = o:conference and month != 7 and SG < 4 and season = 2014 and team=Cubs

Active again today on the Cubs..play them again if it loses we are still up + money on this spot/series

Alex Vaile · 08-13-14, 11:09 AM

First 3 plays: (Bases)

Under 6.5 - 105 Dodgers vs Braves
Under 7.5 - 110 Brewers vs Cubs
Under 7 -120 Nats 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)

JMon · 08-13-14, 11:09 AM

Daily report posted Indians in first game of a double header at home (nice results, but juiced)...looks tempting thoughts?

Alex Vaile · 08-13-14, 11:11 AM

Who has a query for red sox reds? Leaning sox

JMon · 08-13-14, 11:13 AM

Play Balt

Supporting SDQL (me, tarosil):

sA(SHRA) <= .5 and p:BPRA >= 4 and line>=-140 and SG>1

HF and p:margin>=7 and s:margin>0 and SG>1 and os:margin<0 and tS(runs, N=9)>oS(runs, N=9) and tA(BPRA, N=10) < oA(BPRA, N=10) and o:site streak > -8 and WP > 48

HF and p:margin > 6 and s:W and 1 < SG < 5 and os:L and tS(runs, N=9) >= oS(runs, N=9) and p:BPRA < 3

JMon · 08-13-14, 11:14 AM

Originally posted by Alex Vaile

Who has a query for red sox reds? Leaning sox

Had nothing on that game.

JMon · 08-13-14, 11:18 AM

Play Oak

Supporting SDQL:

p:margin<-6 and conference=AL and 11>=total>=7 and SG<4 and line>=-200 and rest=0

H and line >=100 and tA(HR) <= .9 and 1.4 >= STDSWHIP >= 1.3 and A(o:SHRA@o:starter and o:season) <= .5 and conference = AL and rest = 0 and SG<4

JMon · 08-13-14, 11:21 AM

Play Det

Interesting situation here fading the Pirates of two consecutive home wins, now playing on the road in det

SDQL

team=Pirates and A and p:HW and pp:HW and 20080527<=date

Alex Vaile · 08-13-14, 11:23 AM

Originally posted by JMon

Play Balt

Supporting SDQL (me, tarosil):

sA(SHRA) <= .5 and p:BPRA >= 4 and line>=-140 and SG>1

HF and p:margin>=7 and s:margin>0 and SG>1 and os:margin<0 and tS(runs, N=9)>oS(runs, N=9) and tA(BPRA, N=10) < oA(BPRA, N=10) and o:site streak > -8 and WP > 48

HF and p:margin > 6 and s:W and 1 < SG < 5 and os:L and tS(runs, N=9) >= oS(runs, N=9) and p:BPRA < 3

These look great thanks JMon.

emceeaye · 08-13-14, 11:26 AM

Originally posted by JMon

Daily report posted Indians in first game of a double header at home (nice results, but juiced)...looks tempting thoughts?

Heres support, but dbacks changed their starter, and we know nothing about him:

playoffs==0 and conference==NL and o:conference==AL and (site=='away' and -105 < line) and line>154 and season>2008 and SG=1

JMon · 08-13-14, 11:38 AM

Play Balt under

SDQL support (only two parameters)

p:errors>=3 and sA(SWHIP@starter and season, N=10)<=1.10

JMon · 08-13-14, 11:40 AM

Originally posted by emceeaye

Heres support, but dbacks changed their starter, and we know nothing about him:

playoffs==0 and conference==NL and o:conference==AL and (site=='away' and -105 < line) and line>154 and season>2008 and SG=1

I'm going to take a shot on them.

emceeaye · 08-13-14, 11:44 AM

Originally posted by JMon

like it! liked them on ml, but crossed it off due to conflict, but I'll play RL with you.

Jmon, it looks like the last 2 lost where it went into extra innings in previous game (as with this one), but I think still worth a play.

emceeaye · 08-13-14, 11:45 AM

Originally posted by JMon

I'm going to take a shot on them.

Me too. Lets get it.

Alex Vaile · 08-13-14, 12:04 PM

Not to mention Peavy has lost 19 starts in a row! On it with you guys!

Alex Vaile · 08-13-14, 12:59 PM

Originally posted by JMon

Play Oak

Supporting SDQL:

p:margin<-6 and conference=AL and 11>=total>=7 and SG<4 and line>=-200 and rest=0

H and line >=100 and tA(HR) <= .9 and 1.4 >= STDSWHIP >= 1.3 and A(o:SHRA@o:starter and o:season) <= .5 and conference = AL and rest = 0 and SG<4

Conflicting info for As. Dr. M has his query of day on Royals as As since 52714 are 0 and 9 in games following a win by 5 or more runs. Good luck buddy

emceeaye · 08-13-14, 01:04 PM

Originally posted by Alex Vaile

Conflicting info for As. Dr. M has his query of day on Royals as As since 52714 are 0 and 9 in games following a win by 5 or more runs. Good luck buddy

Thanks Alex. Do you have original query?

Alex Vaile · 08-13-14, 03:33 PM

Yes hold on
Team=Athletics and p:margin>=5 and p:runs>5 and SG<SGS and date>=20140527

Alex Vaile · 08-13-14, 03:36 PM

More support for Baltimore.
HF and 13 >= p:margin >= 6 and s:margin > 0 and SG > 1 and os:margin<0 and tS(runs, N=9) > oS(runs, N=9) and tA(BPRA, N=10) < oA(BPRA,N=10)

JMon · 08-13-14, 03:49 PM

Originally posted by Alex Vaile

Conflicting info for As. Dr. M has his query of day on Royals as As since 52714 are 0 and 9 in games following a win by 5 or more runs. Good luck buddy

ironically the spot I am playing is how teams do after blow loss of more than six. Going to take my chances and ride with Oak

JMon · 08-13-14, 04:44 PM

Dr. Smooth

Alex Vaile · 08-13-14, 04:51 PM

Originally posted by JMon

ironically the spot I am playing is how teams do after blow loss of more than six. Going to take my chances and ride with Oak

O ok. Cool good luck. Total bs call in white sox game just now on catcher.

Alex Vaile · 08-13-14, 05:04 PM

Wow 7 run inning all started with a bullshit call at home plate. So much for that game.

azsportswin · 08-13-14, 05:11 PM

Originally posted by Alex Vaile

Wow 7 run inning all started with a bullshit call at home plate. So much for that game.

......and ended with baseball's worst reliever puking all over himself again....how is this guy still in the majors, that's what I want to know???!!!

Alex Vaile · 08-13-14, 05:25 PM

Originally posted by azsportswin

......and ended with baseball's worst reliever puking all over himself again....how is this guy still in the majors, that's what I want to know???!!!

As soon as they said warming up in the bullpen Ronald Bellasario I knew it was over.

JMon · 08-13-14, 06:23 PM

Wtf, ugh.. Atleast we got clev