NBA Stituational Bet, SDQL

**perryhs** · 01-12-15, 09:03 PM

NCAABB

pp:margin<-30 and p:W and p:line>-5

**perryhs** · 01-12-15, 09:20 PM

NCAABB

p:minutes >pp:minutes+30 and op:O

p:minutes >pp:minutes+10 and rest=0

**perryhs** · 01-12-15, 09:39 PM

NCAABB

pop:ats margin>20 and p:WA

pop:ats margin<-20 and p:LH

**perryhs** · 01-13-15, 06:36 AM

NCAABB

p:field goals made > po:field goals made+5 and p:three pointers made+5 < po:three pointers made and (A or p:A)

**hobbs4** · 01-13-15, 06:58 AM

Hey Nash I am interested in the video if you could send it to me. Thanks

**perryhs** · 01-13-15, 07:17 AM

NCAABB

p:field goals made > po:field goals made and p:fouls > po:fouls+10 and H and total<140

**perryhs** · 01-13-15, 07:26 AM

NCAABB

p:field goals made > po:field goals made and po

ffensive rebounds > p

ffensive rebounds+10 and p:U

**pip2** · 01-13-15, 09:34 AM

Originally posted by Consigliere

Here is an interesting table...how the trends have stacked up so far split by team the choice was on. These are ATS picks only, and haven't split out as fav or dog...would make sense that there are outlier teams when it comes to situational betting practices and maybe as simple as using this to filter out picks. As a whole the ATS picks are doing well and the trends cancelling each other out has proved to be profitable for +9 units or so depending on your juice.


Row Labels	Sum of Win	Sum of Loose	Sum of Unique wins	Sum of Unique Losses
Buck	1	0	1	0
Bull	7	5	3	2
Cava	3	6	1	2
Celt	3	0	2	0
Clip	12	2	4	0
Griz	3	5	2	3
Hawk	4	1	3	1
Heat	3	1	2	1
Horn	5	0	3	0
Jazz	2	0	2	0
King	3	2	3	1
Knic	2	9	0	3
Lake	3	3	1	2
Magi	5	3	5	2
Mave	4	6	3	2
Nets	2	4	2	3
Nugg	9	7	5	3
Pace	1	2	1	1
Peli	8	7	3	3
Pist	3	1	2	1
Rapt	8	3	4	1
Rock	5	6	2	0
Seve	4	0	2	0
Spur	8	5	5	2
Suns	10	4	5	3
Thun	1	11	1	3
Timb	0	7	0	2
Trai	8	3	4	2
Warr	3	0	1	0
Wiza	1	4	1	3
Grand Total	131	107	73	46

Hey Consigliere, do you ever update these figures? I'm pretty curious about how they would read at this point in the season...

**perryhs** · 01-13-15, 10:08 AM

NCAABB

AP TOP 25 Week 10 (Jan. 12)

team in [KENTY,VIRG,GONZ,DUKE,VILLA,LOUVI,WISC,UT AH,KAN,ARZ,IAST,NOTRE,WIST,MARY,NOCAR,WV A,VCU,OKL,ARK,TEX,SETHA,BAY,NIOWA,OKL,WY OM]

WYOM I can't delete the space

**perryhs** · 01-13-15, 11:01 AM

NCAABB

p:field goals made > po:field goals made+5 and po:field goals attempted > p:field goals attempted+10

**perryhs** · 01-13-15, 11:20 AM

NCAABB

p:field goals made > po:field goals made+5 and p

ffensive rebounds > po:defensive rebounds and p:total is not None

**dmitean** · 01-13-15, 02:06 PM

Looking at Nash's NBA plays that he made with all the queriesm if we look at double plays and remove all the ones that have contradicting plays, we get no less than 17% yield! Very impressive!

**nash13** · 01-13-15, 02:37 PM

Originally posted by dmitean

Looking at Nash's NBA plays that he made with all the queriesm if we look at double plays and remove all the ones that have contradicting plays, we get no less than 17% yield! Very impressive!

that is the beauty of getting a lot of trends together. in essence they squeeze the best out of it. just to clarify misunderstanding, everyone with knowledge and wanting to contribute is invited to join the google sheet. i am going to purchase the aautmation tool, it is not necessary for everyone, but saves a ton of time.
last time i checked we were on the verge of getting over 650+ queries ogether in 6 sports. my manual rsearch for 2014 took about 1 week in 3 sports.

**perryhs** · 01-13-15, 10:33 PM

NCAABB

p:margin > op:margin+10 and p:line > op:line+10 and H

**perryhs** · 01-13-15, 10:34 PM

NCAABB

p:dps > op:dps+20 and p:line > op:line+20 and p

vertime = op

vertime=0

**perryhs** · 01-13-15, 11:12 PM

NCAABB

p:steals > po:steals+5 and p:line > op:line+10

**perryhs** · 01-13-15, 11:13 PM

NCAABB

p:three pointers made > po:three pointers made+5 and p:line > op:line+10 and H

**perryhs** · 01-14-15, 02:19 AM

NCAABB

p:steals<=3 and po:turnovers>10 and H and p

oints > op

oints

**perryhs** · 01-14-15, 02:31 AM

NCAABB

po:steals<=1 and p:turnovers>10

or

po:steals/p:turnovers<0.1 and F

**zxc** · 01-14-15, 07:54 AM

Hi can anybody help me with my SDQL query.

streak <= -3 and ats streak <= -3 and playoffs = 0 and season = 2011

I'm trying to create an SDQL query for teams that are playing at home after losing 3 Straight on SU and ATS on their previous games but I think I'm putting the wrong query.

**nash13** · 01-14-15, 08:05 AM

H and streak <= -3 and ats streak <= -3 and playoffs = 0 and season = 2011

**nash13** · 01-14-15, 08:16 AM

Since NFL is not so popular among researchers, here are my results for 2014 NFL season so far.

I have to correct myself. NFL has some value. Bot low volume.
Here are my results from 2014 plays (1.91 odds)
Overview:
All Picks with double plays and contradictions:
ALL: 218-157 (P:41,38 Y:11,03% SR:58,13%)
ATS: 143-107 (P:23,13 Y:9,25% SR:57,20%)
TOT: 75-50 (P:18,25 Y:14,60% SR:60,00%)

Without Contradictions (Double Plays allowed)
ALL: 165-105 (P:45,15 Y:16,72% SR:61,11%)
ATS: 102-68 (P:24,82 Y:14,60% SR:60,00%)
TOT: 63-37 (P:20,33 Y:20,33% SR:63,00%)

Single Plays only, Contradictions and Double Plays eliminated
ALL: 85-55 (P:22,35 Y:15,96% SR:60,71%)
ATS: 52-26 (P:21,32 Y:27,33% SR:66,67%)
TOT: 33-29 (P:1,03 Y:1,66% SR:53,23%)

My Own System (Double Plays allowed, Contradictions disallowed, Only 3-Star Plays)
ALL: 76-47 (P:22,16 Y:18,02% SR:61,79%)
ATS: 50-32 (P:13,50 Y:16,46% SR:60,98%)
TOT: 26-15 (P:8,66 Y:21,12% SR:63,41%)

**CONNEMARA** · 01-14-15, 03:47 PM

what are the dbl plays in English please

**nash13** · 01-14-15, 05:08 PM

Double Plays are: if i find more than one trend active. i bet the amount of units active on each trend per bet. 3 active trends = 3 unit bet. etc.

**CONNEMARA** · 01-14-15, 08:10 PM

My question is what are the teams your wagering on with dbl plays

**perryhs** · 01-15-15, 12:10 AM

NCAABB

month not in [3,4] and site streak<=-3 and streak>=3

**perryhs** · 01-15-15, 12:21 AM

NCAABB

month not in [3,4] and p

oints<60 and pp

oints<60 and site streak<=-2 and D and op

oints>60 and opp

oints>60

**perryhs** · 01-15-15, 12:29 AM

NCAABB

month not in [3,4] and p:margin>10 and pp:margin>10 and site streak<=-2 and F

**perryhs** · 01-15-15, 01:07 AM

NCAABB

P:season=season and P:W and PP:season=season and PP:W and P:F and PP:F and F and total<140

**perryhs** · 01-15-15, 01:14 AM

NCAABB

P:season=season-1 and P:W and PP:season=season-1 and PPP:season=season-1 and PPP:W and p

oints<80

**Cutler'sThumb** · 01-15-15, 02:06 PM

There is now a "Query Automation" tab on the spreadsheet that gives a clear run down of what the developer has come up with for Nash13. For anyone who likes the volume angle (see Nash's back tests), I think this tool is a really good value. I'm sure it's not perfect, but it should still be a huge time saver.

**GSoro** · 01-15-15, 04:40 PM

Originally posted by perryhs

NCAABB

P:season=season-1 and P:W and PP:season=season-1 and PPP:season=season-1 and PPP:W and p

oints<80

Appreciate these college queries, could you have the english translation with it as well as you add more in the future? thanks in advance

**FortySix** · 01-15-15, 08:45 PM

So im guessing the regular posters have left the thread these days?

**nash13** · 01-15-15, 10:14 PM

I don't know, maybe the Best Bet thing was not going well enough, or they have better things to do. I will keep updating the spreadsheet and use it as always, all of you are invited to discuss, contribute and criticize.

**perryhs** · 01-16-15, 05:05 AM

NCAABB

game number>20 and tA(line is None)>0.6 and WP>70