SDQL Query of the Day

DPA and DPS [QUOTE=Superskrub;25626]Whats dpa and dps short for?[/QUOTE] These stand for Delta Points Allowed and Delta Points Scored respectively. DPS is the difference between the number of points the team actually scored and the number of points they were expected to score. For example, if a game has a line of seven and a total of 41, the favorite is "expected" to win 24-17 -- right on both numbers. If the favorite wins 30-10. Their DPS is plus six and their DPA is minus 7. That is, they scored six points more than expected and allowed seven points fewer than expected. So, the SDQL text for a team that scored more points than expected in each of their last three games would be: p:dps>0 and pp:dps>0 and ppp:dps Prof M.

8.25.10 SDQL Query of the Day: 8/25/2010 The Buffalo Bills since December 1993 when they are on the road off a 1-3 point win. The SDQL text is: [B]team=Bills and A and 01993120[/B] As a reminder, these are provided so the reader can become familiar with the SDQL and start to investigate situations of their own. Prof Meyer

8.26.10 SDQL Query of the Day: 8/26 The Panthers since 2003 during the regular season when hosting a team that has allowed less than 3.75 yards per carry season-to-date. SDQL Text: [B]team=Panthers and H and oA(o:YPRA)=2003 and REG[/B] The oA stands for opponent's average and the YPRA stands for yards per rushing attempt. Brutal. Note that they have failed to cover by an average of more than two touchdowns in this situation. Prof M.

8.27.10 SDQL Query of the Day 8/27 The Bears are 10-0 ATS (+14.8 ppg) since 1992 on the road when they are off a win that got them to 500 on the season. The SDQL text is: [B] team=Bears and A and WP=50 and p:W and season>=1992[/B] That it. You can run this team trend yourself and verify the record and check out the complete game listing by using the SDQL text box at lvasports.com. Prof M.

8.28.10 SDQL Query of the Day (8/28) The Cowboys since Christmas 2002 as a dog after a loss in which they failed on at least two red zones attempts. The SDQL text is: [B]team=Cowboys and p:RZF>=2 and D and p:L and 20021225

8.29.10 NFL SDQL Query of the Day (8/29) The Texans since 2006 as a dog when they suffered a double-digit ATS loss last week. The SDQL text is: [B]team=Texans and D and p:ats margin=2006[/B] The NB stands for "No Bye" so the double-digit ATS loss must have been the previous week. Prof Meyer

8.30.10 NFL SDQL Query of the Day 8/30 The Lions as a TD+ dog when they are off a home loss in which they suffered a turnover margin of at least plus-two. The SDQL text is: [B]team=Lions and line>=7 and p:HL and 2=1992[/B] Note that TOM is the turnover margin. The long form is t:turnovers - o:turnovers. Prof Meyer

8.31.10 The Colts since November 1993 during the regular season as a dog after a win in which they committed no turnovers. The SDQL is: [B] team=Colts and p:TO=0 and D and p:W and REG and date>19931101[/B] Running the query reveals that the Colts have won each of their last eight in this spot straight up. Note: When the regular season approaches, I will post queries that are ACTIVE for the upcoming week of action. Prof M.

In your free report on the homepage you write this in the Buffalo play: NFL teams that have a winning record of 400 or less have committed an average of 2.1 turnovers per game when they are off a win by more than 3 points in which they were turnover-free. Could you make a SDQL for this, only looking at regular season games after the first 6 weeks?

[QUOTE=Superskrub;26116]In your free report on the homepage you write this in the Buffalo play: NFL teams that have a winning record of 400 or less have committed an average of 2.1 turnovers per game when they are off a win by more than 3 points in which they were turnover-free. Could you make a SDQL for this, only looking at regular season games after the first 6 weeks?[/QUOTE] Assuming that the it's "have committed an average of AT LEAST 2.1 turnovers per game," I think that the SDQL would be: [B]WP=2.1 and p:margin>3 and p:TO=0 and week>6[/B] Prof M.