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.
This one does well with the exception of series game 3.
-
Comment -
HD and tA(W) < .42 and month < 7 and division!=o:divisionComment -
Green, don't put sentence periods at the end of your queries, it may confuse the noobs trying to learn.
Comment -
hmm if you look at the las t seasons you can see that your trend is quite a bit upside down.Comment -
Originally posted by OLY
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.Comment -
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.Comment -
Like it green..Originally posted by green7
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:divisionComment -
look like arizona is the play here but if we filter total 8.5 giants look better..Originally posted by JMon
H and WP < 55 and (month = 4 or month = 5) and SG != 3 and 170 >= line >= 105 and division = o:division and total = 8.5Comment -
HD and tA(W) < .42 and month < 7 and division = o:division and total=8.5
giantsComment -
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.Comment -
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 allComment -
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.
Comment -
why the site not show the play giants anymore ??Originally posted by figueComment -
who is the home dog now fig...line moveOriginally posted by figue
Comment -
thanks you rigth.i bet giants yesterday ,today no play.Originally posted by JMonwho is the home dog now fig...line move
so ,do we have to wait game time to run the querys and wait lines and totals moves ?? what is your procedure ??Comment -
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.Originally posted by figue
Damn Padres load bases in the bottom of the ninth..
Looks like I am going to have me some Royals today
Comment -
game number<5 and HD and tA(W)<.42 and division=o:division and p:LComment -
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...
Comment -
I like both of those plays today, green for other reasons! glOriginally posted by green7Comment -
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<4Comment -
Originally posted by JMon175 >= 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...You on fire today my friend, both of these are sharp as a tack. Thanks!Originally posted by JMon
Comment -
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.Comment -
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.Comment -
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:conferenceComment -
Originally posted by Mako-SBRYou 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.
Comment -
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 SanchezComment -
Interesting day situation worth looking at hitting at a 70+% clip
p:hits - po:hits >= 10 and A and day = Thursday and line <= 165Comment -
nice 2-0 dogs.Originally posted by figueComment -
late but ...yankees
AF and pp:LOB=14 and 7<p:LOB<18 and -3<p:marginComment -
Originally posted by figue
that's nice fig, where did/how you find this one?Comment -
from SDB grup ,i ask for some query for RL-1.5+money and someone give this there from another forum.Originally posted by JMonComment -
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
Comment -
I will have to work on this one, but it's possible.Originally posted by figuestolen 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
Comment -
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>=7Comment -
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: DWComment
