A perfect sdql?

[kingdom]

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.

[kingdom]

bad numbers

[asiagambler]

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

I forgot what the win percentage parameter is

[kingdom]

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.

[kingdom]

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

[The Kraken]

Take this to the think tank

[asiagambler]

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

https://sportsdatabase.com/nba/query?output=default&sdql=WP+%3E%3D+0.6+and+line+%3D+4.5&submit=++S+D+Q+L+%21++

[kingdom]

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.

[kingdom]

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?output=default&sdql=A+and+-11+%3C+line+%3C%3D+-10&submit=++S+D+Q+L+%21++

[Otters27]

How hard is this stuff to learn?

[kingdom]

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.

[kingdom]

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?sdql=+team+%3D+Cowboys+and+points+%3E%3D+24&submit=++S+D+Q+L+%21++

[b1slickguy]

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

134-201-13 (-0.12, 40.0%)

avg total: 8.7

over / under: -$8,960 / +$5,596

ROI: -23.1% / +14.8%

2015-2018

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

143-76-6 (1.55, 65.3%)

avg total: 8.7

over / under: +$6,049 / -$8,095

ROI: +24.5% / -32.6%

2017-2019

215-225-22 (0.29, 48.9%)

avg total: 8.9

over / under: -$2,864 / -$829

ROI: -5.6% / -1.6%

[kingdom]

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?sdql=team%3DBroncos+and+p%3AL+and+p%3AF+&submit=++S+D+Q+L+%21++

[kingdom]

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?sdql=team+%3D+Packers+and+o%3Apoints+%3E%3D+17+and+season%3E2015+and+A+and+D&submit=++S+D+Q+L+%21++

[kingdom]

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++

[kingdom]

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

[Snowball]

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.

[mdunlap3]

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.

[kingdom]

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.

[kingdom]

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

https://killersports.com/nfl/query?sdql=+p%3AWAD+and+tA%28rushes%29%3C34+and+oA%28TOP%29%2F60%3E32+and+p%3ATOP%2F60+%3C32+and+o%3AWP%3E25+and+season+%3E%3D+2009+&submit=++S+D+Q+L+%21++

[kingdom]

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?sdql=H+and+surface%3Dgrass+and+PRSW%3E10+and+p%3AWF+and+tA%28points%2CN%3D3%29%3E23.5+and+day%3DSunday+and+date%3E%3D20160000&submit=++S+D+Q+L+%21++

[kingdom]

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/query?output=default&sdql=team%3DORE+and+H+and+p%3Atotal%3C%3D77+and+p%3Aou+margin%3C%3D-3+and+date%3E%3D20071201&submit=++S+D+Q+L+%21++

[kingdom]

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.

[kingdom]

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.

[kingdom]

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.

[kingdom]

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.

[kingdom]

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.

[kingdom]

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

https://sportsdatabase.com/ncaafb/query?output=default&sdql=tA%28passing+yards%29+%3E+350+and+D+and+month%21%3D9&submit=++S+D+Q+L+%21++

[b1slickguy]

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.

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.

[kingdom]

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.

[kingdom]

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.

[kingdom]

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/query?sdql=t%3Ateam%3DFRES+and+A+and+date%3E%3D20161205&submit=++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/query?sdql=t%3Ateam%3DTOL+and+-30+%3C+line+%3C+-10+and+date%3E%3D20151117&submit=++S+D+Q+L+%21++

[kingdom]

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/query?sdql=t%3Ateam%3DTOL+and+-30+%3C+line+%3C+-10+and+date%3E%3D20151117&submit=++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/query?sdql=t%3Ateam%3DHOU+and+D+and+date%3E%3D20121018&submit=++S+D+Q+L+%21++

[kingdom]

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.