NFL - Situational Plays - SDQL

**Alex Vaile** · 09-15-14, 09:04 AM

Dr M's plays 3 and 0 yesterday.
5 and 2 overall

**chopperocker** · 09-17-14, 01:45 PM

team=Ravens and 8<t:rest and (2008,1)<=(season,week) 12-1 SU 9-4 ATS.

**Mako-SBR** · 09-18-14, 02:55 PM

A few scenarios for you guys to check the validity on via SDQL if you're bored today (or better, at work ha). Haven't gotten a chance to enter/research them myself as I'm on the road:

S03: Home Team, After Previous Week Thursday Night Football Loss Of 8 Or More Points

S07: Away Dogs, Division Game, Closes at +10.5 or more Points, Games 1 Through 11 Only

S10: All +3 to +7 Point Dogs Playing In Non-Division Games Who Lost By 20 Or More Points The Previous Week

S14: All Away Teams On MNF In Division Games Where The Spread Closes Anywhere Between -8 and +6.5

**JMon** · 09-18-14, 04:16 PM

Originally posted by chopperocker

team=Ravens and 8<t:rest and (2008,1)<=(season,week) 12-1 SU 9-4 ATS.

team=Ravens and 8 < t:rest and (2008,1)<=(season,week)

chopper ...note space before/after <

**JMon** · 09-18-14, 04:26 PM

Originally posted by Mako-SBR

A few scenarios for you guys to check the validity on via SDQL if you're bored today (or better, at work ha). Haven't gotten a chance to enter/research them myself as I'm on the road:

S03: Home Team, After Previous Week Thursday Night Football Loss Of 8 Or More Points

S07: Away Dogs, Division Game, Closes at +10.5 or more Points, Games 1 Through 11 Only

S10: All +3 to +7 Point Dogs Playing In Non-Division Games Who Lost By 20 Or More Points The Previous Week

S14: All Away Teams On MNF In Division Games Where The Spread Closes Anywhere Between -8 and +6.5

S03: H and p:day=Thursday and p:margin<=-8

S07: A and DIV and line>=10.5 and 11>=game number>=1

S10: 7>=line>=3 and NDIV and p:margin<=-20

S14: A and day=Monday and DIV and -8< line <6.5

like a couple here

note eliminate spaces -8< line <6.5

**emceeaye** · 09-19-14, 01:19 PM

Originally posted by JMon

S03: H and p:day=Thursday and p:margin<=-8

S07: A and DIV and line>=10.5 and 11>=game number>=1

S10: 7>=line>=3 and NDIV and p:margin<=-20

S14: A and day=Monday and DIV and -8< line <6.5

like a couple here

note eliminate spaces -8< line <6.5

Thanks!

Here is Dr. M's query from yesterday on NFL:

team=Steelers and A and p:AD and po: points>=10 and season>=1999

Its consistent with the one you posted:
7>=line>=3 and NDIV and p:margin<=-20

**chopperocker** · 09-19-14, 08:00 PM

Originally posted by JMon

team=Ravens and 8 < t:rest and (2008,1)<=(season,week)

chopper ...note space before/after <

thanx bro!

**chopperocker** · 09-19-14, 08:14 PM

team=Ravens and 8 < t:rest and (2008,1)<=(season,week)

12-1 su 9-4 ats

8 < t:rest and (2004,1)<=(season,week) and op:HDW

27-10 su 27-9-1 ats

p:FL and p:TO=4 and po:TO=0 and HD

3-0 suats

p:FL and p:TO=4 and po:TO=0 and D

17-7-1 ats

**chopperocker** · 09-19-14, 08:27 PM

p:H and HD and op:A and (2009,1)<=(season,week)

28-11-2 Over

**JMon** · 09-21-14, 08:43 AM

Play NYG/HOU OV

Basically we want to play over with a poor rushing team facing a poor rushing defense.

SDQL

tA(RY) <= 70 and 125 >= oA(o:RY) >= 95 and p:RY <= 99 and pp:RY <= 99

**JMon** · 09-21-14, 08:58 AM

Originally posted by chopperocker

8 < t:rest and (2004,1)<=(season,week) and op:HDW

8 < t:rest and (2004 , 1) <= (season , week) and op:HDW and (line >= 3 or line <= -3.5) and game number > 2

thanks for sharing chopper! just added a line parameter as it appeared most losses came from the +3 to -3 area. Check out NFC conf as well.

**chopperocker** · 09-21-14, 12:45 PM

Originally posted by JMon

8 < t:rest and (2004 , 1) <= (season , week) and op:HDW and (line >= 3 or line <= -3.5) and game number > 2

thanks for sharing chopper! just added a line parameter as it appeared most losses came from the +3 to -3 area. Check out NFC conf as well.

excellent! we will keep this one in our back pocket.

**FlyinAir** · 09-22-14, 03:10 AM

MONDAY NIGHT FOOTBALL TREND
The home favorite is 11-2 SU when the total is between 44 and 49 since 2011. 12-3 since 2010 (80%)

HF and day=Monday and season>=2010 and total>44 and total<49

**nash13** · 09-22-14, 09:58 AM

I have four SDQL circumstances for NFL.

Sum(ats margin > 0@team and season, N=6) < 2 and WP < 25 and site != p:site

week > 7 and wins = 0 and line > 5

AF and p:W and pp:W and ppp:W and conference != o:conference and total < 46

first one works for ATS and TOT
second one ATS
third is for overs

**chopperocker** · 09-22-14, 01:55 PM

op:W and pp:HFL and p:AFL and HF and (1989,1)<=(season,week) 13-3-1 to the Under

**JMon** · 09-22-14, 04:43 PM

Play over Jets/Bears

Basically this spot, while limited is in sample but successful, is play over btw two non conference teams coming off games where they covered the spread. Note below other parameters within.

SDQL

-4<=line<=4 and not C and p:ATSW and op:ATSW and 47>=total>=43 and season>=1997 and H

Since 1997 we have seen this spot go....

O/U: 30-7-0 (8.69, 81.1%)

**JMon** · 09-22-14, 04:47 PM

Looks like 3-0 in this thread this week gents. Keep it up!

**JMon** · 09-22-14, 04:48 PM

Originally posted by nash13

I have four SDQL circumstances for NFL.

Sum(ats margin > 0@team and season, N=6) < 2 and WP < 25 and site != p:site

week > 7 and wins = 0 and line > 5

AF and p:W and pp:W and ppp:W and conference != o:conference and total < 46

first one works for ATS and TOT
second one ATS
third is for overs

Thanks for sharing nash13

**emceeaye** · 09-22-14, 11:31 PM

Originally posted by JMon

Play over Jets/Bears

Basically this spot, while limited is in sample but successful, is play over btw two non conference teams coming off games where they covered the spread. Note below other parameters within.

SDQL

-4<=line<=4 and not C and p:ATSW and op:ATSW and 47>=total>=43 and season>=1997 and H

Since 1997 we have seen this spot go....

O/U: 30-7-0 (8.69, 81.1%)

Beautiful!

**hyahya** · 09-25-14, 09:37 AM

HD and p:AW and line<6 and op:HW

**emceeaye** · 09-25-14, 04:04 PM

Originally posted by hyahya

HD and p:AW and line<6 and op:HW

Thanks!

Add week<=5 to improve record.

**JMon** · 09-25-14, 06:09 PM

Originally posted by hyahya

HD and p:AW and line<6 and op:HW

love ml %...made some minor adjustments.

H and p:AW and op:HW and (5.5 >= line >= 1.5 or line >= 8.5) and division!=NFC East

**hyahya** · 09-26-14, 01:00 PM

p:ALF and HF and o:streak>2

**hyahya** · 09-26-14, 05:55 PM

p:AW and HD and line<4 and DIV

**Timmay** · 09-26-14, 11:53 PM

Originally posted by hyahya

p:ALF and HF and o:streak>2

What does this mean?

**chopperocker** · 09-27-14, 10:38 AM

Originally posted by Timmay

What does this mean?

http://killersports.com/Download/NFL/query_manual.pdf

**hyahya** · 09-27-14, 08:09 PM

p:O and pp:O and op:U and AD and 8>line and season>2003 and total>45

**hyahya** · 09-28-14, 09:12 AM

p:HLF and conference!=o:conference and AD and line<6

**JMon** · 09-28-14, 10:12 AM

Play Oak, possible ML

SDQL from KS newsletter

team=Dolphins and F and oA(TY)/ oA(plays)<4.98 and date>=20031019 and p:line<10

**FortySix** · 09-28-14, 10:38 AM

Originally posted by JMon

Play Oak, possible ML

SDQL from KS newsletter

team=Dolphins and F and oA(TY)/ oA(plays)<4.98 and date>=20031019 and p:line<10

JMon, are you still playing this line even though the game is in London?

**JMon** · 09-28-14, 10:55 AM

Originally posted by FortySix

JMon, are you still playing this line even though the game is in London?

Ya I am going to take a shot at it. It doesn't have a site parameter so it does not bring me much concern. bol

**chopperocker** · 09-28-14, 10:11 PM

week+2=tn:week and (1989,1)<=(season,week) and site=home and op:A and opp:A

8-0 SUATS since '89

**chopperocker** · 09-29-14, 10:30 AM

week<=4 and (2014,1)<=(season,week) and AF

12-3 to the Over

rather extreme for a short term small sample, but worth noting.

**emceeaye** · 09-29-14, 10:49 AM

Originally posted by chopperocker

week<=4 and (2014,1)<=(season,week) and AF

12-3 to the Over

rather extreme for a short term small sample, but worth noting.

This is nice as it is consistent with results of Dr. M's posted query of the day:

A and Patriots:Rob Gronkowski: p:receiving touchdowns>0 and p:W and NB

(Remove space after 2nd colon)

**chopperocker** · 09-29-14, 02:54 PM

week 5 look ahead queries

tp:week+2=t:week and (1989,1)<=(season,week) and WP>99 and AD

1-13 SU, 3-11 ATS since '89

week+2=tn:week and (1989,1)<=(season,week) and site=home and op:A and opp:A

8-0 SUATS since '89