Originally Posted by
Mako-SBR
New one, no play with it today but it passes the tests for consistency over the years, Z-value (win % + volume), good ATS margin, and decent logic:
HF and WP>=72 and game number>=25 and p: LF and line<=-9.5 and total>=187.5
I'll explain a bit more about how it came about for those still learning "why" we choose to pair up certain filters but not others when tinkering with queries.
The logic is that you're playing the elite team (72+ win % on the season) who is a heavy home fav (laying 9.5 points minimum) after the team just lost their last game also as the fav (home or away). There are tons of 'bounce back' queries and scenarios in the NBA, some work, some don't, and when you chase them in SDQL you need to be patient because it can take time to put the puzzle together properly while filtering out the noise.
For this particular one it's later in the season to make sure we're not betting in November on some fluke pretender that had a lucky hot start (doesn't begin until 25 games in or more), and since we need a shit-ton of scoring from the fav to cover that massive line we're eliminating any game where the total is below 187.5 (gets rid of some mediocre heavy dog opponents that actually show up defensively for 'big' games and lock down the fav's scoring versus the norm).
It works inside or outside of division or conference games (a lot of systems break down if a game is, or is not, a well-known division opponent, always screen for that when you feel you've found a winning query), and it allows the comfort of being a true square (you're on the same elite marquee home that the rest of the clueless public is).
That's it, pretty simple. It's not perfect but it's an example of what you're chasing with SDQL, something that only has excess filters if each of the filters fit (mostly) within the logic of the play, and something that can be applied in most circumstances within said logic.