NBA Stituational Bet, SDQL

[JMon]

Overall Group Record - 24-19-1 55.8% (+4.00)

Yesterday's recap 2-3-1 (-1.15) - close to being a good day..pip loses by the hook and consig pushes

Official Entries: Max 10 of 10:

1. JMon - 3-4 (-.60)

2. pip2 - 2-2 (-.10)

3. nash13 - 5-1 (+4.00)

4. Ronald S. - 4-2 (+1.95)

5. hyahya - 2-3 (-1.35)

6. Mako-SBR - 2-4 (-2.40)

7. FlyinAir - 1-2 (-1.45)

8. Consigliere - 4-1-1 (+2.95)

9. Sports Mind - 1-0 (+1.00)

10. Golf Addict - 0-0 (0.00)

[nash13]

I can't send PM because I have not reached the required number of posts.
My email is GolfAddict420@gmail.com
Hopefully he sees this post or can you possibly send a message for me?

I activated you in the spreadsheet.

[pip2]

Spitball Queries

mia/lac OVER from hyahya -- O/U:47-30-0 (2.77, 61.0%)
p:WAD and p:margin>=6 and HD and line<=6 and season>=2010 and season

lac covers vs mia from jmon -- ATS:23-57-2 (-2.94, 28.8%)
HD and p:AW and points < 105 and 2011<=season and o:rest<2

[JMon]

No Best Bet from me today!

[nash13]

I am out too.

[hyahya]

NBA 2014-15 best bet
Play Sacramento Kings -1.5 -110
p:AWD and op:HFL and rest>0 and o:rest>0 and
<line<4<line<4 and="" season=""><line<4 and="" season=""><line<4 and="" 2<line<4="" season="">-4<line<4 and="" season="">2011

Two rested teams with opposite previous results in an expected close game. Take the team coming off the surprising loss.

Not sure what's going on above with the formatting. I'm trying to add line between -4 and 4 and season after 2011. BTW, Sac will not show up in this query as the line in the DB is posted at -4 while it currently stands at -1.5.</line<4></line<4></line<4></line<4<line<4>

[Consigliere]

4 trends tracking on the spreadsheet today. Pip covered both of the actual picks already.NBA56
NBA62
NBA106
NBA107

[SportsMind]

Nothing for me today. GL everyone

[Mako-SBR]

Damn, nothing on my sheet. BOL to those on the Clippers again.

NBA 2014-15 best bet
Play Sacramento Kings -1.5 -110
p:AWD and op:HFL and rest>0 and o:rest>0 and
<line<4<line<4 and="" season=""><line<4 and="" season=""><line<4 and="" 2<line<4="" season="">-4<line<4 and="" season="">2011

Two rested teams with opposite previous results in an expected close game. Take the team coming off the surprising loss.

Not sure what's going on above with the formatting. I'm trying to add line between -4 and 4 and season after 2011. BTW, Sac will not show up in this query as the line in the DB is posted at -4 while it currently stands at -1.5.</line<4></line<4></line<4></line<4<line<4>

Yeah even with smilies disabled there's still another glitch with SBR's software when it comes to very specific line parameters, we had this happen last season once or twice. Luckily it's rare, all you can do is word it out as you did hyahya.

[Consigliere]

No BB for me today. Nothing too compelling. May tail the two trend picks for half unit on clippers heat but have a feeling they may split out.

[pip2]

Damn, nothing on my sheet. BOL to those on the Clippers again.



Yeah even with smilies disabled there's still another glitch with SBR's software when it comes to very specific line parameters, we had this happen last season once or twice. Luckily it's rare, all you can do is word it out as you did hyahya.

I finally found out I was losing characters in my posts when there was no space between my < or > characters and the next word...

[JMon]

NBA 2014-15 best bet
Play Sacramento Kings -1.5 -110
p:AWD and op:HFL and rest>0 and o:rest>0 and
<line<4<line<4 and="" season=""><line<4 and="" season=""><line<4 and="" 2<line<4="" season="">-4<line<4 and="" season="">2011

Two rested teams with opposite previous results in an expected close game. Take the team coming off the surprising loss.

Not sure what's going on above with the formatting. I'm trying to add line between -4 and 4 and season after 2011. BTW, Sac will not show up in this query as the line in the DB is posted at -4 while it currently stands at -1.5.</line<4></line<4></line<4></line<4<line<4>

p:AWD and op:HFL and rest>0 and o:rest>0 and 4>=line>=-4 and 2011<=season

[Ronald S.]

Very interesting... 2 teams who both performed well above expectations in their previous games has a strong correlation with the Under! The higher the deviation, the more it favors the Under.

83-124-1 (-3.97, 40.1%) avg total: 194.8

55-92-1 (-4.48, 37.4%) avg total: 194.6

34-77-0 (-6.77, 30.6%) avg total: 194.3

27-56-0 (-5.76, 32.5%) avg total: 194.5

18-44-0 (-7.58, 29.0%) avg total: 194.3

12-34-0 (-8.21, 26.1%) avg total: 195.3

10-22-0 (-7.11, 31.2%) avg total: 195.0

[Ronald S.]

NBA SDQL 'BEST BET' 2014-15

11/20/14 4:00 PM EST

Clippers/Heat Under 197.5 -105 (5dimes)

p:ats margin >= 19 and op:ats margin >= 19 and H
O/U: 18-44-0 (-7.58, 29.0%) avg total: 194.3

Very interesting trend I posted above. Play the under when both teams easily covered the spread against their opponent in their previous game. In this case, both teams covered by 19+ points.

[Ronald S.]

Also, I added this to the spreadsheet... just to be sure, how is profit calculated? I did Wins*100 - Losses*110. And ROI is profit/games I assume? And lastly, I didn't know the Z Score if someone could help me out with that. Thanks!

[GolfAddict]

NBA SDQL ‘BEST BET’ 2014-15

11/20/144:20 EST

Kings -2.5 -110

t:team=Bulls and p:A and p:W and date>=20140411
ATS:0-7-0 (-8.71, 0.0%)

t:team=Kings and H and p:L and date>=20140303
ATS:7-1-0 (4.81, 87.5%)

Kings are 7-1 after a loss at home and Bulls are 0-7 after a win on the road.I know the sample size is small but it could be argued that is a good thing because it relates to these players.

[JMon]

@ Ronald... cool stuff bud!

[SportsMind]

t:team=Bulls and p:A and p:W and date>=20140411
ATS:0-7-0 (-8.71, 0.0%)

t:team=Kings and H and p:L and date>=20140303
ATS:7-1-0 (4.81, 87.5%)

Kings are 7-1 after a loss at home and Bulls are 0-7 after a win on the road.I know the sample size is small but it could be argued that is a good thing because it relates to these players.

Not sure any sample size that small is a good thing, especially when it is a very selective with no reasoning for the dates. Just looking at the Bulls query, in the 9 games before the date selected, they were 7-2 ATS with most of the same players.

[lyon804]

Solid work Ronald

[JMon]

Does the google doc have this saved for NCAAF...???? If not save away...solid for ATS fade and under. I will not waste my time on the english version as it's straight forward. Notice the spaces for formating.

pL and n and -28 < line < =-7 and opoints<15 and rest<=6 and p:margin>-21

[nash13]

Does the google doc have this saved for NCAAF...???? If not save away...solid for ATS fade and under. I will not waste my time on the english version as it's straight forward. Notice the spaces for formating.

pL and n and -28 < line < =-7 and opoints<15 and rest<=6 and p:margin>-21

top class work as always, will save it right away

[JMon]

NBA SDQL ‘BEST BET’ 2014-15

11/20/14...some plays may be pending.....

hyahya - SAC -1.5 (1.1 to win 1)

Ronald S. - LAC UN 197.5 ( 1.05 to win 1)

GolfAddict - SAC -2.5 (1.1 to win 1)

Bol fellas....let's get a

[pip2]

NBA SDQL 'BEST BET' 2014-15

11-20-14 - 5:00m PST

Play Chicago Bulls/Sacramento Kings Under 195½ -105*

SDQL:

season>2006 and total > 194 and day=Thursday and (rest=2 or rest=3) and o:rest < 4 and line > -7.5 and month!=2 and month!=12

SDQL: English
since 2006 when Thursday night games have a total of more than 194 and the point of view team has 2 or 3 days of rest and the opponent has less than 4 days rest and the line for the point of view team is higher than -7.5, and the month is not February or December, bet the UNDER

[GolfAddict]

Thought I had same date for both queries to only include this season... not sure what happened there. Oh well still like the pick and with the date I intended to input pretty much the same results

[Cutler'sThumb]

NBA SDQL 'BEST BET' 2014-15

11-20-14 - 5:00m PST

Play Chicago Bulls/Sacramento Kings Under 195½ -105*

SDQL:

season>2006 and total > 194 and day=Thursday and (rest=2 or rest=3) and o:rest < 4 and line > -7.5 and month!=2 and month!=12

SDQL: English
since 2006 when Thursday night games have a total of more than 194 and the point of view team has 2 or 3 days of rest and the opponent has less than 4 days rest and the line for the point of view team is higher than -7.5, and the month is not February or December, bet the UNDER

Hi pip, I plugged the query in, but the system spit out Clippers/Heat as the game that fit tonight not Bulls/Kings. Did I miss something? Trying to work backwords from from the posts to slowly learn my way around. Thanks!

[pip2]

Cutler, originally both games showed up, but I think at some point the total changed to move the sac/chi game out of the query. (Try changing the 194 in that query to 193.5, and the sac/chi game should show up again.) But I also had another query going that kind of showed an under for sac/chi as well, so I made the bet...

[JMon]

Overall Group Record - 27-20-1 57.4% (+5.95)

Yesterday's recap 3-1 (+1.95) - nice day guys!

Official Entries: Max 10 of 10:

1. JMon - 3-4 (-.60)

2. pip2 - 3-2 (+.90)

3. nash13 - 5-1 (+4.00)

4. Ronald S. - 4-3 (+.90)

5. hyahya - 3-3 (-.35)

6. Mako-SBR - 2-4 (-2.40)

7. FlyinAir - 1-2 (-1.45)

8. Consigliere - 4-1-1 (+2.95)

9. Sports Mind - 1-0 (+1.00)

10. GolfAddict - 1-0 (+1.00)

[pip2]

NBA SDQL 'BEST BET' 2014-15

11/21/14 9:05pm PST Reduced Basketball New Orleans Pelicans/Denver Nuggets Under 213½ -105*

SDQL:

A and tA(assists) > oA(assists) and tA(rebounds) < oA(rebounds) and tA(FTA) < oA(FTA) and tA(blocks) > oA(blocks) and tA(FGP) > oA(FGP) and tA(TPP) > oA(TPP) and tA(TO) < oA(TO) and o:rest!=2 and season > 2006 and (194 > total or total > 198)

SDQL: English
Team is away, playing an opponent which averages fewer assists, but more rebounds and more freethrow attempts. The opponent doesn't average as many blocked shots as the team, and the team has both a superior field goal percentage and 3-point percentage to the opponent. As well, the opponent on average turns the ball over more often than the team. The opponent has had any amount of rest except 2 days, and we are only looking at games from the 2007 season and after, and we are excluding games where the total was between 194 and 198.

[pip2]

Results

1-0: mia/lac OVER from hyahya -- O/U:47-30-0 (2.77, 61.0%)
p:WAD and p:margin>=6 and HD and line<=6 and season>=2010 and season

1-0: lac covers vs mia from jmon -- ATS:23-57-2 (-2.94, 28.8%)
HD and p:AW and points < 105 and 2011<=season and o:rest<2

Total: 2-0

[pip2]

Spitball Queries

dal covers vs lal from ronald -- ATS: 96-48-1 (2.88, 66.7%)
H and ats streak >= 4 and -11.5 <= line <= -9.5

orl and bkn cover vs cha and okc From J R ATS: 583-453-21 (1.37, 56.3%)
AD and WP < 50 and (o:rest=0 or rest=1) and ats streak < 0 and 0 < o:ats streak < 3

phi/phx under FROM HYAHYA O/U:34-59-2 (-4.02, 36.6%)
H and total >= 200 and tS(ou margin < -11,N=2) = 2 and game number < 30

det covers vs atl From jh3 ATS: 33-0-0 (13.48, 100.0%)
AD and A(W) <= 0.500 and p:L and pp:L and op:L and opp:L and oA(W) >= 0.500 and season >= 2005

phi/phx under From rcg O/U:303-392-12 (-1.43, 43.6%)
p:dps < -11 and op:dpa < -11 and rest <= 1 and o:rest <= 1

bkn covers vs okc From jmon ATS: 24-8-2 (6.57, 75.0%) p:L and op:L and A and rest>=1 and 0<=line<=3 and P:margin >= 5 and 2010 <= season and 3 > o:rest > 0

phi/phx and lal/dal under From jmon O/U: 9-32-0 (-8.16, 22.0%)
total > 202 and pu margin <= -18 and WP <=25 and 2009 <=season

no/den under from me dinking around unsuccessfully with sac/chi game O/U:45-80-4 (-2.66, 36.0%)
A and tA(assists) > oA(assists) and tA(rebounds) < oA(rebounds) and tA(FTA) < oA(FTA) and tA(blocks) > oA(blocks) and tA(FGP) > oA(FGP) and tA(TPP) > oA(TPP) and tA(TO) < oA(TO) and o:rest!=2 and season > 2006 and (194 > total or total > 198)

[hyahya]

Pip2, the 33-0 query is most likely wrong as the A(W) term should be tA(W).

[nash13]

NBA Best Bet

11-21-14 07:00 CET

Suns/76ers Under 209@-103 5Dimes

total > 202 and pu margin <= -18 and WP <=25 and 2009 <=season

English: Take the Under in a game where the total line is above 202 and the previous over/under margin has been -18 or less under the line and the Winning Percentage of the team involved is below 25%. Only take games after the season 2009 and beyond into account.

[pip2]

Pip2, the 33-0 query is most likely wrong as the A(W) term should be tA(W).

I guess I was thinking that was not an average, but the number of road wins. Whatever it is, when that situation (whatever it is) comes up, it seems to have a pretty consistent outcome!

[hyahya]

Actually, what I'm saying is that the query is probably invalid as we ran across the same situation in the baseball thread where the A(W) term was used and returned an undefeated query that was bogus.

[Heart]

How were the results of the baseball season using these methods?