[bking79]

alex can you look up Arizona

[Alex Vaile]

alex can you look up Arizona

Sorry just saw this. Had a good solid query for under in this game.

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

And

tA(doubles, N=10) < 1.9 and 8.9 < tA(hits, N=10) < 10.4 and .5 < tA(HR, N=10) < 1.3 and 1 < oA(doubles, N=10) < 1.7 and oA(hits, N=10) < 9.9 and oA(HR, N=10) < 1.1 and SG < 4 and 5 > SGS > 2 and p:HR < 3 and p:hits < 15 and 18 > pp:hits > 4 and 3 < ppp:hits < 16 and 3 < pppp:hits < 13 and ppppp:hits < 15 and pppppp:hits < 15 and ppppppp:hits > 6 and op:hits < 13 and s:SRA < 7 and s:SHRA < 2 and os:SRA < 8 and os:SPT < 122

ROI 36% under damn wish I saw this I also have this pointing to over but small sample

team = Padres and A and p: D and po:runs>=7 and date >= 20150731

12/4 o/u in this spot

[Alex Vaile]

Play Marlins +124

team=Marlins and AD and p:L and pp:L and season>2014

13-13 SU including 8-2 last 10 opportunities

team=Braves and HF and p:W and pp:W and season>2014

4-3 SU this spot.

starter=Tom Koehler and AD and o:team=Braves

1-3 SU but the 1 win was against Teheran

[Alex Vaile]

Play Mets + 215

team=Dodgers and line<=-140 and p:AD and po:BL=0 and p:W and date>=20090601

Dodgers 0/9 SU in this spot

[Alex Vaile]

Today's results: 6-4 + 2.11 units
Season to date: 161-133-3 + 24.71 units

Winners: Giants ML and RL, Angels over, Marlins ML, Royals ML and Brewers

Losers: Marlins under, Orioles under, Mets and Pirates

[Alex Vaile]

Monday:

Play Over 8.5 -110 Yankees vs Blue Jays
Play Over 8 + 100 Dodgers vs Cubs

AD and tS(o:hits-starter hits + o:walks - starter walks) / tS(9-starter innings pitched) <= 1.15 and line <= 150 and month < 9 and rest < 2 and date>=20160509

30/5 o/u in this spot

[Alex Vaile]

Play Mets + 115

team=White Sox and SG=1 and A and p:F and o:STDSERA>4 and date>=20120716

White Sox 2-12 in this spot

[Alex Vaile]

Play Padres + 188

team=Padres and SG=1 and p:AD and po:SF and date>=20140912

Pads 12-3 SU in this spot

[Alex Vaile]

Play Royals -110
Play Yankees + 128

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

ROI 28%

[Alex Vaile]

Play Over 9.5 -105 Pirates vs Marlins

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 18% 900 game sample

And

team=Pirates and SG=1 and A and p:walks<=1 and
date>=20130705

Pirates 12/0/1 o/u in this spot

[Alex Vaile]

Play Reds +139

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

ROI 7%

And

team=Rockies and SG=1 and p:margin<=-5 and
date>=20130927

Rockies 0-13 SU in this spot

[Alex Vaile]

Play Twins vs Athletics Over 8.5 -120

team=Twins and D and 6<=o:starter rest<=7 and 20160415<=date

Twins 9/0 o/u in this spot

[lanyard90]

hey man, I would PM but I have to make 40 posts..lol anyway I was wondering how you learned how to use SDQL? I've been using it somewhat but I don't know exactly how to use it myself I just use some preset ones.

[Alex Vaile]

hey man, I would PM but I have to make 40 posts..lol anyway I was wondering how you learned how to use SDQL? I've been using it somewhat but I don't know exactly how to use it myself I just use some preset ones.

I learned by just watching what others were posting a few years back then I began researching some of what Dr. ED meyer has put out. I just began tinkering a little with simple situations gleaned from boxscores. All the parameters are then entered at another site. Check out the threads from the last couple years.

[lanyard90]

Alright thanks man, i'll be checking your thread often now, I just found it

[lanyard90]

Also, do you know if you can use SDQL to find trends for Team Totals?

[Alex Vaile]

Play Rangers + 155

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

ROI 41 500 game sample

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 22% 700 game sample

[Alex Vaile]

Also, do you know if you can use SDQL to find trends for Team Totals?

No i don't think so

[lanyard90]

No i don't think so

alright thanks brother...& also thanks for posting the query text itself... its helpful.

[tecmoslayer]

I am now 0-4 following your plays this season. Your system needs work.

Play Twins vs Athletics Over 8.5 -120

team=Twins and D and 6<=o:starter rest<=7 and 20160415<=date

Twins 9/0 o/u in this spot

[bking79]

alex good one on rangers im 2-0 with boston an Oakland

[Alex Vaile]

I am now 0-4 following your plays this season. Your system needs work.

Buddy you keep saying that. Look back at my plays. I don't claim to win them all but have been doing decent lately. Play them all or don't complain if one loses that you played. Up 25 units u should b able to find a winner. Did you play the Mets, Rangers or Reds? Didn't hear you complain about those.

[Alex Vaile]

Play Angels - 105

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

ROI 25%

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 15%

[Alex Vaile]

Today's results: 6-5 + 1.79 units
Season to date: 167-138-3 + 26.5 units

Winners: Pirates over, Angels, Rangers, Mets, Reds, Royals

Losers: Athletics over, Jays Over, Yankees, Cubs over, and Padres

[bking79]

alex leaning Astros today

[bking79]

The Nationals are 0-15 OU on the road off a road game when seeking same season revenge vs their opponents starting pitcher.
SU: 8-9 (0.00, 47.1%) avg line: 100.3 / -111.2 on / against: -$155 / +$120 ROI: -7.4% / +5.4% RL: 8-9 (0.26, 47.1%) avg line: -135.1 / 123.1 on / against: -$352 / +$245 ROI: -14.6% / +13.1% OU: 0-17-0 (-3.38, 0.0%) avg total: 7.1

[bking79]

alex we gotta look into Phillies I like them tonight if yu could find somthin on that game

[Alex Vaile]

Tuesday:

Play Nationals vs Phillies Under 7 + 100

team = Nationals and A and oS:W and oS:season = season and p:A and date >= 20140916

Nats 0/17 o/u in this spot

[Alex Vaile]

Play Jays - 146

(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

H and -115 > line > -160 and DIV and game number > 10 and month < 7 and 1 >= tA(W, N=10) >= .7 and .7 >= oA(W, N=10) >= .5 and season > 2008 and 7.5 < total < 10 and p:W

ROI 25%

[Alex Vaile]

Play Miami -125

starter = Jose Fernandez and H and s:SSO > s:SHA and date >= 20130413

Marlins 22-0 in this spot

[Alex Vaile]

alex leaning Astros today

Nice one bking sorry I was at work but excellent call

[Alex Vaile]

The Nationals are 0-15 OU on the road off a road game when seeking same season revenge vs their opponents starting pitcher.
SU: 8-9 (0.00, 47.1%) avg line: 100.3 / -111.2 on / against: -$155 / +$120 ROI: -7.4% / +5.4% RL: 8-9 (0.26, 47.1%) avg line: -135.1 / 123.1 on / against: -$352 / +$245 ROI: -14.6% / +13.1% OU: 0-17-0 (-3.38, 0.0%) avg total: 7.1

Oops didn't see u had this too. Great one gotta play it

[Alex Vaile]

alex we gotta look into Phillies I like them tonight if yu could find somthin on that game

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 23% 600 game sample

[Alex Vaile]

Play Orioles -120

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

Orioles 25-0 SU in this spot

[Alex Vaile]

Play Giants - 125

WP < 53 and A(SWHIP@starter and season) < 1.2 and A(SOPW@starter and season) >= .333 and A(SSPB@starter and season) >= .50 and D and conference = NL and SG < 4 and line > 100 and month!= 9

ROI 8% 960 game sample

And

team=Giants and p:SII<=2 and date>=20160511

Giants 10-0 SU in this spot