2016 SDQL Plays

[Alex Vaile]

Yesterday's results: 7-4 + 4.04 units
Season to date: 417-393-14 + 4.62 units

Winners: Phillies ML and RL, Orioles, Cubs Under, Dodgers under, Nats and As RL

Losers: Padres, Cards under, As ML and Astros

[thekoreanmang]

Good job, Alex. Do you bet everything you put up here? Do you also bet others' picks?

[Alex Vaile]

Good job, Alex. Do you bet everything you put up here? Do you also bet others' picks?

Thanks mang! I was glad to see the Phillies come through. Yes I play everything I put in here. I don't play anyone else's plays right now but I will occasionally check a few other's threads, sometimes I borrow queries from the SDQG that I pickup.

[Alex Vaile]

Play Marlins + 185
Play Marlins RL -110

team = Marlins and starter = Tom Koehler and line>=140 and s:SWHIP < 1 and date >= 20140600

Marlins 6-1 when Koehler starts as a +140 dog and last start's WHIP less than 1.

And

team = Cubs and H and line<=-140 and p:H and 5 <= p:PU and not p:X and date >= 20160511

Cubs 0-6 after using 5+ pitchers as a 140+ favorite coming off home game

And

team = Marlins and p:BL = 0 and p:L and pp:BL = 0 and pp:L and date >= 20150728

Marlins 10-0 coming off a loss in which they never lead

And

team = Cubs and LGS and p: D and p:BPRA > 1 and tS(1@month=7 and rest>2) > 0 and p:LOB<20 and date >= 2011092

Cubs 0-17 SU in last game of series after game as a dog where bullpen gave up more than 1 run

[Alex Vaile]

Play Nationals vs Diamondbacks Over 8.5 + 100

team = Nationals and line<=-135 and s:W and ss:W and date >= 20160424

Nats 18/2 o/u when a 135+ favorite and starter won last 2 starts

team=Diamondbacks and po:hits>=12 and p:runs>0 and sA(SHA) > 5.5 and date>=20160525

Dbacks 11/0 o/u in this spot

[Alex Vaile]

Play Blue Jays vs Astros Under 8 -115

team=Astros and p:HL and p:BL=0 and line>-130 and date>=20140826

ASTROS 0/20 o/u after home loss that they never lead

[Alex Vaile]

Play Red Sox - 116
Play Red Sox RL + 140

team=Red Sox and p:AL and p:SF and date>=20140902

Red Sox 20-5 after an away loss after scoring first

And

team = Red Sox and A and po:walks = 0 and p:AL and date >= 20070525

Red Sox 11-0 SU 11-0 RL after an away loss where they didn't walk anyone

[thekoreanmang]

Play Marlins + 185
Play Marlins RL -110

team = Marlins and starter = Tom Koehler and line>=140 and s:SWHIP < 1 and date >= 20140600

Marlins 6-1 when Koehler starts as a +140 dog and last start's WHIP less than 1.

And

team = Cubs and H and line<=-140 and p:H and 5 <= p:PU and not p:X and date >= 20160511

Cubs 0-6 after using 5+ pitchers as a 140+ favorite coming off home game

And

team = Marlins and p:BL = 0 and p:L and pp:BL = 0 and pp:L and date >= 20150728

Marlins 10-0 coming off a loss in which they never lead

And

team = Cubs and LGS and p: D and p:BPRA > 1 and tS(1@month=7 and rest>2) > 0 and p:LOB<20 and date >= 2011092

Cubs 0-17 SU in last game of series after game as a dog where bullpen gave up more than 1 run

I like that a good number of dogs get picked but don't seem of these queries seem very specific? Like it almost seems like you could create any situation to provide a strong record. Not saying that's what you do but I'm trying to wrap my head around some of these queries as I'm new to SDQL.

[Alex Vaile]

Play Phillies + 154
Play Phillies RL -110
Play Over 7.5 + 110

team = Phillies and D and SG > 1 and p:WHD and po:BL > 0 and date >= 20150411

Phillies 9-2 SU 11-0 RL after a win as a home dog that they came back and won. Playing against Giants super cold

And

team = Giants and SG > 1 and A and REG and p:line<=-105 and oS:SRA>0 and oS:L and oS:season = season and tS(1@month=7 and rest>2) > 0 and date >= 20060920

Giants 22/2 o/u vs starting pitcher seeking revenge for an away game in regular season after all star break.

And

team = Phillies and p:H and p:SII >= 5 and p:margin>2 and p:HR<5 and date >= 20100900

Phillies 12/0 o/u after scoring in 5 separate innings and didn't hit 5 hrs

[Alex Vaile]

I like that a good number of dogs get picked but don't seem of these queries seem very specific? Like it almost seems like you could create any situation to provide a strong record. Not saying that's what you do but I'm trying to wrap my head around some of these queries as I'm new to SDQL.

It's all about situations bud. You can create any number of queries to reflect gameday sitautions but only ones that are successful are ones worth a play. Some of these I made and a few I have gathered and are active today

How is this not specific? Cubs 0-17 SU in last game of series after game as a dog where bullpen gave up more than 1 run

[thekoreanmang]

It's all about situations bud. You can create any number of queries to reflect gameday sitautions but only ones that are successful are ones worth a play. Some of these I made and a few I have gathered and are active today

How is this not specific? Cubs 0-17 SU in last game of series after game as a dog where bullpen gave up more than 1 run

Understood. If you read my comment again I wasn't saying that the queries were not specific, my issue was that some queries were overly so. And, that it would seem queries could be conjured and manipulated in a way to produce only positive results. I know that this is not the case, but sometimes it could certainly seem like that especially after stretches of bad performance which we have seen recently.

Like a hyperbolic example would be the Dodgers are 50-1 SU after a game where they lost by one run but only when they had at least one Korean player and the mascot was in the stands for at least 50% of the game. Obviously, results are good but the situation is so specific and kind of random which I do think some parts of some of your queries (and some others I have seen) are.

Don't get me wrong. I appreciate and respect the work you put in. A lot. But, I'm just trying to understand the perspective in which the queries are formed.

Thanks for entertaining this question and thought process. Obviously I'm a noob which is why I'm trying to get to the heart of understanding.

[Alex Vaile]

Ok well yes I see what ur saying. The analogy is a bit crass but it's more about trying to find meaningful information that one feels adds to making an educated guess that we call sports betting. If you feel researching whether or not a Korean player was on the team (I know you were joking) and it helps you as a bettor than rock on...I have so many queries it can be tough to pare down the info. Each day my active queries pop up in database based on the day's games and I go from there to see what's best for the day. Next season I may do just 3 picks a day but I'm happy doing it this way. Good luck to us all!

[thekoreanmang]

I got you. Didn't mean to be crass. Just wanted to show how some situations can seem very random and not a relevant element to contributing to success. Let me take an example from one of your posts to be more clear of what I mean.

Red Sox 11-0 SU 11-0 RL after an away loss where they didn't walk anyone

How relevant is it that in the last game that the Red Sox didn't walk anyone? The starting pitchers are different for today's game and the last game. Sure, maybe a reliever or two might be used in both games but that's maybe accounting for an inning or two. I just don't see how this query is relevant as a winning formula despite its 11-0 mark.

On the flip side, I understand how other queries are relevant to winning. Here's another one from today you posted:

Phillies 12/0 o/u after scoring in 5 separate innings and didn't hit 5 hrs

If the Phillies are scoring in 5 separate innings without hitting 5 HRs, it means that that offense is probably clicking and scoring not just because of individual power but because of small ball hitting, people getting on base and the likelihood that the overall team is playing well offensively.

Let me know if I'm looking at this correctly. Again, not trying to offend, just trying to understand and look at this more smartly because I do appreciate the formulaic approach to sports betting as well as to other areas of life.

[thekoreanmang]

Play Phillies + 154
Play Phillies RL -110
Play Over 7.5 + 110

team = Phillies and D and SG > 1 and p:WHD and po:BL > 0 and date >= 20150411

Phillies 9-2 SU 11-0 RL after a win as a home dog that they came back and won. Playing against Giants super cold

And

team = Giants and SG > 1 and A and REG and p:line<=-105 and oS:SRA>0 and oS:L and oS:season = season and tS(1@month=7 and rest>2) > 0 and date >= 20060920

Giants 22/2 o/u vs starting pitcher seeking revenge for an away game in regular season after all star break.

And

team = Phillies and p:H and p:SII >= 5 and p:margin>2 and p:HR<5 and date >= 20100900

Phillies 12/0 o/u after scoring in 5 separate innings and didn't hit 5 hrs

Looks like Nola pulled and put on DL for Phillies and now replaced by Phil Klein, a reliever, for tonight's start. The queries here don't seem to take into account for Nola so I'm assuming these are still plays. Feel like the PHI ML and RL plays get weaker but the O7.5 gets a big stronger with the Klein for Nola switch.

[Alex Vaile]

I got you. Didn't mean to be crass. Just wanted to show how some situations can seem very random and not a relevant element to contributing to success. Let me take an example from one of your posts to be more clear of what I mean.

Red Sox 11-0 SU 11-0 RL after an away loss where they didn't walk anyone

How relevant is it that in the last game that the Red Sox didn't walk anyone? The starting pitchers are different for today's game and the last game. Sure, maybe a reliever or two might be used in both games but that's maybe accounting for an inning or two. I just don't see how this query is relevant as a winning formula despite its 11-0 mark.

On the flip side, I understand how other queries are relevant to winning. Here's another one from today you posted:

Phillies 12/0 o/u after scoring in 5 separate innings and didn't hit 5 hrs

If the Phillies are scoring in 5 separate innings without hitting 5 HRs, it means that that offense is probably clicking and scoring not just because of individual power but because of small ball hitting, people getting on base and the likelihood that the overall team is playing well offensively.

Let me know if I'm looking at this correctly. Again, not trying to offend, just trying to understand and look at this more smartly because I do appreciate the formulaic approach to sports betting as well as to other areas of life.

Yes you are looking at it correctly. It's called sports data query language. You build queries based on available stats/info from past games. As far as what is relevant and what is not 11-0 is 11-0 is it not? The more queries or information you have for one team or against another is used to make a play. I can only tell you what I have but if u want to disprove or try to say info is not relevant than you are not believing in the basics of building queries. You are free to build your own and try your hand at contributing in here. Other than that I'm not going to defend what I'm doing. Either get on board or don't but I don't know what else to say

[Alex Vaile]

Pitching change Phillies ML and RL cancelled.

Still playing Over but now

Play Over 8 + 105 Giants vs Phillies w all the above wonderful over queries

[Alex Vaile]

Play Rangers - 101

team=Rangers and F and p:hits<=6 and p:L and SG<SGS and date>=20100804 and p:runs<5 and p:HR<2

52-11 SU currently not favored but I still like it

And

starter = Cole Hamels and oA(SO) > 7.35 and oA(HR) > 1.15 and oA(XBH) < 2.25 and date > 20100500

Hamel's teams 26-0 in this spot

And

team = Rangers and p:F and s:W and ss:W and o:STDSERA > 2.4 and date >= 20150914

Rangers 14-0 SU in this spot

And

team = Orioles and H and p:HD and s:SIP<4 and STDSERA < 7.5 and tS(1@month=7 and rest>2) > 0

Orioles 0-15 in this spot

[Alex Vaile]

Play Tigers - 131

team = Tigers and SG > 1 and p:runs>=6 and p:XBH>1 and season=2016

Tigers 15-2 SU in this spot

[Alex Vaile]

Play Astros - 103

team = Astros and H and p:H and p:SII < po:SII and date >= 20150513

Astros 24-2 SU in this spot

[thekoreanmang]

Yes you are looking at it correctly. It's called sports data query language. You build queries based on available stats/info from past games. As far as what is relevant and what is not 11-0 is 11-0 is it not? The more queries or information you have for one team or against another is used to make a play. I can only tell you what I have but if u want to disprove or try to say info is not relevant than you are not believing in the basics of building queries. You are free to build your own and try your hand at contributing in here. Other than that I'm not going to defend what I'm doing. Either get on board or don't but I don't know what else to say

You're right 11-0 is just that but I was trying to find the relevancy. Not asking you to defend anything. Just trying to discuss something that is not so obvious to probably most people in here. I imagine you're posting in here for a reason and that is to share what you've found and what you think are good plays and for the generosity I thank you. But, at the same time, not sure why you're getting defensive here. I don't think at any point that I've posted in here have I expressed any negativity towards you or your work. You know I'm on board but I'm surprised that I got your panties all bunched up. Didn't mean to, bruh.

[Alex Vaile]

[Alex Vaile]

You're right 11-0 is just that but I was trying to find the relevancy. Not asking you to defend anything. Just trying to discuss something that is not so obvious to probably most people in here. I imagine you're posting in here for a reason and that is to share what you've found and what you think are good plays and for the generosity I thank you. But, at the same time, not sure why you're getting defensive here. I don't think at any point that I've posted in here have I expressed any negativity towards you or your work. You know I'm on board but I'm surprised that I got your panties all bunched up. Didn't mean to, bruh.

It's not defensive it's truthful. One can only try to explain himself so many times. The numbers speak for themselves and anyone can do it that's the cool part. Just think of an interesting situation and learn the parameters of Home, Away, Dog, Favorite, Team, starter and you'll be on your way and then you can see the results. No panties bunched here bra just don't understand your continued questioning of the validity/relevance of the queries. You may want to contact JMon or b1slickguy or Mako as they are the real masters of the SDQL. I just have slowly been learning and tinkering and have accumulated a bank of queries that I draw from. I know you're interested TheKoreanMang because you have been following the past few weeks. I like the interest and welcome your contributions my friend. It's all good

[Alex Vaile]

Play Angels - 122

team = Athletics and SG > 1 and D and p:LD and p:BL > 0 and tS(1@month=7 and rest>2) > 0 and date >= 20150812

As 0-11 in this spot

And

team = Athletics and AD and p: D and o:STDSERA > 3.9 and tS(1@month=7 and rest>2) > 0 and date >= 20130825

As 0-15 in this spot

And

team = Angels and SG > 1 and F and p:F and oS:W and oS:season = season and tS(1@month=7 and rest>2) > 0 and season >= 2013

Angels 16-0 seeking revenge against same starting pitcher same season after break

And

team = Athletics and A and p:A and p:BL > 1 and date >= 20160423

As 7-16 SU this season in this spot

[thekoreanmang]

Nice addition on the late late games.

[Alex Vaile]

Nice addition on the late late games.

Thanks! Looks like I should have stuck with Phillies ha they pulled it off agaiN. At least over hit too!

[thekoreanmang]

Thanks! Looks like I should have stuck with Phillies ha they pulled it off agaiN. At least over hit too!

Yeah. I got on them live so got lucky. Thinking about it some more, it really shouldn't have mattered that the Phils changed their pitcher because after all the prior wins in the same situation produced the same result regardless of pitcher. Of course, not sure who all the pitchers were in those prior wins. Anyway, good job.

[tallwhiterussian]

MEN? I'm glad you both are smoking the peace pipe and are on the same page now....Can we get down to business? what do we have for the early games? Just kidding appreciate everything Vale !!!!

[Alex Vaile]

Yesterday's results: 6-5 + .85 units
Season to date: 423-398-14 + 5.47 units

Winners: Giants over, Angels, Tigers, Nats Over, Marlins RL and Astros Under

Losers: Marlins ML, Astros ML, Red Sox ML and RL and Rangers

[Alex Vaile]

Thursday:

Play Phillies + 113
Play Phillies RL - 145
Play Over 8 - 105 Giants vs Phillies

team = Phillies and -120 <= line <= 120 and p: D and s:L and s:BL > 0 and date >= 20130906

Phillies 14-4 SU 17-1 RL in this spot

And

team = Phillies and D and SG > 1 and p:WHD and po:BL > 0 and date >= 20150411

10-2 SU 12-0 RL

And

team=Giants and SG>1 and A and -135 <=line <=135 and total <10 and p:AF and 5 <=p:PU and date>=20110602

Giants 17/1 o/u in this spot

[Alex Vaile]

Play Orioles - 132

team=Orioles and HF and p:H and p:S3 = p:runs and date >= 20120807

O's 21-0 SU in this spot

And

team = Orioles and HF and p:F and p:S3 = p:runs and date >= 20120807

16-1 SU in this spot

[Alex Vaile]

Play Under 8 + 100 Jays vs Astros

team=Astros and p:HL and p:BL=0 and line>-130 and date>=20140826

Astros 0/21 o/u in this spot

[Alex Vaile]

Play Angels - 128

team = Athletics and SG > 1 and D and p:LD and p:BL > 0 and tS(1@month=7 and rest>2) > 0 and date >= 20150812

As 0-12 SU 2-10 RL in this spot

And

team = Athletics and A and p:A and p:BL > 1 and date >= 20160423

As 7-17 SU in this spot

And

team = Athletics and AD and p: D and o:STDSERA > 3.9 and tS(1@month=7 and rest>2) > 0 and date >= 20130825

As 0-16 SU in this spot

[Alex Vaile]

Play Red Sox - 132

team=Mariners and H and p:W and op:BL=0 and season>2012

Mariners 21-48 SU in this spot

And

Pomeranz 2-0 against Mariners also

[Alex Vaile]

Yesterday's results: 3-4 - 1.65 units
Season to date: 426-402-14 + 3.82 units

Winners: Red Sox, Jays under and Phillies RL

Losers: Phillies ML, Phillies over, Angels blew it and Orioles too

[Alex Vaile]

Friday:

Play Dodgers - 133
Play Dodgers RL + 170

team = Red Sox and line>=-120 and 12 <= p:hits and p:AW and SG = 1 and season >= 2007

Red Sox 1-22 SU 1-20 RL in this spot

And

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)

ROI 20% 770 game sample