Last 10 MLB Over System

https://www.sportsdatabase.com/mlb/query?sdql=H+and+season%3D2014+and+tS%28ou+margin%2CN%3D10%29%2BoS%28ou+margin%2CN%3D10%29%3E40&submit=S+D+Q+L+!

 

1958, I really appreciate that.  If I understand it correctly, it was more than I was expecting.  Would you mind translating this into plain english for me please.

"H and season = 2014 and tS(ou margin,N=10) + oS(ou margin,N=10) > 40"

 

Thanks again!

the over/under margin summation of last 10 games for the team and its opponent.  H is for home team so that games are not reported twice.  Do not know if this is what you are asking but some of the over plays do come in...
if you put <-40  you get toadys under play that lost unfortunately.

If I am correct, we need to add the other qualification that each  team has a O/U differential of at least 10+ as well.  I attempted to add that here:

H and season=2014 and tS(ou margin,N=10)+oS(ou margin,N=10)>40 and tS(ou margin,N=10)>10 and oS(ou margin,N=10)>10

All the >40 and >10 can be changed to <-40 and <-10 to get the Under plays if we do it exactly opposite of the Over plays.

 

Overs:

https://www.sportsdatabase.com/mlb/query?sdql=H+and+season%3D2014+and+tS%28ou+margin%2CN%3D10%29%2BoS%28ou+margin%2CN%3D10%29%3E40+and+tS%28ou+margin%2CN%3D10%29%3E10+and+oS%28ou+margin%2CN%3D10%29%3E10&submit=S+D+Q+L+%21

Unders:

https://www.sportsdatabase.com/mlb/query?sdql=H+and+season%3D2014+and+tS%28ou+margin%2CN%3D10%29%2BoS%28ou+margin%2CN%3D10%29%3C-40+and+tS%28ou+margin%2CN%3D10%29%3C-10+and+oS%28ou+margin%2CN%3D10%29%3C-10&submit=S+D+Q+L+%21

Top Under bet for APR 17 result:

1. SEA (-17.5) + TEX (-21) = -38.5, bet Under 9, lost

Under System at 0-1

(I'm not going to include the past Under System results of 5-1 as listed in post #63, because those were not posted pre-game time, but I think it's important to remember that they're there.)

Thanks to everyone for contributing their knowledge to this thread.

Feel free to add any info or comments.

I'd like to keep tracking both the Over and Under systems for now even though I think the Over one will turn out to be a non-moneymaker and the Under one will... just a gut feeling...

 

APR 18

No Over play today, Over System at 6-2.

Under System at 0-1

Top Under bet today:

2. NYY (-2) + TB (-13) = -15, bet Under 7.5

I have tweaked my previous query that was built with the help of 1958a.  Notice today’s date, 20140418 in the query and the link.  This will weed out all the extra past and future dates we don’t care about but you will have to change it every day.  It is easier to just go to the web page and paste the query in the field, change the date and click Submit.

 

https://www.sportsdatabase.com/mlb/query

 

Over Plays Query:

 

H and season=2014 and date = 20140417 and tS(ou margin,N=10)+oS(ou margin,N=10)>40 and tS(ou margin,N=10)>10 and oS(ou margin,N=10)>10

 

Returns teams with totals  greater than 10 and a combined total greater than 40.

 

https://www.sportsdatabase.com/mlb/query?sdql=H+and+season%3D2014+and+date+%3D+20140417+and+tS%28ou+margin%2CN%3D10%29%2BoS%28ou+margin%2CN%3D10%29%3E40+and+tS%28ou+margin%2CN%3D10%29%3E10+and+oS%28ou+margin%2CN%3D10%29%3E10&submit=S+D+Q+L+%21

 

 

Under Plays Query:

 

H and season=2014 and date = 20140418 and tS(ou margin,N=10)+oS(ou margin,N=10)< 0 and tS(ou margin,N=10)< 0 and oS(ou margin,N=10)< 0

 

Returns teams with negative totals and a negative combined total.

 

https://www.sportsdatabase.com/mlb/query?sdql=H+and+season%3D2014+and+date+%3D+20140418+and+tS%28ou+margin%2CN%3D10%29%2BoS%28ou+margin%2CN%3D10%29%3C+0+and+tS%28ou+margin%2CN%3D10%29%3C+0+and+oS%28ou+margin%2CN%3D10%29%3C+0&submit=S+D+Q+L+%21

 

EDIT ^  I still had yesterdays date in the Over Play Query.

To save yourself from having to change the date to get just today's predictions you can do: date=today

Sweet!  I searched for that in the pdf help file but did not find it.  Glad to know it works!

I noticed that if you only look back to the most recent 5 games when adding up the differential, instead of 10, then last year, while there were fewer plays, the system was 18-10-1 instead of 40-46-3.

Thanks for your work in this thread Canis, and to the others as well, although nice to find the profitable L5 game system play, it exists too rarely enough for me to be interested in it...