[Alex Vaile]

Who do you like today JMon? I don't see you in here too much. Drop a nugget of SDQL knowledge on us.

[Alex Vaile]

Today's results : 6-0!!! + 6.64 units and bball won too.
Season to date : 90-73 + 16.69 units

Seattle ML and RL, Angels and Angels under, Rangers and Orioles under all winners.
Awesome day!

[inZane]

good job Alex

[Alex Vaile]

Today's plays :


Play Angels Under 8 -120

conference=NL and o:conference=AL and A and 230>=line>-105 and month<8 and 9.5>=total>=7
( JMon )

Removing Angels ML play. Too high of a price for this guy and hot query conflicts w it. Only under for this game.

[Alex Vaile]

Play Royals + 102
Play Royals Under 8.5 -115
Play Marlins + 127
Play Marlins Under 8 -110

p:L and p:hits>7.5 and op:SO>5 and D and season>=2015 and o:STDSERA>4.05 and total>7.5 (FlyinAir)

[Alex Vaile]

Play Astros even
Play Astros Under 9 -120

STR and o:STR and s:margin = -1 and s:streak = 2 and s:biggest lead < 3 and s:errors < 2 and -9 < p:M8 < 3 and p:M8 != -2 and -4 < p:M1 < 3 (not sure )

[Alex Vaile]

Atlanta at Cleveland UNDER 193.5 -- In the series opener, the OU line 197.5 and loved to 199.5. We released the UNDER and wrote that it would most likely be the highest OU line of the series. Under this number has plenty of line value.
Game three was a back-and-forth affair than ended with a three-point Cavs win in overtime. Both of these teams have strong UNDER indicators as a result.

Atlanta is 0-14 OU as a dog with less than two days rest off a road loss that featured at least eight lead changes, as long as they were not a dog of 12-plus points in that loss. The SDQL text is:

team=Hawks and D and rest<2 and p:LC>=8 and p:AL and p:line<12 and date>=20100500

Cleveland is 0-8 OU as a home favorite with at most one day of rest off a game in which there were eight or more lead changes, staying under by an average of 18.6 ppg, with all eight games coming from this season. As you can see by running this SDQL text: t:team=Cavaliers and HF and rest<2 and p:LC>=8 and date>=20141119

each of their last six have stayed under by AT LEAST 15 points.

Finally, we have an interesting playoff-only system involving a team that is off a close win in which they blew a big lead. In the post-season, NBA teams are 0-8 OU off a 1-4 point win as a home favorite in which they held a lead of at least eight points. The SDQL text is:

playoffs=1 and 0=8 and p:HF and season>=2013

Note that these games have stayed under by an average of 17.3 ppg and the three qualifying games from these playoffs stayed under by 13, 22 and 20 points respectively. Make the play the UNDER.

[Alex Vaile]

good job Alex

Thanks. Been a back and forth last few weeks. Nice to have a solid week!

[Alex Vaile]

Play Over 8 +105 Rockies vs Reds

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 ( Bases )

[Cordoba25]

Some guy in some other thread stated that the Dodgers have never lost at home with Kershaw as a > -200 fav. Alex, could you (or anyone else) please run a query in this? sdql language is chinese to me have no clue how I would enter something like this. This may be worth betting as an open parlay w/ something else if true..

[FlyinAir]

Some guy in some other thread stated that the Dodgers have never lost at home with Kershaw as a > -200 fav. Alex, could you (or anyone else) please run a query in this? sdql language is chinese to me have no clue how I would enter something like this. This may be worth betting as an open parlay w/ something else if true..

That is incorrect!

starter = Clayton Kershaw and H and line<-200

He's 21-10 at home when the line is bigger than -200, BUT the Dodgers have won 12 in a row in Kershaw starts at home and the line is bigger than -200. The over is 9-3 in those last 12 starts

[FlyinAir]

But the real reason I popped in here was to share

MATT GARZA is 7-2 SU when pitching at home, after the opp scored more than 6.5 runs in their previous game, and GARZA'S opp is a lefty

starter = Matt Garza and H and op:runs>6.5 and o:STL

[Cordoba25]

That is incorrect!

starter = Clayton Kershaw and H and line<-200

He's 21-10 at home when the line is bigger than -200, BUT the Dodgers have won 12 in a row in Kershaw starts at home and the line is bigger than -200. The over is 9-3 in those last 12 starts

Thx FlyinAir

[JMon]

Who do you like today JMon? I don't see you in here too much. Drop a nugget of SDQL knowledge on us.

I don't have a lot of time on my hands any more as I did last year. My shops are my bread and butter and that's my concentration now. Additionally just found out today a solid employee just gave a 2 weeks.

Anyway...looks like you are holding down the fort with some of my trends from last year and doing a grand job at it!! I'll try to chime in when I can! Nevertheless bol to you and those following

[JMon]

Today's results : 6-0!!! + 6.64 units and bball won too.
Season to date : 90-73 + 16.69 units

Seattle ML and RL, Angels and Angels under, Rangers and Orioles under all winners.
Awesome day!

Almost forgot to say...nice day. Oddly I won all as well except on different plays. Laa, oak, nym, pitt, and min. Grand day for sdql and the believers!

[Alex Vaile]

Yesterday's results: 5-3 +2 units

(I meant to cancel Rockies over when I got emailed about pitching change but I didn't get it in time so I'll take the loss.

Season to date : 95-76 + 18.89 units

Angels under, Astros and Astros under, Royals Under, Marlins Under winners and Marlins, Royals and Rockies over losers.

[Alex Vaile]

Today's plays:

Play Twins - 105
Play Twins Under 9 -120

STR and o:STR and s:margin = -1 and s:streak = 2 and s:biggest lead < 3 and s:errors < 2 and -9 < p:M8 < 3 and p:M8 != -2 and -4 < p:M1 < 3 ( emceeaye )

[Alex Vaile]

Play Rockies + 142

A and A(starter whip@starter and season, N=3)<2.50 and A(o:starter whip@o:starter and o:season, N=3)>=2.25 and 2012<=season and line<=160 and rest=0 and 9.5>=total>=8 and month!=8 ( JMon )

[Alex Vaile]

Play Rangers + 147
Play Rangers RL + 1.5 -150

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:R1 < 5 and op:R2 < 4 and 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 and s:SHF > 21 and s:SSO < 10 and op:BL < 8 and 2 < p:PU < 7 and -39 < tS(margin, N=10) - oS(margin, N=10) < 32 and oS(HR, N=10) > 4 and 3 < tS(HR, N=10) < 19 and oS(doubles, N=10) < 29 and tS(hits, N=10) > 63 and 65 < oS(hits, N=10) < 105 and line < 225 and day != Sunday and oss:SHA < 11 and oss:SHRA < 3 and game number > 24 and tS(margin, N=20) - oS(margin, N=20) < 43 and tS(hits, N=20) - oS(hits, N=20) < 27 ( Bases )

ROI % ML 47
ROI % RL 18

[Alex Vaile]

Play Angels Under 7 - 105

conference=NL and o:conference=AL and A and 230>=line>-105 and month<8 and 9.5>=total>=7 ( JMon )

[2buckluck]

Thanks Alex for posting all of these !! Great share, helps me out a ton by adding something to my own analysis, best of luck!!

[Alex Vaile]

Thanks Alex for posting all of these !! Great share, helps me out a ton by adding something to my own analysis, best of luck!!

No prob 2buckluck glad I can help. I just want to win and hope we all can benefit. I have accumulated many queries and trends from other folks who have been kind enough to help me out. To a winning day!!!

[Alex Vaile]

Play Under 7.5 -120 D-Backs vs Cardinals

team=Diamondbacks and A and p:BL>0 and p:L and LGS and po:BPRA=0 and po:runs>2 and date>=20110500

team=Cardinals and p:SO>=p:hits and LGS and p:HR<2 and date>=20140727 (MTI)

[Alex Vaile]

Yesterday's results: 3-4 - 1.33 units
Season to date : 98-80 + 17.56 units

Twins, Rockies and Cards under winners and Twins Under Angels under, Rangers ML and Rangers RL losers.

[Alex Vaile]

Today's plays :

Play Tigers + 119

month = 5 and streak = 2 and -6110 or line<-110) ( Bases)

[Alex Vaile]

Play Orioles + 120 Game 1

starter=Chris Sale and C and s:SPT>=110 and s:H and starter rest<30
team=Orioles and D and os:QS and oss:QS and osss:QS and op:W and date>=20140526 (MTI)

[birdsfan]

team = Orioles and p:runs = 0 and date >= 20120804
SU: 18-4 (1.64, 81.8%) avg line: -117.1 / 104.4 on / against: +$1,564 / -$1,659 ROI: +55.4% / -65.1%


team = Orioles and p:runs = 0 and date >= 20120804 and H
SU: 12-1 (2.00, 92.3%) avg line: -145.9 / 131.3 on / against: +$1,107 / -$1,134 ROI: +57.7% / -84.8%

[Alex Vaile]

Play Under 6.5 even Braves vs Giants

Sum(hits@team and season) / Sum(at bats@team and season) <= .250 and o:conference = NL and STDSERA <= 2.70 and 2011<=season and SG!=2 (JMon)



Play Dodgers + 105 Friday 5/29

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 (Bases)

[Alex Vaile]

Play Padres + 123

team=Pirates and A and p:HW and pp:HW and 20080527<=date ( JMon )

Pirates not great after a couple home wins and head to the road.

[Alex Vaile]

Almost forgot to say...nice day. Oddly I won all as well except on different plays. Laa, oak, nym, pitt, and min. Grand day for sdql and the believers!

Nice day for the both of us. And been a grind last few. I found your Pirate fade today. Best of luck!

[Alex Vaile]

Play Seattle + 106

team=Indians and A and 2<=o:streak and SG=1 and date>=20120921 (MTI)

team=Indians and F and line>-170 and SG=1 and wins<=o:wins and date>=20140900

[Alex Vaile]

Wow Giants 6 run inning blew it for me. Would have been only win today. They're hot! I'm not!

[Alex Vaile]

Yesterday's results : 0-5 - 5 units
Season to date : 98-85 + 12.56 units.

Everyone lost. Forgettable Day!

[Alex Vaile]

Today's plays :

Play Dodgers + 105

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 (Bases)

[Alex Vaile]

Play Houston - 135

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