MLB - Situation Plays - SDQL

[Alex Vaile]

Wtf, ugh.. Atleast we got clev

Yup I played it too. Thanks guys.

[emceeaye]

Yah Jmon, bummer. The fact that white sox wasn't even close makes me wonder if that one point win in extra innings yesterday may have had a negative effect...hey nice call on cubs and Balt!!!!

[Alex Vaile]

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.

It was really the horrible call by umps to overturn an out call. It started the meltdown. Wasnt even close.

[Alex Vaile]

Play Balt under

SDQL support (only two parameters)

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

Nice hits today.

[Alex Vaile]

3 and 0 again posted plays for + 3 units
78 and 62 overall
+ 11.31 units

[emceeaye]

3 and 0 again posted plays for + 3 units
78 and 62 overall
+ 11.31 units

Kick ass Alex! Nice picks today with the unders--i went with em as well...2-1 is on the unders works for me!!

Correction: looks like all 3 of your unders came through, but I went with padres under as well which was a loss.

[moshi]

Is the SDQL not showing RL results summary for anyone else?

[emceeaye]

Is the SDQL not showing RL results summary for anyone else?

same problem here, and now not even loading a bookmark

[Alex Vaile]

same problem here, and now not even loading a bookmark

Ya the last few days it looks like they're doing work at the site or something. No RL info and most bookmarks not working will after I used my saved trend. Weird tech issues.

[emceeaye]

Ya the last few days it looks like they're doing work at the site or something. No RL info and most bookmarks not working will after I used my saved trend. Weird tech issues.

Yes, for past few days, it seems lije some technical changez to site are going on. Sounds like at least you're able to enter something in input box through a query, no? I'm not even getting a blank query box to enter a query

[Alex Vaile]

No emceeaye your right site isnt working. I emailed them

[JMon]

saved trends are not loading as well.... Send them an email guys!

[Alex Vaile]

Working now

First posted play:
( Bases)
Under 9 even Boston vs Houston

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]

Interleague total, Play Det/Pitt under

Supporting SDQL

7.5>=total>=7.0 and 4.2>=STDSERA>=3.7 and conference=NL and o:STDSWHIP<=1.3 and o:conference=AL and rest=0

[Alex Vaile]

Second and third posted plays: ( Dr.M )
Play tigers - 205
Tigers RL -105

28 and 0 in this spot for Scherzer. RL 26 and 2.

starter = Max Scherzer and H and s:A and s:SSO>s:SHA and s:SIP<9 and date>=20100428

[JMon]

Play KC un

I've posted this SDQL before

H and total<=7 and STDSERA<=3.5 and t:conference=AL and s:SWA<=1 and ss:SWA<=1

[Alex Vaile]

Fourth play: ( Bases )

Play Houston + 138

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:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs 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

[JMon]

Like that bos total...going to play it with you alex!

[Alex Vaile]

Like that bos total...going to play it with you alex!

Yup. That query has been hot too. I played your Detroit under already so far so good. I also hit on no runs in first inning in tiger game. Lets have a great day. What do u think of Mets Wash game? Strasburg fade material on the road and Gee and Mets solid at avoiding the sweep. Line keeps going up for Wash?

[Alex Vaile]

Play KC un

I've posted this SDQL before

H and total<=7 and STDSERA<=3.5 and t:conference=AL and s:SWA<=1 and ss:SWA<=1

Funny I added the DAY parameter and it improved to an amazing 2 19 o/u. Nice query!

[JMon]

Funny I added the DAY parameter and it improved to an amazing 2 19 o/u. Nice query!

nice catch

[JMon]

Fourth play: ( Bases )

Play Houston + 138

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:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs 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

I can't get this to run.....?

[emceeaye]

Yup. That query has been hot too. I played your Detroit under already so far so good. I also hit on no runs in first inning in tiger game. Lets have a great day. What do u think of Mets Wash game? Strasburg fade material on the road and Gee and Mets solid at avoiding the sweep. Line keeps going up for Wash?

Alex, found this one that supports Nats. It has large sample size and when you add SG=3 and month=8, though a small sample size, favors Nats:

WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and conference = NL and line>100 and SG < 4 and month!= 9

[emceeaye]

I can't get this to run.....?

I think you have to remove all the "op:inning runs" as advised by Bases in the past. But strangely, the record doesn't seem that good now.

[Alex Vaile]

I can't get this to run.....?

I re copied and pasted try now. It didn't work for me when I transferred it back but did work when I ran it from bookmarks. Hope it works
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:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs 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

SU: 727-709 (0.13, 50.6%) avg line: 137.3 / -150.4 on / against: +$27,651 / -$37,072 ROI: +19.3% / -17.2%
OU: 670-685-80 (0.36, 49.4%) avg total: 8.5 over / under: -$7,440 / -$5,275 ROI: -4.7% / -3.3%

[Alex Vaile]

Alex, found this one that supports Nats. It has large sample size and when you add SG=3 and month=8, though a small sample size, favors Nats:

WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and conference = NL and line>100 and SG < 4 and month!= 9

Thanks for doing that. Nats just seem to have Mets number

[JMon]

Alex, found this one that supports Nats. It has large sample size and when you add SG=3 and month=8, though a small sample size, favors Nats:

WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and conference = NL and line>100 and SG < 4 and month!= 9

ya I was just getting ready to post that one of mine..that query has been a gold mind this year, but even tho Mets are 5-14 in this spot, I don't believe I am going to play it. Call it a gut feeling if you will.

[JMon]

I re copied and pasted try now. It didn't work for me when I transferred it back but did work when I ran it from bookmarks. Hope it works
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:inning runs op:R1 < 5 and op:inning runs op:R2 < 4 and op:inning runs 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

SU: 727-709 (0.13, 50.6%) avg line: 137.3 / -150.4 on / against: +$27,651 / -$37,072 ROI: +19.3% / -17.2%
OU: 670-685-80 (0.36, 49.4%) avg total: 8.5 over / under: -$7,440 / -$5,275 ROI: -4.7% / -3.3%

emc was right...wow how did I miss this query. Killer dog spot and close to 30u won this season

[Alex Vaile]

Wow phil coke I thought this is bad and sure enough 2 run hr. Hes like Bellasario. Awful pitcher. Hope they can shut the door. How does he have a job?

[emceeaye]

Wow phil coke I thought this is bad and sure enough 2 run hr. Hes like Bellasario. Awful pitcher. Hope they can shut the door. How does he have a job?

Alex, you a Dodger fan too who couldn't wait for Bellisario to be traded?

[JMon]

Det under winner

[emceeaye]

Rays SU support

What do you guys think of these 2 queries on Rays su? First one is from website trends and the next I came up with

t:team=Rays and A and date>=20140615

AF and LGS and p:margin>=9 and tA(W, N=9)>oA(W, N=9)+.11

[emceeaye]

Det under winner

Nice one Jmon, I went with it too!

[mdunlap3]

Nice hits on DET yall...OAk and KC just went over though

[mdunlap3]

Hard to back Nats tonight as Stras is awful on the road...might have to stay away from this one.