Go_Nads's Blog

Posted Sunday, January 06, 2013 03:48 PM

Better MLB Series O/U Chase

website to use: http://g.sportsdatabase.com/mlb/query

3 Game Series (change series games==3 to 2 or 4 for 2 or 4 game series)
American League: Sum(series game==series games==3)@season=2011 and division[0]=A and team
National League: Sum(series game==series games==3)@season=2011 and division[0]=N and team

Check how many of those 3 game series had at least one OVER
American League: Sum((O or p:O or pp:O)*(series game==series games==3))@season=2011 and division[0]=A and team
National League: Sum((O or p:O or pp:O)*(series game==series games==3))@season=2011 and division[0]=N and team

Check how many of those 2 game series had at least one OVER
American League: Sum((O or p:O)*(series game==series games==2))@season=2011 and division[0]=A and team
National League: Sum((O or p:O)*(series game==series games==2))@season=2011 and division[0]=N and team

Check how many of those 4 game series had at least one OVER
American League: Sum((O or p:O or pp:O or ppp:O)*(series game==series games==4))@season=2011 and division[0]=A and team
National League: Sum((O or p:O or pp:O or ppp:O)*(series game==series games==4))@season=2011 and division[0]=N and team


Posted Sunday, January 06, 2013 03:11 PM

MLB Over/Under Series Chase Query

This is for the website: http://g.sportsdatabase.com/mlb/query

To query the total # of 3 game series (or 4 or 2 game series):

National League: Sum(series game==series games==3)@season=2011 and team=Nationals,Braves,Phillies,Mets,Marlins,Reds,Cardinals,Brewers,Pirates,Cubs,Astros,Giants,Dodgers,Diamondbacks,Padres,Rockies

American League: Sum(series game==series games==3)@season=2011 and team=Yankees,Orioles,Rays,'Blue Jays','Red Sox',Tigers,'White Sox',Royals,Indians,Twins,Athletics,Rangers,Angels,Mariners

(that is for 3 game series, to change to 4 or 2 game series, change the 3 to a 4 or 2 in the series games==3)

To see the total # of times each American League team (in a 3 game series) had game 1 go OVER (where the last 2 games went under):
Sum(U and p:U and pp:O and series game==series games==3)@season=2012 and team=Yankees,Orioles,Rays,'Blue Jays','Red Sox',Tigers,'White Sox',Royals,Indians,Twins,Athletics,Rangers,Angels,Mariners

Then to check GM1 U, GM2 O, GM3 U, you would change (U and p:U and pp:O) to (U and p:O and pp:U)

Little work involved, but much simpler than doing it manually. I'll keep checking for a simpler way.


Profile

User: Go_Nads
Joined: October 2012
Location: United States
Team:
Occupation:

Recent Posts

Archive

Categories