2015 SDQL Baseball Thread

[bking79]

Worlds worst picker is on whitesox redsox mets so fade them 3

[mdunlap3]

Read in the google Group that there are some major database issues. Maybe stay away from MLB till they are corrected.

Yeah Dr.M mentions this on his page as well.

[mdunlap3]

i like pirates and tampa bay

Rationale?

[mdunlap3]

Play Dodgers

starter=Zack Greinke and H and line<=-200.....95%

team=Dodgers and line<=-200 and season>=2011....75%

[Alex Vaile]

Rationale?

I actually had a query to support the Pirates but felt -170 on the road was too pricy. im trying to dig it up but games already started.

[Alex Vaile]

Season to date 51-50 + +.84 units
Yesterday's results : 0-1 -1.35 units

Reds losers on Chapman's wild pitch in 9th.

[Alex Vaile]

Today's plays :

Play Astros - 140

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

[bking79]

Play Against
Any team (LA DODGERS)
team with an excellent SLG (>=.440) against a very good starting pitcher (WHIP<=1.250) -NL, with a good bullpen whose WHIP is 1.350 or better on the season

38-15 over the last 5 seasons.
71.7% (22.6 units)

[bking79]

Play On
Any team (MINNESOTA)
terrible speed team - averaging 0.35 or less SB's/game on the season, after a game where they had 4 or less hits

126-81 over the last 5 seasons.
60.9% (46.6 units)

[bking79]

month > 3 and month < 6 and AD and line <= 150 and p:L and WP < 50 and o:WP > 50 and season = 201 MARLINS TONIGHT

[bking79]

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 METS BLUEJAYS YANKEES TWINS THIS ONE IS BETTER ON THE RUNLINE DOGS

[posey]

I had some open queries from 4/29:
Astros ML -110, W, +0.90 u
Twins ML +141, W, +1.41 u
2-0, +2.31 u.

Overall:
22-15, +10.11 u.

_________________________


Today, 5/12

100 <= line <= 150 and A and DIV and p:W and league = AL and WP >= 45 and o:WP >= 45 and SG <= 3
Yankees +118

DIV and SG >= 1 and total >= 8 and p:margin <= -3 and AD and line <= 150 and month <= 5 and league = AL and o:STDSERA - STDSERA <= 2
Blue Jays +110
Twins +130

AD and tS(o:hits-starter hits + o:walks - starter walks) / tS(9-starter innings pitched) <= 1.15 (this query is from someone else, but I don't remember who)
Mets +120
Blue Jays +110
Yankees +118
Twins +130


So all in all, since we got some different trends supporting the same teams:
Mets +120
Yankees +118
Blue Jays +110
Twins +130

[bking79]

Whats up posey how yu been ya the ad and tso query is good with dog runlines

[Alex Vaile]

[QUOTE=posey;23996527]I had some open queries from 4/29:
Astros ML -110, W, +0.90 u
Twins ML +141, W, +1.41 u
2-0, +2.31 u.

Overall:
22-15, +10.11 u.

_________________________


Today, 5/12

100 <= line <= 150 and A and DIV and p:W and league = AL and WP >= 45 and o:WP >= 45 and SG <= 3
Yankees +118

DIV and SG >= 1 and total >= 8 and p:margin <= -3 and AD and line <= 150 and month <= 5 and league = AL and o:STDSERA - STDSERA <= 2
Blue Jays +110
Twins +130

AD and tS(o:hits-starter hits + o:walks - starter walks) / tS(9-starter innings pitched) <= 1.15 (this query is from someone else, but I don't remember who)
Mets +120
Blue Jays +110
Yankees +118
Twins +130

Ya this above query has been pretty cold in May I was gonna throw it in there but decided against it. Good luck I've been getting crushed last week. What up Posey.

So all in all, since we got some different trends supporting the same teams:
Mets +120
Yankees +118
Blue Jays +110
Twins +130[/QUOTE

[Alex Vaile]

Play Against
Any team (LA DODGERS)
team with an excellent SLG (>=.440) against a very good starting pitcher (WHIP<=1.250) -NL, with a good bullpen whose WHIP is 1.350 or better on the season

38-15 over the last 5 seasons.
71.7% (22.6 units)

These superstat systems are great. There is so much info out there. Last year I tried to have JMon make some of these trends into queries as its an SDQL thread . Its not easy but possible. Maybe someone can help?

[Alex Vaile]

Play Braves vs Reds Under 8 even

(SG = 2 or SG = 3) and SGS - SG < 2 and (p:runs + op:runs) < 6 and (p:HR + op:HR) < 2 and H and pp:HR < 4 and opp:HR < 5 and s:SHRA < 4 and os:SHRA < 3 and ppp:HR < 4 and pppp:HR < 4 and p:runs < 4 and op:runs < 7 and opp:runs < 11 and (pp:runs + opp:runs) > 2 and streak < 3 and o:streak > -4 and ou streak > -4 and ou streak > -6 and opp:SG != 4 and p:hits < 10 and (p:hits - op:hits) > -9 and op:TLOB > 2 and tA(doubles, N=10) < 2.5 and oA(doubles, N=10) < 2.5 and (game number > 64 or game number < 54) and starter rest > 4 and o:starter rest < 29 and 28.9 > (p:SIP + pp:SIP + ppp:SIP + pppp:SIP) > 18.9 and (p:SIP + pp:SIP + ppp:SIP) > 14.9 and (s:SSO + ss:SSO) < 18 and -12 < tS(ou margin, N=10) < 24 and STDSERA + o:STDSERA > 3.07 and o:game number > 28 (Bases )

ROI 29%

[posey]

These superstat systems are great. There is so much info out there. Last year I tried to have JMon make some of these trends into queries as its an SDQL thread . Its not easy but possible. Maybe someone can help?

If I had the time (I won't over the next few days unfortunately) I think I could do it. But to be honest: this trend means nothing. This looks much more like coincidence than a real trend.
Why should you play against a good slugger team against a good starter with a respectable bullpen?
This doesn't take the own pitching into account, where the game is played (H/A), opposing offense or whatever.

[Alex Vaile]

I just thought it was interesting to take a sentence with stats and translate into SDQL.

[posey]

Today, 5/12
Mets +120, L, -1.00 u
Yankees +118, L, -1.00 u
Blue Jays +110, W, +1.10 u
Twins +130, L, -1.00 u

1-3, -1.90 u.

Overall:
23-18, +8.21 u.

[Alex Vaile]

Season to date : 52-51 + .44 units
Yesterday's results : 1-1 -.40 units

Reds under winner, Astros losers

[Alex Vaile]

Today's plays:

Play Twins + 132
Play Twins RL +1.5 -155

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

27% ROI ML
11 ROI RL

[Alex Vaile]

Play White Sox + 104 ( 2 units)

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)

ROI amazing 37 %

[escism]

So I've been trying to dig in and understand some of these Totals Systems. I today I was checking to see how teams do after having 3 Overs in a row and then I broke it down by team to see how each team performed in that situation. Then I wanted to see how they did in the month of May to see if there were any streaks by month. Then I added the parameter of >=2014 and I was blown away to see that Cleveland is 13-1 in this spot with a 79% ROI. Then I went and looked at 5Dimes and they're going off at +100. So I took it as a sign today. Just thought it was a nice little nugget that I came across and good timing today as well. BOL

ou streak >= 3 and team = Indians and month = 5 and season >= 2014

[Alex Vaile]

Nice work excism

[posey]

I just thought it was interesting to take a sentence with stats and translate into SDQL.

Yeah of course, was only my opinion on such things in general and no offense.

[posey]

Overall:
23-18, +8.21 u.

5/13

100 <= line <= 150 and A and DIV and p:W and league = AL and WP >= 45 and o:WP >= 45 and SG <= 3
Blue Jays +110 (caution: bad streak this season)

AD and tS(o:hits-starter hits + o:walks - starter walks) / tS(9-starter innings pitched) <= 1.15
Blue Jays +110
Mets -101

[escism]

@Posey

What exactly are you calculating or hoping to understand w/ this part of the query:

tS(o:hits-starter hits + o:walks - starter walks) / tS(9-starter innings pitched)

Is that a common stat that or just something you came up with?

[Alex Vaile]

Yeah of course, was only my opinion on such things in general and no offense.

Ya Posey its all good. None taken. I respect ur opinion. It wasn't that one in particular but some can b useful. Heres to a good day!

[Alex Vaile]

Season to date : 55-51 + 4.84 units
Yesterday's results : 3-0 +4.4 units

White Sox 2 unit play winner, Twins ML and Twins RL winners.

[bking79]

Are yu taking cardinals today alex?

[Alex Vaile]

Are yu taking cardinals today alex?

Its a tough one. Cards are 10-0 as an AF after a loss against AL competition And 4 and 0 in Day. But Wacha only 4 and 8 as AF. Conversely you have Bauer who is 5 and 1 as a HD. Id lean Indians and under personally As they are 11 and 1 SU in last year and a half in Thurs day games. Line going up. Idk

[Alex Vaile]

Today's plays :

Play Dodgers RL -1.5 even

HF and p:FL and p:SG = 3 and SG = 1 and p:line > -190 and streak > -6 and o:streak < 4 and p:runs < 8 and op:hits < 12 and op:runs < 9 ( Bases )

RL ROI 28%

[Alex Vaile]

Play Twins + 155
Play Twins RL +1.5 - 135

day = Thursday and A and -170 < line < 280 and playoffs = 0 and SG < 4 and streak > -4 and -5 < o:streak < 3 and s:SRA > 1 and s:SHA > 4 and s:SSO < 8 and 81 < s:SPT < 107 and 19 > p:hits > 3 and pp:hits > 5 and ppp:hits < 12 and op:hits > 2 ( Bases)

ROI ML 30%
ROI RL 21%

[posey]

5/13
Blue Jays +110, L, -1.00 u
Mets -101, L, -1.00 u

0-2, -2.00 u.

23-20, +6.21 u.

[JMon]

@posey

what exactly are you calculating or hoping to understand w/ this part of the query:

ts(o:hits-starter hits + o:walks - starter walks) / ts(9-starter innings pitched)

is that a common stat that or just something you came up with?

whip