MLB - Situation Plays - SDQL

**BasesLoaded314** · 05-20-14, 02:35 AM

month = 5 and streak = -4 and opponent streak is 1 or 2
month = 5 and streak = 2 and opponent streak is -2, -3,-4 or -5 (exclude lines between -110 and +110)

**BasesLoaded314** · 05-20-14, 03:03 AM

month = 5 and streak = 2 and opponent streak is -2, -3,-4 or -5 and (only lines LOWER than -113) and s:SRA<6 and os:SRA!=0 and day!=Wednesday and F

**BasesLoaded314** · 05-20-14, 03:09 AM

if you move the line parameter down to -131 it bumps roi to 50%... not bad for a 95 game sample size. what do u guys think?

**BasesLoaded314** · 05-20-14, 03:17 AM

month=6 and 4<streak<9

**BasesLoaded314** · 05-20-14, 03:18 AM

hmmm, im having some problems copying and pasting..... month=6 and streak is 5,6,7 or 8

**emceeaye** · 05-20-14, 10:36 AM

Originally posted by BasesLoaded314

if you move the line parameter down to -131 it bumps roi to 50%... not bad for a 95 game sample size. what do u guys think?

Just to sum up:

month = 5 and streak = 2 and -2>=o:streak>=-5 and line<-131 and s:SRA<6 and os:SRA!=0 and day!=Wednesday and F

Nice!

**JMon** · 05-20-14, 10:48 AM

Originally posted by emceeaye

Just to sum up:

month = 5 and streak = 2 and -2>=o:streak>=-5 and line<-131 and s:SRA<6 and os:SRA!=0 and day!=Wednesday and F

Nice!

Yes..thanks bases

I added month of 6 and -125 needs to be captured!

**BasesLoaded314** · 05-20-14, 12:45 PM

System - Favorites with a money line of -110 or higher with a starting pitcher whose ERA is 3.70 or better on the season (NL), after a game where the bullpen threw 8 or more innings are 96-33 (74%) since 1997.

I cant figure out how to get BP innings.... anybody know how? this was to support the Reds, but theyre no longer a favorite (quite shocking to me with cueto on the hill...)

**emceeaye** · 05-20-14, 06:10 PM

Originally posted by BasesLoaded314

System - Favorites with a money line of -110 or higher with a starting pitcher whose ERA is 3.70 or better on the season (NL), after a game where the bullpen threw 8 or more innings are 96-33 (74%) since 1997.

I cant figure out how to get BP innings.... anybody know how? this was to support the Reds, but theyre no longer a favorite (quite shocking to me with cueto on the hill...)

I think this is it:

A and line>=-110 and STDSERA<=3.70 and conference=NL and BPIP>=8

But doesn't look promising.

**tarosill** · 05-20-14, 06:28 PM

Originally posted by BasesLoaded314

I cant figure out how to get BP innings.... anybody know how? this was to support the Reds, but theyre no longer a favorite (quite shocking to me with cueto on the hill...)

I think this is what you were looking for.

(p:innings pitched-Starter: p:innings pitched)>=8

**BasesLoaded314** · 05-20-14, 09:29 PM

thanks tarosill! I wasn't able to verify the results of the "system" I posted earlier, but I did come across this:

A and (190>line>129 or 115>line) and 4.11>STDSERA>2.97 and conference=NL and (p:innings pitched-Starter: p:innings pitched)>=5

**Roadkill86** · 05-20-14, 09:38 PM

Let's see what happens when Max Scherzer takes the mound when the Tigers are on the skids and on the road...

team=Tigers and starter=Max Scherzer and streak<=-2 and A

**Roadkill86** · 05-20-14, 10:56 PM

Blue Jays games seem to be pretty low-scoring with Drew Hutchison on the mound as a road dog...

starter=Drew Hutchison and AD

**emceeaye** · 05-21-14, 12:25 PM

Originally posted by tarosill

I think this is what you were looking for.

(p:innings pitched-Starter: p:innings pitched)>=8

Thanks for clarifying tarosill...Here's one I put together looking at home favs who are coming off a series game 1 or 2 in which their bullpen innings pitched were less than their opponent's in previous game; and in which their opponent's bullpen innings pitched was more than the opponent's starter's innings pitched; opponent's previous bullpen's runs allowed is 5 or more; the home fav's starting pitcher's ERA in this game is less than that of their opponent's; and the home fav's winning % exceeds 44. It's got a good ROI for SU and especially RL, but tweaks that might make sample size larger, and increase frequency with which this query applies, would be appreciated.

HF and p:innings pitched-Starter: p:innings pitched < op :innings pitched-Starter: op :innings pitched and (op:innings pitched-Starter: op: innings pitched) > Starter: op:innings pitched and op:BPRA>=5 and STDSERA < o:STDSERA and WP >= 44 and SG>1

**tarosill** · 05-21-14, 02:22 PM

Originally posted by BasesLoaded314

thanks tarosill! I wasn't able to verify the results of the "system" I posted earlier, but I did come across this:

A and (190>line>129 or 115>line) and 4.11>STDSERA>2.97 and conference=NL and (p:innings pitched-Starter: p:innings pitched)>=5

Both queries that you posted yesterday are very solid. Thanks!

**tarosill** · 05-21-14, 02:56 PM

Originally posted by emceeaye

Thanks for clarifying tarosill...Here's one I put together looking at home favs who are coming off a series game 1 or 2 in which their bullpen innings pitched were less than their opponent's in previous game; and in which their opponent's bullpen innings pitched was more than the opponent's starter's innings pitched; opponent's previous bullpen's runs allowed is 5 or more; the home fav's starting pitcher's ERA in this game is less than that of their opponent's; and the home fav's winning % exceeds 44. It's got a good ROI for SU and especially RL, but tweaks that might make sample size larger, and increase frequency with which this query applies, would be appreciated.

HF and p:innings pitched-Starter: p:innings pitched < op :innings pitched-Starter: op :innings pitched and (op:innings pitched-Starter: op: innings pitched) > Starter: op:innings pitched and op:BPRA>=5 and STDSERA<o:STDSERA and WP>=44 and SG>1

This is how I would play it.

HF and p:innings pitched - Starter: p:innings pitched < op:innings pitched - Starter: op:innings pitched and (op:innings pitched - Starter: op:innings pitched) > Starter: op:innings pitched and 4 < op:BPRA < 11 and WP > 44 and SG > 1 and STDSERA <= o:STDSERA

In my opinion there is no need for more plays/season. Very good and consistent results. Thanks!

**Alex Vaile** · 05-21-14, 04:21 PM

It comes up as an error when I tried it. Is there a space needed somewhere?

**JMon** · 05-21-14, 04:27 PM

Originally posted by BasesLoaded314

thanks tarosill! I wasn't able to verify the results of the "system" I posted earlier, but I did come across this:

A and (190>line>129 or 115>line) and 4.11>STDSERA>2.97 and conference=NL and (p:innings pitched-Starter: p:innings pitched)>=5

very nice

**JMon** · 05-21-14, 04:53 PM

Originally posted by tarosill

This is how I would play it.

HF and p:innings pitched - Starter: p:innings pitched < op:innings pitched - Starter: op:innings pitched and (op:innings pitched - Starter: op:innings pitched) > Starter: op:innings pitched and 4 < op:BPRA < 11 and WP > 44 and SG > 1 and STDSERA <= o:STDSERA

In my opinion there is no need for more plays/season. Very good and consistent results. Thanks!

Very nice you two!

**JMon** · 05-21-14, 04:55 PM

Originally posted by Alex Vaile

It comes up as an error when I tried it. Is there a space needed somewhere?

Alex they put a space after the : to avoid posting of a emoticon. You need to remove that space.

**JMon** · 05-21-14, 05:01 PM

Originally posted by tarosill

This is how I would play it.

HF and p:innings pitched - Starter: p:innings pitched < op:innings pitched - Starter: op:innings pitched and (op:innings pitched - Starter: op:innings pitched) > Starter: op:innings pitched and 4 < op:BPRA < 11 and WP > 44 and SG > 1 and STDSERA <= o:STDSERA

In my opinion there is no need for more plays/season. Very good and consistent results. Thanks!

line <= -130 and SG = 3; produces 90% winners! will be noted in my saved file

**emceeaye** · 05-21-14, 05:40 PM

Nice Jmon!
If only we would have known about this 3 days ago to benefit from it...hopefully it'll come back around soon!

Originally posted by JMon

line <= -130 and SG = 3; produces 90% winners! will be noted in my saved file

**Alex Vaile** · 05-21-14, 07:39 PM

Originally posted by JMon

Alex they put a space after the : to avoid posting of a emoticon. You need to remove that space.

O ok thanks JMON I got it now.

**BasesLoaded314** · 05-21-14, 11:44 PM

month = 6 and streak = 2 and 3.01 > (p:innings pitched - Starter: p:innings pitched) > 1.32 and SG = 2 and line>-221
month = 6 and 9>streak>4

**BasesLoaded314** · 05-22-14, 12:06 AM

month = 6 and streak = 2 and 3.01 > (p:innings pitched - Starter: p:innings pitched) > 1.32 and s:SRA<5 and line>-191 and 8>os:SRA>2 and 8>oss:SRA and 8>osss:SRA and 6>ossss:SRA

**BasesLoaded314** · 05-22-14, 12:16 AM

month = 6 and streak = 2 and 3.01 > (p:innings pitched - Starter: p:innings pitched) > 1.32 and (op:hits=8 or op:hits=9)

**BasesLoaded314** · 05-22-14, 12:30 AM

be careful with all those, I just noticed the base query produced amazing results in 2013, 2012, 2008 and 2004 however all the other seasons showed no edge

**BasesLoaded314** · 05-22-14, 01:09 AM

month=6 and H and (STDSERA - o :STDSERA)<-1.8 and (day=Friday or day=Saturday) and 0<s:SRA<6

**BasesLoaded314** · 05-22-14, 01:11 AM

month=6 and H and (STDSERA - o:STDSERA)<-1.8 and (day=Friday or day=Saturday) and 6>s:SRA>0

**BasesLoaded314** · 05-22-14, 01:31 AM

month = 6 and H and (STDSERA + o:STDSERA) > 8.3 and s:SRA = 0 and total>7 and os:SRA!=0

**BasesLoaded314** · 05-22-14, 01:45 AM

month = 6 and HF and s:SRA = 4 and (SG=2 or SG=3)
month = 6 and HF and s:SRA = 4 and SG=1

**BasesLoaded314** · 05-22-14, 02:31 AM

month = 6 and p:hits = 11 and (s:SRA = 2 or s:SRA = 3) and (H or F) and os:SRA > 1 and 6 > op:runs > 0

**JMon** · 05-22-14, 07:49 AM

Originally posted by BasesLoaded314

month = 6 and p:hits = 11 and (s:SRA = 2 or s:SRA = 3) and (H or F) and os:SRA > 1 and 6 > op:runs > 0

Thanks bases...very nice. I tweaked it for action

(month = 8 or month = 6) and 11 >= p:hits >= 8 and (s:SRA = 2 or s:SRA = 3) and site = home and -110 > line >= -250 and os:SRA > 1 and 5 > op:runs > 0 and total < 11 and SG < 3

**Alex Vaile** · 05-22-14, 09:19 AM

Originally posted by BasesLoaded314

month = 6 and streak = 2 and 3.01 > (p:innings pitched - Starter: p:innings pitched) > 1.32 and s:SRA<5 and line>-191 and 8>os:SRA>2 and 8>oss:SRA and 8>osss:SRA and 6>ossss:SRA

Looks like a great query Bases. Anything for today's games?

**BasesLoaded314** · 05-22-14, 01:19 PM

Originally posted by Alex Vaile

Looks like a great query Bases. Anything for today's games?

month = 5 and streak = 2 and -2>=o:streak>=-5 and line<-131 and s:SRA<6 and os:SRA!=0 and day!=Wednesday and F

month = 6 and streak=1 and F and 7>s:SRA and 8>os:SRA and (ss:SRA!=1 or ss:SRA!=2) and (sss:SRA>4 or sss:SRA<3) and SG<4 and 15>p:hits>5 and op:hits>6 and 14>pp:hits and 26>op:LOB>5