NBA Stituational Bet, SDQL

**JMon** · 12-07-14, 10:06 AM

NBA SDQL "Best Bet" 2014-15

Overall Group Record - 61-51-1 54.4% (+6.58) (max wagered -to win 1 unit)

Yesterday's recap 3-0 (+3.00) - Good job fellas!!!

Official Entries: Max 10 of 10:

1. JMon - 10-9 (+1.00)

2. pip2 - 11-8 (+2.57)

3. nash13 - 6-4 (+1.82)

4. Ronald S. - 9-8 (+.45)

5. hyahya - 6-4 (+1.55)

6. Mako-SBR - 6-10 (-5.00)

7. FlyinAir - 1-2 (-1.45)

8. Consigliere - 7-3-1 (+3.84)

9. Sports Mind - 2-0 (+2.00)

10. GolfAddict - 3-3 (-.20)

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

I can't get ahold of FlyinAir...those that have expressed interest in that spot on the best bet (Alex, 46, Heart)- I'll let you guys decide who wants it. Keep in mind you will also be taking over his record. Just let me know.

**JMon** · 12-07-14, 10:30 AM

NBA SDQL "Best Bet" 2014-15

12-7-14 - 9:25a CT

Play: Nuggets +5.5 -110

SDQL: A and 9.5 >= line >= 3.5 and tA(points) >= 103 and p:M2 <= -15 and playoffs = 0

English: In reg season, play a road dog averaging 103 or more points a game coming off a game where they were down 15 or more at the half.

**emceeaye** · 12-07-14, 11:54 AM

Originally posted by pip2

If okc doesn't win ATS, I'm going to kick myself for not going with CHA 1st quarter as bet of the day...

Again today with pistons and Thunder. Thunder ATS 1st quarter

**pip2** · 12-07-14, 12:35 PM

Originally posted by emceeaye

Again today with pistons and Thunder. Thunder ATS 1st quarter

On it, thanks for letting me know -- my system is malfunctioning today..

**Mako-SBR** · 12-07-14, 03:11 PM

NBA SDQL "Best Bet" 2014-15

12-7-14 - 12:00p PST

Play: NO (-2.5) LAL

SDQL:
HD and tA(points)>98.5 and p

oints<101 and pp

oints<100 and game number>=21 and 189.5<=total<=210 and line<=7 and C and season>=2006

English: Fading a home dog that is averaging over 99 points per game, but scored less than 101 points in their last two games, up against a conference opponent with a typical total and getting less than 7 points. Works particularly well if the opponent lost their last game, and lost it by a massive point margin as New Orleans just did.

Notes:
Lot of good queries pointing to this one today, and it seems like a gift with the Pelicans laying so few points against the hapless Lakers...let's cash it!

**pip2** · 12-07-14, 03:32 PM

NBA SDQL 'BEST BET' 2014-15

12/7/14 10:00am NBA Basketball 805 Oklahoma City Thunder 1st Quarter -3 -110* vs Detroit Pistons

SDQL:

p:M3 > 0 and (A or D) and p:L and rest = 0 and season > 2010

SDQL: English

Since 2010, for the 1st quarter, fade the away or dog team that just lost last night after leading at the end of the third quarter.

**dmitean** · 12-07-14, 04:03 PM

The only thing I'm worried about in LA game, is that Scott makes changes in the starting unit, with both Boozer and Lin losing their place in favor of Davis and Price.
That means that changes the style a bit and can influence the queries...

**dmitean** · 12-07-14, 04:20 PM

Can I check in SDQL, how a team, that lost the previous match up, plays, if they play each other B2B (without rest, or with rest, but without playing other teams in between)?
Example - Wizards lost tonight in Boston and play Boston again tomorrow...

**Ronald S.** · 12-07-14, 04:27 PM

No best bet for me today again. GL everyone

**Ronald S.** · 12-07-14, 04:31 PM

Originally posted by dmitean

Can I check in SDQL, how a team, that lost the previous match up, plays, if they play each other B2B (without rest, or with rest, but without playing other teams in between)?
Example - Wizards lost tonight in Boston and play Boston again tomorrow...

I think something like this?
P:L and o:team=po:team and team=opo:team

I actually did try to look at this angle before but had no success in finding anything substantial... hopefully you have better luck!

**nash13** · 12-07-14, 04:40 PM

I am back from my mini vacation, added the new queries to the spreadsheet, will look in the other threads for newcomers. Not enough time to select plays for tonight.

**pip2** · 12-07-14, 05:45 PM

Originally posted by Ronald S.

I think something like this?
P:L and o:team=po:team and team=opo:team

I actually did try to look at this angle before but had no success in finding anything substantial... hopefully you have better luck!

P:L and o:team=po:team and team=opo:team and season>2010 and p:line<2

ATS:..60-38-2 (2.62, 61.2%)
O/U:..55-44-1 (2.81, 55.6%)

**dmitean** · 12-07-14, 05:56 PM

No query on earth can predict such an ugly game. I watch 2 - 3 games a day, so you can imagine how many games I seen this season and this one the ugliest I have seen so far (the game in Atlanta)...
Just beyond terrible...
Denver stopped playing after first 8 minutes, Hawks stopped playing after 24 minutes.
I honestly would support a rule, that both teams should be denied a win, if they fail to play at least bad basketball, because calling this game, "a bad game" would be a praise...
I honestly want 2.5 hours of my life back, after watching this...

**pip2** · 12-07-14, 05:56 PM

Originally posted by pip2

P:L and o:team=po:team and team=opo:team and season>2010 and p:line<2

ATS:..60-38-2 (2.62, 61.2%)
O/U:..55-44-1 (2.81, 55.6%)

oops! that only works for the playoffs, if it works at all...

**dmitean** · 12-08-14, 01:36 AM

Originally posted by Ronald S.

I think something like this?
P:L and o:team=po:team and team=opo:team

I actually did try to look at this angle before but had no success in finding anything substantial... hopefully you have better luck!

Thanks! This is where I was looking for:
P:L and o:team=po:team and team=opo:team and P:AF and playoffs = 0
SU:30-5 (15.11, 85.7%)ATS:22-12-1 (5.00, 64.7%) avg line: -10.1O/U:20-15-0 (4.56, 57.1%) avg total: 193.5

Or this one:
P:L and o:team=po:team and team=opo:team and playoffs = 0 and line<-6
SU:40-7 (12.91, 85.1%)ATS:29-17-1 (3.52, 63.0%) avg line: -9.4O/U:24-23-0 (2.29, 51.1%) avg total: 195.9

**Alex Vaile** · 12-08-14, 03:19 AM

Originally posted by Mako-SBR

NBA SDQL "Best Bet" 2014-15

12-7-14 - 12:00p PST

Play: NO (-2.5) LAL

SDQL:
HD and tA(points)>98.5 and p

oints<101 and pp

oints<100 and game number>=21 and 189.5<=total<=210 and line<=7 and C and season>=2006

English: Fading a home dog that is averaging over 99 points per game, but scored less than 101 points in their last two games, up against a conference opponent with a typical total and getting less than 7 points. Works particularly well if the opponent lost their last game, and lost it by a massive point margin as New Orleans just did.

Notes:
Lot of good queries pointing to this one today, and it seems like a gift with the Pelicans laying so few points against the hapless Lakers...let's cash it!

Beautiful! Thanks for posting!

**nash13** · 12-08-14, 08:46 AM

Uodated most of the spreadsheets queries from here and GoogleGroup. Would be nice if anyone could double check if anything important is missing.

**JMon** · 12-08-14, 08:55 AM

NBA SDQL "Best Bet" 2014-15

Overall Group Record - 62-53-1 53.9% (+5.38) (max wagered -to win 1 unit)

Yesterday's recap 1-2 (-1.2)

Official Entries: Max 10 of 10:

1. JMon - 10-10 (-.10)

2. pip2 - 11-9 (+1.47)

3. nash13 - 6-4 (+1.82)

4. Ronald S. - 9-8 (+.45)

5. hyahya - 6-4 (+1.55)

6. Mako-SBR - 7-10 (-4.00)

7. FlyinAir - 1-2 (-1.45)

8. Consigliere - 7-3-1 (+3.84)

9. Sports Mind - 2-0 (+2.00)

10. GolfAddict - 3-3 (-.20)

**pip2** · 12-08-14, 10:38 AM

Originally posted by dmitean

Thanks! This is where I was looking for:
P:L and o:team=po:team and team=opo:team and P:AF and playoffs = 0
SU:30-5 (15.11, 85.7%)ATS:22-12-1 (5.00, 64.7%) avg line: -10.1O/U:20-15-0 (4.56, 57.1%) avg total: 193.5

Or this one:
P:L and o:team=po:team and team=opo:team and playoffs = 0 and line<-6
SU:40-7 (12.91, 85.1%)ATS:29-17-1 (3.52, 63.0%) avg line: -9.4O/U:24-23-0 (2.29, 51.1%) avg total: 195.9

This one I did a while back just became active: season>2003 and date-P:date<2 and A
ATS: 45-24-0 (2.31, 65.2%)

**pip2** · 12-08-14, 11:38 AM

NBA SDQL 'BEST BET' 2014-15

12/8/14 8:30am pst Reduced Basketball 502 Washington Wizards -9 -105* vs Boston Celtics

SDQL:

season>2003 and date-P:date<2 and A

SDQL: English

Since 2003, the away team wins the second game of b2b/home-and-home games

**pip2** · 12-08-14, 11:44 AM

Originally posted by pip2

NBA SDQL 'BEST BET' 2014-15

12/8/14 8:30am pst Reduced Basketball 502 Washington Wizards -9 -105* vs Boston Celtics

SDQL:

season>2003 and date-P:date<2 and A

SDQL: English

Since 2003, the away team loses the second game of b2b/home-and-home games

Crap! My bet is the opposite of my sdql!

**dmitean** · 12-08-14, 11:56 AM

No, it actually supports your play.
The team that lost the night before, covers in the night after.
I checked the games and in all of them (checked the last 6 - 7), the visiting team lost the night before...

**hyahya** · 12-08-14, 12:06 PM

Unless I'm missing something, pip2's query is pointing to Boston as he stated. I actually think the better play is the under for that game, will probably make that my best bet.

**dmitean** · 12-08-14, 12:21 PM

I'm saying that in his query, the teams that covered, were the teams that lost the game the night before and while on paper, the query supports Boston, in reality, it really supports Wizards play.

**Heart** · 12-08-14, 01:15 PM

Here's a simple one I don't see on the spreadsheet..

H and line>10 [139-98-2 (1.77, 58.6%)]

larger the spread the better the odds...

H and line>12 [45-30-0 (1.93, 60.0%)]

Timberwolves +12.5 fit these tonight

**IllyPhilly[DOC]** · 12-08-14, 01:24 PM

I figured WIZZ win vs BOST but do they cover -9? That is a lot.

**JMon** · 12-08-14, 02:30 PM

Pip is that play, official?

**Cutler'sThumb** · 12-08-14, 02:47 PM

Just posted the hockey plays. No time for me to look at NBA today tho. Hopefully someone has time, as I'm sure there are plenty of active trends

**GolfAddict** · 12-08-14, 03:42 PM

NBA SDQL “BEST BET” 2014-15

12/8/143:38PM EST

Toronto Raptors -9 (-110)

HF and p:HFL and WP >= 75 and o:WP <= 45 and o:rest = 0 and playoffs = 0

SU:12-1 (17.31, 92.3%)
ATS: 10-3-0 (4.35, 76.9%)

When a superior team coming off a loss at home as a favorite hosts an inferior team that is on no rest play the superior team.

**Ronald S.** · 12-08-14, 03:44 PM

THink I will pass on the best bet today. I had a query lined up for Boston but did not take into consideration the same opponent in the previous game angle

AD and ats streak >= 4 and season >= 2012 and 2.5 <= line <= 9.5
ATS: 45-22-1 (2.62, 67.2%) avg line: 5.8

EDIT: Actually I think I will go with Toronto. Golf Addict reminded me of the p:HFL queries

**dmitean** · 12-08-14, 03:47 PM

Don't have the time to put them in to the doc, but here are today's queries:
159 Indiana -1
154 55 Denver +9
154 11 5 4 Suns +7.5 (4, 5 and 11 have some similarity)
141 80 Wizards -9
131 100 Minny +12.5
126 Under 193 in Indiana (mediocre)
114 Cleveland -7.5
108 87 Over 215 in Toronto (don't like 87 too much)
85 Atlanta +1
8 Under 215 in Toronto (not a big fan of this one as well)

**Mako-SBR** · 12-08-14, 03:50 PM

NBA SDQL 'Best Bet' 2014-15

12-8-14 - 12:20p PST

Play: PHX (+7.5) LAC -110

SDQL:
A and p:AFL and rest in [1,2,3] and 67>=game number>=21 and 48<=WP<=80 and P:L and season>=2006

English:
Playing a solid-performing and rested away team that lost its last away game as the favorite, during the meat of the season, against a team it previously lost to.

Notes:
Full dance card today with 5 plays based purely on SDQL queries, but this is the one I chose for the best bet simply because I like the revenge/coming off a trap game loss/etc angle it involves. BOL all!

**Ronald S.** · 12-08-14, 04:02 PM

NBA Best Bet

12/8/14 4:00 PM EST

Toronto -9.5 -105 (vs Denver) (5dimes)

H and p:HFL and line <= -9.5 and season >= 2011
ATS: 47-24-2 (3.10, 66.2%) avg line: -11.7

Play the large home favorite coming off a loss as a home favorite in their previous game.

**SportsMind** · 12-08-14, 04:35 PM

I'm going to withdraw from Best Bet as I just haven't had the time lately.

This crazy query had a bad result earlier this month but is showing up again.

10-32 (-6.38, 23.8%)
3-37-2 (-6.45, 7.5%)	avg line: -0.1
20-20-2 (-0.63, 50.0%)	avg total: 196.8