Giving this another shot

Question

I&#x27;ve been working with the SDQL again for MLB and made what I hope are improvements on what I&#x27;ve had in years past. Instead of using year long systems, this year I&#x27;m tailoring each query to the specific month, starting pitcher, or home plate umpire. For example:month = 4 and D and 2 &lt; pp:SHRA &#x2B; p:SHRA &lt; 5 and pp:BPRA &#x2B; p:BPRA &#xD;&#xA;&lt; 6 and rest &lt; 2 and -5 &lt; streak &lt; 6 and -9 &lt; site streak&#xD;&#xA; &lt; 8 and 40 &lt; WP &lt; 61Dogs in the month of April whose starters gave up either 3 or 4 home runs the past 2 games, and whose bullpens allowed less than 6 runs the last 2 games, who haven&#x27;t lost more than 4 in a row or won more than 5 in a row, or lost more than 8 in a row on the road/at home or won more than 7 on the road/at home, and have a winning percentage between 40% and 61%. That&#x27;s a mouthful, but the results since 2004 are a 103-66 record on an average moneyline of &#x2B;129 for an ROI of 39.5%. Last season these games were 10-8. These tweaks will limit the number of plays I make and hopefully reduce some of the volatility I&#x27;ve seen in years past. I&#x27;ll be posting more of my queries in this thread leading up to the baseball season starting. I wish everyone the best of luck this season. We&#x27;re all on the same team, after all.

BCap888 · Answer

I&#x27;ve been working with the SDQL again for MLB and made what I hope are improvements on what I&#x27;ve had in years past. Instead of using year long systems, this year I&#x27;m tailoring each query to the specific month, starting pitcher, or home plate umpire. For example:month = 4 and D and 2 &lt; pp:SHRA &#x2B; p:SHRA &lt; 5 and pp:BPRA &#x2B; p:BPRA &#xD;&#xA;&lt; 6 and rest &lt; 2 and -5 &lt; streak &lt; 6 and -9 &lt; site streak&#xD;&#xA; &lt; 8 and 40 &lt; WP &lt; 61Dogs in the month of April whose starters gave up either 3 or 4 home runs the past 2 games, and whose bullpens allowed less than 6 runs the last 2 games, who haven&#x27;t lost more than 4 in a row or won more than 5 in a row, or lost more than 8 in a row on the road/at home or won more than 7 on the road/at home, and have a winning percentage between 40% and 61%. That&#x27;s a mouthful, but the results since 2004 are a 103-66 record on an average moneyline of &#x2B;129 for an ROI of 39.5%. Last season these games were 10-8. These tweaks will limit the number of plays I make and hopefully reduce some of the volatility I&#x27;ve seen in years past. I&#x27;ll be posting more of my queries in this thread leading up to the baseball season starting. I wish everyone the best of luck this season. We&#x27;re all on the same team, after all.

sfg8 · Answer

hmmm. look forward to your plays...

BCap888 · Answer

Example 2: (Starting Pitcher)0 &lt; Mike Leake:s:home runs allowed and p:HR = 0When Mike Leake starts and he gave up at least 1 home run in his last start, and his team had no home runs in their previous game, the Reds are 23-9 winning by an average of 1.66 runs and a 34.9% ROI. In 2013 the Reds lost his first 2 starts that fit the system then won the last 8 to finish &#x2B;5.98 units on 10 plays.

BCap888 · Answer

Example 3month = 8 and D and sssss:SSO = 5 and 3 &lt; ssss:SSO &lt; 6 and 1 &lt; &#xD;&#xA;sss:SSO and ss:SSO &lt; 10 and s:SSO &lt; 10 and -7 &lt; streak &lt; 4 &#xD;&#xA;and -2 &lt; o:streak and season = 2013Dogs in August when the starter struck out 5 five starts ago, 4 or 5 four starts ago, more than 1 three starts ago, less than 10 two starts ago and less than 10 in his last start. The team must be on a streak less than &#x2B;4 and better than -7, and their opponent must be on a streak of better than -2. These games are 55-36 on an average line of &#x2B;136 for an ROI of 42.7%. In 2013: 10-7 &#x2B;7.58 units.

orhane · Answer

https://sportsdatabase.com/mlb/query?sdql=tp%3Aruns%3C%3D2&#x2B;and&#x2B;op%3Aruns%3C%3D2&#x2B;and&#x2B;conference&#x2B;%3DAL&amp;submit=S&#x2B;D&#x2B;Q&#x2B;L&#x2B;!a nice over/under system

orhane · Answer

minimum of 200 or better 300&#x2B; plays are good to avoid variances

BCap888 · Answer

That&#x27;s what I tried last year thinking that the more plays would lead to more consistency but I found out quickly that if on the season you won say 150 and lost 110 or so that would be really good for totals, but those 110 losses can come at any time and if they all happen within a short time frame you can go bust real fast. Just my way of thinking but I&#x27;d rather be looking at a small number of plays that have won consistently each season.  Less bankroll swings IMO. I agree that in the long term the systems with more plays are more likely to get to their average number of units won, but it will be a roller coaster ride getting there.

1958a · Answer

agree,if you let say, have 20 systems that win consistently for the last 5-6 years , then you are in the safe side.  Some of these systems will produce a losing season but most of them will be at the winning side.  I look for ROI&gt;20% and at least 50 games for the last 6 season (that is season&gt;2007).

orhane · Answer

i have round about 50 systems (some are based on logic other are big trends) for 6 sports (NBA, NFL, MLB, NHL, NCAAB and NCAAF) Maybe we can share with each other?

orhane · Answer

if ayone likes to share contact me via pm. here is a good one: https://sportsdatabase.com/mlb/query?sdql=S%28points%3Eo%3Apoints%40team+and+season%2CN%3D15%29%3E%3D12+and+WP%3E%3D62+and+season&submit=S+D+Q+L+!

BCap888 · Answer

Example 4 (Total)STR and o:STR and s:margin = -1 and s:streak = 2 and s:biggest lead &lt;&#xD;&#xA; 3 and s:errors &lt; 2 and -9 &lt; p:M8 &lt; 3 and p:M8 != -2 and -4 &#xD;&#xA;&lt; p:M1 &lt; 3Unders are 113-39 (74.3%) for a &#x2B;40.5% ROI.Last season 16-4 Unders &#x2B;54.0% ROI.

orhane · Answer

p:margin = 1 and pp:margin = 1 and Fone of my easiest. betting against home false favs

BCap888 · Answer

Here is the breakdown of the systems I&#x27;ll be using this year:Number of systems - 91Totals - 25Sides - 66Monthly - 39Starter - 40Umpire - 4Season Long Other - 8I know it seems like a lot of systems but it&#x27;s really not. There will only be about 6 monthly systems active on a given day, and the starter trends will only apply when the given starter is pitching. 2013 Results:There were 314 Totals plays that went 226-88 (72%) for a profit of 128.75 Units.There were 981 Side plays that went 660-321 (67.3%) for a profit of 420.86 Units.I haven&#x27;t yet broken down the monthly results or the starter results but when I do I&#x27;ll put those up too.The money management I&#x27;ll be using is a 3-Unit system. For each system that a play applies to will be worth one unit. 1 Unit will be 2% of my current bankroll, 2 Units will be 3%, and 3 Units will be 4%. If a play comes up more than three times it will still only be worth 3 Units.And finally, in addition to putting the plays for each day in this thread I&#x27;ll also put them out through Twitter. The handle to go to for those is @Brian8CAP if that&#x27;s something you would find easier than checking the forum. BOL everybody.

orhane · Answer

good work. i will add you on twitter. i use them mostly for nba and nhl plays.

Kababayan · Answer

Thank you BCap

orhane · Answer

Do you only cover MLB?Added you on twitter.

BCap888 · Answer

I like to focus on baseball but I&#x27;ve got a few for NBA, NHL and NFL as well. I prefer betting a money line but I don&#x27;t really get into hockey.

1958a · Answer

there is always a "first time"gsw-2 ?A 28-0 TREND FOR IThttps://sportsdatabase.com/nba/query?sdql=rest&#x2B;%3D&#x2B;0&#x2B;and&#x2B;site&#x2B;%3D&#x2B;away&#x2B;and&#x2B;p%3Asite&#x2B;%3D&#x2B;away&#x2B;and&#x2B;p%3Aline&#x2B;%3C&#x2B;-4.5&#x2B;and&#x2B;p%3Amargin&#x2B;after&#x2B;the&#x2B;third&#x2B;%3E&#x2B;0&#x2B;and&#x2B;p%3Aline&#x2B;%3E&#x2B;-9.5&#x2B;and&#x2B;line&#x2B;%3E&#x2B;-6&#x2B;and&#x2B;o%3Arest&#x2B;%3C&#x2B;2&#x2B;and&#x2B;op%3Asite&#x2B;%3D&#x2B;home&#x2B;and&#x2B;streak&#x2B;%3E&#x2B;1&#x2B;and&#x2B;p%3Aats&#x2B;margin&#x2B;%3C&#x2B;18&#x2B;and&#x2B;p%3Apoints&#x2B;%2B&#x2B;po%3Apoints&#x2B;%3C&#x2B;201&#x2B;and&#x2B;op%3Apoints&#x2B;%3E&#x2B;82&amp;submit=S&#x2B;D&#x2B;Q&#x2B;L&#x2B;!

BCap888 · Answer

Month by month breakdown of 2013. I haven't included the Starter trends because there are only about 12 plays or so for each one per season so the monthly breakdown would be kind of random.

April

Sides - 90-53 Avg Line (126.1) +56.8 Units
Totals- 20-8 +11.2 Units

May

Sides - 58-42 Avg Line (136.6) +37.1 Units
Totals - 20-12 +6.5 Units

June

Sides - 67-43 Avg Line (134.7) +41.7 Units
Totals - 21-6 +14.4 Units

July

Sides - 121-42 Avg Line (-122.7) +74.5 Units
Totals - 17-15 +4.6 Units

August

Sides - 101-52 Avg Line (-102.4) +66.6 Units
Totals - 17-12 +3.4 Units

September

Sides - 44-30 Avg Line (136.3) +28.0 Units
Total - 18-2 +15.8 Units

In July and August favorites become a little more valuable so a lot of those two months' systems take advantage of that.

One other thing I haven't addressed yet is when two teams that are playing each other come up on different systems. If they show up the same number of times, I'll just cancel them out, but if one is more than the other I'll wager the net amount of units.

bruin95 · Answer

&#xD;&#xA; &#xD;&#xA;The way undefeated or perfect trends have been going on sportsdatabase lately, you probably just gave this one the kiss of death, LOL!  Yesterday, I found one that was 27-0, since January, in the NBA.  There were 3 teams that qualified.  The result---0-3.  Never fails.  Put money on it, and it loses.  Same thing happened on Tuesday.  Two perfect trends in effect, involving 4 teams.  0-4.  I lose more money on trend betting than with any other method.

orhane · Answer

short term trends are not working for me. mine have to be at least 8 out of 10 seasons in profit and high volume. otherwise it is just law of averrages.

BCap888 · Answer

Example 5 (Starter)Madison Bumgarner:s:walks allowed&lt;3 and -4&lt;streak&lt;2Giants are 47-19 on an average line of -124 for a &#x2B;32.3% ROI and &#x2B;27.7 units since 2009. The UNDER is also fairly profitable for this one as well, but I&#x27;m focused on the side.During the season when I post plays I&#x27;ll put up something like this as well as give the year to date numbers and last 7 days numbers:AprilRoyals &#x2B;120 (1 to win 1.2)Twins &#x2B;135 (2 to win 2.7)StarterDavid Price - Rays -130 (1.3 to win 1)UmpireJim Reynolds - Tigers/Athletics O7.5 -110 (1.1 to win 1)OtherOrioles/Blue Jays U8 -110 (2.2 to win 2)On Twitter I&#x27;ll only be listing the plays and units wagered and not all of the other info. Starting to think opening day may never get here...

orhane · Answer

Will you post the trends too or just the picks?

BCap888 · Answer

Probably just the picks. I can put the background of the systems though, like the ROI or the record of it for the current season.

BCap888 · Answer

Example 6 (Month) April Underdogmonth=4 and D and -6&lt;p:margin&lt;3 and 4&lt;p:SO&lt;8 and 4&lt;p:SIP&lt;8 and p:SHRA&lt;3 and p:HR&lt;3 and WP&lt;75 and -7&lt;streak&lt;4 and p:PU&lt;7 and 8&lt;p:LOB&lt;17 and o:STR and rest&lt;2 and p:errors&lt;3 and 1&lt;p:fly balls&lt;14 and -5&lt;o:streak and p:runs!=6 and p:runs!=596-61 Avg Line of 131.1 &#x2B;42% ROI2013: 13-5 &#x2B;10.85 Units &#x2B;60.2% ROI Average Score of 5.1 to 3.9

Giving this another shot

Hot Forum Topics