1. #1
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    A perfect sdql?

    So, i'm watching an nfl game on my tv and redzone on my pc and decided to fire up old pc to use during game.
    starting looking at bookmarks and old sdql queries. i like to punch in different combos looking for consistent winners.




    Last edited by kingdom; 10-04-19 at 01:44 AM.

  2. #2
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    bad numbers
    Last edited by kingdom; 09-30-19 at 09:57 PM.

  3. #3
    asiagambler
    asiagambler's Avatar SBR PRO
    Join Date: 07-23-17
    Posts: 6,372
    Betpoints: 30436

    Looks like it's just defaulting to W and line = 4.5

    I forgot what the win percentage parameter is

  4. #4
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by asiagambler View Post
    Looks like it's just defaulting to W and line = 4.5

    I forgot what the win percentage parameter is
    thanks man. i knew i had an error somewhere lol. i shoulda just had the 60% in there. duh.

  5. #5
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    if anyone knows how to search win %60 and that line appreciate any help in successful query

  6. #6
    The Kraken
    The Kraken's Avatar Become A Pro!
    Join Date: 12-24-11
    Posts: 28,917
    Betpoints: 532

    Take this to the think tank

  7. #7
    asiagambler
    asiagambler's Avatar SBR PRO
    Join Date: 07-23-17
    Posts: 6,372
    Betpoints: 30436

    Found it, it's just WP so WP >= 0.6 and line = 4.5

    https://sportsdatabase.com/nba/query...+S+D+Q+L+%21++

  8. #8
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by asiagambler View Post
    Found it, it's just WP so WP >= 0.6 and line = 4.5

    https://sportsdatabase.com/nba/query...+S+D+Q+L+%21++

    thanks man.

  9. #9
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    well this one's 57%. not a ton of opportunities, but looking for more in this range. have to check the months but seems to do well later in season.

    https://sportsdatabase.com/nba/query...+S+D+Q+L+%21++

  10. #10
    Otters27
    Otters27's Avatar SBR PRO
    Join Date: 07-14-07
    Posts: 30,688
    Betpoints: 410

    How hard is this stuff to learn?

  11. #11
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by Otters27 View Post
    How hard is this stuff to learn?
    i obviously don't know yet. tedious as hell. wish i could find some proven ones. but for system and progressive betting its good stuff.

  12. #12
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    cowboys pretty amazing when they score 24 pts. 74% ats. even better when on road at like 80 or so. here is overall:

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++

  13. #13
    b1slickguy
    WDKYWMYAK
    b1slickguy's Avatar SBR PRO
    Join Date: 11-24-11
    Posts: 11,094
    Betpoints: 29800

    Quote Originally Posted by Otters27 View Post
    How hard is this stuff to learn?
    Not too difficult to learn, but creating meaningful winning queries is a bit of a task. I've been using it for about a decade and only end up with a handful of queries for each sport every year that have a large enough sample size and have meaningful parameters. MLB and NBA are where I've had my best success over the years. Check out the SDQL manuals for each sport on the Killersports homepage along with the Daily Reports to see queries with English translations to familiarize yourself with the parameters and how they can be used. I really prefer queries that produce several plays per week in the daily sports like MLB and NBA and show a positive ROI for at least a few seasons.

    My best MLB O/U query (playing the under) performed even better in 2019 than the previous 4 seasons, while a few performed about break even and a few others fell off and showed negative results.

    2019

    OU: 134-201-13 (-0.12, 40.0%) avg total: 8.7 over / under: -$8,960 / +$5,596 ROI: -23.1% / +14.8%

    2015-2018

    OU: 572-751-72 (0.03, 43.2%) avg total: 8.1 over / under: -$25,438 / +$13,230 ROI: -16.4% / +8.7%


    I've also had queries have crazy runs and then completely fall apart.

    2014-2016

    OU: 143-76-6 (1.55, 65.3%) avg total: 8.7 over / under: +$6,049 / -$8,095 ROI: +24.5% / -32.6%

    2017-2019

    OU: 215-225-22 (0.29, 48.9%) avg total: 8.9 over / under: -$2,864 / -$829 ROI: -5.6% / -1.6%
    Last edited by b1slickguy; 09-30-19 at 11:15 PM.

  14. #14
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    i like current trends. broncos after a loss as a favorite post Peyton Manning the o/u is 0-12

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++

  15. #15
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    focusing on cowboys and packers: since dak prescott became qb cowboys are 19-2 su at home and 15-4-2 ats when holding teams under 24 pts.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++

    pack are 2-13 su when giving up 17+ on road in same time frame. both wins have come against the cowboys. interesting to see if pack can buck trend agains against the boys.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++

  16. #16
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    home dogs of 8+ are 3-22 o/u since start of 2017 season. redskins in play this week. pats defense excellent. 2-14 last 16 ats as well.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++

  17. #17
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    based on the trend data this week, plays are pats under, denver under, and cowboys.

  18. #18
    Snowball
    Snowball's Avatar SBR PRO
    Join Date: 11-15-09
    Posts: 30,021
    Betpoints: 3780

    SQDL methods only work if you bet them without regard over and over again
    otherwise there's not enough sample set to manifest the trend in real account money.

  19. #19
    mdunlap3
    mdunlap3's Avatar Become A Pro!
    Join Date: 02-18-13
    Posts: 1,847
    Betpoints: 4843

    A perfect query is one that has an equally strong case from both a theoretical and empirical perspective. A perfect query has produced a strong ROI over a large sampling of observations.

  20. #20
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by Snowball View Post
    SQDL methods only work if you bet them without regard over and over again
    otherwise there's not enough sample set to manifest the trend in real account money.
    truth. some bet trends and others don't. thread title isn't relevant to this, i just didn't want to make another thread. the methods also work with progressive betting as well.

  21. #21
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    this is a trend that has won 16 in a row ats and titans and browns qualify this week.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++

  22. #22
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    gonna put this play in a tease. trend is 0-20 ats since 2016 and favors the colts. i like the colts anyway. just curious how trend holds up against chiefs.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++

  23. #23
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    oregon was 23-0 o/u at home after not going over by 3 or more since 08 season. last week trend was broken as they went under. same trend applies this week. this has been one of oregon's better defenses. for a team that is normally over 70 percent over at home last ten years, things may be different this year.

    https://sportsdatabase.com/ncaafb/qu...+S+D+Q+L+%21++

  24. #24
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by kingdom View Post
    i like current trends. broncos after a loss as a favorite post Peyton Manning the o/u is 0-12

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++
    broncos were an easy under against the chargers.

  25. #25
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by kingdom View Post
    focusing on cowboys and packers: since dak prescott became qb cowboys are 19-2 su at home and 15-4-2 ats when holding teams under 24 pts.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++

    pack are 2-13 su when giving up 17+ on road in same time frame. both wins have come against the cowboys. interesting to see if pack can buck trend agains against the boys.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++
    pack buck the trend again as rodgers is the boogeyman against the cowboys. they fear the green.

  26. #26
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by kingdom View Post
    home dogs of 8+ are 3-22 o/u since start of 2017 season. redskins in play this week. pats defense excellent. 2-14 last 16 ats as well.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++
    under and cover for pats as trend continued.

  27. #27
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by kingdom View Post
    this is a trend that has won 16 in a row ats and titans and browns qualify this week.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++
    titans and browns were both terrible with tennessee missing a bunch of kicks.

  28. #28
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by kingdom View Post
    gonna put this play in a tease. trend is 0-20 ats since 2016 and favors the colts. i like the colts anyway. just curious how trend holds up against chiefs.

    https://killersports.com/nfl/query?s...+S+D+Q+L+%21++
    trend continues as colts not only get the cover, but the su win as well.

  29. #29
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    last week purdue covered by the hook. this week arizona and hawaii are in play as fades.

    https://sportsdatabase.com/ncaafb/qu...+S+D+Q+L+%21++

  30. #30
    b1slickguy
    WDKYWMYAK
    b1slickguy's Avatar SBR PRO
    Join Date: 11-24-11
    Posts: 11,094
    Betpoints: 29800

    Quote Originally Posted by Snowball View Post
    SQDL methods only work if you bet them without regard over and over again
    otherwise there's not enough sample set to manifest the trend in real account money.
    Quote Originally Posted by mdunlap3 View Post
    A perfect query is one that has an equally strong case from both a theoretical and empirical perspective. A perfect query has produced a strong ROI over a large sampling of observations.
    Both of these are very true and imperative. You have to completely commit to playing every instance and keep your sizing either flat or a % of BR. Straying from any of these will result in inevitable failure. Creating queries with a limited number of meaningful parameters is paramount. Watering queries down with too many parameters will only skew the results away from the objective of the original base idea.

  31. #31
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Quote Originally Posted by b1slickguy View Post
    Both of these are very true and imperative. You have to completely commit to playing every instance and keep your sizing either flat or a % of BR. Straying from any of these will result in inevitable failure. Creating queries with a limited number of meaningful parameters is paramount. Watering queries down with too many parameters will only skew the results away from the objective of the original base idea.
    and we will see the results after the event. like a said earlier, if you don't prefer riding a trend thats up to you. if you pay attention you will see i look for situations that have multiple occurrences in a season, therefore they can't be too watered down with parameters. like the cowboys and jets this week fits redskins and pats last week. that is a positive trend for the favorite and the under. i look for recency as it applies to current players and coaching. i don't believe you have to play every instance. quite the opposite as if you incorporate it into your capping of games you favor. nothing guarantees a win, but if i prefer a matchup and a sdql trend that matches it, i will look deeper into it. oregon tonight is a perfect situation. this year's personnel is different as they are extremely strong on the defensive side. it is an interesting trend with them going over, but tonight is a game i wasnt comfortable with despite colorado's weak defense as oregon may completely shut them down.

  32. #32
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    another instance is the steelers are 8-2 last ten as away dog. chargers are 2-7-1 last ten as a home fav. most football bettors have a good idea of how sd performs as a home fav. of course this doesn't guarantee a steelers cover, especially since majority of those were with big ben. but getting pitt in that situation getting 7 is favorable. over the past 3 seasons, chargers are 7-13-1 as a fav for 35%W and 65% L.

  33. #33
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Some saturday ncaa trends: Fresno is strong on the road going 12-3-1 ats since the start of '17 and 3-12-1 o/u.

    https://killersports.com/ncaafb/quer...+S+D+Q+L+%21++

    toledo in a fade of BGU who is 3-17 ats at home in their last 20. Toledo is 8-2 last ten ats as double digit fav.

    https://killersports.com/ncaafb/quer...+S+D+Q+L+%21++

  34. #34
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    Mizzou defense has been solid. they have gone 11-1 in last 12 home games and 10-2 ats and holding teams under an avg of 14 pts in those games. ole miss coming off a bad offensive week. the last 15 games mizzou has face a team gaining less than 300yds in previous game, the under is 0-14-1. expecting mizzou to cover and hold ole miss under today:

    https://killersports.com/ncaafb/quer...+S+D+Q+L+%21++

    Houston has been a solid dog with a 16-6-1 current run including 3 of 4 covers this season.

    https://killersports.com/ncaafb/quer...+S+D+Q+L+%21++

  35. #35
    kingdom
    kingdom's Avatar SBR PRO
    Join Date: 07-25-10
    Posts: 10,093
    Betpoints: 1957

    usc is 1-10 ats as a road dog their last 11. going up to notre dame is a tough spot for a road dog.

    notre dame is 6-0 su and 5-1 ats as a home fav since Book took over as starter.

    purdue is 3-27 su and 7-23 ats as a home dog in last 30 only avg 22ppg.

    maryland is 7-2 su and ats as a fav since start of last season.

12 Last
Top