MLB - Situation Plays - SDQL

[1TimeLucky1]

Made an error

Hey guys I was tailing the under on m's and ended up on pads instead I have time to buy it back obv. But was wondering if there was any data on that play? Please help...

[JMon]

Hey guys I was tailing the under on m's and ended up on pads instead I have time to buy it back obv. But was wondering if there was any data on that play? Please help...

l

have money on lad, already posted that play..nothing on the total

[Alex Vaile]

yep, but still positive money if played yesterday. That's the key. South siders big dog comes in as well as BOS under

Yup and with the dodgers cashing late a nice solid winning day. Tigers cashed easily for me and over hit too in phillies game plus I tagged along for a few of yours too and atl early. Good day today. Nice plays!

[Alex Vaile]

2 and 0 today posted plays + 2.16 units
38 and 26 overall
+ 9.51 units

[emceeaye]

Jmon, what is the earliest time you are able to see results of queries showing active games for the next day's games? I ask because the database doesn't seem to be updated to accommodate the next day's games until the next morning when I'm already sleeping. Has that been your experience, or is there a way to update the database the night before to announce any active games for the next day?

Thanks.

yep, but still positive money if played yesterday. That's the key. South siders big dog comes in as well as BOS under

[BasesLoaded314]

it *usually* updates between 2 and 3 am CDT, but every once in a while its later

[JMon]

Jmon, what is the earliest time you are able to see results of queries showing active games for the next day's games? I ask because the database doesn't seem to be updated to accommodate the next day's games until the next morning when I'm already sleeping. Has that been your experience, or is there a way to update the database the night before to announce any active games for the next day?

Thanks.

Aside bases above response, Im not sure on the first updates..I think they have one around 10:30-11a time. I usually cap in the mornings anyhow. Actually, they are better about updates for MLB. I remember in previous years, I would have to email Joe telling him to update the db.

[Alex Vaile]

First posted play for 7 / 13:

Atlanta Braves - 150 pretty juicy so tread lightly but results pretty good.
Teheran 12 and 1 in this spot with 13 quality starts. Strangely 11 of the 13 games also went under.
starter = Julio Teheran and F and s:L and season>=2013

[JMon]

ref post #750

Situation A: Fade a Sunday NL Getaway team

2014 tracking results on the fade: 17-23 (+200)

Last week (-125)

Fading(play against):

Nationals
Pirates

[JMon]

ref post #750

Situation B: Sunday Under Getaway

2014 tracking results over-under-push: 17-19-2 (+30)

Last week: (-105)

Play under

A's
Pirates

[BeanTownClown88]

Tailed the nats over yesterday...thanks! Awesome thread, sweet data

[JMon]

Showcasing the possible under on the Indians

RG3 and DIV and H and 2005<=season and month>6 and team=Indians

team=Indians and DAY and F and line>-165 and p:hits<=6 and p:L and 20050828<=date

[Alex Vaile]

H and 9.5 > total > 7.5 and SG = 3 and SGS < 6 and playoffs = 0 and 73 < os:SPT < 109 and o:starter rest > 6 and month = 7 and p:hits < 16 and 1 < tA(doubles, N=10) < 2.3

Awesome numbers and then I adjusted for July which slimmed sample but results quite nice.
Second posted play :

Under 8.5 -115 Yankees vs Orioles.
I hate unders for Sunday night TV games but even when I added NGT to query ROI still high 20's.

[Alex Vaile]

Tailed the nats over yesterday...thanks! Awesome thread, sweet data

Glad u tailed the over. It took extras to cash it but it was a solid day.

[Alex Vaile]

Third posted play:
Marlins + 132

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

[Alex Vaile]

Showcasing the possible under on the Indians

RG3 and DIV and H and 2005<=season and month>6 and team=Indians

team=Indians and DAY and F and line>-165 and p:hits<=6 and p:L and 20050828<=date

Looking great for a nice morning under!

[emceeaye]

another under with decent record and ROI--counterintuitive though

Although starting pitchers have a high runs allowed last starts, record is good of this one by Bases:

4 < so:R1 < 9 and s:SRA < 10 and s:SPT < 110 and starter rest < 40 and s:SHRA < 3 and SG != 3 and (game number > 118 or game number < 107) and os:SRA < 7 and os:SHA > 2 and os:SSO < 10 and os:SHRA < 3 and ou streak > -3

[Trmeyer]

go with the braves. Im a cubs fan and their lineup today is garbage.

[BeanTownClown88]

On the under for cleveland. pitchers bumbling through it so far but only 1 run!

[emceeaye]

thanks, I'all just have to wake up earlier

Aside bases above response, Im not sure on the first updates..I think they have one around 10:30-11a time. I usually cap in the mornings anyhow. Actually, they are better about updates for MLB. I remember in previous years, I would have to email Joe telling him to update the db.

Thanks for the clarification guys. I'll just have to get up earlier to run the queries especially given that MLB already gets priority with respect to updates relative to the other sports, and that it likely can't get updated any earlier. I'm debating whether to just pay $2 per query to save time, but after 100-200 queries saved, there is more pressure to turn in a significant profit, enough to offset the storage/automated running of queries costs.

[Alex Vaile]

Showcasing the possible under on the Indians

RG3 and DIV and H and 2005<=season and month>6 and team=Indians

team=Indians and DAY and F and line>-165 and p:hits<=6 and p:L and 20050828<=date

Nice winner!

[BasesLoaded314]

Favorites dominate the 1st game back after ASG:

month = 7 and rest > 2 and F

[BasesLoaded314]

rest > 2 and month = 7 and F and streak>-3 and 5>o:streak>-4 and 9>starter rest>5

[BasesLoaded314]

some sunday night homework

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

-5 < ou streak < 2 and SG = 3 and H and ou streak > -4 and tS(ou margin, N=10) < 11 and 6 < tS(O, N=20) < 11 and oS(total, N=10) > 81.5 and tS(total, N=10) > 76 and s:SHF > 20 and os:SHF > 13 and os:SPT > 73 and 76 < s:SPT < 117 and -3.5 < su margin < 5.5 and osu margin < 4.5 and p:hits + pp:hits > 9 and op:hits + opp:hits < 27 and p:margin > -6 and p:RMAX < 6 and op:SII < 4 and pp:RMAX < 6 and opp:SII < 6

(team = Padres or team = Giants or team = Mariners) and H and total > 6 and (SGS < 4 or (SGS = 4 and SG != 4 and SG != 2)) and 1605 < start time < 2215 and p:hits < 10 and day != Friday and p:HR + op:HR < 3 and tS(HR, N=10) + oS(HR, N=10) < 23 and 2 < pp:hits < 14 and pu margin + opu margin < 8 and tS(ou margin, N=10) > -12.5

streak = 1 and SG = 2 and SGS = 3 and o:streak > -8 and (H or day != Saturday) and ((A and -166 < line < 200) or (H and -300 < line < 162)) and -2 < p:hits - op:hits < 12 and p:hits > 4 and op:hits > 3 and 4 > p:SO - op:SO > -3 and -3 < p:errors - op:errors < 2 and site streak > -7 and o:site streak > -8 and 1 < p:SII < 6 and op:RMAX < 4 and game number > 12 and 70 < os:SPT < 118 and os:SSO < 9 and s:SHA + s:SWA > 3

H and -7 < ou streak < 2 and -6 < 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

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

[Alex Vaile]

1 and 1 today with Baltimore game rained out no action for an even day.
39 and 27 overall
+ 9.51 units good job today guys!

[FlyinAir]

bases, do you just think of all this and put 'em together or how're you coming up with all these?

[Alex Vaile]

Nice work Bases. I don't know how you think of such detailed queries but you sure have a talent for crafting some creative stuff. I just wanted to point out a few I was having trouble with generating the readouts on the sdql query page. Maybe something missing? Just a heads up. It may b me messing up copy paste but I tried a few different times. Thanks again man I use your queries everyday to help with my wagers. I really appreciate it. It adds another element to capping games I've never even thought of before.

-5 < ou streak < 2 and SG = 3 and H and ou streak > -4 and tS(ou margin, N=10) < 11 and 6 < tS(O, N=20) < 11 and oS(total, N=10) > 81.5 and tS(total, N=10) > 76 and s:SHF > 20 and os:SHF > 13 and os:SPT > 73 and 76 < s:SPT < 117 and -3.5 < su margin < 5.5 and osu margin < 4.5 and p:hits + pp:hits > 9 and op:hits + opp:hits < 27 and p:margin > -6 and p:RMAX < 6 and op:SII < 4 and pp:RMAX < 6 and opp:SII < 6

(team = Padres or team = Giants or team = Mariners) and H and total > 6 and (SGS < 4 or (SGS = 4 and SG != 4 and SG != 2)) and 1605 < start time < 2215 and p:hits < 10 and day != Friday and p:HR + op:HR < 3 and tS(HR, N=10) + oS(HR, N=10) < 23 and 2 < pp:hits < 14 and pu margin + opu margin < 8 and tS(ou margin, N=10) > -12.5

[JMon]

Hey fellas.. Hope you are enjoying the break as much as I am. Bases is a fukkin grind. Honest, I have got the itch.. but all in all, good break. After a brutal May and a good 2nd June and July .....losing roughly 5+ to date. Recovered 20+ during that time.

During the break I came up with this spot.. Have you wondered what happens to a team after a home loss, had more hits than their oppt. Put them in a first game of a series on zero rest...and you have yourself a nice fade and dog play......currently 7-19 fading the fav, last two. Let down spot???

p:HL and p:hits > po:hits and 125 > line >= -160 and SG = 1 and rest = 0 and o:rest = 0 and 9>=total>=6.5

Side note..plan on doing a NFL SDQL segment. Hope to see all of you over on the NFL forum in due time. Work together, win together.

[b1slickguy]

Nice one, JMon.
Wish everyone well for the 2nd half.
Modified one from sportsdatabase that was originally a KC specific query.
Only 3 filters.
Good luck.

SG=2 and p:runs<=4 and oA(runs, N=3)>10

[emceeaye]

Here's one I came up with that's pretty good

Here's one I tweaked from a database trend. It has a decent ROI and good WP. Please feel free to tweak to increase N and WP.

HF and p:A and p:L and season>2008 and tA(W, N=13)>=.55 and tA(s:SRA + ss:SRA+sss:SRA)<=14 and tA(s:SRA + ss:SRA)<=5.5 and s:SRA<=5

[BasesLoaded314]

bases, do you just think of all this and put 'em together or how're you coming up with all these?

the key is to start off by keeping the parameters open, that way u can begin to see where possible value lies. check out the following query:

day and site

specificially, see how:
road teams perform on Thursdays
home teams on sat/sun

also, check out my posts #1021 and 1022 on the topic.

[BasesLoaded314]

Nice work Bases. I don't know how you think of such detailed queries but you sure have a talent for crafting some creative stuff. I just wanted to point out a few I was having trouble with generating the readouts on the sdql query page. Maybe something missing? Just a heads up. It may b me messing up copy paste but I tried a few different times. Thanks again man I use your queries everyday to help with my wagers. I really appreciate it. It adds another element to capping games I've never even thought of before.

-5 < ou streak < 2 and SG = 3 and H and ou streak > -4 and tS(ou margin, N=10) < 11 and 6 < tS(O, N=20) < 11 and oS(total, N=10) > 81.5 and tS(total, N=10) > 76 and s:SHF > 20 and os:SHF > 13 and os:SPT > 73 and 76 < s:SPT < 117 and -3.5 < su margin < 5.5 and osu margin < 4.5 and p:hits + pp:hits > 9 and op:hits + opp:hits < 27 and p:margin > -6 and p:RMAX < 6 and op:SII < 4 and pp:RMAX < 6 and opp:SII < 6

(team = Padres or team = Giants or team = Mariners) and H and total > 6 and (SGS < 4 or (SGS = 4 and SG != 4 and SG != 2)) and 1605 < start time < 2215 and p:hits < 10 and day != Friday and p:HR + op:HR < 3 and tS(HR, N=10) + oS(HR, N=10) < 23 and 2 < pp:hits < 14 and pu margin + opu margin < 8 and tS(ou margin, N=10) > -12.5

I think you need to replace the smilies with ": o" with the space in the middle removed

[BasesLoaded314]

Here's one I tweaked from a database trend. It has a decent ROI and good WP. Please feel free to tweak to increase N and WP.

HF and p:A and p:L and season>2008 and tA(W, N=13)>=.55 and tA(s:SRA + ss:SRA+sss:SRA)<=14 and tA(s:SRA + ss:SRA)<=5.5 and s:SRA<=5

and line > -191

[BasesLoaded314]

D and pW and p:runs < 4 and SGS < 5 and SG != 3 and -4 < p:streak < 2 and 6 > o:streak > -4 and line > 134 and op:runs < 10 and 0 < op:TLOB < 11 and p:SG < 4 and p:SGS > 2

F and SG = 1 and season > 2006 and H and SGS = 3 and (day = Monday or day = Tuesday) and -3 < streak < 2 and -7 < o:streak < 5 and p:hits > 6 and 11 > p:runs > 3 and 0 < op:runs < 10 and total > 7.5

HF and p:FL and p:SG = 3 and SG = 1 and p:line > -190 and streak > -6 and o:streak < 4 and p:runs < 8 and op:hits < 12 and op:runs < 9

s:SSO = 2 and 3.9 < s:SIP < 4.5 and s:SHA < 9 and day != Saturday and day != Monday and (A or day != Sunday) and (A or day != Tuesday) and (A or day != Wednesday) and line < 185 and p:margin > -9 and p:runs > 0

s:SSO = 2 and 5.4 > s:SIP > 4.9 and 11 > s:SHA > 4 and s:SWA < 4 and 20 < s:SHF < 26 and 4 < starter rest < 7 and (A or SG != 2) and day != Saturday and day != Tuesday and starter wins != 1 and starter wins - starter losses > -7 and op:margin > -8

s:SHRA = 2 and s:SSO = 4 and s:SIP > 3.9 and s:SHA < 10 and 3 < s:SRA < 6 and streak > -3 and (line < -127 or line > 110) and starter rest < 12 and op:hits < 12

s:SIP = 8 and 0 < s:SRA < 3 and s:SSO > 3 and 0 < s:SWA < 5 and s:SHF < 34 and starter rest < 7 and 3 < s:SHA < 6 and (A or day != Saturday) and (A or SG < 4) and line < 147 and 2 < p:hits < 16 and op:margin > -9 and game number < 154

H and rest = 1 and o:rest = 0 and day = Tuesday and streak > -3 and o:streak < 5 and p:hits < 12

day = Thursday and A and -170 < line < 280 and playoffs = 0 and SG < 4 and streak > -4 and -5 < o:streak < 3 and s:SRA > 1 and s:SHA > 4 and s:SSO < 8 and 81 < s:SPT < 107 and 19 > p:hits > 3 and pp:hits > 5 and ppp:hits < 12 and op:hits >2

[BasesLoaded314]

that smiley is ": D"