NBA Stituational Bet, SDQL

**JMon** · 02-18-14, 06:13 PM

Originally posted by Wojo

I don't have any data to support it, but having 5 or more days off seems like it would have an influence on a lot of situations.

In fact I was just thinking about this! Going mining!

**figue** · 02-18-14, 09:18 PM

Originally posted by JMon

In fact I was just thinking about this! Going mining!

any SDQL play for next days ??

**husky** · 02-18-14, 10:50 PM

This thread is great. JMon, I would appreciate any insight on some of your sdql situations for all sports.

**b1slickguy** · 02-18-14, 11:26 PM

Originally posted by Mako-SBR

Received this in a trend email this week, but when I put it into SDQL the historic performance doesn't match the numbers referenced:

NBA Teams are 37-12 on the road against an opponent that covered by 10+ points against them in their same-season home match earlier.

Anyone have a query that can produce the right record?

Originally posted by dshaffe4

Here is what I got. Its only for this season though.

Knicks winner.

**b1slickguy** · 02-18-14, 11:32 PM

chopperocker, check in, bro. Haven't seen you around lately.

**figue** · 02-18-14, 11:33 PM

Originally posted by b1slickguy

Seeing possible play on Knicks. Good luck.

**Dynobites** · 02-19-14, 01:34 AM

Hey guy. Have been viewing for awhile, and recently ran across Killersports two weeks ago. I barley know any 'code', but today at work I wrote down a list of situations. Can anybody put them into correct 'code' format for me? I'll throw you my daily pts.

**JMon** · 02-19-14, 06:36 AM

Originally posted by Dynobites

Hey guy. Have been viewing for awhile, and recently ran across Killersports two weeks ago. I barley know any 'code', but today at work I wrote down a list of situations. Can anybody put them into correct 'code' format for me? I'll throw you my daily pts.

I know slickguy and myself could possibly help. Let em rip.

**fataliz** · 02-19-14, 07:02 AM

what's the syntax for putting teams with say previous games away? like previous games consecutive 2 away?

**fataliz** · 02-19-14, 08:04 AM

delete

**JMon** · 02-19-14, 12:44 PM

fataliz if you're looking for a team that was on the road use

p:A

or one the road their last two games

p:A and pp:A

**JAnthony** · 02-19-14, 12:57 PM

Since SBR admin is removing all links, maybe those who are willing to share their system, can share the 'code' for it, so that others can input it and see what's there?

**fataliz** · 02-19-14, 01:53 PM

for the fade home team after 2 road wins matchup, today magic is a play

**Ro0k** · 02-19-14, 02:15 PM

I think I like Orlando tonight. They have to be embarrassed after losing to the Bucks last night.

On the flip side, the Cavs have won the last 6 matchups both home and away.

Just makes me kind of nervous.

**Mako-SBR** · 02-19-14, 04:14 PM

Originally posted by b1slickguy

Knicks winner.

Another one, active tonight on the Celtics:

Edit: Links not allowed guys so here is the code itself (input this into any SDQL query page):

AD and WP<50 and o:WP>50 and ats streak<0 and o:ats streak>0 and on:H and 10<=game number<=60 and season>=2009

**JMon** · 02-19-14, 04:52 PM

Nice Mako

Here is one for the Spurs under (since ,05)...play at your own risk

1. >=200 total
2. Revenging a SU loss as a Fav
3 Btwn two winning teams (75 to 60%)
4. oppt on 1 more days rest

total>=200 and P:FL and 75>=WP>=60 and 75>=o:WP>=60 and 2005<=season and o:rest>0

**FortySix** · 02-19-14, 04:59 PM

Thanks Mako for sharing this with us. I love this "website" that you guys have shown to me. Amazing trends. I also like the Pistons +2.5 tonight because the Bobcats are 1-11-1 ATS at home after a win on the road..

So with the SDQL you gave us, Celtics +6 looks nice?

**Mako-SBR** · 02-19-14, 05:47 PM

Originally posted by JMon

Nice Mako, Here is one for the Spurs under (since ,05)...play at your own risk

1. >=200 total
2. Revenging a SU loss as a Fav
3 Btwn two winning teams (75 to 60%)
4. oppt on 1 more days rest

total>=200 and P:FL and 75>=WP>=60 and 75>=o:WP>=60 and 2005<=season and o:rest>0

I was just thinking last night "I need to research more Under systems...the public and the books are always playing and adjusting the line against the over, hard to find solid EV..."
Thanks JMon, love it.

Originally posted by FortySix

Thanks Mako for sharing this with us. I love this "website" that you guys have shown to me. Amazing trends. I also like the Pistons +2.5 tonight because the Bobcats are 1-11-1 ATS at home after a win on the road..

So with the SDQL you gave us, Celtics +6 looks nice?

Yes, very hard to take such a stinky away dog like the Celtics, particularly when the Suns have been solid at home ATS...but that's the discipline of this particular path. If you believe the situational trend is valid then you're at its mercy and have to play it consistently season to season until it fails or the lines adjust.

**figue** · 02-19-14, 08:57 PM

Originally posted by Mako-SBR

Another one, active tonight on the Celtics:

Edit: Links not allowed guys so here is the code itself (input this into any SDQL query page):

AD and WP<50 and o:WP>50 and ats streak<0 and o:ats streak>0 and on:H and 10<=game number<=60 and season>=2009

mako,what say this trend ??

**Mako-SBR** · 02-19-14, 09:20 PM

Originally posted by figue

mako,what say this trend ??

It's the same trend as post #21, I posted the query today because the external site link got edited out of that post.

**figue** · 02-19-14, 09:35 PM

Originally posted by Mako-SBR

It's the same trend as post #21, I posted the query today because the external site link got edited out of that post.

thanks buddy bol.

**figue** · 02-19-14, 11:42 PM

Originally posted by Mako-SBR

Another one, active tonight on the Celtics:

Edit: Links not allowed guys so here is the code itself (input this into any SDQL query page):

AD and WP<50 and o:WP>50 and ats streak<0 and o:ats streak>0 and on:H and 10<=game number<=60 and season>=2009

damn push ,on to next.

**b1slickguy** · 02-20-14, 12:31 AM

Originally posted by figue

let me know if its a play please

Locked it in moments ago.
Good luck

**FortySix** · 02-20-14, 12:38 AM

Still a good work, the line opened at +7 so depending on when you got the line you would end up winning or push. Still a great trend to say the least.

On that "website" it has great match-up info daily like today with the Wizards and also the Spurs @ Blazers game.
The only trend which is screaming out now is Bucks are 7-26 ATS at home after a win since March 2012.

Please let me know when you guys are locking any plays in because I truly believe in situational plays and maybe it might be good to look into them the night before so we can maybe get the highest line before the public moves the lines.

Thanks fellas, great thread.

**figue** · 02-20-14, 12:53 AM

Originally posted by b1slickguy

Locked it in moments ago.
Good luck

taling you,bol.

**Mako-SBR** · 02-20-14, 01:56 AM

Got lucky with+6.5 on the Celtics, lost on the Spurs bet. Always better to be 1-1 on a night versus 0-2 of course, we'll see what tomorrow brings.

**Dynobites** · 02-20-14, 02:14 AM

Looking at trends for this Mia/Okc game.

The under is 5-1 L6 scenarios in which the Heat previous win was on the road, scoring more than 100 pts - with their next game (not vs OKC) at home. --Same situation for the Thunder, in which the under is 3-1 L4 scenarios, or 8-4 L12--

The under is 4-2 L6 scenarios in which the Thunder previous win was on the road, in which they scored more than 100pts, their previous previous win was on the road, their previous previous previous game was a win. Last time the Thunder played the Heat in this situation the won by 17pts.
(Here's the cord for that one: team=Thunder and p:AW and p

oints > 100 and pp:AW and ppp:W)

Only played with this for twenty minutes but I'm pounding the under of 206.5.

**Wojo** · 02-20-14, 02:33 AM

Hi Dynobites,
Not trying to be a jerk, just giving my opinion from a statistical perspective.

Having a data sample of 4, 6, or even 12 games isn't mathematically very reliable.

Just something to consider.

GL2A!

**JMon** · 02-20-14, 07:18 AM

Originally posted by Mako-SBR

Got lucky with+6.5 on the Celtics, lost on the Spurs bet. Always better to be 1-1 on a night versus 0-2 of course, we'll see what tomorrow brings.

ya tough on the spurs games, but that's way it goes sometimes. BTW is that you on the killersports google group asking questions?

**Noleafclover** · 02-20-14, 02:02 PM

A couple comments - seems like all bets are off when the heat play the thunder, hard to bet as if it were just another game. You know miami at least will get up for that game, that's their M.O. And kinda disconcerting the thunder gave up 103 to the injured lakers, maybe they're going through a period of not playing good D? They may well come out cold after the all-star break, though.

**Mako-SBR** · 02-20-14, 02:24 PM

Originally posted by JMon

ya tough on the spurs games, but that's way it goes sometimes. BTW is that you on the killersports google group asking questions?

Yep yep, it's too bad that group doesn't have more people participating after all this time. Great work by you in there by the way JMon.

Originally posted by Noleafclover

A couple comments - seems like all bets are off when the heat play the thunder, hard to bet as if it were just another game. You know miami at least will get up for that game, that's their M.O. And kinda disconcerting the thunder gave up 103 to the injured lakers, maybe they're going through a period of not playing good D? They may well come out cold after the all-star break, though.

Agree, it's actually nice that none of the systems I follow are pointing out any games tonight, would prefer to get past the all-star-break week with as few plays as possible.

**figue** · 02-20-14, 03:06 PM

Originally posted by JMon

ya tough on the spurs games, but that's way it goes sometimes. BTW is that you on the killersports google group asking questions?

nice, i just join to that group

**Mako-SBR** · 02-20-14, 03:54 PM

One I finished tweaking and researching this morning, which is too bad because it just won last night on Golden State. Passed the walk-forward tests and looks good:

A and tA(points)>=102 and oA(o: points)>=102 and op :W and p: points>=100 and pp: points>=100 and month in [12,1,2,3,4]

Logic behind it:

Basically you're taking away teams with strong offenses that are averaging 102+ PPG on the season and are coming off two straight games where their offense was in a rhythm and scored 100+ points, against a poor defensive team that has given up 102 or more PPG for the season.

As you'd probably guess it works particularly well when the away team is also getting points (dog), but even as the away favorite the hot offense still wins against a shitty defense 67% of the time ATS in this scenario the past 7 seasons.

NOTE: Take out the spaces after the colons in the query, the SBR emoticons are triggering with the ": p" phrase when there's no space in it, like this

**figue** · 02-20-14, 04:08 PM

Originally posted by Mako-SBR

One I finished tweaking and researching this morning, which is too bad because it just won last night on Golden State. Passed the walk-forward tests and looks good:

A and tA(points)>=102 and oA(o: points)>=102 and op :W and p: points>=100 and pp: points>=100 and month in [12,1,2,3,4]

Logic behind it:

Basically you're taking away teams with strong offenses that are averaging 102+ PPG on the season and are coming off two straight games where their offense was in a rhythm and scored 100+ points, against a poor defensive team that has given up 102 or more PPG for the season.

As you'd probably guess it works particularly well when the away team is also getting points (dog), but even as the away favorite the hot offense still wins against a shitty defense 67% of the time ATS in this scenario the past 7 seasons.

NOTE: Take out the spaces after the colons in the query, the SBR emoticons are triggering with the ": p" phrase when there's no space in it, like this

wow ,nice ,thnaks.

**Noleafclover** · 02-20-14, 04:53 PM

Originally posted by Mako-SBR

A and tA(points)>=102 and oA(o: points)>=102 and op :W and p: points>=100 and pp: points>=100 and month in [12,1,2,3,4]

That's sick.

BTW all, heat qualify as revenging a home-opener ats loss of 10+. However, I think a significant reason that situation does so well is because the huge disappointment influences perception and the line for the following game - but perception of the Heat is still high and the line is still giving a lot of respect.

I'm thinking of parlaying them with the over anyway, because I don't think their D can shut down OKC, so I feel if they do cover it goes over. And there are other reasons to like the over that I'll leave unstated here. Only worry of an okc no-show and under is if Westbrook comes out sub-zero - even cool he'll increase the pace of the game.