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

    MLB - Situation Plays - SDQL

    A continuation of what we started in the NBA thread, this will be the headquarters for pursuing MLB plays using SDQL-based research.

    Remember to add spaces after the colon-p parameters when posting queries here on SBR, because the board auto adds emoticons that screw up the text (and when copy/pasting the queries others have posted here previously be sure to take said spaces back out again.

    I'll start off with a query I tinkered around with a bit this week to prep for the pending season, it deals with home dogs having a win rate of 51% or higher on the season going similarly talented opponents in their own division who have a similar win rate or slightly higher:

    HD and WP>=51 and o:WP>=61 and division=o:division and season>=2006

    SU: 48-26 (0.32, 64.9%) avg line: 114.6 on / against: +$2,950 ROI: +39.9%

    BOL to all who contribute and thanks for sharing your hard work for everyone to benefit from.
    Points Awarded:

    LiarGame gave Mako-SBR 1 Betpoint(s) for this post.


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

    This one is for April Only

    DIV and D and p:W and 40<o:WP< 50 and season>=2010 and line<=166 and month=4

    SU: 28-16 (0.39, 63.6%)

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

    Nice figue, any time I see the ROI go over 40% I get excited...

    When Jmon starts posting his best ours will go to the back of the short bus but it's still good to get them out there for discussion/learning.

  4. #4
    NBACover
    NBACover's Avatar Become A Pro!
    Join Date: 02-26-14
    Posts: 85

    I'll be here over the season, just checking in.

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

    Can't wait

  6. #6
    Noleafclover
    Noleafclover's Avatar Become A Pro!
    Join Date: 06-06-13
    Posts: 1,349
    Betpoints: 3010

    Excited!

  7. #7
    tonywayne
    tonywayne's Avatar Become A Pro!
    Join Date: 11-05-13
    Posts: 229
    Betpoints: 244

    I just started betting back in Oct/Nov, and I'm REALLY looking forward to baseball season. This thread is going to be a big help, and I will contribute when & where I can.

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

    jmon any query for this :

    since 2008, pitchers coming off 1st career CG Shutout are combined 9-21 (16 ND) 5.89 ERA & 1.67 WHIP / opposing teams are 32-14 (70%)

    betting the OVER -vs- pitchers coming off 1st career CG Shutout have been $$$$ L6 years / 27-11-8 (1st 5) OVER & 31-11-4 (FG) OVER

  9. #9
    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
    jmon any query for this :

    since 2008, pitchers coming off 1st career CG Shutout are combined 9-21 (16 ND) 5.89 ERA & 1.67 WHIP / opposing teams are 32-14 (70%)

    betting the OVER -vs- pitchers coming off 1st career CG Shutout have been $$$$ L6 years / 27-11-8 (1st 5) OVER & 31-11-4 (FG) OVER
    fading a pitcher coming of a complete game or perfect game is usually a nice fade. However using 1st career and sdql may be impossible or if it is possible I do not know how to do it.

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

    Teacher jmon,do you have this for april on your data base??

    line > 0 and p:margin < 3 and o:WP >= 40 and p:runs > 0 and month = 4

  11. #11
    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
    Teacher jmon,do you have this for april on your data base??

    line > 0 and p:margin < 3 and o:WP >= 40 and p:runs > 0 and month = 4
    I'm sure I have something similar. Puppies have been taking a beat down the last two years in the month of April; which is the normal spot to find them. Just like favs in the summer, when the bats and ball heat up. I'm working on my database now, which is a nightmare. Looking for line and/or scheduling adjustments.

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

    Look good...

    H and p:margin > 7 and op:runs = 0 and season > 2008 and WP < 60 and o:WP > 38.5 and rest = 0

  13. #13
    b1slickguy
    WDKYWMYAK
    b1slickguy's Avatar SBR PRO
    Join Date: 11-24-11
    Posts: 11,066
    Betpoints: 28921

    Quote Originally Posted by JMon View Post
    Can't wait
    Just reloaded Puppy Slacko on my sdql laptop. Ready for some doggies now. Woof Woof

    We are becoming an army, fellas.
    Good luck to all this season.

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

    Quote Originally Posted by b1slickguy View Post
    Just reloaded Puppy Slacko on my sdql laptop. Ready for some doggies now. Woof Woof

    We are becoming an army, fellas.
    Good luck to all this season.

  15. #15
    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
    Look good...

    H and p:margin > 7 and op:runs = 0 and season > 2008 and WP < 60 and o:WP > 38.5 and rest = 0
    like this one fig . doggies perform in this one very nicely, so I eliminated summer months. The situation doesn't do will in interleague play, so I eliminated those. As well as the first game of a series. I ran a "group by" and noticed margins of 3 and 4 need to be captured...... p:margin=7,6,5,4,3,2,1

    H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month!=7 and month!=8) and 2008<=season and SG > 1

    I did make reference in my database for the original query of p:margin>7, with my additions, for a "Hammer Play" 28-3 SU (with dogs being a remarkable 8 and freakin 1

    Cheers

  16. #16
    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
    like this one fig . doggies perform in this one very nicely, so I eliminated summer months. The situation doesn't do will in interleague play, so I eliminated those. As well as the first game of a series. I ran a "group by" and noticed margins of 3 and 4 need to be captured...... p:margin=7,6,5,4,3,2,1

    H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month!=7 and month!=8) and 2008<=season and SG > 1

    I did make reference in my database for the original query of p:margin>7, with my additions, for a "Hammer Play" 28-3 SU (with dogs being a remarkable 8 and freakin 1

    Cheers
    Very cool, love it.

  17. #17
    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
    Very cool, love it.
    Mako and all..I'm a different animal when it comes to MLB betting vs. NBA. NBA, I spot play..MLB I am a volume bettor. I bet large amounts of money and games every single day. The last 3 years I have hit (each year) roughly 55-50% +40u on over 500+ plays. This is in course of a ML system player. I play many dogs, as well as favs; love totals. I will spot play in here ONLY. However, I will give the sdql query. Just keep in mind, my situations one must play them all, every day. Thus a bankroll is needed.

  18. #18
    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 this one fig . doggies perform in this one very nicely, so I eliminated summer months. The situation doesn't do will in interleague play, so I eliminated those. As well as the first game of a series. I ran a "group by" and noticed margins of 3 and 4 need to be captured...... p:margin=7,6,5,4,3,2,1

    H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month!=7 and month!=8) and 2008<=season and SG > 1

    I did make reference in my database for the original query of p:margin>7, with my additions, for a "Hammer Play" 28-3 SU (with dogs being a remarkable 8 and freakin 1

    Cheers
    even better :

    H and p:margin >= 3 and op:runs = 0 and WP < 60 and o:WP > 38.5 and line > -230 and conference = o:conference and (month != 7 and month != 8) and 2008 <= season and SG > 1 and total > 6.5

  19. #19
    OLY
    OLY's Avatar Become A Pro!
    Join Date: 03-18-14
    Posts: 42

    This is going to be fun this season

  20. #20
    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 JMon View Post
    Mako and all..I'm a different animal when it comes to MLB betting vs. NBA. NBA, I spot play..MLB I am a volume bettor. I bet large amounts of money and games every single day. The last 3 years I have hit (each year) roughly 55-50% +40u on over 500+ plays. This is in course of a ML system player. I play many dogs, as well as favs; love totals. I will spot play in here ONLY. However, I will give the sdql query. Just keep in mind, my situations one must play them all, every day. Thus a bankroll is needed.
    After two weeks, database is cleaned, adjusted, deleted, and ready for action! I have weeded out over 200 nonperforming trends/situations.

  21. #21
    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
    After two weeks, database is cleaned, adjusted, deleted, and ready for action! I have weeded out over 200 nonperforming trends/situations.
    cant wait !!

  22. #22
    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
    After two weeks, database is cleaned, adjusted, deleted, and ready for action! I have weeded out over 200 nonperforming trends/situations.
    That is awesome, school is about to be in session.

    "I brought my pencilllllllll..."

  23. #23
    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
    That is awesome, school is about to be in session.

    "I brought my pencilllllllll..."
    I hope so... no shortcut abbreviations in MLB.

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

    D and p: D and p:W and p:runs <= 3

    Easiest system I know. ROI is high enough, Big volume plays.

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

    I am a big fan of plays with higher volume and good return. Low numbers are an indicator for random moves in my opinion.
    So here are my fav Baseball plays (not all by me):

    HF and p: HD and p: margin > 4
    SU: 124-92 (0.73, 57.4%) avg line: -135.7 / 124.5 on / against: -$332 / -$746 ROI: -1.1% / -3.5%
    OU: 84-126-6 (-0.55, 40.0%) avg total: 8.7 over / under: -$5,360 / +$3,305 ROI: -22.7% / +13.8%

    p: margin = 1 and pp: margin = 1 and F

    SU: 297-264 (0.10, 52.9%) avg line: -151.2 / 137.4 on / against: -$8,843 / +$5,515 ROI: -10.4% / +9.8%
    OU: 250-283-27 (0.36, 46.9%) avg total: 8.7 over / under: -$5,780 / +$660 ROI: -9.4% / +1.1%

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

    Quote Originally Posted by nash13 View Post
    I am a big fan of plays with higher volume and good return. Low numbers are an indicator for random moves in my opinion.
    So here are my fav Baseball plays (not all by me):

    HF and p: HD and p: margin > 4
    SU: 124-92 (0.73, 57.4%) avg line: -135.7 / 124.5 on / against: -$332 / -$746 ROI: -1.1% / -3.5%
    OU: 84-126-6 (-0.55, 40.0%) avg total: 8.7 over / under: -$5,360 / +$3,305 ROI: -22.7% / +13.8%

    p: margin = 1 and pp: margin = 1 and F

    SU: 297-264 (0.10, 52.9%) avg line: -151.2 / 137.4 on / against: -$8,843 / +$5,515 ROI: -10.4% / +9.8%
    OU: 250-283-27 (0.36, 46.9%) avg total: 8.7 over / under: -$5,780 / +$660 ROI: -9.4% / +1.1%
    nice querys

  27. #27

  28. #28
    Cougs
    Cougs's Avatar Become A Pro!
    Join Date: 03-30-14
    Posts: 15
    Betpoints: 540

    JMon, I wanted to thank you for all your hard work, dedication and willingness to help everyone become smarter and more profitable! I stumbled upon SBR only a couple months ago, and thankfully, clicked on the NBA SDQL because it sounded analytical and evidence based as opposed to the numerous (and useless) "my picks", "LOCK OF THE DAY!", "guaranteed!" threads that populate this site (and are synonymous with losing strategies...). Also, much thanks to the others who contribute frequently (Mako, JAnthony, figue...and everyone else).

    Anyways, on to my point. As it relates to this baseball season, you mentioned above that your approach is entirely different that the situational betting you do in the NBA and that you've been very profitable with high volume betting the last few years. Will your plan be to share your queries with us such that if we chose to, we could bet all the games that you plan to? I would suspect that if we only were privy to some queries, our variance would be much higher. Obviously you don't owe anything to anyone, so if you chose not to share all, I would have no reason to complain...I only ask so I can determine whether high volume betting is for me or not.

    Lastly, the MLB SQDL bible with all the queries in there...are you a contributor to that? Would you recommend one to blindly be betting those queries??

    Thanks so much...and as I continue to learn and create my own queries, I'll be sure to share!

    Best of luck to all!

  29. #29
    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 Cougs View Post
    JMon, I wanted to thank you for all your hard work, dedication and willingness to help everyone become smarter and more profitable! I stumbled upon SBR only a couple months ago, and thankfully, clicked on the NBA SDQL because it sounded analytical and evidence based as opposed to the numerous (and useless) "my picks", "LOCK OF THE DAY!", "guaranteed!" threads that populate this site (and are synonymous with losing strategies...). Also, much thanks to the others who contribute frequently (Mako, JAnthony, figue...and everyone else).

    Anyways, on to my point. As it relates to this baseball season, you mentioned above that your approach is entirely different that the situational betting you do in the NBA and that you've been very profitable with high volume betting the last few years. Will your plan be to share your queries with us such that if we chose to, we could bet all the games that you plan to? I would suspect that if we only were privy to some queries, our variance would be much higher. Obviously you don't owe anything to anyone, so if you chose not to share all, I would have no reason to complain...I only ask so I can determine whether high volume betting is for me or not.

    Lastly, the MLB SQDL bible with all the queries in there...are you a contributor to that? Would you recommend one to blindly be betting those queries??

    Thanks so much...and as I continue to learn and create my own queries, I'll be sure to share!

    Best of luck to all!
    Cougs thank you for the kind words. The main reason why I post here is to help. I am a high volume player in MLB simply as I have many many dog systems, or situations if you will, that I use. Majority of my plays are dogs, but I also have my share of favs and totals as well. I usually hit around 50-55% over the season, but one needs to keep in mind (ex., +110 ml = 47.62% break even). So over the course of the MLB season (and its many games) one can see how units will add up, hitting 55% as a majority dog player! Keep in mind a volume player is not for everyone, where there will be days were one will go 1-7 and another 6-2.

    In this thread I will not post all my plays, nor situations, but will spot play with a play I like and give it's query. I will be more than happy to help any with MLB sdql, as one will find out (while the language and principle are similar) each sport and its use are different , or least it is for me.

    As for as the MLB SQDL bible, there is some great stuff in there, but I would not blindly bet it or anything for that matter. However, it is a great tool to learn the language. I pay no mind to it now as I have my own database, but it was a tool for me years ago. And no I am not a contributor it.

    Cheers

  30. #30
    Cougs
    Cougs's Avatar Become A Pro!
    Join Date: 03-30-14
    Posts: 15
    Betpoints: 540

    Thanks for the heads up, JMon. You're doing great work...and quite frankly, you know that you don't owe anything to anyone! I will look to learn from what you (and others) post. Great work and continued luck!

  31. #31
    Tillos
    Tillos's Avatar Become A Pro!
    Join Date: 03-28-14
    Posts: 179

    Hello. How do I type in 'no bigger'. For example; a team coming off an away favorite with a line no bigger than -145.

    p:AF and p:line<-145??

  32. #32
    GiveMeaBJ
    WIN WIN WIN
    GiveMeaBJ's Avatar Become A Pro!
    Join Date: 09-08-09
    Posts: 8,449
    Betpoints: 335

    So when do these come into effect? I am assuming can't just start on opening day or am I wrong?

  33. #33
    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 Tillos View Post
    Hello. How do I type in 'no bigger'. For example; a team coming off an away favorite with a line no bigger than -145.

    p:AF and p:line<-145??
    need to flip it around

    p:AF and p:line>-145

  34. #34
    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 GiveMeaBJ View Post
    So when do these come into effect? I am assuming can't just start on opening day or am I wrong?
    one has to wait until the situations happen to be predictive for the next game.. usually takes awhile for, opening day NOPE unless you have "previous season" stat queries... example like a team with a win % of 55-60 last season during the first 15 games of the year. How do they perform. Those would get you opening day queries!

    Off to the biz...gl

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

    Good day Guys.

    Here's one.

    month=4 and AD and day and division=o:division.

    Yes, April is typically a good dog month in particular circumstances.....though from this query we can see certain days bringing the best results. My theory is that young guys will spend their weekends out chasing skirts and imbibing in their favorite beverages and their performance will not as good on the road during and afterwards. If anyone has any other ideas behind the discrepancy of performance of different days, I'd be interested in hearing what they have to say.

1234 ... Last
Top