1. #2836
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

  2. #2837
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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




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

  3. #2838
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

    pop:ats margin>20 and p:WA


    pop:ats margin<-20 and p:LH

  4. #2839
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    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)

  5. #2840
    hobbs4
    hobbs4's Avatar Become A Pro!
    Join Date: 09-22-10
    Posts: 93
    Betpoints: 382

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

  6. #2841
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

  7. #2842
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

    p:field goals made > po:field goals made and po:offensive rebounds > p:offensive rebounds+10 and p:U

  8. #2843
    pip2
    pip2's Avatar Become A Pro!
    Join Date: 10-21-12
    Posts: 543
    Betpoints: 3403

    Quote Originally Posted by Consigliere View Post
    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...
    Last edited by pip2; 01-13-15 at 08:59 AM.

  9. #2844
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    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

  10. #2845
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

  11. #2846
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

    p:field goals made > po:field goals made+5 and p:offensive rebounds > po:defensive rebounds and p:total is not None

  12. #2847
    dmitean
    dmitean's Avatar Become A Pro!
    Join Date: 03-30-11
    Posts: 364
    Betpoints: 3106

    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!

  13. #2848
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7166

    Quote Originally Posted by dmitean View Post
    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.

  14. #2849
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

  15. #2850
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

    p:dps > op:dps+20 and p:line > op:line+20 and p:overtime = op:overtime=0

  16. #2851
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

  17. #2852
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

  18. #2853
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

  19. #2854
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

    or

    po:steals/p:turnovers<0.1 and F

  20. #2855
    zxc
    zxc's Avatar Become A Pro!
    Join Date: 11-15-12
    Posts: 41
    Betpoints: 2589

    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.

  21. #2856
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7166

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

  22. #2857
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7166

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

  23. #2858
    CONNEMARA
    CONNEMARA's Avatar Become A Pro!
    Join Date: 04-08-10
    Posts: 115
    Betpoints: 613

    what are the dbl plays in English please

  24. #2859
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7166

    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.

  25. #2860
    CONNEMARA
    CONNEMARA's Avatar Become A Pro!
    Join Date: 04-08-10
    Posts: 115
    Betpoints: 613

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

  26. #2861
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

  27. #2862
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

    month not in [3,4] and p:points<60 and pp:points<60 and site streak<=-2 and D and op:points>60 and opp:points>60

  28. #2863
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

  29. #2864
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    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

  30. #2865
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB


    P:season=season-1 and P:W and PP:season=season-1 and PPP:season=season-1 and PPP:W and p:points<80

  31. #2866
    Cutler'sThumb
    Update your status
    Cutler'sThumb's Avatar Become A Pro!
    Join Date: 12-06-11
    Posts: 287
    Betpoints: 2862

    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.

  32. #2867
    GSoro
    GSoro's Avatar Become A Pro!
    Join Date: 02-26-14
    Posts: 87
    Betpoints: 802

    Quote Originally Posted by perryhs View Post
    NCAABB


    P:season=season-1 and P:W and PP:season=season-1 and PPP:season=season-1 and PPP:W and points<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

  33. #2868
    FortySix
    FortySix's Avatar Become A Pro!
    Join Date: 02-18-14
    Posts: 134
    Betpoints: 2308

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

  34. #2869
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7166

    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.

  35. #2870
    perryhs
    perryhs's Avatar Become A Pro!
    Join Date: 01-07-15
    Posts: 68
    Betpoints: 306

    NCAABB

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

First ... 79808182838485 ... Last
Top