NBA Stituational Bet, SDQL

cofaga · 03-16-14, 06:42 PM

P:HWD and AD and 13>line>9 and p:W and pp:W

Revenge play

figue · 03-16-14, 10:44 PM

Originally posted by JMon

Yes, I have small plays on Char, Phx and Phx un. You. Starting to work on my MLB database. didn't realize I have over 600 situation I have to go through and clean up. Good grief.

figue · 03-16-14, 10:45 PM

Originally posted by JMon

A total I posted awhile back is going tonight on the Spurs games. Anyone remember what it was????? hint...off two wins of 10 points or more and it was especially good in the western conf.

figue · 03-17-14, 12:23 AM

Originally posted by Mako-SBR

One of JMon's NHL plays is also active today, heads up:

AF and tS(L, N=7)>=5 and 49>=WP>=40 and o:WP<50 and rest>0

i know was for today,but why i cant get the play?? last play show me was jan 28.

Noleafclover · 03-17-14, 01:56 PM

Rockets are recc'd against Jazz by this SDQL:

F and p:AL and p:margin<=-8 and WP>=o:WP and line<=-10.5 and game number<=68 and total>=187 and total<=212 and season>=2006

Far as I can tell, only active one from this thread. I'm not in love with it.

Mako-SBR · 03-17-14, 02:32 PM

Originally posted by figue

i know was for today,but why i cant get the play?? last play show me was jan 28.

JMon already answered this in the thread, line likely moved out of the queries' range after it was posted which would remove it from being displayed.

Originally posted by Noleafclover

Rockets are recc'd against Jazz by this SDQL:

F and p:AL and p:margin<=-8 and WP>=o:WP and line<=-10.5 and game number<=68 and total>=187 and total<=212 and season>=2006

Far as I can tell, only active one from this thread. I'm not in love with it.

It's overfit a bit already but that scenario is a bit stronger if the game features teams from the same Conference but not in the same Division as the Rockets/Jazz are (rises to 74.3% ATS). That whopper line is certainly a tall order given their recent performance though.

I might put a half unit on it just for kicks, with the C/Div filter it hasn't lost by an ATS margin greater than a single basket since 2008. The Under looks good on it as well, though that line makes the ceiling reaaaaal low, haha.

figue · 03-17-14, 04:25 PM

[QUOTE=Mako-SBR;21415530]JMon already answered this in the thread, line likely moved out of the queries' range after it was posted which would remove it from being displayed.

thanks.

figue · 03-17-14, 04:28 PM

one for NHL:

AD and p:goals >= 6 and p:HW and rest = 0 and total = 5.5

8-20-0 (-0.11, 28.6%)

avg total: 5.5

JMon · 03-17-14, 04:39 PM

Originally posted by figue

one for NHL:

AD and p:goals >= 6 and p:HW and rest = 0 and total = 5.5

8-20-0 (-0.11, 28.6%)

avg total: 5.5

thanks fig...I don't like this years recent performance on this small sample; I'll pass. GL

figue · 03-17-14, 04:44 PM

Originally posted by JMon

thanks fig...I don't like this years recent performance on this small sample; I'll pass. GL

any nba for today ??

JMon · 03-17-14, 04:46 PM

Not much for me today, but like this one (bounce back game) for a normal size play: Looking for SDQL translation here fellas! Who can get if first!

1. Road team
2. Salty offense ave 102 more a game
3. Against an OK offense av btwn 98-92
4. after 42+ games
5. after a blowout loss of 15 or more.

cofaga · 03-17-14, 04:52 PM

Originally posted by JMon

Not much for me today, but like this one (bounce back game) for a normal size play: Looking for SDQL translation here fellas! Who can get if first!

1. Road team
2. Salty offense ave 102 more a game
3. Against an OK offense av btwn 98-92
4. after 42+ games
5. after a blowout loss of 15 or more.

A and tA(points)>102 and 98>=oA(points)>=92 and game number>42 and p:margin<=-15

and under play if anyone is interested

P:HL and AD and 212>total>204 and rest=0 and p: points>110 and rest < o:rest<o:rest< html=""></o:rest<>

figue · 03-17-14, 05:14 PM

Originally posted by cofaga

A and tA(points)>102 and 98>=oA(points)>=92 and game number>42 and p:margin<=-15

and under play if anyone is interested

P:HL and AD and 212>total>204 and rest=0 and p: points>110 and rest<o:rest< html=""></o:rest<>

bol

19th Hole · 03-17-14, 05:43 PM

Originally posted by cofaga

and under play if anyone is interested

P:HL and AD and 212>total>204 and rest=0 and p: points>110 and rest < o:rest<o:rest< html=""></o:rest<>

Thanks,
Nevermind.
Spacing issue...

FortySix · 03-17-14, 05:46 PM

Originally posted by 19th Hole

<form action="query"><input id="sdql" name="sdql" value="P:HL and AD and 212>total>204 and rest=0 and p: points>110 and rest < o:rest" size="120"> <input name="submit" value="S D Q L !" size="60" type="submit"> </form>An error occurred (104). Please check your SDQL and try again.

Query Fundamentals:

Hey 19th, you need to take out the space between the p: points so it reads p

oints.

cofaga · 03-17-14, 05:56 PM

rest=0 and 207>total>199 and o:rest=0 and p: points>100 and op: points>100 and pp: points>100

over play, again use at your own risk

JMon · 03-17-14, 06:21 PM

Originally posted by cofaga

A and tA(points)>102 and 98>=oA(points)>=92 and game number>42 and p:margin<=-15

<o:rest< html=""></o:rest<>

nice cofaga.. guess I need to be eliminated you from the session. But I did state "after 42+ games" which cover the 42 mark and you didn't in your query. All is well...talking about a 1% difference, but!

In my description....Salty offense ave 102 more a game. I should have stated 102 or more

figue · 03-17-14, 06:25 PM

this one is for NHL,if you parlayed favorite/over you would be 68-27 with results that show,im rigth jmon ??

line > 0 and p:margin < 3 and o:WP >= 40 and p:goals > 0 and pp:LD and pp:margin < 3 and pp:goals + o:goals > total and p:W

Noleafclover · 03-17-14, 06:57 PM

Originally posted by figue

this one is for NHL,if you parlayed favorite/over you would be 68-27 with results that show,im rigth jmon ??

line > 0 and p:margin < 3 and o:WP >= 40 and p:goals > 0 and pp:LD and pp:margin < 3 and pp:goals + o:goals > total and p:W

Looks nice, will definitely save. Not seeing a result for today, I'm not doing it wrong am I? Also dropped "line>0" still great results, larger sample size.

JMon · 03-17-14, 07:31 PM

Originally posted by figue

this one is for NHL,if you parlayed favorite/over you would be 68-27 with results that show,im rigth jmon ??

line > 0 and p:margin < 3 and o:WP >= 40 and p:goals > 0 and pp:LD and pp:margin < 3 and pp:goals + o:goals > total and p:W

without checking, but "o:goals" without a summative is not predictive. Thus present time you will see.

figue · 03-17-14, 07:46 PM

Originally posted by JMon

without checking, but "o:goals" without a summative is not predictive. Thus present time you will see.

so,what is the rigth query here ??

JMon · 03-17-14, 08:03 PM

Originally posted by figue

so,what is the rigth query here ??

fig, I don't know. I didn't make it! Surly you know what the game reference "p" is by now? Plug it in and see what happens. I already gave you the inaccurate parameter.

jkadleccavanagh · 03-17-14, 10:08 PM

New to this but I have been trying to build my own lately.

Here is one but I'm not sure on the sample size. Looking at Wizards ML in particular

AF and p:WHD and op:AL and rest>o:rest

hyahya · 03-17-14, 11:38 PM

Here's one for tomorrow:

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

Wojo · 03-18-14, 12:15 AM

Thanks, hyahya, nice trend!

b1slickguy · 03-18-14, 12:19 AM

Originally posted by JMon

Not much for me today, but like this one (bounce back game) for a normal size play: Looking for SDQL translation here fellas! Who can get if first!

1. Road team
2. Salty offense ave 102 more a game
3. Against an OK offense av btwn 98-92
4. after 42+ games
5. after a blowout loss of 15 or more.

Originally posted by cofaga

A and tA(points)>102 and 98>=oA(points)>=92 and game number>42 and p:margin<=-15

and under play if anyone is interested

P:HL and AD and 212>total>204 and rest=0 and p: points>110 and rest < o:rest

figue · 03-18-14, 12:32 AM

Originally posted by hyahya

Here's one for tomorrow:

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

bol

figue · 03-18-14, 12:35 AM

Originally posted by figue

one for NHL:

AD and p:goals >= 6 and p:HW and rest = 0 and total = 5.5

8-20-0 (-0.11, 28.6%)

avg total: 5.5

not bad 1-0

19th Hole · 03-18-14, 05:04 AM

Originally Posted by figue
one for NHL:

AD and p:goals >= 6 and p:HW and rest = 0 and total = 5.5

8-20-0 (-0.11, 28.6%)

avg total: 5.5

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

hyahya · 03-18-14, 08:15 AM

Here's another:

HD and season>2009 and p: points<100 and pp: points<100 and tA(points)>100

Probably a little too general. Changing to:

HD and season>2009 and p: points<100 and pp: points<100 and tA(points)>100 and p:W

More descriptive of the actual situation but drops our sample size significantly and shows less consistency over time as it's 2-9 since 2009 but only 8-17 since 2002 (6-8 between 2002-2009)

hyahya · 03-18-14, 08:27 AM

Like this one quite a bit:

HD and season>2002 and p:AL and pp:A and ppp:A and pppp:A and ppppp:A and op:W

dmitean · 03-18-14, 09:11 AM

Originally posted by hyahya

Like this one quite a bit:

HD and season>2002 and p:AL and pp:A and ppp:A and pppp:A and ppppp:A and op:W

Last two seasons, 1 - 3 SU and with 2 points line, most chances, the team that will win the game will cover.

Maybe it adds a bit to take the Wizards, but can't see it as argument for the Kings.

hyahya · 03-18-14, 09:19 AM

I actually like it best for the under.

dmitean · 03-18-14, 09:24 AM

I like Over in Atlanta - days of the week and Toronto playing on a road off a home loss with day's rest - both show clear Over tendency in Raptors games.

zert · 03-18-14, 09:42 AM

If you guys are making play on a trend, cant it be said that there is a trend for the other side too. Thanks