Who do you like today JMon? I don't see you in here too much. Drop a nugget of SDQL knowledge on us.
-
Comment -
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!Last edited by Alex Vaile; 05-26-15, 11:10 AM.Comment -
good job Alex
Comment -
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.Last edited by Alex Vaile; 05-26-15, 11:09 AM.Comment -
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)Last edited by Alex Vaile; 05-26-15, 11:10 AM.Comment -
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 )Last edited by Alex Vaile; 05-26-15, 11:10 AM.Comment -
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.Comment -
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 )Last edited by Alex Vaile; 05-27-15, 09:36 AM.Comment -
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..Comment -
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:STLComment -
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
Last edited by JMon; 05-27-15, 07:30 AM.Comment -
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.Comment -
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 )Last edited by Alex Vaile; 05-27-15, 09:49 AM.Comment -
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 )Comment -
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 18Comment -
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 )Comment -
Thanks Alex for posting all of these !! Great share, helps me out a ton by adding something to my own analysis, best of luck!!
Comment -
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!!!Comment -
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)Comment -
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.Comment -
Today's plays :
Play Tigers + 119
month = 5 and streak = 2 and -6<o:streak<-1 and (line>110 or line<-110) ( Bases)Comment -
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)Comment -
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%Comment -
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)Comment -
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.Comment -
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>=20140900Comment -
Wow Giants 6 run inning blew it for me. Would have been only win today. They're hot! I'm not!Comment -
Yesterday's results : 0-5 - 5 units
Season to date : 98-85 + 12.56 units.
Everyone lost. Forgettable Day!Comment -
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)Comment -
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 > 2008Comment
