SDQL ..a new tool for me

This is not for todays game,your getting games already played for the last 10 yr's. If you want todays game you can do something like

tA(3DP)>=55 and week<6 and season=2022 , this give you today and back to sept.

and this brings you to 55.6%

or you can do week =6 and it will say Buff and 0% , because the game hasn't  played yet.

and this brings you to 55.6%

@hoody

 thanx for this

p:3DP>=40 and AD and line>-7 and week<7 and season=2022

This should give you next week

I like this one: 3DP>=45 and o:3DP<30 and AD and season>2012

has a record ATS of 57-5- for 92%

@hoody

 When I use this query:  RY>150 and o:PY<200 and F and season>2012..the result is (183-59-10) 76% ats

Does this mean that if am right about a team rushing for over 150 yards while not allowing their opponents to

pass for 200 yards, that I have a 76% chance of covering????

@jowchoo

 rushing first downs >5 and o:rushing first downs <5 and F and season> 2012.......(425-168-13) 72%

So if I can isolate an upcoming game where I think the favorite will rush for more than 5 first downs while holding their

opponents to less than 5 rushing first downs I will have a 72% chance of covering??

This is giving you the result of every game from 2013 where your team had more than 5 first downs and your opponent had less than 5 first down and the F is a Fav. so these game have already been played.

Try somthing like this tA(RFD)>5 and otA(RFD)<5 and AD and line>-7 and week<7 and season=2022 and you get this year and look at the ats small but (100%) and your looking at Car and the Rams next week. Play around you can do it with HF, month, week etc... What your asking is if you can isolate a game where one team will rush for more than 5 RFD's and opp won't , the big thing is can you ISOLATE a game and (team) out of 16 games or 14 I think this week.

For determining how a team will do based on their season-to-date average....i.e., rushing average per game you use  tA(RY)>140 or tA(RY)<100

For determining something based on a team's present opponent's average use oA.......to find out how a team does as a home favorite when their opponent rushes for an average of less than 100 yards per game you would use oA(RY)<100 and HF

p is used for using the previous game's results....if you wanted to find out how a team has performed as an away dog after rushing for 150 yards their previous game you would use AD and p:RY>150

po is used for a team's previous opponents results....if you wished to find out how a team does an away dog after allowing 150 yards  rushing their previous game the query text would be AD and po:RY>150

There is a user's manual with the prefixes listed on the killersports' website.

After you do this for awhile you will see that most of the stats based queries will have regressive results, which means 55-60% of the time a team performing at a high level in a certain stat like turnovers created, rushing yards or passing yards will not continue to do so....and alternatively teams performing poorly in their last game or in their season-to-date average will improve enough to cover games.

It is the equivalent to buying  the dips in the stock market or selling on a short-term top.  Obviously in the stock market you have stop-losses that lessen your risk, which is the advantage of investing in  the stock market versus sports betting investing.

Most of life is balance and regression....when things are going one way for awhile things happen in often inexplicable ways and results reverse themselves.

@Indigo999

 Thank you 999 you are kind to take time to help.

Most of life is balance and regression....when things are going one way for awhile things happen in often inexplicable ways and results reverse themselves.

I truly hope this is TRUE as our world's pendulum has swung far too much in the wrong direction imho.

@Indigo999

 Thank you 999 you are kind to take time to help.

Most of life is balance and regression....when things are going one way for awhile things happen in often inexplicable ways and results reverse themselves.

I truly hope this is TRUE as our world's pendulum has swung far too much in the wrong direction imho.

Instead of using season to date averages probably the last 3 is better for current form