2016 SDQL Plays

[Alex Vaile]

Yesterday's results: 0-3 - 3.07 units
Season to date: 59-49-2 + 12.23 units

As, Phillies and Brewers under losers.

[Alex Vaile]

Play Marlins - 111

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

ROI 16%

[Alex Vaile]

Play Orioles -122

team=Orioles and line>=-140 and p:margin <=-5 and p:H and date>=20120729

Orioles 21-0 SU in this spot

[Alex Vaile]

Play Brewers + 116
Play Brewers RL -145

Sum(hits@team and season)/Sum(at bats@team and season)<=.250 and conference=NL and p:runs>=8 and pp:runs>=8 and 2006<=season and 150>=line>=-250 and SG<4

ROI 31% ML
ROI 20% RL

[InsaneStre4k]

@alex: first part of your query basically means batting average? (SUm(hit.......)/.........)

here is a nice and simple one :31%ROI ML and 37% ROI RL :line<=-186 and A and division=o:division and league=NL and NGT and rest=0 and 2007<=season

[juicername]

I don't mean to downplay your work guys, I'm using trends and SDQL myself for my handicapping, but isn't it risky to base a play on just one single query?

I mean if you played around a bit more you might (probably even?) find queries that completely contradict the one you're running, possibly at an even higher ROI for the other team.

[juicername]

For example, we can see that the Brewers are 2-6 in their last 8 games following a win and Angels are 6-1 in the last 7 meetings in Milwaukee. Huge advantage Angels all of a sudden.

[Alex Vaile]

I don't mean to downplay your work guys, I'm using trends and SDQL myself for my handicapping, but isn't it risky to base a play on just one single query?

I mean if you played around a bit more you might (probably even?) find queries that completely contradict the one you're running, possibly at an even higher ROI for the other team.

Your can always find conflicting trends/queries for sure. One must weigh what he/she feels is worthy of a play. If you have something to offer I'm sure those interested can make the choice to play it. I try to put up more than 1 query for a play but sometimes when I have success with one I'll stick with it for a while

[Alex Vaile]

Play Pirates + 164

t:team = Pirates and H and p:H and Pirates:Andrew McCutchen:home runs > 0 and line>-180 and date >= 20140611

Pirates 14-0 in this spot

AND

HD and WP>=51 and o:WP>=61 and division=o:division and season>=2006

ROI 24%

[juicername]

Your can always find conflicting trends/queries for sure. One must weigh what he/she feels is worthy of a play. If you have something to offer I'm sure those interested can make the choice to play it. I try to put up more than 1 query for a play but sometimes when I have success with one I'll stick with it for a while

Thanks for the reply man. I don't have anything to contribute, your queries are on a whole different level than my simple ones . I enjoy reading this thread and often either follow or stay away from bets based on your plays after I read up a bit on them myself.

Keep up the good work and thank you for sharing.

[burtonrider726]

Marlins are +money now? Or did you mean Dbacks? Thanks for your help!

[Alex Vaile]

Marlins are +money now? Or did you mean Dbacks? Thanks for your help!

I posted my plays early before lines moved. I meant Marlins. Good luck to us!

[Alex Vaile]

Play Over 9 -115 Rangers vs Blue Jays
Play Over 8 -110 Red Sox vs White Sox

p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < ou streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

ROI 19%

[Alex Vaile]

@alex: first part of your query basically means batting average? (SUm(hit.......)/.........)

here is a nice and simple one :31%ROI ML and 37% ROI RL :line<=-186 and A and division=o:division and league=NL and NGT and rest=0 and 2007<=season

Nice one. I saved it to my library.

[Alex Vaile]

Play White Sox - 139

F and p:A and p:W and date>=20150724

ROI 15%

[Alex Vaile]

Thanks for the reply man. I don't have anything to contribute, your queries are on a whole different level than my simple ones . I enjoy reading this thread and often either follow or stay away from bets based on your plays after I read up a bit on them myself.

Keep up the good work and thank you for sharing.

All good thanks!

[Alex Vaile]

Today's results: 5-3 + 1.91 units
Season to date: 64-52-2 + 14.14 units

White Sox ML, Marlins, Orioles, Brewers ML and RL winners and Pirates, Jays over and Red sox over losers.

[InsaneStre4k]

for the brewers one , it's strange cause results are completely different if you put AL instead of NL league in the query.

[Alex Vaile]

Wednesday:

Play Braves + 185

team = Mets and SG > 1 and line <= -200 and WP > o:WP and date >= 20150915 and DIV

Mets 0-6 SU

And

team = Mets and LGS and line < -180 and p:SO > p:hits and date >= 20080928 and p:margin<=2

Mets 0-8 in this spot

And

team = Braves and SG > 1 and AD and p:WAD and p:runs<4 and p:IL>1 and date >= 20080924

Braves 11-0 in this spot

[Alex Vaile]

for the brewers one , it's strange cause results are completely different if you put AL instead of NL league in the query.

I guess it's just some weird match up thing but I'll take the wins.

[Alex Vaile]

Play Over 7.5 + 111 Nationals vs Royals
Play Royals + 136

team=Nationals and A and p:A and po:runs>=6 and date>=20140829

Nats 20/4 o/u in this spot

team = Royals and H and po:BL > 0 and p:W and SG > 1 and date >= 20150707

Royals 12-0 in this spot

[Alex Vaile]

Play Giants - 108

F and p:A and p:W and date>=20150724

ROI 19%

Seeing the line move right before game I don't feel great about it but Peavy has good history in Cincy. Good luck to us all!

[Alex Vaile]

Play Padres + 104

league = o:league and WP < 50 and o:WP < 50 and streak <= -2 and o:streak >= 1 and AWP > o:HWP and AD and season > 2010 and month > 4

ROI 28%

[InsaneStre4k]

Play Padres + 104

league = o:league and WP < 50 and o:WP < 50 and streak <= -2 and o:streak >= 1 and AWP > o:HWP and AD and season > 2010 and month > 4

ROI 28%

i've improved your query by including the month of april and Away fav that are also very profitable (A and month>=4). was already on SDG Over TT but good to be backed by this query

[InsaneStre4k]

WP<50 and o:WP<50 and streak<=-2 and o:streak>=1 and AWP>o:HWP and AF and season>2007 and division=o:division

even more prfitable since line is moving against SDG that is now a home dog.

[Alex Vaile]

WP<50 and o:WP<50 and streak<=-2 and o:streak>=1 and AWP>o:HWP and AF and season>2007 and division=o:division

even more prfitable since line is moving against SDG that is now a home dog.

Awesome thanks InsaneStre4k

[Alex Vaile]

1-3 start not great. And I guess line move was right Peavy just trash right now!

[Alex Vaile]

Play Blue Jays ML -180
Play Blue Jays RL +110

team=Blue Jays and line <-135 and p:SO>=10 and SG>1 and date>=20090925

Jays 24-0 SU in this spot
Jays 21-3 against RL in this spot

And

(s:SRA + ss:SRA)=3 and A and (month= 5 or month =7) and os:SRA<6 and oss:SRA>2 and line>-184

ROI 16%

AND

(s:SRA + ss:SRA) = 3 and A and (month = 5 or month = 7) and os:SRA < 6 and oss:SRA > 2 and line > -184 and p:hits > 5 and pp:hits > 6 and (op:hits + opp:hits + oppp:hits) > 14

ROI 29%

[Alex Vaile]

Play Under 7 -105 Dodgers vs Rays

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

ROI 24%

[Alex Vaile]

Today's results: 2-6 -4.02 units
Season to date: 66-58-2 + 10.12 units

Nats over and Blue Jays ML winners and dodgers under, Jays RL, Royals ML, Padres ML, Braves ML and Giants losers. Crappy day

[juicername]

Perhaps any of you SDQL gurus can help me out here.

Is there a way to get teams stats based on starting pitcher?
For example if I wanted to find how the Cardinals have done on Thursday's with Garcia starting, is there an SDQL query for that?

[nash13]

team = Cardinals and day = Thursday and starter = Jaime Garcia

6-7 (-0.31, 46.2%)	avg line: -143.3 / 130.8	on / against: -$182 / +$122	ROI: -10.7% / +9.8%
4-8 (-1.00, 33.3%)	avg line: -102.4 / -111.2	on / against: -$546 / +$477	ROI: -35.6% / +29.5%
9-3-0 (2.29, 75.0%)	avg total: 7.8	over / under: +$605 / -$810	ROI: +43.4% / -55.1%

seems like a good Over spot, but sample size is too low.

[juicername]

team = Cardinals and day = Thursday and starter = Jaime Garcia

6-7 (-0.31, 46.2%)	avg line: -143.3 / 130.8	on / against: -$182 / +$122	ROI: -10.7% / +9.8%
4-8 (-1.00, 33.3%)	avg line: -102.4 / -111.2	on / against: -$546 / +$477	ROI: -35.6% / +29.5%
9-3-0 (2.29, 75.0%)	avg total: 7.8	over / under: +$605 / -$810	ROI: +43.4% / -55.1%

seems like a good Over spot, but sample size is too low.

Thanks man, I used a : instead of = for the pitcher name for some reason, no wonder I got an error . Cheers.

[Alex Vaile]

Thursday:

Play Orioles -105

team=Orioles and line>=-140 and p:margin <=-5 and p:H and date>=20120729

Orioles 22-0 coming off a 5 run home loss so long as not more than 140 favorite.

[Alex Vaile]

Play Under 8.5 + 100 Rangers vs Jays

H and tS(o:runs<5,N=3) = 3 and op:margin = -1 and total > 8 and season>2009

ROI 18%

And

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

ROI 18%