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

    just to inform you all, i will join the trend market and will offer the trends i found on my own, none of your trends will be included. the trends i found will be featured in the spreadsheet too, the trend market has more value to the people not so familliar with SDQL in my opinion.
    Last edited by nash13; 02-05-15 at 09:32 AM.

  2. #3047
    hyahya
    hyahya's Avatar Become A Pro!
    Join Date: 03-08-14
    Posts: 165

    Quote Originally Posted by pip2 View Post
    season >= 2009 and (tA(FGA) + tA(TO) + tA(FTA) * .44 - tA(offensive rebounds)) - 5 > (tA(FGA,N=2) + tA(TO,N=2) + tA(FTA,N=2) * .44 - tA(offensive rebounds,N=2)) and (oA(FGA) + oA(TO) + oA(FTA) * .44 - oA(offensive rebounds)) - 5 > (oA(FGA,N=2) + oA(TO,N=2) + oA(FTA,N=2) * .44 - oA(offensive rebounds,N=2))

    Got the above to go through --


    SU: 102-102 (0.00, 50.0%)
    ATS: 99-99-6 (0.00, 50.0%) avg line: 0.0
    O/U: 82-122-0 (-4.26, 40.2%) avg total: 192.9
    Add H to remove duplicates and add playoffs=0 and things get even rosier. Always knew it tended to be more of a half court game in the playoffs but pretty cool seeing it quantified.

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

    Quote Originally Posted by nash13 View Post
    just to inform you all, i will join the trend market and will offer the trends i found on my own, none of your trends will be included. the trends i found will be featured in the spreadsheet too, the trend market has more value to the people not so familliar with SDQL in my opinion.
    What's trend market?

  4. #3049
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by nash13 View Post
    just to inform you all, i will join the trend market and will offer the trends i found on my own, none of your trends will be included. the trends i found will be featured in the spreadsheet too, the trend market has more value to the people not so familliar with SDQL in my opinion.
    ya, I will be on there too, but then again I use all their services.

  5. #3050
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742

    Quote Originally Posted by dmitean View Post
    What's trend market?

    KS database set up a trend market where one can buy/sell trend sets.

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

    Quote Originally Posted by hyahya View Post
    Add H to remove duplicates and add playoffs=0 and things get even rosier. Always knew it tended to be more of a half court game in the playoffs but pretty cool seeing it quantified.
    Thanks hyahya!

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

    Hey Nash, check out NBA 72. It's designated as an ATS trend, but it actually does a bit better as an Over trend (after a 2-10 start ATS this season). Do you want to add it again designated as a over trend so the Analyzer sees it both ways (I think that's how it works)?

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

    i will take a look at it right now.

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

    tA(P4) -5 > oA(P4) and game number >= 10
    is 127-113 on totals. that is not valid enough for me.

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

    i think you mean Nba73

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

    and 73 and 125 are dividing the trend in under and ats bets

  12. #3057
    emceeaye
    emceeaye's Avatar Become A Pro!
    Join Date: 08-20-13
    Posts: 704
    Betpoints: 2709

    Quote Originally Posted by pip2 View Post
    season >= 2009 and (tA(FGA) + tA(TO) + tA(FTA) * .44 - tA(offensive rebounds)) - 5 > (tA(FGA,N=2) + tA(TO,N=2) + tA(FTA,N=2) * .44 - tA(offensive rebounds,N=2)) and (oA(FGA) + oA(TO) + oA(FTA) * .44 - oA(offensive rebounds)) - 5 > (oA(FGA,N=2) + oA(TO,N=2) + oA(FTA,N=2) * .44 - oA(offensive rebounds,N=2))

    Got the above to go through --


    SU: 102-102 (0.00, 50.0%)
    ATS: 99-99-6 (0.00, 50.0%) avg line: 0.0
    O/U: 82-122-0 (-4.26, 40.2%) avg total: 192.9
    excellent job pip2 and hyahya

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

    Quote Originally Posted by nash13 View Post
    i think you mean Nba73
    Yep, it was 73. Glad it was already accounted for!
    (I must really have been distracted to get the wrong trend # and call it an Over trend instead of an Under, but you obviously figured out what I meant)
    Last edited by Cutler'sThumb; 02-06-15 at 09:56 AM.

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

    It was a great day for the system yesterday. If only the wizards would have covered, the profit would have been off the charts.
    +21 units since I started tracking with the program
    and that's in one week

  15. #3060
    palms
    palms's Avatar Become A Pro!
    Join Date: 01-21-10
    Posts: 6
    Betpoints: 192

    Quote Originally Posted by nash13 View Post
    It was a great day for the system yesterday. If only the wizards would have covered, the profit would have been off the charts.
    +21 units since I started tracking with the program
    and that's in one week
    Great work Nash. I'm trying to get up to speed and trying out different trends that I think may work. I hope to contribute to this thread soon. Could I get access to the spreadsheet to get some more ideas?

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

    i need your gmail account to connect it to the spreadsheet. you need min of 50 posts, after that you can message me.

  17. #3062
    JMon
    I'd be a lot cooler if you did.
    JMon's Avatar Become A Pro!
    Join Date: 12-11-09
    Posts: 9,800
    Betpoints: 10742


  18. #3063
    chopperocker
    Hang on baby, cuz life's a BITCH!!!
    chopperocker's Avatar Become A Pro!
    Join Date: 08-16-09
    Posts: 1,784
    Betpoints: 55608

    how do I transcribe this in sdql?, "halftime margin of negative 6 to negative 10". thanx in advance!

  19. #3064
    emceeaye
    emceeaye's Avatar Become A Pro!
    Join Date: 08-20-13
    Posts: 704
    Betpoints: 2709

    Quote Originally Posted by chopperocker View Post
    how do I transcribe this in sdql?, "halftime margin of negative 6 to negative 10". thanx in advance!
    -10<=margin at the half<=-6

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

    Action on the Bulls/Pelicans tonight. 3,13,21,81,189 all have Bulls -2. My Bulls are a mess right now but hopefully they snap out of it long enough to slow down The Brow.
    97,211,215 are also on Over 196.5 for this game.

  21. #3066
    TheLineShifter
    TheLineShifter's Avatar Become A Pro!
    Join Date: 12-10-14
    Posts: 9
    Betpoints: 336

    Bulls devastated Pelicans with a 35-point lead

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

    Not exactly. Game was tied 35 - 35 when Davis, best player in the league this season got hurt, left the game and didn't come back. Not saying Pelicans would have won with him, but you can't ignore that as well...

  23. #3068
    TheLineShifter
    TheLineShifter's Avatar Become A Pro!
    Join Date: 12-10-14
    Posts: 9
    Betpoints: 336

    So the question is, let's assume that Anthony was announced not to be playing for the game before it started, would the line have been -35 then ?

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

    No, but would it change the queries that fit? I won't check them each now, but maybe we would have seen queries supporting Pelicans or one two queries would have fallen off from those that fit the Bulls?

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

    Every day, for maybe a a month and a half or so, I have been running a program to go through the Nash google sheet as well as my own compilation of queries, looking for the active ones for that day. At the end of the day I mark the queries as having won or lost, and store them off in a spreadsheet.

    So far I have stored off around 520 queries/results, and around 201 of them were winners and 320 were losers. I am still engaged in looking for patterns and trying to determine the best way to weed out the bad queries from the good ones.

    But what seems kind of striking to me at this point is that 520 is a pretty large sample size. The question I have started asking is, how big a sample size would I need of this, before I could be confident in keeping all the queries I have, just as they are, and then simply fading them rather than playing them? I don't think 520 is a big enough sample size to justify doing so, but what sample size would justify it? 1000? 5000? 10,000?

    If I stored off 1,000 of these query results, and they were still losing at a 60% clip, would that sample size justify simply fading them?
    Last edited by pip2; 02-08-15 at 09:46 AM.

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

    Quote Originally Posted by pip2 View Post
    Every day, for maybe a a month and a half or so, I have been running a program to go through the Nash google sheet as well as my own compilation of queries, looking for the active ones for that day. At the end of the day I mark the queries as having won or lost, and store them off in a spreadsheet.

    So far I have stored off around 520 queries/results, and around 201 of them were winners and 320 were losers. I am still engaged in looking for patterns and trying to determine the best way to weed out the bad queries from the good ones.

    But what seems kind of striking to me at this point is that 520 is a pretty large sample size. The question I have started asking is, how big a sample size would I need of this, before I could be confident in keeping all the queries I have, just as they are, and then simply fading them rather than playing them? I don't think 520 is a big enough sample size to justify doing so, but what sample size would justify it? 1000? 5000? 10,000?

    If I stored off 1,000 of these query results, and they were still losing at a 60% clip, would that sample size justify simply fading them?
    I'm doing a somewhat similar thing. First, I'm backtesting all the trends on the spreadsheet for 4+ seasons ('14 YTD, '13,'12,'08,'06). I'm only thru the first 100 trends, but that backtest shows really good results (60%+) for all the previous full seasons, but '14 is only 523-495 so far. I'm keeping a running list of trends that seem to obviously be weak, and I will use this growing list to filter my plays going forward. I'll be curious to see if the numbers stay flat for '14 as I work my way thru the remaining 2/3 of the trends. It seems statistically unlikely, but Nash13 may be right to look very suspiciously at how the trends project into the future.

    In the meantime, I've been using the analyzer software to play all non-conflicting trends with small units. This should theoretically be better than the raw backtest, because many conflicting plays are eliminated. Since 1/27 those trends have gone 99-114 (was actually doing OK until the last two days, which have gone 11-34).

    NHL has been considerably better, going 79-56, +18.5 units since 1/27. I did a 3 season backtest there that was also positive, but I didn't do '14 YTD, which I will probably do once I finish with NBA. It takes a significant time commitment to comb thru each season for each trend, so I'm just plugging away as time allows.
    *I've liked the NHL more all along, as my overall impression of the NBA trends is that we may have too many smaller trends, which allows for more volatility.
    Last edited by Cutler'sThumb; 02-08-15 at 10:40 AM.

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

    Quote Originally Posted by Cutler'sThumb View Post
    I'm doing a somewhat similar thing. First, I'm backtesting all the trends on the spreadsheet for 4+ seasons ('14 YTD, '13,'12,'08,'06). I'm only thru the first 100 trends, but that backtest shows really good results (60%+) for all the previous full seasons, but '14 is only 523-495 so far. I'm keeping a running list of trends that seem to obviously be weak, and I will use this growing list to filter my plays going forward. I'll be curious to see if the numbers stay flat for '14 as I work my way thru the remaining 2/3 of the trends. It seems statistically unlikely, but Nash13 may be right to look very suspiciously at how the trends project into the future.

    In the meantime, I've been using the analyzer software to play all non-conflicting trends with small units. This should theoretically be better than the raw backtest, because many conflicting plays are eliminated. Since 1/27 those trends have gone 99-114 (was actually doing OK until the last two days, which have gone 11-34).

    NHL has been considerably better, going 79-56, +18.5 units since 1/27. I did a 3 season backtest there that was also positive, but I didn't do '14 YTD, which I will probably do once I finish with NBA. It takes a significant time commitment to comb thru each season for each trend, so I'm just plugging away as time allows.
    *I've liked the NHL more all along, as my overall impression of the NBA trends is that we may have too many smaller trends, which allows for more volatility.
    One impression I get from reading down my saved list of results, is that in one of those days, say, when there are 10 winners and 15 losers, or maybe even 20 losers and 5 winners, there are some names frequently associated with those rare winning queries: Nash, Hiyahya, and Jmon. Their names might be associated with other winners that are simply labeled as "NBAXX" as well.

    It isn't that simple, because they have a lot of queries in general, so they also have some losing queries associated with their names, but I wonder if I might also fix my query libraries by just weeding out everything that wasn't approved/assembled by one of those guys...

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

    i 100% aggree with both posts above. just as in other terms they would say: "it is not about what you have done in the past, it is about what you can do in th future."
    so there is no point in finding a 70% ATS trend which will go forward 50/50 or even worse from now on.
    major point: what can we do about it?
    i see the trend sheet as a pool. not every trend is good or value, some are overfitted other are just sound. i declare statistical and logical criteria and after that i take all things together with things the queries don't show. and then i play the games.
    so far i am YTD up 40 units. if that stays like this, i am ok. as long as i am not loosing money everything is fine.

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

    Quote Originally Posted by nash13 View Post
    i 100% aggree with both posts above. just as in other terms they would say: "it is not about what you have done in the past, it is about what you can do in th future."
    so there is no point in finding a 70% ATS trend which will go forward 50/50 or even worse from now on.
    major point: what can we do about it?
    i see the trend sheet as a pool. not every trend is good or value, some are overfitted other are just sound. i declare statistical and logical criteria and after that i take all things together with things the queries don't show. and then i play the games.
    so far i am YTD up 40 units. if that stays like this, i am ok. as long as i am not loosing money everything is fine.
    I agree with you but along with being fine if I make money, I am perfectly fine if the queries I currently have can consistently lose at a 60% rate, because for me that isn't materially different than winning 60% consistently. My problem is that I am not sure of how big a sample size I need to have in order to declare that the 60% rate is consistent enough to bet on..

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

    Quote Originally Posted by pip2 View Post
    I agree with you but along with being fine if I make money, I am perfectly fine if the queries I currently have can consistently lose at a 60% rate, because for me that isn't materially different than winning 60% consistently. My problem is that I am not sure of how big a sample size I need to have in order to declare that the 60% rate is consistent enough to bet on..
    I can't agree with you here.
    If query is good, that means that the logic behind it was correct and it brings profit.
    If query is bad, it just means that the logic didn't prove itself and that the query shouldn't be relied on, but it doesn't mean the opposite, so even if in the short run fading it should be good, I wouldn't be as sure about it in the long run, as I would be about a query that is good to begin with.

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

    Quote Originally Posted by dmitean View Post
    I can't agree with you here.
    If query is good, that means that the logic behind it was correct and it brings profit.
    If query is bad, it just means that the logic didn't prove itself and that the query shouldn't be relied on, but it doesn't mean the opposite, so even if in the short run fading it should be good, I wouldn't be as sure about it in the long run, as I would be about a query that is good to begin with.
    How about if you had 100,000 query results saved and 60,000 of them lost over the past couple of years? Wouldn't you feel confident about fading them? I would. But what I am wondering is where is the number between 100,000 and 500 where there isn't much of a chance that the 60% figure is just variance?

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

    I don't know.
    For example, if I assume that good rebounding team does good against bad rebounding team, if it comes off a loss where they lost the rebounds battle (just an example of course) and I see that numbers support me and I use it, what changed in the league, that suddenly it should just stop working?

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

    I'm playing with numbers trying to quantify why the overall numbers this year are so different from past years. Thru the first 100 trends, I have a total record of 553-532, 51.34%. I'm sure there would be many conflicting plays if we looked at each day and the win rate would go up, but this win % is still a significant departure from past seasons.
    One of my suspicions is that the smaller trends are hurting the number. Small sample size from the past means it is much easier/more likely for a trend to experience a correction to the mean (especially if the trend is overfitted). So I decided to eliminate all trends that had samples less than 150 going into the season. This eliminated 65 of the first 100 trends. I then added in three other trends from my working list of trends that were on my "weak" list (I had 11 others, but they were in the 65 I already eliminated). This took the record to 248-205, 54.75%.
    I'll keep working on the backtest, but I think there may be an important lesson here: beware small trends. They can be good, but they can also turn quickly, which can be hard to catch when we're dealing with this many trends.

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

    OK, so here are my picks/units for today, fading today's queries:

    mil/bkn O 2 units
    atl L 2 units
    mia L 1 unit
    ut O 1 unit
    ut L 2 units
    ind W 8 units
    phi L 2 units
    phi U 1 unit
    sa U 1 unit
    okc W 2 units
    okc U 2 units

    Let's see how this goes...last night my query library went 6-16, which is actually 16-6 if you are fading them.

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

    Quote Originally Posted by Cutler'sThumb View Post
    I'm playing with numbers trying to quantify why the overall numbers this year are so different from past years. Thru the first 100 trends, I have a total record of 553-532, 51.34%. I'm sure there would be many conflicting plays if we looked at each day and the win rate would go up, but this win % is still a significant departure from past seasons.
    One of my suspicions is that the smaller trends are hurting the number. Small sample size from the past means it is much easier/more likely for a trend to experience a correction to the mean (especially if the trend is overfitted). So I decided to eliminate all trends that had samples less than 150 going into the season. This eliminated 65 of the first 100 trends. I then added in three other trends from my working list of trends that were on my "weak" list (I had 11 others, but they were in the 65 I already eliminated). This took the record to 248-205, 54.75%.
    I'll keep working on the backtest, but I think there may be an important lesson here: beware small trends. They can be good, but they can also turn quickly, which can be hard to catch when we're dealing with this many trends.
    Nice work Cutler. One thing I have come to believe about the sample size is that it might be good to not consider it by itself, but as a function of time. For example, two queries could have the same sample size of 200, but one goes back 20 years to get that 200, while the other goes back 2 years to get the 200. So the sample sizes are not really the same. Are you factoring that into deciding which queries to eliminate?

First ... 85868788899091 ... Last
Top