1. #36
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Quote Originally Posted by Scrivero View Post
    And when I mean everything I mean all your NHL picks and all the SDQL plays, but none of the other MLB picks, such as Angels tonight. Havent followed your other MLB picks, but like you said, NHL is your best skill, and I just love the SDQL stuff you have so theres the reasoning. I hope you continue winning man.
    Thanks and GL tonight.

  2. #37
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Good choice, but I don't regret the Angels play, they were in a good spot at +18.3% ROI. Shoemaker had always pitched tough vs them so I knew it should of been close. They almost pulled it out in the 9th, but the spot and price was right. It's just more of a long term ROI than short as it only has 44.5% win% but +18.3 ROI. When I made the play, they were +150 which has an even higher ROI in that spot. Then throw in that the Astros had to leave for a series at Tampa starting tomorrow, it was a an easy choice for me.

    AD and line >140 and day = Thursday and month = 4

  3. #38
    kilopro
    kilopro's Avatar Become A Pro!
    Join Date: 07-20-16
    Posts: 63
    Betpoints: 5147

    Great picks last night in NHL Fuq. Nats/Braves Over trends look solid for tonite. Looks like line just adjusted from 7.5 to 8 at my book. Do like Duffy also, he was a stud last year while being repeatedly disrespected by the books. GL tonite!

  4. #39
    kilopro
    kilopro's Avatar Become A Pro!
    Join Date: 07-20-16
    Posts: 63
    Betpoints: 5147

    Of course I mention it and they lose. Oh well onto tomorrow.

  5. #40
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Quote Originally Posted by kilopro View Post
    Of course I mention it and they lose. Oh well onto tomorrow.
    yea some tough losses last night, that push in the Nashville game was brutal

  6. #41
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Friday 4/21

    --> Red Sox -105
    --> Yankees +106
    --> Cardinals -105
    --> D-Backs +127
    --> Athletics -123

    --> Giants/Rockies Under 10 -105

    --> Boston Bruins
    _____________________________
    Yesterday

    MLB = 0-3 = -310
    NHL = 1-1 = +0

    Total

    MLB = 16-24 -7.97
    NHL = 12-4 +8.11
    _____________________________
    Could of easily been a 6-0 day but lost some close ones and had a brutal NHL push. I've now had 3 or 4 days in MLB like last night that have put a damper on my MLB season so far, but it's very early.
    I usually post my plays overnight, but last night I was too tired when I got done, so some lines will be different.
    _____________________________

    SDQL

    FADE: The Orioles are 0-17 SU when they are not a favorite of more than 120 after a game as a road favorite in which they scored first.
    team = Orioles and line>=-120 and p:AF and p:SF>0 and date >= 20140605

    UNDER: The Rockies are 0-13 OU as a dog after a game in which Mark Reynolds struck out at least twice.
    team = Rockies and D and Mark Reynolds:strike outs > 1 and date >= 20160430

    OVER: The Marlins are 14-0 OU as a road favorite in the first game of a series when they won the last two games their starter started.
    team = Marlins and FGS and A and F and s:W and ss:W and date >= 20050613

    ---------------------------

    OVER: The Braves are 14-1 OU off a loss as a dog in which they held the lead.
    team = Braves and p and p:BL > 0 and p:L and date >= 20160803

    FADE: The Brewers are 1-9 SU at Home vs the Cardinals in the 2nd game of the series since Sept 21st 2013.
    team=Brewers and H and o:team=Cardinals and SG = 2 and date>= 20130921

    FADE: The Pirates are 1-20 SU off a one-run loss as a dog.
    team = Pirates and p and p:margin = -1 and date >= 20140816

    PLAY: 952-566 ROI = +12.0% Applies to Athletics
    H and (s:SO + os:SO) > 18 and s:SHRA != 2 and p:runs != 3 and op:runs < 9 and os:fly balls > 3 and os:fly balls != 6 and o:team != Cubs and (p:walks + op:walks) < 13 and op:triples < 2 and p:doubles < 5 and 17 > op:hits > 2 and (tA(at bats@team,N=6)<36.5 or tA(at bats@team,N=6)>36.7) and tA(o:at bats@team,N=6)>31 and (tA(SHF,N=8)<26.3 or tA(SHF,N=8)>26.5)

    _____________________________

    Notes:

    Tigers won 4 str8 vs Lefties, 7 str8 dating back to last season.
    Indians lost 4 str8 vs Lefties.
    CC Sabathia 4-0 his last 4 starts and 4-0 career vs Pirates.
    Mike Fiers has won 4 str8 road starts.
    Rays 1-14 Under at Home vs Astros
    Mariners 1-6 Away and the worst team vs Lefties L2 seasons playing hot A's
    Last edited by FUqer; 04-21-17 at 01:35 PM. Reason: error

  7. #42
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    For fun, here is my picks for all games today, minus Mets game since it had a pitching change and the Blue Jays game and some totals which I have zero lean.

    Cardinals
    Diamondbacks & Over
    Red Sox & Under
    Yankees
    Athletics
    Astros & Under
    Rockies & Under
    Phillies & Over
    Rangers & Over
    Tigers
    Marlins
    Indians
    Cubs & Over
    Jays/Angels Over Only

  8. #43
    Scrivero
    Scrivero's Avatar Become A Pro!
    Join Date: 01-30-17
    Posts: 673
    Betpoints: 1249

    Tailed everything (NHL + MLB SDQL) again, thanks man And certainly I do trust that all your picks are good, I just want to see the data to support it with MLB, as I have absolutely no idea about the teams and how they do. Hence I just do the SDQL, its great fun too!

    Edit. Oh, I was on the phone and did not see your last list. Good addition to have such a list, please do it daily if you can! But please keep the SDQL stuff in there too, thanks a lot man
    Last edited by Scrivero; 04-21-17 at 01:53 PM.

  9. #44
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Saturday 4/22

    --> Cardinals -117
    --> Mariners +111
    --> Tigers -110
    --> D-Backs +106
    --> Phillies -123

    --> Blue Jays/Angels Under 9 -110
    _________________________
    Yesterday

    MLB = 3-3 = +17
    NHL = 1-0 = +100

    Total

    MLB = 19-27 -7.80
    NHL = 13-4 +9.11
    ______________
    SDQL

    FADE: The White Sox are 0-21 SU as a 155+ dog after a game in which their opponent left fewer than ten men on base.
    team = White Sox and line>155 and po:LOB < 10 and season >= 2011

    FADE: The Athletics are 0-16 SU at home after playing as a home favorite vs a team that has lost at least their last two games and it is not a series opener.
    team = Athletics and SG > 1 and p:H and p:F and o:streak <= -2 and date >= 20140810

    FADE: The Reds are 1-19 SU as a dog by more than 150 after Joey Votto was hitless in at least three at bats.
    team=Reds and line>150 and Reds:Joey Votto:at bats>=3 and Reds:Joey Votto:hits=0 and date>=20100906

    ---------------------------

    UNDER: The Blue Jays are 13-33-4 O/U for +34.0% ROI the last 2 seasons when facing a left handed starting pitcher.
    team=Blue Jays and o:STL and season >=2016

    OVER: The Twins are 16-2 OU when their line is within 20 cents of pickem after a win in which they drew 5+ walks and it is not the first game of a series.
    team = Twins and line<=120 and p:walks>=5 and p:W and SG > 1 and date >= 20130903

    OVER: The Cubs are 13-1 OU as a road favorite after a game as a road favorite in which they had more strikeouts than hits.
    team = Cubs and SG > 1 and A and F and p:A and p:F and p:SO > p:hits and date >= 20160608

    PLAY: The D-Backs are 11-1 SU at Home their last 12 Home games.
    team = Diamondbacks and H and date >= 20160918

    FADE: The Athletics are 2-17 RL as a home favorite after a win in which they scored in at most two separate innings.
    team=Athletics and HF and p:SII<=2 and p:W and date>=20140820

  10. #45
    Scrivero
    Scrivero's Avatar Become A Pro!
    Join Date: 01-30-17
    Posts: 673
    Betpoints: 1249

    You know what... I think that there could be a way to use your findings in another way too. E.g. instead of Fading the Athletics RL, to actually take them RL. Why? Because:

    team=Athletics and HF and p:SII<=2 and p:W and date>=20140820
    RL: 2-17 (-3.18, 10.5%) avg line: 156.1 / -169.7 on / against: -$1,394 / +$1,368 ROI: -73.3% / +42.4%

    team=Athletics and HF and p:SII<=2 and p:W
    RL: 32-69 (-1.23, 31.7%) avg line: 149.0 / -163.7 on / against: -$2,201 / +$1,764 ROI: -21.2% / +10.5%


    team=Athletics and HF and p:SII<=2 and p:W and date<20140820
    RL: 30-52 (-0.78, 36.6%) avg line: 147.4 / -162.2 on / against: -$807 / +$396 ROI: -9.5% / +2.9%

    What I am trying to say with those numbers is, that even if the previous 19 games would say to Fade the Athletics, maybe it has just been a very long lucky/unlucky/freak streak that is coming to an end. They have actually won their 2 last games with those factors as RL.

    I am in no way trying to say that your findings are bad, exactly the opposite! I just feel like one could and maybe also should try to interpret these differently to win even more. Basically to try to see if there are freak streaks that "should" come to an end based on how the specific scenario has gone prior to the streak. One shouldnt bet against the streak, I know, but maybe, just maybe, there could be a chance to do that here with some of the games.

    What are your thoughts?

  11. #46
    Scrivero
    Scrivero's Avatar Become A Pro!
    Join Date: 01-30-17
    Posts: 673
    Betpoints: 1249

    You had a second query about the Athletics too, so lets run that one too as to what happened prior to that streak:
    team = Athletics and SG > 1 and p:H and p:F and o:streak <= -2 and date < 20140810
    SU: 90-42 (1.42, 68.2%) avg line: -152.2 / 137.6 on / against: +$3,062 / -$3,632 ROI: +15.1% / -26.8%
    RL: 45-42 (-0.07, 51.7%) avg line: 133.6 / -147.6 on / against: +$1,864 / -$2,385 ROI: +20.0% / -18.0%

    That could also suggest playing the Athetics, if one would want to play against the streak. Of course it is hard to know when a streak ends. One could also start chasing the streak to end when it has gone e.g. 0-15 in the last 15 games. Just some more thoughts.

    Edit. And sorry if I derailed your thread in any way.

  12. #47
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    I see what you are saying, but it depends on the match-up for that day. Yesterday for example, I played the Cardinals and had a 9-1 SDQL in their favor, but I also had one for the Brewers that was 20-4, that I didn't even post because of the match-up and other SDQL I found in the Cardinals favor. I always look at all kinds of other SDQL, some smaller and some bigger sample size, but I only post the attractive looking ones. And a few that I do post really don't mean that much, like the Rays and Astros stats, they only play one series a year since the Astros move moved the the AL, so some of the stats are just meaningless. I usually just post whatever and let people interpret them how they want. You got to be careful sometimes too about the lines in some of the SDQL I post. I post early and some of them have to do with lines and if the lines move too much, the SDQL will be invalid by the time the game starts.

    Fading these picks is something I don't intentionally set out to do, because either way you look at it, it's not good odds, but I have went against SDQL plenty of times if the match-up and price takes me there. There are only a few SDQL that I will blindly play on and everyone depends on the price range. Everyone is different though.

  13. #48
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Here are all my leans.

    SU = 9-4
    O/U = 4-4

    -----------------------

    Cardinals
    Mariners
    Tigers & Over
    D-Backs
    Phillies
    Yankees
    Nationals & Under
    Angels & Under
    Indians
    Cubs & Over
    Rockies & Under
    Last edited by FUqer; 04-22-17 at 12:48 PM. Reason: Add Rockies

  14. #49
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Here are just some other reasons why I chose the Mariners.

    +7.0 = 66-49 = Mariners vs Righties last 2 seasons
    +6.6% = Loss by 2 = 238-208 = Mariners
    -4.7% = streak=4 and H = Athletics
    -4.8% = streak=4 = Athletics
    -4.9% = streak=4 and H and o:streak=-2
    -17.9% = 19-29 = Athletics vs Lefties last 2 seasons
    -26.0% = streak=4 and H and o:streak=-2 and DIV and SG=2

    I always look at fading small streaks, but not the big ones.

  15. #50
    Scrivero
    Scrivero's Avatar Become A Pro!
    Join Date: 01-30-17
    Posts: 673
    Betpoints: 1249

    Quote Originally Posted by FUqer View Post
    I see what you are saying, but it depends on the match-up for that day. Yesterday for example, I played the Cardinals and had a 9-1 SDQL in their favor, but I also had one for the Brewers that was 20-4, that I didn't even post because of the match-up and other SDQL I found in the Cardinals favor. I always look at all kinds of other SDQL, some smaller and some bigger sample size, but I only post the attractive looking ones. And a few that I do post really don't mean that much, like the Rays and Astros stats, they only play one series a year since the Astros move moved the the AL, so some of the stats are just meaningless. I usually just post whatever and let people interpret them how they want. You got to be careful sometimes too about the lines in some of the SDQL I post. I post early and some of them have to do with lines and if the lines move too much, the SDQL will be invalid by the time the game starts.

    Fading these picks is something I don't intentionally set out to do, because either way you look at it, it's not good odds, but I have went against SDQL plenty of times if the match-up and price takes me there. There are only a few SDQL that I will blindly play on and everyone depends on the price range. Everyone is different though.
    Great stuff! I am still so intrigued about the possibility of trying to end streaks (streaks that dont make sense to me AND that seem to be a +ROI pick when taking out the streak) that I will start a thread about breaking the streaks. I might regret it forever but then again it might lead to something awesome.

  16. #51
    Scrivero
    Scrivero's Avatar Become A Pro!
    Join Date: 01-30-17
    Posts: 673
    Betpoints: 1249

    Quote Originally Posted by FUqer View Post
    Here are just some other reasons why I chose the Mariners.

    +7.0 = 66-49 = Mariners vs Righties last 2 seasons
    +6.6% = Loss by 2 = 238-208 = Mariners
    -4.7% = streak=4 and H = Athletics
    -4.8% = streak=4 = Athletics
    -4.9% = streak=4 and H and o:streak=-2
    -17.9% = 19-29 = Athletics vs Lefties last 2 seasons
    -26.0% = streak=4 and H and o:streak=-2 and DIV and SG=2

    I always look at fading small streaks, but not the big ones.
    Great! I think if someone, then you could be the one to also find the streaks that actually should end, as you are so good at also finding stuff that supports the play (the streak to continue). Do come visit my thread whenever you wish, it will be up in 5 minutes I will borrow some of your findings (and credit you of course) too.

  17. #52
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    A few more for today

    FADE: The Giants are 0-11 SU since Aug 05, 2014 as a road dog off a game as a favorite in which they used 5+ pitchers
    team=Giants and AD and p:F and 5 <= p:PU and date>=20140805

    PLAY: The Indians are 11-0 since Aug 04, 2016 as a 140+ favorite after Jason Kipnis was hitless in at least three at bats.
    team=Indians and line<=-140 and Indians:Jason Kipnis:at bats>=3 and Indians:Jason Kipnis:hits=0 and date>=20160804

  18. #53
    Scrivero
    Scrivero's Avatar Become A Pro!
    Join Date: 01-30-17
    Posts: 673
    Betpoints: 1249

    Alright, did all the queries and the queries until the streaks started and ended up fading 3 of your plays and tailing 5 of your plays. GOod luck to both of us!

  19. #54
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    I will prolly play Montreal tonight, I want to play St.Louis this afternoon, but can't pull the trigger.

  20. #55
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Added 4/22

    --> Montreal Canadiens

  21. #56
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Quote Originally Posted by fuqer View Post
    here are all my leans.

    Su = 9-4
    o/u = 4-4

    -----------------------

    cardinals
    mariners
    tigers & over
    d-backs
    phillies
    yankees
    nationals & under
    angels & under
    indians
    cubs & over
    rockies & under


    su 10-1
    o/u 2-1-2 o/u

    sdql 6-1-2

    mlb 4-1-1
    nhl 0-1

  22. #57
    Scrivero
    Scrivero's Avatar Become A Pro!
    Join Date: 01-30-17
    Posts: 673
    Betpoints: 1249

    Nice evening! I think all my tails hit and all my fades lost Well, Athletics won SU but I took them RL for a bigger ROI. All in all you made me money again, thanks man!

  23. #58
    juicername
    Thomorino - Fade and Get Paid
    juicername's Avatar Become A Pro!
    Join Date: 10-14-15
    Posts: 6,906
    Betpoints: 3972

    Fun with a SDQL thread, GL.

    If I were you I would however stop focusing on the trends involving a single hitter such as "team=Indians and line<=-140 and Indians:Jason Kipnis:at bats>=3 and Indians:Jason Kipnis:hits=0 and date>=20160804" since you could run similar queries on every player in the lineup and get big leans either way.

    I do however like queries like this one "
    team=Giants and AD and p:F and 5 <= p:PU and date>=20140805", especially as it shows great ROI not only for SF but MLB in general, and it's a situation that makes a lot of sense.

  24. #59
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Quote Originally Posted by juicername View Post
    Fun with a SDQL thread, GL.

    If I were you I would however stop focusing on the trends involving a single hitter such as "team=Indians and line<=-140 and Indians:Jason Kipnis:at bats>=3 and Indians:Jason Kipnis:hits=0 and date>=20160804" since you could run similar queries on every player in the lineup and get big leans either way.

    I do however like queries like this one "
    team=Giants and AD and p:F and 5 <= p:PU and date>=20140805", especially as it shows great ROI not only for SF but MLB in general, and it's a situation that makes a lot of sense.
    Not focusing on them at all, I don't even play most of the SDQL trends and when I do it's for more reasons than just the SDQL. I think I mentioned a few times now in this thread that there are very few I play blindly and that some of them I post are pretty meaningless and just for show, but some people like that stuff so I post them and let people do what they want. I always cross reference team trends to all of MLB and vice versa.

  25. #60
    juicername
    Thomorino - Fade and Get Paid
    juicername's Avatar Become A Pro!
    Join Date: 10-14-15
    Posts: 6,906
    Betpoints: 3972

    Quote Originally Posted by FUqer View Post
    Not focusing on them at all, I don't even play most of the SDQL trends and when I do it's for more reasons than just the SDQL. I think I mentioned a few times now in this thread that there are very few I play blindly and that some of them I post are pretty meaningless and just for show, but some people like that stuff so I post them and let people do what they want. I always cross reference team trends to all of MLB and vice versa.
    Got ya, just skimmed through the thread quickly. Will follow more closely going forward. Again, GL

  26. #61
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    4/23 Pitching Notes

    Michael Fulmer is one of my favs, but the Tigers have lost his last 3 starts on the road. They are 4-0 when he starts on Sundays and 2-0 vs Twins.
    Kyle Gibson is 15-8 after 2 str8 losses. 4-7 vs Tigers
    ----------------
    When Mike Leake starts, the Cardinals have won his last 2 starts, and won 7/8 of his Sunday starts, and he is 2-0 in MIL since he joined them.
    Jimmy Nelson is 2-6 vs Cardinals career.
    -------------
    Mike Foltynewicz team's are 7-1 after he lost his last two starts. He is 2-1 vs Phillies
    Zach Eflin is 1-0 vs Braves career.

    -------------
    When Yovani Gallardo starts, his team have lost his last 3 starts and are 0-6 vs A's when he starts, and 2-8 his last 10 starts on Sunday, and 0-5 his last 5 starts in April.
    When Andrew Triggs starts, the A's are 3-0 this year, he shut down the Angels, Royals and Rangers.
    ----------------------
    When Jeff Samardzija starts, the Giants have lost during his L5 starts, and they are 5-16 L21 and have lost his last 8 Sunday starts.
    Kyle Freeland 4th start. Rockies are 2-1 in his 3 starts.
    ----------------
    Tom Koehler is 1-10 L11 starts. 3-0 vs Padres
    Luis Perdomo is 12-9 career and 2-0 vs Marlins.
    -------------------
    When Joe Musgrove starts, the Astros have a 6-7 record.
    When Matt Andriese starts, the Rays are 1-0 vs the Astros.
    -------------
    When Marcus Stroman starts on the Road, the Jays are 2-10 and 1-5 L6 on Sundays and 0-2 vs the Angels.
    When Ricky Nolasco starts, his team are 2-8 his L10 Sunday starts. His teams are 4-1 vs the Blue Jays when he starts.
    ----------------
    When Eduardo Rodriguez starts, Boston have won during his last 2 starts in Baltimore
    When Kevin Gausman starts, the Orioles have won 7 of last 8 time he starts after he lost on the road loss his previous start. The Orioles are 9-1 his last 10 starts at Home and have won his last 3 Sunday starts. The Orioles are 1-4 L5 starts vs Boston.
    --------------
    Jordan Montgomery's 3rd start. The Yankees are 2-0 so far when he starts. This is his 1st road start.
    When Ivan Nova starts on Sundays, his team is 14-7.
    ----------------
    Brandon McCarthy has won 5/6 last starts. 4-0 on Sunday with Dodgers. won 6 of last 7 April starts. 0-2 vs D-Backs
    Shelby Miller is 0-9 L9 after winning his last start, 6 of those with D-Backs. 0-2 vs Dodgers with D-Backs.
    ------------
    When Jason Hammel starts, the Royals are 0-3. His teams are 2-8 is last 10 starts, lost last 5 road starts and 9 of last 10 road starts, 2-11 his last 13 starts on Sunday.
    Yu Darvish 1-5 L6 team starts, 15-5 career in April.

  27. #62
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Sunday 4/23

    --> Padres +100
    --> Tigers -104
    --> Cardinals -114
    --> Braves -118
    _________________________
    Yesterday

    MLB = 4-1 = +306
    NHL = 0-1 = -110

    Total

    MLB = 23-28 -474
    NHL = 13-5 +801
    -------------------------
    SDQL

    FADE: 110-227 ROI = -32.8% - Applies to Marlins
    (so:R1 = 3 or so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

    PLAY: The White Sox are 21-0 RL as a 160+ dog after they allowed six-plus runs.
    team=White Sox and 160<=line and 6<=po:runs and date >= 20130600
    --------------
    FADE: The Mets are 1-17 RL in the last game of a three-game series when they lost the first two, with the last as a favorite.
    team = Mets and p:F and LGS and SG = 3 and streak <= -2 and date >= 20130428

    PLAY: The Diamondbacks are 12-1 L13 Home games.
    t:team = Diamondbacks and H and date >= 20160918

    FADE: Shelby Miller is 0-9 SU since May 28th 2015 after he won his last start.
    starter=Shelby Miller and s:W and date>=20150528

    UNDER: The Marlins are 1-13 OU on the road when their line is within 25 cents of pick-em after an extra inning win.
    team = Marlins and A and -125 <= line <= 125 and p:XW and date >= 20070702

    OVER: The Braves are 14-2 OU off a loss as a dog in which they held the lead.
    team = Braves and p and p:BL > 0 and p:L and date >= 20160803

  28. #63
    Scrivero
    Scrivero's Avatar Become A Pro!
    Join Date: 01-30-17
    Posts: 673
    Betpoints: 1249

    Quote Originally Posted by FUqer View Post
    Not focusing on them at all, I don't even play most of the SDQL trends and when I do it's for more reasons than just the SDQL. I think I mentioned a few times now in this thread that there are very few I play blindly and that some of them I post are pretty meaningless and just for show, but some people like that stuff so I post them and let people do what they want. I always cross reference team trends to all of MLB and vice versa.
    I think what I will have to do is to tail all your plays which you post and not fade any of those. Then, for the SDQL you have posted but not played, I will check those if I could find a FADE some out of them as there is probably a reason why you do not play them even if SDQL would support it.

    I should look for my own trends and there are (like someone gave a tip in my thread) loads available online. Still, the problem with those is that I dont know how to create the SDQL query to check the ROI and then to check the ROI before the streak. An example would be:
    "Giants are 1-10 in Samardzijas last 11 starts vs. a team with a winning record." If I would have to create the SDQL query for that and and the same time check the dates when was the starting point of that streak, it would take me forever.

  29. #64
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    All Leans 4/23

    SU = 19-5
    O/U = 6-5
    ---------------

    Padres & Under
    Tigers & Under
    Cardinals & Over
    Braves & Over
    Nationals
    Cubs
    Athletics
    Indians/White Sox Under only
    Giants/Rockies Over only
    Blue Jays/Angels Over only

  30. #65
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Quote Originally Posted by Scrivero View Post
    I think what I will have to do is to tail all your plays which you post and not fade any of those. Then, for the SDQL you have posted but not played, I will check those if I could find a FADE some out of them as there is probably a reason why you do not play them even if SDQL would support it.

    I should look for my own trends and there are (like someone gave a tip in my thread) loads available online. Still, the problem with those is that I dont know how to create the SDQL query to check the ROI and then to check the ROI before the streak. An example would be:
    "Giants are 1-10 in Samardzijas last 11 starts vs. a team with a winning record." If I would have to create the SDQL query for that and and the same time check the dates when was the starting point of that streak, it would take me forever.
    team = Giants and starter=Jeff Samardzija and op:WP>50

    No date needed in this case because he hasn't been with the Giants that long and it shows he is 2-11 or 1-9 L10 against winning teams.
    If you wanted to narrow by a date, you just do a broad search, find out the date when the streak starts and add (and date>=20160728)
    Of course just sub the date with your date, 2016 being the year, 07(July) being the month and 28th being the day.

    So it would be this if you needed to add a date.
    team = Giants and starter=Jeff Samardzija and op:WP>50 and date>=20160417
    The only thing that scares me is that the Giants pound lefties and are in need of a win.
    Last edited by FUqer; 04-23-17 at 04:59 AM.

  31. #66
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Here's a few small codes from my pitching notes above, that I don't always have time to post cuz I try to get through them quickly, but I know you like as many queries as possible.

    1-10
    starter=Tom Koehler and date>=20160825

    9-1
    starter=Kevin Gausman and H and date>=20160605

  32. #67
    Scrivero
    Scrivero's Avatar Become A Pro!
    Join Date: 01-30-17
    Posts: 673
    Betpoints: 1249

    Quote Originally Posted by FUqer View Post
    team = Giants and starter=Jeff Samardzija and op:WP>50

    No date needed in this case because he hasn't been with the Giants that long and it shows he is 2-11 or 1-9 L10 against winning teams.
    If you wanted to narrow by a date, you just do a broad search, find out the date when the streak starts and add (and date>=20160728)
    Of course just sub the date with your date, 2016 being the year, 07(July) being the month and 28th being the day.

    So it would be this if you needed to add a date.
    team = Giants and starter=Jeff Samardzija and op:WP>50 and date>=20160417
    The only thing that scares me is that the Giants pound lefties and are in need of a win.
    Thanks for the info and for the tips and also for the pitching codes!

    And the lefties query I guess would be this (borrowed from another place): REG and o:team=Giants and starter throws=L and season=2016
    So yea, 22-30 last year SU, in the favor of the Giants. Giants though also have some pitcher problems themselves right now? I will most likely just tail that Over of yours for that game.

  33. #68
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    One thing I like to do a lot, that I'm not doing today is pair the 2 big dogs that I like the most and at least hope for a split. Today I wanted to play the Royals +180 and the White Sox +172, but didn't pull the trigger.

  34. #69
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    I've said before I like to keep tabs on streaks, this is one thing I do everyday. The last time there were so many streaks, there were only a few left the next day.

    Example: streak=-5 and AF

    You can add onto it to narrow it down with last game of series, division game, etc....

    streak=-5 and AF and LGS and DIV


    Losing Streaks

    Braves -5 Road Fav (ROI +7.7%)
    Reds -4 Home Dog (ROI -5.5%)
    White Sox -3 Home Dog (ROI -1.8%)
    Mets -3 Home Dog (ROI -1.8%)
    Royals -3 Road Dog (ROI -3.1%)
    Mariners -3 Road Dog (ROI -3.1%)
    Giants -3 Road Fav (ROI +1.1%)
    ____________________________

    Winning Streaks

    Nationals +6 Road Fav (ROI +6.3%)
    Athletics +5 Home Fav (ROI -10.9%)
    Indians +5 Road Fav (ROI -6.5%)
    Orioles +4 Home Fav (ROI -2.7%)
    Cubs +4 Road Fav (ROI -4.5%)
    Rangers +3 Home Fav (ROI -1.3%)
    Phillies +3 Home Dog (ROI +3.1%)
    _____________________________

  35. #70
    FUqer
    FUqer's Avatar Become A Pro!
    Join Date: 01-22-15
    Posts: 3,968
    Betpoints: 861

    Here is another chart I do that I like to look at everyday. Sorry, I wish there was an easier way for me to copy and paste from my notepad.

    Example: team=Brewers and o:STL and season >=2016
    SU: 31-21 (0.79, 59.6%) avg line: 131.9 / -143.4 on / against: +$1,821 / -$2,066 ROI: +32.8% / -26.9%

    OU: 29-20-3 (1.04, 59.2%) avg total: 8.6 over / under: +$753 / -$1,155 ROI: +13.2% / -20.1%

    The Brewers and Marlins who both have losing records but have very good records vs lefties, so I play on them a lot vs lefties. I also look at the O/U like when the Blue Jays face a lefty.

    Vs Lefties L2 Seasons

    Brewers 31-21 (ROI = +32.8%) (Over ROI = +13.2%)
    Marlins 23-14 (ROI = +31.9%) (Under ROI = +14.0%)
    Pirates 21-13 (ROI = +23.1%) (Over ROI = +10.8%)
    Padres 23-25 (ROI = +13.6%) (Under ROI = -1.4%)
    Twins 25-26 (ROI = +13.1%) (Over ROI = +11.9%)
    White Sox 24-19 (ROI = +13.1%) (Under ROI = -5.1%)
    Phillies 16-19 (ROI = +9.8%) (Under ROI = -4.6%)
    Giants 33-26 (ROI = +9.8%) (Under ROI = -0.6%)
    Tigers 28-22 (ROI = +7.1%) (Under ROI = +1.3%)
    Yankees 28-26 (ROI = +6.4%) (Over ROI = +4.9%)
    D-Backs 26-24 (ROI = +5.5%) (Over ROI = +13.5%)
    Royals 23-23 (ROI = +5.5%) (Over ROI = +4.8%)
    Orioles 27-25 (ROI = +4.5%) (Under ROI = +10.3%)
    Cubs 35-20 (ROI = +3.9%) (Under ROI = +9.9%)
    Rangers 24-22 (ROI = +3.5%) (Under ROI = -0.8%)
    Indians 36-25 (ROI = +3.3%) (Under ROI = +5.6%)
    Red Sox 22-18 (ROI = +2.1%) (Under ROI = +4.0%)
    Angels 23-24 (ROI = +1.7%) (Under ROI = +16.4%)
    Nationals 21-17 (ROI = -0.8%) (Over ROI = -1.3%)
    Rockies 24-30 (ROI = -2.3%) (Under ROI = -2.2%)
    Mets 21-22 (ROI = -3.3%) (Over ROI = +3.0%)
    Blue Jays 26-24 (ROI = -9.5%) (Under ROI = +34.0%)
    Astros 30-30 (ROI = -9.8%) (Under ROI = -3.3%)
    Reds 13-21 (ROI = -10.5%) (Over ROI = +3.1%)
    Braves 17-31 (ROI = -10.6%) (Over ROI = +12.2%)
    Mariners 26-36 (ROI = -17.5%) (Over ROI = -1.7%)
    Rays 20-30 (ROI = -17.5%) (Over ROI = +3.2%)
    Athletics 19-29 (ROI = -17.9%) (Over ROI = +12.1%)
    Cardinals 21-27 (ROI = -20.2%) (Over ROI = +5.2%)
    Dodgers 25-33 (ROI = -20.7%) (Under ROI = +8.9%)

    ------------------------------------------

    Vs Righties L2 Seasons

    Orioles 72-52 (ROI = +13.1%) (Under ROI = +8.5%)
    Rangers 76-58 (ROI = +9.9%) (Over ROI = +4.1%)
    Mariners 66-49 (ROI = +7.0%) (Over ROI = -2.0%)
    Braves 57-70 (ROI = +6.7%) (Over ROI = +2.9%)
    Indians 76-54 (ROI = +6.1%) (Over ROI = +0.8%)
    Yankees 66-56 (ROI = +3.1%) (Under ROI = +5.4%)
    Dodgers 79-52 (ROI = +2.7%) (Under ROI = +1.4%)
    Astros 64-53 (ROI = +2.0%) (Under ROI = +5.0%)
    Cardinals 71-58 (ROI = +1.0%) (Under ROI = -4.1%)
    Cubs 87-51 (ROI = +0.4%) (Over ROI = -1.8%)
    Red Sox 80-59 (ROI = +0.3%) (Under ROI = -2.4%)
    Nationals 85-58 (ROI = +0.3%) (Over ROI = -3.1%)
    Rockies 61-63 (ROI = -0.3%) (Under ROI = +7.9%)
    Reds 62-78 (ROI = -1.0%) (Over ROI = +8.5%)
    Royals 64-66 (ROI = -1.6%) (Under ROI = +8.8%)
    Athletics 57-71 (ROI = -3.3%) (Under ROI = +12.9%)
    Mets 74-61 (ROI = -4.7%) (Under ROI = +3.9%)
    Phillies 59-81 (ROI = -6.1%) (Over ROI = -2.1%)
    Angels 58-71 (ROI = -6.7%) (Under ROI = +0.4%)
    White Sox 61-71 (ROI = -6.7%) (Over ROI = -1.7%)
    Padres 51-79 (ROI = -6.9%) (Over ROI = -2.8%)
    Blue Jays 70-65 (ROI = -8.3%) (Under ROI = +8.6%)
    Marlins 64-75 (ROI = -10.3%) (Over ROI = +1.6%)
    D-Backs 53-74 (ROI = -11.2%) (Over ROI = +6.5%)
    Brewers 49-75 (ROI = -12.5%) (Under ROI = +4.7%)
    Giants 62-62 (ROI = -12.6%) (Under ROI = +0.1%)
    Rays 56-72 (ROI = -12.7%) (Under ROI = -3.8%)
    Pirates 63-79 (ROI = -14.8%) (Over ROI = +2.6%)
    Twins 41-84 (ROI = -28.7%) (Over ROI = +9.7%)
    ---------------------------------------------

First 12345 ... Last
Top