MLB - Situation Plays - SDQL

[JMon]

ref post #750

Situation B: Sunday Under Getaway

2014 tracking (ONLY) results over-under-push: 18-20-2 (+20)

Last week: (-10)

Play under

Mariners
Orioles
Cubs
Giants
Brewers
Rockies
Royals
Rays
Astros

again this is going to be interesting tracking results this week with so many plays!

[JR007]

good luck with this JMON, so many plays is a "yikes" though.....

[JR007]

Wash, opens at CoL tomorrow, that looks like the most difficult of all the travel schedules today......some of these teams have the day off tomorrow

[JMon]

good luck with this JMON, so many plays is a "yikes" though.....

tell me about it....going to me just watching most of those. I do like SD side.

[JMon]

I have a lot of conflicting data, going to be laying low today.. I will be playing this one

fade a winning road team of a big loss....fade Reds

55>=WP>=50 and p:margin<=-5 and A and 2006<=season and 155>line>=-200

[JMon]

H and 10 >= total >= 8 and po:runs <= 4 and ppo:runs <= 4 and pppo:runs < 4 and op:L and op:margin = -1 and 2010 <= season and rest = 0 and month != 8

also supports getaway under ..play under south siders

[Alex Vaile]

First posted play for 7 / 20:

Angels -160

team=Mariners and p:XW and SG>1 and season>=2011
Mariners 0 and 14 off an extra inning win against same team. Play angels

[JMon]

One of bases totals queries is active, with support from the getaway under as well. Play under Pirates

note...eliminate space btwn o: ou streak

H and -7 < ou streak < 2 and -6 < o: ou streak < 2 and SG < 4 and 5 > SGS > 2 and 11.5 > total > 6 and p:hits < 18 and op:hits < 17 and pp:hits < 18 and 3 < ppp:hits < 17 and pppp:hits < 16 and ppppp:hits < 15 and pppppp:hits > 2 and opp:hits < 15 and s:SRA < 5 and 0 < os:SRA < 10 and 2 < s:SHA < 10 and s:SHRA < 2 and os:SHRA < 3 and os:SWA < 7 and s:SSO > 3 and s:SHF < 33 and 16 < os:SHF < 34 and 73 < os:SPT < 110 and 76 < s:SPT < 117 and starter rest < 13 and o:starter rest < 11 and day != Monday and -22.5 < tS(ou margin, N=6) < 10.5 and -15 < oS(ou margin, N=6) < 18.5 and ss:SRA < 6 and ss:SHA > 2 and ss:SSO > 1 and ss:SHF > 19 and oss:SHF < 32 and 4 < s:starter rest < 9 and os:starter rest < 22 and game number < 154 and tS(O, N=10) < 7 and 23 < tS(runs, N=10) < 63 and 36 < tS(hits, N=6) < 65 and 1 < oS(errors, N=10) < 10

[Alex Vaile]

Yup and this query of bases lists 4 games today with unders the Pirates one of them:

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)

Pirates under
Yankee under
Red sox under
Rays under

Also the roof in Miami closed today in finale of this 3 game set. From otunj he told us this game type can b very profitable.

Second posted play under 7.5 red sox -130
Third play under 7.5 Giants vs Marlins even based on roof query.

[Alex Vaile]

Double post oops

[Alex Vaile]

Lincecum wow that was a terrible pitch.

[JMon]

I have a lot of conflicting data, going to be laying low today.. I will be playing this one

fade a winning road team of a big loss....fade Reds

55>=WP>=50 and p:margin<=-5 and A and 2006<=season and 155>line>=-200

McCann

[Alex Vaile]

3 and 0 today! Angels what a comeback!
44 and 29
+ 12.3 units

[Alex Vaile]

McCann

Nice win JMon those guys need some better sunglasses

[Alex Vaile]

Yup and this query of bases lists 4 games today with unders the Pirates one of them: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)Pirates underYankee underRed sox underRays underAlso the roof in Miami closed today in finale of this 3 game set. From otunj he told us this game type can b very profitable. Second posted play under 7.5 red sox -130Third play under 7.5 Giants vs Marlins even based on roof query.

This query was hot today. 3 and 0 and 1 push

[emceeaye]

LuckyChuck's strategy seems pretty good

...and if you dont have the spare money for the automated query runner/active game identifier and/or don't have a lot of time to run each and every query manually (as much as you wish you could), this might be the poor-man's alternative... until the end of July at least.

F and line<=-150 and month=7 and season>2013.
SU + RL

Better yet, how about this one until the end of July?

F and line<=-150 and month=7 and season>2013 and s:SRA+ss:SRA<9
SU +RL

What do you think?

[JMon]

ref post #750

Situation A: Fade a Sunday NL Getaway team

2014 tracking results on the fade: 18-24 (+200)

Last week (ev)

Fading (play against):

Phillies
Cubs
Giants
Brewers
Mets
Rockies

geez this spot usually only spits out 1-2 plays.

wow...sides go a perfect 6-0, with three dogs. Wished I would have play them all lol. Getaway totals went 4-4-1.

[Alex Vaile]

First posted play for 7 / 21:

White Sox -173
Chris Sale 16 and 0 in this spot
starter= Chris Sale and H and line <-135 and s:SHF<34 and date> 20120515

[Alex Vaile]

wow...sides go a perfect 6-0, with three dogs. Wished I would have play them all lol. Getaway totals went 4-4-1.

That's a pretty cool result from getaway sides. For fun I threw a 7 teamer down for a few bucks and missed 1 on Giants loss. 6 out of 7. Good luck today!

[Alex Vaile]

...and if you dont have the spare money for the automated query runner/active game identifier and/or don't have a lot of time to run each and every query manually (as much as you wish you could), this might be the poor-man's alternative... until the end of July at least.

F and line<=-150 and month=7 and season>2013.
SU + RL

Better yet, how about this one until the end of July?

F and line<=-150 and month=7 and season>2013 and s:SRA+ss:SRA<9
SU +RL

What do you think?

I like it. Nice work lucky charm and emceeaye. Simple yet very effective. I'm going to use these as well.

[JMon]

Well if this doesn't go against everything we know....lol. Play on a AL dog of 160 >= line > 115, starting a pitcher of a era>=6.7 on the season after giving up b2b runs of 5 or more. Play Rangers @ your own risk!!!

160 >= line > 115 and STDSERA >= 6.7 and conference = AL and s:SRA >= 5 and ss:SRA >= 5 and SG < 3 and rest != 1 and month!= 5

[JMon]

another contrarian mind boggler spot..

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

Play on Rockies

[JMon]

line <= -140 and DIV and month = 7 and conference = NL and (SG=1 or SG=4) and team=Braves

solid both ml and rl

[steinoli]

Braves, White Sox and Yankees for today

F and line<=-150 and month=7 and season>2013
Braves
White Sox
Yankees

line <= -140 and DIV and month = 7 and conference = NL and (SG = 1 or SG = 4) and 2009 <= season
Braves

A and line>=150 and sA(SHA)<=5.5 and month=7 and total<10.5
Braves

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

[steinoli]

ok so i forgot the Yanks

[Alex Vaile]

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)

Second posted play:

Under 7.5 -120 Marlins vs Braves.

[BasesLoaded314]

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)

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 pp:margin < 6 and -10 < opp:margin < 8 and -14 < ppp:margin < 10 and oppp:margin > -13 and p:hits > 5 and pp:hits < 11 and 5 < ppp:hits < 11 and 0 < os:SSO < 10 and 0 < s:SSO < 9 and s:SPT < 113 and os:SPT > 69 and 19 < os:SHF < 32 and line > -216


p:R8 + p:R9 = 1 and SG < 5 and SG != 3 and SGS < 5 and 0 < streak < 4 and 0 > o:streak > -3 and (site streak > 3 or -10 < site streak < 0) and 5 < p:hits < 14 and 2 < p:TLOB < 10 and p:runs < 9 and s:SRA < 8 and p:HR < 4 and 0 < os:SSO < 8 and 4 < starter rest < 10 and s:SPT > 66 and o:starter rest < 11 and os:SPT < 116 and op:R9 < 2

a little blue bird has a page w/ my username that will be tracking all my sdql picks if anyone is interested

[Alex Vaile]

2 and 0 today + 2 units
46 and 29 overall
+ 14.3 units

[JMon]

This is a simplified version of the query that produces even better results.

HF and p:A and -7 < p:margin < 0 and tS(W, N=12) > 6 and 0 < s:SRA < 5 and season > 2008

check it out in interleague play

HF and p:A and -7 < p:margin < 0 and tS(W, N=12) > 6 and 0 < s:SRA < 5 and 2006<=season and conference!=o:conference

[1TimeLucky1]

Hey guys having some success tailing, trying to learn more have my 1st query to contribute. It's 11-1..
F and line<=-150 and A and month=7 and season>2013 and s:SRA+ss:SRA<9 . I tweaked emcees poor mans query. Please let me know if you have something that conflicts this, I don't want to give out a loser on my first contribution.

[Alex Vaile]

Hey guys having some success tailing, trying to learn more have my 1st query to contribute. It's 11-1..
F and line<=-150 and A and month=7 and season>2013 and s:SRA+ss:SRA<9 . I tweaked emcees poor mans query. Please let me know if you have something that conflicts this, I don't want to give out a loser on my first contribution.

I like it. Super high odds but record pretty good over limited sample. Thanks lucky

[Alex Vaile]

check it out in interleague play

HF and p:A and -7 < p:margin < 0 and tS(W, N=12) > 6 and 0 < s:SRA < 5 and 2006<=season and conference!=o:conference

21 and 1 pretty damn good.

[Alex Vaile]

First posted play for 7 / 22:

Red Sox -115

Blue Jays 0 and 16 in this situation.

team=Blue Jays and -120<=line<=120 and p:L and po:hits>10 and SG <SGS and date>=20130420

[Alex Vaile]

Second posted play:

Under 8 -120 Dodgers vs Pirates

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)

[Alex Vaile]

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)

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 pp:margin < 6 and -10 < opp:margin < 8 and -14 < ppp:margin < 10 and oppp:margin > -13 and p:hits > 5 and pp:hits < 11 and 5 < ppp:hits < 11 and 0 < os:SSO < 10 and 0 < s:SSO < 9 and s:SPT < 113 and os:SPT > 69 and 19 < os:SHF < 32 and line > -216


p:R8 + p:R9 = 1 and SG < 5 and SG != 3 and SGS < 5 and 0 < streak < 4 and 0 > o:streak > -3 and (site streak > 3 or -10 < site streak < 0) and 5 < p:hits < 14 and 2 < p:TLOB < 10 and p:runs < 9 and s:SRA < 8 and p:HR < 4 and 0 < os:SSO < 8 and 4 < starter rest < 10 and s:SPT > 66 and o:starter rest < 11 and os:SPT < 116 and op:R9 < 2

a little blue bird has a page w/ my username that will be tracking all my sdql picks if anyone is interested

Thanks Bases! Good luck buddy I'll have to check you out on there.