Announcement

Collapse
No announcement yet.

Week 13 queries for our braintrust

Collapse
X
Collapse
 
  • Page of 4
  • Filter
  • Time
  • Show
Clear All
new posts
Previous 1 2 3 4 template Next
  • #1

    Week 13 queries for our braintrust

    I have one that I could use you brainiacs to run a query on as it would take me a long time to check it my way.

    Revenging a previous season Playoff loss. Now favored. (SFo @ Philly)

    Tags: None
  • #2
    Think this is what you're looking for Jim

    P:playoffs = 1 and P:L and F

    https://killersports.com/nfl/query?_...+S+D+Q+L+%21++

    Comment

    • #3
      Originally posted by Thomas View Post
      Think this is what you're looking for Jim

      P:playoffs = 1 and P:L and F

      https://killersports.com/nfl/query?_...+S+D+Q+L+%21++
      That was quick. Damn. It would have taken me three hours! Thanks, Tom

      So it looks like 8-7 ATS for a revenging away favorite.

      But.... 2-7 ATS Away between weeks 9 and 16.

      Comment

      • #4
        Not sure where your coming up with those numbers Jim

        P:playoffs = 1 and P:L and AF, 13-15-1 ats

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

        add in the weeks you mention (which wont include week 9 or 16)

        P:playoffs = 1 and P:L and AF and 9<week<16, 4-8-1 ats

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

        Include weeks 9-16, 7-11-1 ats

        P:playoffs = 1 and P:L and AF and 9<=week<=16

        Comment

        • #5
          Okay...let's see...I think I can narrow it down to the bare metal.

          Road conference favs of -2 or more vs a team they lost to s/u on the road in the playoffs the previous season:

          P:playoffs=1
          P:AL
          ACF
          P:season=season-1
          line<=-2

          KillerSports.com

          10-0 s/u
          &
          6-3-1 ats

          Add in: vs a non-div opp w/a total between 40.5 & 56:

          NDIV
          56>total>40.5

          KillerSports.com

          6-0 s/u
          &
          6-0 ats

          Add in: after week 6:

          week>6

          KillerSports.com

          5-0 s/u...by 19, 23,13, 10 & 17
          &
          5-0 ats...by 15, 18.5, 10, 7.5 & 10

          Add in: both teams not off a bye & on Sunday:

          NB
          o:NB
          day=Sunday

          KillerSports.com

          3-0 s/u
          &
          3-0 ats
          &
          0-3 o/u

          Key notes:

          All 3 took the lead by half-time & never looked back
          Road teams out-rushed their opp by 151.0 ry/gm vs 69.0 ry/gm
          Road teams won the turnover battle 0.3 t/o vs 2.0 t/o

          SF-2'

          Under 46'
          Last edited by Riderx; 11-29-2023, 08:48 PM.

          Comment

          • #6
            best 3 straight teams by 18 or more, didn't lead at HT last game by 33+, and opponent not on 11+ losing streak (1-20 ou)


            p:margin > 16 and pp:margin > 16 and ppp:margin > 16 and season>2004 and 6<week<18 and p:M2<33 and o:streak>-11
            12-9-0 (3.48, 57.1%)
            10-11-0 (-1.10, 47.6%) avg line: -4.6 +6: 15-6-0 (71.4%) -6: 6-14-1 (30.0%) +10: 15-6-0 (71.4%) -10: 5-16-0 (23.8%)
            1-20-0 (-9.95, 4.8%) avg total: 46.3 +6: 0-20-1 (0.0%) -6: 5-14-2 (26.3%) +10: 0-21-0 (0.0%) -10: 10-11-0 (47.6%)
            26.7 111.7 33.7 224.3 20.9 1.4 3.6 7.0 3.7 5.7 19.9
            26.5 120.3 33.9 200.7 19.9 1.2 4.5 6.4 2.2 3.3 16.4
            Nov 30, 2023 view Thursday 13 2023 Cowboys Seahawks home -9.0 47.5

            Comment

            • #7
              another under

              thursday
              week 9-14
              home
              favorite >=7
              previous won
              not on a >1 home or away site streak
              p: turnover margin <=2
              op:turnover margin <= "5" ouch
              p: points at half >0
              total >= 35

              0-12 o/u (-9.92)

              https://killersports.com/nfl/query?_...+S+D+Q+L+%21++


              dal under 47.5



              _______________________________________________
              ( ) in football and baskets is avg ats or ou margin..baseball it's avg odds and run differential for sides and totals..winners and late scratches usually not recognized in the horse thread but on occasion will mention.. always double check race and horse # if you play .. I do lose a lot more races than I win.. playing in advance, late odds moves and high takeout very hard to overcome .. derby future opinion post 3713 on page 149 (horse plays)

              Comment

              • #8
                Originally posted by bleeker View Post
                another under

                thursday
                week 9-14
                home
                favorite >=7
                previous won
                not on a >1 home or away site streak
                p: turnover margin <=2
                op:turnover margin <= "5" ouch
                p: points at half >0
                total >= 35

                0-12 o/u (-9.92)

                https://killersports.com/nfl/query?_...+S+D+Q+L+%21++

                dal under 47.5
                Right there with ya', Glenn...

                Comment

                • #9
                  Originally posted by rolltide View Post
                  best 3 straight teams by 18 or more, didn't lead at HT last game by 33+, and opponent not on 11+ losing streak (1-20 ou)


                  p:margin > 16 and pp:margin > 16 and ppp:margin > 16 and season>2004 and 6<week<18 and p:M2<33 and o:streak>-11
                  12-9-0 (3.48, 57.1%)
                  10-11-0 (-1.10, 47.6%) avg line: -4.6 +6: 15-6-0 (71.4%) -6: 6-14-1 (30.0%) +10: 15-6-0 (71.4%) -10: 5-16-0 (23.8%)
                  1-20-0 (-9.95, 4.8%) avg total: 46.3 +6: 0-20-1 (0.0%) -6: 5-14-2 (26.3%) +10: 0-21-0 (0.0%) -10: 10-11-0 (47.6%)
                  26.7 111.7 33.7 224.3 20.9 1.4 3.6 7.0 3.7 5.7 19.9
                  26.5 120.3 33.9 200.7 19.9 1.2 4.5 6.4 2.2 3.3 16.4
                  Nov 30, 2023 view Thursday 13 2023 Cowboys Seahawks home -9.0 47.5
                  And rolltide...

                  Comment

                  • #10
                    Originally posted by Thomas View Post
                    Not sure where your coming up with those numbers Jim

                    P:playoffs = 1 and P:L and AF, 13-15-1 ats

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

                    add in the weeks you mention (which wont include week 9 or 16)

                    P:playoffs = 1 and P:L and AF and 9<week<16, 4-8-1 ats

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

                    Include weeks 9-16, 7-11-1 ats

                    P:playoffs = 1 and P:L and AF and 9<=week<=16
                    Tom, I'm using the list you linked to in Post #3 - games from 2015 to the present.

                    On that list there are only 17 away games listed in total. (above you are talking about results for 29 games????)

                    10 of them are between weeks 9-16 inclusive and the record of those teams is 3-7 ATS (I was tired when I looked last night and mistakenly read 2-7 ATS).

                    Something isn't squaring up with the numbers you provide here. I'm only going by the list you provided.

                    Comment

                    • #11
                      Originally posted by Michelangelo View Post

                      Tom, I'm using the list you linked to in Post #3 - games from 2015 to the present.

                      On that list there are only 17 away games listed in total. (above you are talking about results for 29 games????)

                      10 of them are between weeks 9-16 inclusive and the record of those teams is 3-7 ATS (I was tired when I looked last night and mistakenly read 2-7 ATS).

                      Something isn't squaring up with the numbers you provide here. I'm only going by the list you provided.
                      Jim, if you look at the top left of the K'S page after you click on the link, there are actually 93 games which go back to 2001. It's not showing all of them.

                      I tried to eliminate any clutter in post #5...

                      Comment

                      • #12
                        Originally posted by Riderx View Post

                        Jim, if you look at the top left of the K'S page after you click on the link, there are actually 93 games which go back to 2001. It's not showing all of them.

                        I tried to eliminate any clutter in post #5...
                        John, Is there a way to see the list of the full 93 games? Thanks.

                        Comment

                        • #13
                          day = Thursday and p:division = po:division and p:HW and 10 <= week <= 14 and p:turnover margin <= 1 and site streak = 1 and season >=1995 and line <=3

                          2-17 o/u (-8.34)


                          https://killersports.com/nfl/query?_...+S+D+Q+L+%21++



                          dal under
                          _______________________________________________
                          ( ) in football and baskets is avg ats or ou margin..baseball it's avg odds and run differential for sides and totals..winners and late scratches usually not recognized in the horse thread but on occasion will mention.. always double check race and horse # if you play .. I do lose a lot more races than I win.. playing in advance, late odds moves and high takeout very hard to overcome .. derby future opinion post 3713 on page 149 (horse plays)

                          Comment

                          • #14
                            Originally posted by bleeker View Post
                            day = Thursday and p:division = po:division and p:HW and 10 <= week <= 14 and p:turnover margin <= 1 and site streak = 1 and season >=1995 and line <=3

                            2-17 o/u (-8.34)


                            https://killersports.com/nfl/query?_...+S+D+Q+L+%21++



                            dal under
                            on 11/30/17 the game was 17-7 (47) going into the 4th qtr and ended 38-14
                            _______________________________________________
                            ( ) in football and baskets is avg ats or ou margin..baseball it's avg odds and run differential for sides and totals..winners and late scratches usually not recognized in the horse thread but on occasion will mention.. always double check race and horse # if you play .. I do lose a lot more races than I win.. playing in advance, late odds moves and high takeout very hard to overcome .. derby future opinion post 3713 on page 149 (horse plays)

                            Comment

                            • #15
                              Originally posted by Michelangelo View Post

                              John, Is there a way to see the list of the full 93 games? Thanks.
                              Here ya' go, Jim:

                              KillerSports.com

                              Be forewarned: this shows all games no matter how long ago the playoff games were...could be 2,3,4 years ago, not just 1. That's why I tried to clean it up.

                              Comment

                              Previous 1 2 3 4 template Next
                              Working...
                              X