MLB - Situation Plays - SDQL

[green7]

HD and tA(W) < .42 and month < 7 and division = o:division and SG.

This one does well with the exception of series game 3.

[green7]

HD and tA(W) < .42 and month < 7 and division!=o:division

[Mako-SBR]

Green, don't put sentence periods at the end of your queries, it may confuse the noobs trying to learn.

[nash13]

hmm if you look at the las t seasons you can see that your trend is quite a bit upside down.

[b1slickguy]

This is some cool stuff.

Need to edit post.
Post the actual query, not the link. Mods do not allow and will delete.
Just a heads up for all.
Good luck.

[green7]

Typically a very good trend or angle will be winners either 3 out of 4, or 4 out of 5 years. Of course some angles reverse themselves and hopefully one doesn't bury themselves expecting it to turn around some time during the season.

Often an exceptional angle that has a poor year has a very profitable season the next year.

Is it always that way? If I could predict that, I would be writing this from my own personal tropical island.

Away divisional dogs had a -3.2% ROI last year when deleting Saturday/Sunday games, the second losing year since 2004.

Home divisional dogs <42% have been terrible the past two years after 8 straight years of profitability.

Home non-divisional dogs <42% were good again last year.

So, what will happen this year?....that is the essence of sports betting, it is discerning whether what has had relevance in the past will have it in the future. It is hoping, wishing and praying that what we do will pay off for ourselves, and it is hopefully helping some others along the way.

Good fortune to all of us this year.

[JMon]

HD and tA(W) < .42 and month < 7 and division = o:division and SG.

This one does well with the exception of series game 3.

Like it green..

played around with one...only one losing season in db

H and WP<55 and (month=4 or month=5) and SG!=3 and 170>=line>=105 and division=o:division

[figue]

Like it green..

played around with one...only one losing season in db

H and WP<55 and (month=4 or month=5) and SG!=3 and 170>=line>=105 and division=o:division

look like arizona is the play here but if we filter total 8.5 giants look better..

H and WP < 55 and (month = 4 or month = 5) and SG != 3 and 170 >= line >= 105 and division = o:division and total = 8.5

[figue]

HD and tA(W) < .42 and month < 7 and division = o:division and total=8.5

giants

[green7]

Good find Figue.....one of those little quirks that can at least keep you off of a play and maybe go the other way. Of course if you lose when reversing a trend, the tendency is to beat yourself up a little bit.

We all have a bruise or two from doing that....haha.

[JR007]

appreciate the learning curve, good luck this season.......you are right green, tough to figure what happened in the past will happen in the future......bases is the most statistical of all

[JMon]

Rolling with my first play of the year and not for the faint of hearts. SD vs Greinke and LAD. Play SD.

WP>50 and H and 165>line>=100 and o:WP>50 and SG<4 and (month=4 or month=5 or month=9 or month=10)

HD in dog month (April, May, Sept, and Oct) when both teams have a winning record

D and p: DW and p:runs <= 3 and SG < 5 and total < 10 and conference=o:conference

In conference play, good to take a dog off a low run win as a dog

site==home and line>=100 and Average(errors@team and season)<=.5 and p:runs<=3 and po:runs<=3 and 2007<=season

Play home dogs that are good fielding teams after scoring and allowing 3 runs or less. team=Padres were VERY good in this situation last year. This year...who knows????

gl if you play, like I said above I am only spot playing in here. I am a volume player and only hit 50-55% of my dogs plays.

[figue]

HD and tA(W) < .42 and month < 7 and division = o:division and total=8.5

giants

why the site not show the play giants anymore ??

[JMon]

why the site not show the play giants anymore ??

who is the home dog now fig...line move

[figue]

who is the home dog now fig...line move

thanks you rigth.i bet giants yesterday ,today no play.
so ,do we have to wait game time to run the querys and wait lines and totals moves ?? what is your procedure ??

[JMon]

thanks you rigth.i bet giants yesterday ,today no play.
so ,do we have to wait game time to run the querys and wait lines and totals moves ?? what is your procedure ??

it probably depends on personal preference on either betting opening or closing lines. Some like to get a good price; other like to watch for line movement.

Damn Padres load bases in the bottom of the ninth.. Looks like I am going to have me some Royals today

[green7]

game number<5 and HD and tA(W)<.42 and division=o:division and p:L

[JMon]

175 >= line >= 135 and t:conference = AL and tA(runs) <= 4.5 and p:L and p:margin >= -2 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.75 and SG>1 and day!=Saturday and 2006<=season

I will be curious if someone can translate this play on the Royals...

[JMon]

game number<5 and HD and tA(W)<.42 and division=o:division and p:L

I like both of those plays today, green for other reasons! gl

[JMon]

Lad total tonight

Like to see a total of 7 and under with a national league team only averaging 3.8 or less runs a game, off a one win game. Looking for months before July. April hits at a 80% clip!

total<=7 and tA(runs)<=3.8 and t:conference=NL and p:margin=1 and month<7 and 2008<=season and SG<4

[Mako-SBR]

175 >= line >= 135 and t:conference = AL and tA(runs) <= 4.5 and p:L and p:margin >= -2 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.75 and SG>1 and day!=Saturday and 2006<=season

I will be curious if someone can translate this play on the Royals...

Lad total tonight

Like to see a total of 7 and under with a national league team only averaging 3.8 or less runs a game, off a one win game. Looking for months before July. April hits at a 80% clip!

total<=7 and tA(runs)<=3.8 and t:conference=NL and p:margin=1 and month<7 and 2008<=season and SG<4

You on fire today my friend, both of these are sharp as a tack. Thanks!

[figue]

month<5 and line>0 and p:margin<3 and o:WP>=40 and p:runs>0 and season=2014 and total>7 and total<9.5

Tomorrow twins and cubs.

[green7]

AD and division=o:division and p:W and playoffs=0 and day!=Saturday and day!=Sunday and temperature<85

This has given an 11.2% ROI in the history of the database, and the return would be even better if you can use matchbook or pinnacle. It lost last year for the first time and barely won the year before. Perhaps the linemaker has caught up to this angle. It's started well this year,....the month of June has been the only losing month for this angle overall. Like many little quirks in our queries, I've got no idea why the game time temperature would affect the visitor's ability to win. I've mentioned previously that I think ballplayers go out on Friday and Saturday night on the road and it plays a negative part in their performance the next day.

[JMon]

we want to fade a conference fav under -210 after two mediocre 1 win games... check out how team=Pirates do in this situation and somewhat the Tigers do since '09

p:margin =1 and pp:margin=1 and F and line>-210 and month!=5 and conference=o:conference

[JMon]

You on fire today my friend, both of these are sharp as a tack. Thanks!

another close lose with a big dogs...however totals cleaned up. Just getting warmed up. Takes awhile to get the ol' mind switched over from sport to sport. At least mine it does...lol.

[JMon]

While this is not a great sample, but wanted to show the sweep angle in sdql and how one can filter a starter...Look how Anibal Sanchez has fared in trying to close out a home three game sweep since being a Tiger.

H and p:W and pp:W and SG=SGS=SG=3 and team=Tigers and starter=Anibal Sanchez

then look at him in the total database

H and p:W and pp:W and SG=SGS=SG=3 and starter=Anibal Sanchez

[JMon]

Interesting day situation worth looking at hitting at a 70+% clip

p:hits - po:hits >= 10 and A and day = Thursday and line <= 165

[figue]

month<5 and line>0 and p:margin<3 and o:WP>=40 and p:runs>0 and season=2014 and total>7 and total<9.5

Tomorrow twins and cubs.

nice 2-0 dogs.

[figue]

late but ...yankees

AF and pp:LOB=14 and 7<p:LOB<18 and -3<p:margin

[JMon]

late but ...yankees

AF and pp:LOB=14 and 7<p:LOB<18 and -3<p:margin

that's nice fig, where did/how you find this one?

[figue]

that's nice fig, where did/how you find this one?

from SDB grup ,i ask for some query for RL-1.5+money and someone give this there from another forum.

[figue]

stolen this:

Play Under - All teams where the total is 7 to 8.5 - bad team from last season (38% to 46%) playing a team that had a winning record last year, after 2 or more consecutive wins.
(37-9 since 1997.) (80.4%, +27 units. Rating = 4*)

WP>50 P:season p:W and pp:w o:WP>38 <46 help

[JMon]

stolen this:

Play Under - All teams where the total is 7 to 8.5 - bad team from last season (38% to 46%) playing a team that had a winning record last year, after 2 or more consecutive wins.
(37-9 since 1997.) (80.4%, +27 units. Rating = 4*)

WP>50 P:season p:W and pp:w o:WP>38 <46 help

I will have to work on this one, but it's possible.

[JMon]

Interleague FAV- fading a NL dog on the road. Simply logic, but profitable last year and over the database

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

[JMon]

Big Dog

Play dog off a upset win over divisional dog; revenging 4 straight losses

175>=line>=125 and P:L and PP:L and PPP:L and PPPP:L and p: DIV and p: DW