1. #36
    green7
    green7's Avatar Become A Pro!
    Join Date: 10-21-10
    Posts: 190

    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.

  2. #37
    green7
    green7's Avatar Become A Pro!
    Join Date: 10-21-10
    Posts: 190

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

  3. #38
    Mako-SBR
    Mako-SBR's Avatar Become A Pro!
    Join Date: 10-15-13
    Posts: 492
    Betpoints: 3262

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

  4. #39
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7160

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

  5. #40
    b1slickguy
    WDKYWMYAK
    b1slickguy's Avatar SBR PRO
    Join Date: 11-24-11
    Posts: 11,069
    Betpoints: 28935

    Quote Originally Posted by OLY View Post
    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.

  6. #41
    green7
    green7's Avatar Become A Pro!
    Join Date: 10-21-10
    Posts: 190

    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.

  7. #42
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by green7 View Post
    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

  8. #43
    figue
    Update your status
    figue's Avatar Become A Pro!
    Join Date: 07-23-10
    Posts: 2,524
    Betpoints: 2638

    Quote Originally Posted by JMon View Post
    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

  9. #44
    figue
    Update your status
    figue's Avatar Become A Pro!
    Join Date: 07-23-10
    Posts: 2,524
    Betpoints: 2638

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

    giants

  10. #45
    green7
    green7's Avatar Become A Pro!
    Join Date: 10-21-10
    Posts: 190

    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.

  11. #46
    JR007
    JR007's Avatar Become A Pro!
    Join Date: 02-21-10
    Posts: 5,279

    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

  12. #47
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    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.

    Points Awarded:

    nash13 gave JMon 1 Betpoint(s) for this post.


  13. #48
    figue
    Update your status
    figue's Avatar Become A Pro!
    Join Date: 07-23-10
    Posts: 2,524
    Betpoints: 2638

    Quote Originally Posted by figue View Post
    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 ??

  14. #49
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by figue View Post
    why the site not show the play giants anymore ??
    who is the home dog now fig...line move

  15. #50
    figue
    Update your status
    figue's Avatar Become A Pro!
    Join Date: 07-23-10
    Posts: 2,524
    Betpoints: 2638

    Quote Originally Posted by JMon View Post
    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 ??

  16. #51
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by figue View Post
    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

  17. #52
    green7
    green7's Avatar Become A Pro!
    Join Date: 10-21-10
    Posts: 190

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

  18. #53
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    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...

  19. #54
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by green7 View Post
    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

  20. #55
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    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

  21. #56
    Mako-SBR
    Mako-SBR's Avatar Become A Pro!
    Join Date: 10-15-13
    Posts: 492
    Betpoints: 3262

    Quote Originally Posted by JMon View Post
    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...
    Quote Originally Posted by JMon View Post
    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!

  22. #57
    figue
    Update your status
    figue's Avatar Become A Pro!
    Join Date: 07-23-10
    Posts: 2,524
    Betpoints: 2638

    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.

  23. #58
    green7
    green7's Avatar Become A Pro!
    Join Date: 10-21-10
    Posts: 190

    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.

  24. #59
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    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

  25. #60
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by Mako-SBR View Post
    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.

  26. #61
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    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

  27. #62
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

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

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

  28. #63
    figue
    Update your status
    figue's Avatar Become A Pro!
    Join Date: 07-23-10
    Posts: 2,524
    Betpoints: 2638

    Quote Originally Posted by figue View Post
    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.

  29. #64
    figue
    Update your status
    figue's Avatar Become A Pro!
    Join Date: 07-23-10
    Posts: 2,524
    Betpoints: 2638

    late but ...yankees

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

  30. #65
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by figue View Post
    late but ...yankees

    AF and pp:LOB=14 and 7

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

  31. #66
    figue
    Update your status
    figue's Avatar Become A Pro!
    Join Date: 07-23-10
    Posts: 2,524
    Betpoints: 2638

    Quote Originally Posted by JMon View Post
    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.

  32. #67
    figue
    Update your status
    figue's Avatar Become A Pro!
    Join Date: 07-23-10
    Posts: 2,524
    Betpoints: 2638

    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

  33. #68
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by figue View Post
    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.

  34. #69
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    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
    Last edited by JMon; 04-04-14 at 10:33 AM.

  35. #70
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    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

First 12345 ... Last
Top