MLB - Situation Plays - SDQL

[emceeaye]

I was wondering can the New York Yankees bounce back after the yesterday's loss?

team = Yankees and starter = Hiroki Kuroda and s:W and p:L and H

Let's see.

This is a good one posted by Jmon earlier that certainly also points to Yankees:

conference=NL and o:conference=AL and A and 230>=line>-105 and month<8 and 9.5>=total>=7

[JMon]

Not on this game personally, but wanted to share...fading a BIG FAV in may

H and -185>line>=-235 and Sum(o:earned runs-starter earned runs@team and season)/Sum(9-starter innings pitched@team and season)<=3.75 and month=5 and 2008<=season and conference=o:conference and total<10.5

[green7]

taking the Chisox tonight JMon.

[Roadkill86]

My records show I stole this one from JMon...

A and 10 > = total > = 7 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) < = 3.33 and conference = NL and Sum(hits@team and season) / Sum(at bats@team and season) < = .250 and o:conference = NL and STDSERA < = 2.70 and 2011< =season and SG!=2

[JMon]

taking the Chisox tonight JMon.

bol friend

[Alex Vaile]

STR and o:STR and s:margin = -1 and s:streak = 2 and s:biggest lead < 3 and s:errors < 2 and -9 < p:M8 < 3 and p:M8 != -2 and -4 < p:M1 < 3

What streak is it showing?

[Mako-SBR]

Not on this game personally, but wanted to share...fading a BIG FAV in may

H and -185>line>=-235 and Sum(o:earned runs-starter earned runs@team and season)/Sum(9-starter innings pitched@team and season)<=3.75 and month=5 and 2008<=season and conference=o:conference and total<10.5

taking the Chisox tonight JMon.

Same, thanks J, BOL on this one all.

[Roadkill86]

season>2011 and SG=3 and playoffs=0 and p:X and conference=NL and H

What happens to the totals in NL game 3s after game 2 goes extras?

[JMon]

After observing the Rangers box scores this morning...to my surprise I found this!!

55>=WP>=50 and p:margin<=-5 and A and 2006<=season and 155>line>=-200

Fade a road winning team off a big loss...simple as that

[green7]

Along the same lines as JMon

HD and tA(W)<.42 and DIV and game number>20 and p:runs-po:runs>4 and NGT


We are taking a terrible team with a WP<42 as a home divisional dog after winning big yesterday.


Also.....

pp:ADL and p:ADL and AD and series game=3 and not DIV and C and po:runs-p:runs>4 and DAY


so, I am taking the White Sox again today, which makes me either tenacious or a glutton for punishment.

[emceeaye]

I may go with the dog here as well but when you add tA(W)<.42 to Jmon's hammer play, although the N is low, the results aren't as promising:

H and tA(W)<.42 and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month!=7 and month!=8) and 2008<=season and SG > 1

HD and tA(W)<.42 and DIV and game number>20 and p:runs-po:runs>4 and NGT


We are taking a terrible team with a WP<42 as a home divisional dog after winning big yesterday.


Also.....

pp:ADL and p:ADL and AD and series game=3 and not DIV and C and po:runs-p:runs>4 and DAY


so, I am taking the White Sox again today, which makes me either tenacious or a glutton for punishment.

[JMon]

I may go with the dog here as well but when you add tA(W)<.42 to Jmon's hammer play, although the N is low, the results aren't as promising:

H and tA(W)<.42 and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month!=7 and month!=8) and 2008<=season and SG > 1

the hammer play is only active when the margin of victory is p:margin>7, which is tonight. Signaling a wp<40 is a good filter to the original query though

[green7]

Good find emceeaye

Looked at your update and it got me juicing out of the Astros play.

Do I really want to be putting my money on the Astros?.....hmmm, not today.

Good luck if you're taking them guys.

[Alex Vaile]

Total <= 7 and tA(runs) <= 3.3 and oA(runs) <= 3.8 and conference = NL and o:conference = NL and rest = 0 and 2011<=season
TOTAL ACTION QUERY ACTIVE TODAY!

[green7]

interleague angle

This is relevant to the NY/NY game tonight.....trend towards the under.

P:L and PP:L and AF and conference=AL and not C

[JMon]

Looked at your update and it got me juicing out of the Astros play.

Do I really want to be putting my money on the Astros?.....hmmm, not today.

Good luck if you're taking them guys.

why?

[emceeaye]

because teams with under 42% winning percentage don't do as well

why?

Jmon's hammer play has been good to me in the past. But when you look at the outcome of the 23 games in this situation when the home team has a winning percentage of under 42%, you see that the home dog's chances of winning is around 48%...not too good.

Update: well it looks like I had margin of p:margin>3 for the hammer play instead of margin>7...not sure how that happened. In the case of the latter, it still favors the dog...

Sorry if this screwes it up for you, Green.

[Roadkill86]

season>2011 and SG=3 and playoffs=0 and p:X and conference=NL and H

What happens to the totals in NL game 3s after game 2 goes extras?

It gets rained out. That's what.

[Roadkill86]

p:L and WP>60 and H and DAY and o:WP<50 and p:hits<7 and SG>1

This will be active in the morning

[Capper1124]

[green7]

Obviously I didn't look at the query in question closely enough.

The query below brings a 23.9% return, though series game 3s are not as good as the other SGs.


HD and tA(W)<.42 and p:margin >= 7 and DIV


And this one brings a 13% ROI.


HD and tA(W)<.42 and p:margin >= 7 and not DIV and C



The onus is on each individual to check everything in a query that someone else puts out before lining up at the wagering window.

Lesson learned.

[JMon]

Been working on this total. It has hit decent throughout the database, but more predominantly since 2012 (due to number of games). Months of 4 and 5 seem modest before the 2012 era. Interleague play has been weeded out- also one should note the NL conference within this situation.

Logic is rather simple here. We are basically taking the under of a team with a poor BA against a team with a decent BP; starting a pitcher on good rest. Enjoy and good luck

Sum(hits@team and season) / Sum(at bats@team and season) <= .255 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.33 and 8.5>=total>=8 and starter rest >= 7 and conference=o:conference and rest<4 and 2012<=season

[JAnthony]

Been working on this total. It has hit decent throughout the database, but more predominantly since 2012 (due to number of games). Months of 4 and 5 seem modest before the 2012 era. Interleague play has been weeded out- also one should note the NL conference within this situation.

Logic is rather simple here. We are basically taking the under of a team with a poor BA against a team with a decent BP; starter a pitcher on good rest. Enjoy and good luck

Sum(hits@team and season) / Sum(at bats@team and season) <= .255 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.33 and 8.5>=total>=8 and starter rest >= 7 and conference=o:conference and rest<4 and 2012<=season

It returns even better results, if you take that total all the way up to 10. (10>=total>=8)

[JMon]

It returns even better results, if you take that total all the way up to 10. (10>=total>=8)

from 2012<=season indeed it does, I was more inclined to keep the integrity of the situation pre =2012, where 9,9.5 seem to be mediocre at best. I will definitely will save up to 10 and make note to watch >8.5. Thanks

[emceeaye]

Here is another one

Thanks Jmon,

Here's another one I came up with. It's also pretty intuitive and includes any home fav with a winning percentage higher than 45%, who won their last game by at least 2 runs; also scored a total of 30 runs over their last 6; and their opponent never led in their last game:

HF and tA(W)>=.45 and p:margin>=2 and tS(runs@team and season,N=6)=30 and po:BL=0 and season>=2008.

SU: 67-24 (1.35, 73.6%) avg line: -158.7 / 144.0 on / against: +$3,050 / -$3,382 ROI: +21.1% / -37.2%
RL: 45-46 (-0.12, 49.5%) avg line: 138.8 / -151.4 on / against: +$1,578 / -$2,118 ROI: +17.1% / -15.3%
OU: 43-45-3 (0.21, 48.9%) avg total: 8.4 over / under: -$605 / -$285 ROI: -6.1% / -2.

tweaks and improvements appreciated.

[BasesLoaded314]

p:date = date -1 and pp:date = date -1 and o:rest>0

p:date = date -1 and pp:date = date -1 and SG = 1 and 161>line>-171 and pp:margin<2



lol, looks like no action here. I was about to pound the rockies

[JMon]

p:date = date -1 and pp:date = date -1 and o:rest>0

p:date = date -1 and pp:date = date -1 and SG = 1 and 161>line>-171 and pp:margin<2



lol, looks like no action here. I was about to pound the rockies

nice sdql work...if you would please enlighten (translation) the noobs when you post a query as it helps in the learning process.

[JR007]

[Roadkill86]

Man, the Athletics pounded the Indians tonight. I wonder what happens when a winning AL team wins by 10 or more in the 1st game of a series on the road against a losing team, and is favored to win again the next day....

AF and p:W and SG=2 and p:margin > 9 and WP > 50 and o:WP < 50 and conference=AL

[Alex Vaile]

Nice query for tomorrow! Thanks Roadkill

[Roadkill86]

The Diamondbacks are a dog at home tomorrow, facing a starter with a ERA under 2, and just got blanked by 6 or more runs. D-Backs home win % is under .500, and the total is 8 (or more). Sounds like an easy under, right?

HD and o:STDSERA < 2.2 and STDSERA > 3.8 and p:margin < -5 and month!=4 and HWP < 50 and total >= 8

[JMon]

Man, the Athletics pounded the Indians tonight. I wonder what happens when a winning AL team wins by 10 or more in the 1st game of a series on the road against a losing team, and is favored to win again the next day....

AF and p:W and SG=2 and p:margin > 9 and WP > 50 and o:WP < 50 and conference=AL

[JMon]

good work roadkill

[JMon]

Thanks Jmon,

Here's another one I came up with. It's also pretty intuitive and includes any home fav with a winning percentage higher than 45%, who won their last game by at least 2 runs; also scored a total of 30 runs over their last 6; and their opponent never led in their last game:

HF and tA(W)>=.45 and p:margin>=2 and tS(runs@team and season,N=6)=30 and po:BL=0 and season>=2008.

SU: 67-24 (1.35, 73.6%) avg line: -158.7 / 144.0 on / against: +$3,050 / -$3,382 ROI: +21.1% / -37.2%
RL: 45-46 (-0.12, 49.5%) avg line: 138.8 / -151.4 on / against: +$1,578 / -$2,118 ROI: +17.1% / -15.3%
OU: 43-45-3 (0.21, 48.9%) avg total: 8.4 over / under: -$605 / -$285 ROI: -6.1% / -2.

tweaks and improvements appreciated.

H and tA(W)>=.45 and p:margin>=2 and tS(runs@team and season,N=6)=30 and po:BL=0 and 120>=line>=-195 and conference=o:conference and total<=10 and SG>1 and month>4 and 2008<=season

good throughout the DB too.

[JMon]

wow...

team=Mariners and po:hits>=12 and AD