NFL season wins data

Thx indigo

Made angle 4:

HF and n:day=Thursday and week=1 and line>-7.5 and total<52.5 and we get a juicy (1-10) ATS ans (3-8) O/U

Will have this in week 1.

#2 Goes to 78% with these additions:

week=1 and season>2018 and D and n:F and nn:F and line<7 and total<51.5......(11-3)   78.6%

Played with your #6 and was able to make it 79% (15-4)....hope you do not mind.

AD and n:F and nn:F and week=1 and season>2015 and 7>line>1 and day!=Monday

Played with this winner.

1<week<=3 and line<7 and AD and not PO=1 and on:D and seaon>2018 and total>38......(28-6)...82%...NICE

.

I'd rather have a 62% angle with hundreds of results than an 85% angle with 15 results.....siphoning down to the nth degree won't improve your results, long-haul.

I would have thought you'd be cognizant of that after you very successfully faded angles/trends last year with small sample sizes that were perfect or close to it.

It is 34 sample size,not 15 and we differ on the the relevant priority of sample sizes as discussed before. My success last season was NOT due to

successfully fading trends with small sample sizes but rather integrating regression into a teaser model. I am expecting near 1K plays this year as SDQL

will open up more small sample size data and the regression stuff is fairly consistent. One area of exploration for me this year will be half time props when

SDQL warrants. Have you ever thought about applying these querys to half time wagers?

Put these on killer

week=1 and A and -3<=line<=7 and PRSW>=7 and tpS(TO)-opS(TO)>=10  

 week=1 and tpS(W,N=5)-opS(W,N=5)>1 and HF and season>2011 and 41.5<total<54 and line<-6 

@jowchoo

I don't think either data base has halftime lines, so ATS results will be tough to research and ascertain.

If you know how to find those halftime lines, please let us all know.

Not sure what your trying to do but try this

AD and line<6 and M2>line and week=1  (50-9-3) 84% on killer and 82% on the dog, looking at Q1 and Q2 on the site it works but like you said it doesn't give you halftime lines, you may half to do some homework.

That is a PRESENT parameter.  Naturally if the margin at the half is greater than the line, those teams will almost always cover the spread.

This is my thinking:

Run this query at dog:     season=2024 and p:P1>p:P3 and D and n:D and p:W and op:W and week<17 and line>1.5

you will see that the DOG is (0-7) losing by an average of 13.1 pts as a dog of 4.3.

Looking at the Q scores, we see that the Dog Averages 7.4 first half pts while their opps average 17.5.

This implies a first half bet on the fav. somewhere around -2.5/-3.5......Right?

In this case:

season=2024 and p:rest<5 and A and surface=artificial and F and week<18

The Fav is (5-0) being a 3.5 fav.

We see that the fav is losing 14.6 to 13.6 at the half, where the final averages are 34.2-19.2

Looks to me a very tasty second half bet and we do not need to know what that line was.

Somewhere around 2/3/4, as you can see the Fav smoked the Dog (19.4-4.6) I am all over

these this year.

Once someone has a database with half-time lines one can proceed....there are in-game injuries, etc., that are in the equation that one cannot go back in a retrograde scenario to see if something works.  There are probably sports database suppliers that sell that information.

If you can beat it (half-time lines) all power to you.  The books want to be the candy store, with every type of enticement for kids like us.  Too much of a good thing basically benefits them.   Does one need to play more than 600 or 1000 plays in a year?

That is where we enter into the realm of Gordon Gecko and crackheads.

7)  Take a week 1 away dog that missed the playoffs last season, whose present opponent will be an underdog their next two games...46-19-5 ATS (+7.6), 70.8%.  

These teams have gone 33-37 straight up, with an average line of 4.2.

ON Panthers, and possibly the Dolphins, as that MD/IC line now is around pick 'em.

If you guys post your angles on my thread, explain the parameters so those not versed in query text can understand what your query entails.  Ideally, angles with lesser parameters and filters are what this thread is about.  If for example, you have more than 5 different filters on a query, post those types of  angles on a separate thread.

This thread is not just for query freaks like you and me, but the common man that may not use a database.

8)  Take a week one team (except for away favorites) whose next week line will greater than 3 points stronger than their present opponent's next week line.....158-102-9 ATS, 60.8% (+3.3)

This takes into consideration that the age-old possibility that time is not linear and that what happens in the future can have influence in the past.

Query text.....week = 1 and n:line-on:line<-3 and not AF 

Play ON:  Vikings, Rams, Lions, Broncos, Commanders, Dolphins, Cowboys

@jowchoo

 Thanks.

@hoody

week=1 and A and -3<=line<=7 and PRSW>=7 and tpS(TO)-opS(TO)>=10

THX...a top drawer query!

Fantastic information.  Thanks to all ! Please keep it coming! Thanks again !!

D and week=1 and DIV and opS(playoffs)>1 and tpS(playoffs)=0 and season>2010

Since 2011 a Divisional DOG who missed the playoffs last year playing an opponent who was in the playoffs

went (15-3) ats 83%.

ON:   Dallas,  NYGiants

week=1 and F and season>2020 and n:DIV and total<49.5

Since 2021, in week 1, a Favorite whose next game is a Divisional game with a total less than 49.5

has gone (3-11) ats and (2-12) O/U

ON: MINNESOTA and UNDER

HD and week=1 and season>2011 and DIV and line>1

Since 2012,  a Home Divisional Dog in week 1 getting more than 1 point

has gone (18-3)  86%.

ON:

CLEVELAND, ATLANTA, GREEN BAY, SEATTLE...........All will be on my list :-)

day=Monday and -9

day=Monday and -9<line<7 and 50.5>total>=42 and H and season >2017 went 49-18 to the under. All will be in my anchor teaser plays

@ Indigo

Put this in the CFL and you get 65% and not bad on the U, but there's not many games.