NBA Stituational Bet, SDQL

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

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 points<101 and ppoints<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!

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

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)

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%)

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

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!

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...

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.

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.

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

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

Pip is that play, official?

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

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.