NBA Stituational Bet, SDQL

Originally Posted by JR007

have a fair question for you guys, have you experienced losing streaks using sdql, and if so can you give me a duration ??? 5,6 or 7 games long ?? like anything else it depends on your selections.....just wondering as I have seen the newsletter at the other place have bad runs using this over the years in( NFL) but that was a different sport.......unlike modeling, can't really have a margin of safety..using sdql.......outside of sample size.....and how much of a sample size do you need to base a play on ??? thanks

\


Streaks will still occur both ways. When a "super" query produces a few losses in a row I try to identify if any further tweaking is needed and will monitor it instead of playing. I will re-save it labeled accordingly. I do not have a set number of losses at which this occurs because some queries are high volume plays and some may only have 3-4 plays in an entire season. This in itself is all part of the experience using sdql and a skill that has nothing to do with the language. See Mako's post #170 for some guidelines or rules for queries. Great inquiry, JR.
Good luck.

Originally Posted by Tillos

This 'SDQL' shows that the HF scores an average well over 104pts; and winning by an average of 10pts (after coming off 3 straight 100+ games). This HF has scored over over 104 points is seven straight games. While their opp has allowed 100+ in 13 STRAIGHT games.

HF and p: points>100 and ppp: points>100 and ppp: points>100 and op:H and season=2013


The Team Total Over might be a safe bet here

Hey Tillos,
You made a mistake that I am guilty of at times. In your query, you wanted to show a team that has scored over 100 pts 3 games in a row. However, your second and third games show "pppoints". You should have typed "ppoints" for Game #2.

It changes the results quite a bit.

GL2A!

This seems very tempting due to the short line and knowing Cavs line-up at this moment. Though might be a trap line, because Pacers are being heavily backed by the public. Not sure I'm gonna play this, but it's worth a look.

WP>=65 and 30<=o:WP<=40 and A and game number>=60 and -6<=line<=-4

wouldn't the over be a safe play if this query plays out as projected??

Originally Posted by comon kryptonite

wouldn't the over be a safe play if this query plays out as projected??

Throw a total filter in there of 189< and see how low totals do on the O/U in that particular situation.

Nothing good for me today...

Lean (only) Orl un 195, Ind ov 183.5 and Chi ov 182.5

Here's one from previous posts. My apologies, since I don't know to whom the credit for this belongs.

H and season>2009 and line>5 and p:margin<-15 and op:margin>5 and p:A and pp:A

tS(A, N=4)=4 and H and (4-rest-p:rest)=3 and o:rest>0 and game number>=65 and P:L

An interesting situation here.

Originally Posted by JAnthony

tS(A, N=4)=4 and H and (4-rest-p:rest)=3 and o:rest>0 and game number>=65 and P:L

An interesting situation here.

Ya it's interesting there hasn't been a fav in this situation since 2008

Originally Posted by JMon

Ya it's interesting there hasn't been a fav in this situation since 2008

Yeah, looked into that as well, but there have been situations around PK, since -1.5 is pretty much the same thing, might have a small play.

p:WD and pp:WD and tA(margin, N=2)>=5 and op:WP>=55 and game number>=65 and season>=2007

Road favourite day for me.

Originally Posted by JAnthony

tS(A, N=4)=4 and H and (4-rest-p:rest)=3 and o:rest>0 and game number>=65 and P:L

An interesting situation here.

I love this team tonight.

damn missed this winner yesterday

A and P:L and Po: points > 74 and WP >= 40 and WP <= 49 and o:WP > 29 and o:WP < 54 and rest > 0 and season = 2013

another missed winner for me today

D and p:margin >= 30 and rest < 2 and season = 2013

ATS:	1-7-0 (-3.56, 12.5%)	avg line: 5.2

Originally Posted by JAnthony

p:WD and pp:WD and tA(margin, N=2)>=5 and op:WP>=55 and game number>=65 and season>=2007

Road favourite day for me.