2015 SDQL Baseball Thread

InsaneStre4k · 08-22-15, 03:27 PM

sent you a PM alex!

biz1127 · 08-22-15, 05:36 PM

p:RMAX > 5 and AF and month!=4 and p:A and n:series game<4 and total>7

RUN LINE: Road Fav, Prev Away and scored at least 6 runs in an inn, not April, total at least 7.5

100-69 (0.09, 59.2%)

avg line: 121.2 / -133.0

on / against: +$5,388 / -$6,432

ROI: +30.7% / -28.1%

New York Mets

Alex Vaile · 08-23-15, 12:27 AM

Today's results : 3-2-1 + 1 units
Season to date : 346-335 -.6 units

White Sox over, Giants under, Rays ML winners, Athletics under and Dodgers losers and Nats over pushed.

Alex Vaile · 08-23-15, 01:35 AM

Originally posted by biz1127

p:RMAX > 5 and AF and month!=4 and p:A and n:series game<4 and total>7

RUN LINE: Road Fav, Prev Away and scored at least 6 runs in an inn, not April, total at least 7.5

100-69 (0.09, 59.2%)

avg line: 121.2 / -133.0

on / against: +$5,388 / -$6,432

ROI: +30.7% / -28.1%

New York Mets

Nice query and result!

biz1127 · 08-23-15, 02:42 AM

Thanks Alex, hope you don't mind me adding to your thread.

Alex Vaile · 08-23-15, 03:18 AM

Originally posted by biz1127

Thanks Alex, hope you don't mind me adding to your thread.

Not at all. Always welcome especially those that contribute.

Alex Vaile · 08-23-15, 03:21 AM

Sunday's plays :

Play Padres + 136
Play Mets - 122

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

( JMon )
ROI % 41 ML

Alex Vaile · 08-23-15, 10:31 AM

Originally posted by Alex Vaile

Nice query and result!

Active again today! Cheers!

Alex Vaile · 08-23-15, 10:31 AM

Originally posted by InsaneStre4k

sent you a PM alex!

Ok bud I'll check it out

Alex Vaile · 08-23-15, 10:36 AM

Play Royals - 108

p:errors = 0 and op:errors = 1 and (H or SG > 1) and SG < 5 and SGS > 2 and SGS - SG < 3 and (H or day != Saturday) and ((H and -215 < line < 142) or (A and -200 < line < 175)) and (conference = AL or o:conference = NL) and op:HR < 3 and p:runs > 2 and p:margin > -2 and 12 > pp:margin > -9 and streak < 5 and -7 < o:streak < 3 and p:SO < 14 and game number > 13 and -21 < tS(margin, N=10) < 29 and -30 < oS(margin, N=10) < 26 and s:SHA > 1 and s:SWA < 6 and s:SSO < 11 and s:SIP > 1.9 and s:SHF > 21 and s:SPT < 121 and 4 < starter rest < 17 and os:SRA < 7 and os:SWA < 6 and 20 < os:SHF < 33 and os:SIP < 8.1 and o:starter rest < 10 and op:runs < 9 and opp:runs < 13 and oppp:runs < 11 and oS(runs, N=10) > 21 and tS(HR, N=10) < 19 and tS(walks, N=10) > 16 and 42 < tS(SO, N=10) < 86 and site streak > -10 and o:site streak > -8 and op:SII < 5 and p:RMAX > 1 and oss:SHF > 13 and oss:SPT > 73 and -5 < tS(W, N=10) - oS(W, N=10) < 6 and -8 < tS(errors, N=10) - oS(errors, N=10) < 6 and opp:RMAX < 5

( Bases )
ROI % 25

Alex Vaile · 08-23-15, 11:10 AM

Play Under 7.5 - 105 White Sox vs Mariners

team = Padres or team = Giants or team = Mariners) and H and total > 6 and (SGS < 4 or (SGS = 4 and SG != 4 and SG != 2)) and 1605 < start time < 2215 and p:hits < 10 and day != Friday and p:HR + op:HR < 3 and tS(HR, N=10) + oS(HR, N=10) < 23 and 2 < pp:hits < 14 and p

u margin +op

u margin < 8 and tS(ou margin, N=10) > -12.5

( Bases )
ROI % 23

biz1127 · 08-23-15, 12:08 PM

Toronto/LA Angels UNDER 8
Team scored 15+ last game, total 7.5/8

p:runs>=15 and total<=8 and total>7 and season>=2007

OU:17-38-1 (-0.02, 30.9%) avg total: 7.8 over / under: -$2,465 / +$1,900 ROI: -40.3% / +30.6%

biz1127 · 08-23-15, 12:11 PM

Chi Sox/Seattle UNDER 7.5

UNDER (<=8.5): Home, Lost Prev as a Home Dog in Extras

H and p:LHDX and total<9

66-111-4 (-0.30, 37.3%)

avg total: 7.8

over / under: -$5,410 / +$3,830

ROI: -27.4% / +19.0%

biz1127 · 08-23-15, 12:12 PM

Originally posted by biz1127

p:RMAX > 5 and AF and month!=4 and p:A and n:series game<4 and total>7

RUN LINE: Road Fav, Prev Away and scored at least 6 runs in an inn, not April, total at least 7.5

100-69 (0.09, 59.2%)

avg line: 121.2 / -133.0

on / against: +$5,388 / -$6,432

ROI: +30.7% / -28.1%

New York Mets

Active again.

New York Mets (-1.5)

Alex Vaile · 08-23-15, 05:08 PM

Originally posted by Alex Vaile

Play Under 7.5 - 105 White Sox vs Mariners

team = Padres or team = Giants or team = Mariners) and H and total > 6 and (SGS < 4 or (SGS = 4 and SG != 4 and SG != 2)) and 1605 < start time < 2215 and p:hits < 10 and day != Friday and p:HR + op:HR < 3 and tS(HR, N=10) + oS(HR, N=10) < 23 and 2 < pp:hits < 14 and p

u margin +op

u margin < 8 and tS(ou margin, N=10) > -12.5

( Bases )
ROI % 23

Ya we blew it on this total. I read something before the game that made me question it but o well. 2 gascans lately. I didn't have much time to research it but too late now.

Alex Vaile · 08-24-15, 12:26 AM

Today's plays: 2-2 -. 05 units
Season to date : 348-337 - .65 units

Royals and Mets winners and Pads and White Sox under losers.

UNLV34 · 08-24-15, 09:43 AM

Play on Mets -210

team = Phillies and D and p:W and p:SF and o:team = Mets and total = 7

Phillies 0-6 in this spot. Also, possibly a play on OVER the total??

Good luck today .

Alex Vaile · 08-24-15, 09:56 AM

Play Cubs - 131
Play Cubs RL + 170

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

( JMon )
ROI % 40 ML
ROI % 22 RL

Alex Vaile · 08-24-15, 10:00 AM

Play Reds - 122
Play Royals - 122

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

( JMon )
ROI % 27

Also Farmer 0 and 4 SU on the road with all 4 games going over

Alex Vaile · 08-24-15, 10:05 AM

Play Cardinals - 121

H and -8 > (starter wins - starter losses + o:starter losses - o:starter wins) > -14 and day != Wednesday and day != Thursday and day != Friday and 6 > s:SRA > 0 and p:hits < 13 and total > 6.5 and (1.4 > STDSWHIP>1.1 or tA(runs) > 4.8)

This query has an ROI of over 20 and points to D-backs but good for a fade lately as 12 out of last 15 games have lost. So I'm playing Cards. Good luck

Alex Vaile · 08-24-15, 10:07 AM

Play Red Sox + 133

team=Red Sox and D and p:L and p:SF and date>=20140900

(SDQG)

Red Sox 9 and 0 in this spot and 6 and 3 over under

UNLV34 · 08-24-15, 10:52 AM

Originally posted by Alex Vaile

Play Cubs - 131
Play Cubs RL + 170

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

( JMon )
ROI % 40 ML
ROI % 22 RL

Another supporting pick for the Cubs today ..

team = Cubs and HF and p:W and date >= 20150807

Cubs are 9-0 since the All-Star break as a home favorite after a win.

biz1127 · 08-24-15, 02:33 PM

op:SO>12 and AF and op:W and FGS and season>=2008

Road Fav, opponent won previous and struck out 13+ times, FGS, since 2008

15-3 (2.44, 83.3%)	avg line: -136.3 / 123.6	on / against: +$1,095 / -$1,128	ROI: +44.4% / -62.6%
13-5 (0.94, 72.2%)	avg line: 127.0 / -138.5	on / against: +$1,211 / -$1,347	ROI: +65.5% / -53.6%

St Louis
St Louis (-1.5)

Alex Vaile · 08-24-15, 04:26 PM

Originally posted by UNLV34

Another supporting pick for the Cubs today ..

team = Cubs and HF and p:W and date >= 20150807

Cubs are 9-0 since the All-Star break as a home favorite after a win.

Make that 10 and 0

Alex Vaile · 08-24-15, 04:28 PM

Originally posted by biz1127

op:SO>12 and AF and op:W and FGS and season>=2008

Road Fav, opponent won previous and struck out 13+ times, FGS, since 2008

15-3 (2.44, 83.3%)	avg line: -136.3 / 123.6	on / against: +$1,095 / -$1,128	ROI: +44.4% / -62.6%
13-5 (0.94, 72.2%)	avg line: 127.0 / -138.5	on / against: +$1,211 / -$1,347	ROI: +65.5% / -53.6%

St Louis
St Louis (-1.5)

On it too Biz! Good luck

Alex Vaile · 08-24-15, 04:38 PM

Play Over 8 - 105 Cardinals vs D-Backs

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 )
ROI % 20

b1slickguy · 08-24-15, 05:03 PM

Fade Astros.
Good luck.

po:starter='Clayton Kershaw' and p:W and AD

Bbfromgpt · 08-24-15, 05:09 PM

Originally posted by b1slickguy

Fade Astros.
Good luck.

po:starter='Clayton Kershaw' and p:W and AD

Any stats to back this up?

b1slickguy · 08-24-15, 05:23 PM

Originally posted by Bbfromgpt

Any stats to back this up?

Teams are 11-25 (31%) in this situation spanning Kershaw's career.
Good luck.

Alex Vaile · 08-24-15, 10:26 PM

Just saw my bets were cancelled on Cardinals and Cardinals over plays due to pitching change so those are no good.

Alex Vaile · 08-24-15, 10:26 PM

Originally posted by b1slickguy

Fade Astros.
Good luck.

po:starter='Clayton Kershaw' and p:W and AD

Nice call Slick was close but cashed.

b1slickguy · 08-24-15, 10:55 PM

Originally posted by Alex Vaile

Nice call Slick was close but cashed.

Thanks, close indeed. Felt like the Cubs game all over.
Good luck.

Alex Vaile · 08-25-15, 12:17 AM

Originally posted by b1slickguy

Thanks, close indeed. Felt like the Cubs game all over.
Good luck.

Definitely. When the Indians scored in the 8th I was worried for sure.

b1slickguy · 08-25-15, 12:36 AM

Nice results today, Alex.

Alex Vaile · 08-25-15, 01:45 AM

Today's results: 4-1 + 3.33 units
Season to date : 352-338 + 2.68 units (out of the red again!!)

Royals, Reds, Cubs ML and Red Sox winners and Cubs RL loser. Cardinals ML and over cancelled.