2015 SDQL Baseball Thread

**bking79** · 05-19-15, 07:19 AM

i like the royals play

**bking79** · 05-19-15, 07:29 AM

**bking79** · 05-19-15, 07:30 AM

Alex i was thinkin if we should fade this query because its been doin bad its good for runlines but not moneylines

**bking79** · 05-19-15, 07:32 AM

We would be 10-4 since may 12 faden this one

**bking79** · 05-19-15, 07:35 AM

Today we would take blue jays braves giants and nationals

**bking79** · 05-19-15, 07:38 AM

May 1st till now if we faded we would be 26 wins 15 losses

**posey** · 05-19-15, 10:12 AM

5/18

Brewers @ Tigers, Tigers ML -137, L, -1.00 u

0-1, -1.00 u.

Record: 32-23, +11.87 u.

**Alex Vaile** · 05-19-15, 02:41 PM

Originally posted by bking79

Alex i was thinkin if we should fade this query because its been doin bad its good for runlines but not moneylines

I agree. May hasn't been kind to this query.

**birdsfan** · 05-19-15, 05:35 PM

starter = Ricky Nolasco and s:AW and A
SU: 18-12 (0.57, 60.0%) avg line: 122.5 / -133.9 on / against: +$966 / -$1,176 ROI: +30.5% / -28.7%
OU: 21-8-0 (1.33, 72.4%) avg total: 8.4 over / under: +$1,235 / -$1,595 ROI: +40.0% / -48.5%

**Alex Vaile** · 05-19-15, 06:20 PM

Originally posted by birdsfan

starter = Ricky Nolasco and s:AW and A
SU: 18-12 (0.57, 60.0%) avg line: 122.5 / -133.9 on / against: +$966 / -$1,176 ROI: +30.5% / -28.7%
OU: 21-8-0 (1.33, 72.4%) avg total: 8.4 over / under: +$1,235 / -$1,595 ROI: +40.0% / -48.5%

Nice find Birds

**Alex Vaile** · 05-19-15, 06:22 PM

Originally posted by bking79

May 1st till now if we faded we would be 26 wins 15 losses

The higher odds make the losses hurt more but that's a solid record

**Alex Vaile** · 05-19-15, 06:46 PM

Originally posted by birdsfan

starter = Ricky Nolasco and s:AW and A
SU: 18-12 (0.57, 60.0%) avg line: 122.5 / -133.9 on / against: +$966 / -$1,176 ROI: +30.5% / -28.7%
OU: 21-8-0 (1.33, 72.4%) avg total: 8.4 over / under: +$1,235 / -$1,595 ROI: +40.0% / -48.5%

Wow 7 to 0 in the 2nd.

**leetreaper** · 05-19-15, 07:08 PM

bird

**Alex Vaile** · 05-20-15, 12:14 AM

Season to date : 64-59 + 5.12 units
Today's plays : 3-1 for + 2 units

Royals, Giants and Giants under winners and Tigers RL loser.

**FlyinAir** · 05-20-15, 01:38 AM

Hey boys!

Have a dog play today 5/20 and the record is 10-2 on the season.

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

Also, we should smack the under in this game since it's so high.

**Alex Vaile** · 05-20-15, 05:22 AM

Today's plays :

Play D-Backs + 120
Play Orioles - 135

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

**Alex Vaile** · 05-20-15, 05:24 AM

Play Under 7.5 even D-Backs vs Marlins

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

ROI 40%

**Alex Vaile** · 05-20-15, 05:34 AM

Play Under 7 + 105 Dodgers vs Giants

total<=7 and Sum(hits@team and season)/Sum(at bats@team and season)<=245 and conference=NL and (p:runs+po:runs)<=2 and 2011<=season (JMon)

ROI 21 %

**Alex Vaile** · 05-20-15, 05:44 AM

Originally posted by FlyinAir

Hey boys!

Have a dog play today 5/20 and the record is 10-2 on the season.

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

Also, we should smack the under in this game since it's so high.

I'll give it a go. Thanks for posting!

**bking79** · 05-20-15, 08:44 AM

Fellas di yu guys find anything on yankees today?

**Alex Vaile** · 05-20-15, 10:47 AM

Originally posted by bking79

Fellas di yu guys find anything on yankees today?

Yes the query that we're fading in May would b to go against Yankees and Angels, taking Nats and Jays.

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

I've got these others going with high ROI so I'm sitting out on these today. Best of luck.

**posey** · 05-20-15, 10:51 AM

Alex there's some danger for the Dbacks it seems.

HF and SG > 1 and streak <= 4 and C and tS(W, N=10) <= 2 and month = 5
SU: 63-29 (1.32, 68.5%) avg line: -142.6 / 130.5 on / against: +$2,140 / -$2,488 ROI: +16.3% / -27.0%

**azsportswin** · 05-20-15, 10:57 AM

Originally posted by FlyinAir

Hey boys!

Have a dog play today 5/20 and the record is 10-2 on the season.

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

Also, we should smack the under in this game since it's so high.

I like to follow this thread, but don't run the actual queries.....I leave that to you professionals....can you tell us what game this is? Thanks!

**posey** · 05-20-15, 11:01 AM

Originally posted by azsportswin

I like to follow this thread, but don't run the actual queries.....I leave that to you professionals....can you tell us what game this is? Thanks!

Phillies

ML 10-2
RL 11-1
OU 3-8-1

**Alex Vaile** · 05-20-15, 11:03 AM

Originally posted by posey

Phillies

ML 10-2
RL 11-1
OU 3-8-1

Ya sample pretty small. I figured id play it for half a unit. Results of this season pretty solid.

**azsportswin** · 05-20-15, 11:05 AM

Thanks Posey, appreciate it!

**Alex Vaile** · 05-20-15, 11:05 AM

Play Blue Jays - 125

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) ( Bases )
This query also lists Twins but I can't back Pelfrey again. With the fade of other query and this one too I'll go with the Jays. Lot of plays today. Good luck to us all.

**bking79** · 05-20-15, 11:06 AM

So we cancel d backs and take marlins ?

**Alex Vaile** · 05-20-15, 11:06 AM

Originally posted by posey

Alex there's some danger for the Dbacks it seems.

HF and SG > 1 and streak <= 4 and C and tS(W, N=10) <= 2 and month = 5
SU: 63-29 (1.32, 68.5%) avg line: -142.6 / 130.5 on / against: +$2,140 / -$2,488 ROI: +16.3% / -27.0%

We ll see I'm hoping that this won't continue and this more recent season will hold true.

**posey** · 05-20-15, 11:12 AM

Originally posted by Alex Vaile

We ll see I'm hoping that this won't continue and this more recent season will hold true.

I am playing Dbacks nonetheless. Have found two other queries supporting Zona.

Let's start it.

Record: 32-23, +11.87 u.

5/20

Diamondbacks @ Marlins, Diamondbacks +126

A - month = 5 and HF and streak <= -4 and HWP < 50 and WP < 50 and o:streak > 0 and WP < 50
SU: 33-44 (-0.31, 42.9%) avg line: -126.4 / 116.4 on / against: -$2,303 / +$1,863 ROI: -23.7% / +24.2%

B - HF and SG > 1 and streak <= 4 and C and tA(runs, N=5) < 3 and p:L and line > -140 and total < 9 and STDSERA + o:STDSERA < 8 and game number > 20 and month < 7 and season > 2007
SU: 15-20 (-0.23, 42.9%) avg line: -122.3 / 112.3 on / against: -$896 / +$699 ROI: -21.0% / +20.0%

**Alex Vaile** · 05-20-15, 11:17 AM

Originally posted by posey

Alex there's some danger for the Dbacks it seems.

HF and SG > 1 and streak <= 4 and C and tS(W, N=10) <= 2 and month = 5
SU: 63-29 (1.32, 68.5%) avg line: -142.6 / 130.5 on / against: +$2,140 / -$2,488 ROI: +16.3% / -27.0%

Oh damn ya I see ur talking about Dbacks. Thanks for the heads up but I already made my plays.

**posey** · 05-20-15, 11:40 AM

Found some support for the Snakes.

streak < 0 and month = 5 and STDSERA < 3.5 and C and HF and tA(hits, N=6) / tA(at bats, N=6) < .23 and tS(home runs, N=6) + tS(doubles, N=6) + tS(triples, N=6) <= 15 and game number > 15 and line > -155 and 6.5 < total < 9.5 and season != 2008
SU: 18-30 (-0.38, 37.5%) avg line: -129.3 / 119.3 on / against: -$2,055 / +$1,755 ROI: -33.1% / +36.6%

And some support for the Marlins...damn.

month = 5 and H and -125 > line > -150 and SG > 1 and streak < o:streak and WP < o:WP and tA(hits, N=7) / tA(at bats, N=7) < .235 and oA(hits, N=7) / oA(at bats, N=7) > .24
SU: 23-7 (1.70, 76.7%) avg line: -136.3 / 126.3 on / against: +$1,342 / -$1,412 ROI: +32.8% / -47.1%

**posey** · 05-20-15, 12:32 PM

Reds @ Royals, Over 8 +110

A - starter = Jason Marquis and AD and 7 < total < 10 and o:WP > 50 and 110 < line < 300
OU: 23-6-2 (1.66, 79.3%) avg total: 8.5 over / under: +$1,650 / -$1,935 ROI: +48.6% / -56.5%

B - team = Royals and p:runs allowed < 1 and HF and SG > 1 and season > 2010
OU: 9-5-0 (1.32, 64.3%) avg total: 8.0 over / under: +$345 / -$540 ROI: +23.1% / -34.1%

C - team = Reds and p:runs < 1 and D and SG > 1 and season > 2010 and total > 6.5
OU: 8-3-0 (0.59, 72.7%) avg total: 8.1 over / under: +$480 / -$565 ROI: +39.5% / -46.7%

D - team = Royals and os:L and p:W and op:L and o:STDSERA > 5 and season > 2010 and 7 < total < 9
OU: 12-7-0 (-0.08, 63.2%) avg total: 8.2 over / under: +$410 / -$625 ROI: +19.4% / -30.1%

E - game number > 20 and month < 6 and league = AL and o:league = NL and SG > 1 and p:runs + op:runs <= 3 and season > 2009 and 6.5 < total < 10
OU: 14-6-3 (1.30, 70.0%) avg total: 8.0 over / under: +$748 / -$965 ROI: +29.8% / -37.7%

**Alex Vaile** · 05-20-15, 03:22 PM

Marlins are a tough team to back right now. I've been burned a few times. Their pitching is suspect and bullpen has been giving up runs late in games. I'm hoping that continues....

**birdsfan** · 05-20-15, 04:43 PM

starter = Wei Yin Chen and s:L and H
SU: 16-4 (1.35, 80.0%) avg line: -127.3 / 115.9 on / against: +$1,116 / -$1,201 ROI: +43.0% / -56.9%