NBA Stituational Bet, SDQL

Originally Posted by JMon

So it's my understanding some are back testing every single query as a whole- to see how they perform if one played every query? Is that right? Or am I misunderstanding what's going on? If that is the case, that is foolish and a complete waste of time. Not everything is black or white, nor can be statistically proven or hold logic. Logic..give me a fukkin break..square fukks. You are fool if you think otherwise. Some speak of small samples....I will take on anyone here in a contest using small samples/current year queries to those that claim bigger samples are better.

Sdql comes with experience and learning the hard way. Not scrapping, not copying and pasting, not using someone else's thoughts/queries and trying to make money off it. It's about learning the hard way through trial and error. There are around 4-6 contributors to this thread that should even have a say. The rest are piggy backers and you know who are are.

You sound really pissed. But you make top notch queries and probably good money as well, so it's not clear why you would be so pissed off. If people aren't doing it the way you do it, they will probably pay the price in terms of losing money, so they will suffer all you could want. And if they don't lose money, then maybe there is more than 1 way to do it. Who cares, either way?

Not so much pissed off, but the truth, eh?

mil/bkn O 2 units -- +2
atl L 2 units -- -2
mia L 1 unit -1
ut O 1 unit -- +1
ut L 2 units -- -2
ind W 8 units -- +8
phi L 2 units -2
phi U 1 unit -- +1
sa U 1 unit -- +1
okc W 2 units -- +2
okc U 2 units -- -2
___________________
total +6

My Inbox was full, if anyone was trying to write me messages, now I cleared it.
Just a heads up report for the tracking starting 29/01/15.
NHL: 45-30-4
+49 units profit (on variable staking)
28% Yield

NBA:
59-56-1
-29 units profit (on variable staking)
-11% Yield

NCAAB:
81-74-3
+5 units profit (on variable staking)
3% yield

So i think JMon has a point and is spot on with his observations that blindly playing picks is not the way to go, as far as for NBA with its large possibilities. NHL seems to be a different story. My main field of expertise was MLB so far, so I am not sure how my observations form there might transfer to other sports. MLB is working in circles and has monthly awesome working queries. Year in year out. NBA and NFL are the sports i can not figure out yet.

The discussions here going a bit out of hand, which was never my purpose to do this in the first place.

Originally Posted by JMon

Not so much pissed off, but the truth, eh?

I'll freely admit that I'm nowhere near the expert level of many of the guys on this thread with regards to constructing my own queries. As JMon correctly states, it takes years of hard work to really be good at that, and I only discovered SDQL 3 months ago. The concept of trends and SDQL appealed greatly to the way I approach this game, and I'm sure I'll pick up the whole package in due time. In the meantime, however, I joined the group just as there was a massive amount of info being uploaded, and I've spent a lot of time trying to work out the best possible way to use all that info. JMon, you obviously have a successful system down, so feel free to ignore my efforts. If I crash and burn trying it my way, it'll just be an expensive lesson.

It may well be a waste of time to back test all the trends, but doing it has allowed me to familiarize myself with the language and see how individual trends behave over time, and which ones have flat lined recently and should be put on the bench. The NBA is still a work in progress (still over 1/2 of the trends to work thru), but I've completed this process in the NHL, and have seen great results (thanks Oilers!). I don't play every trend, but rather the trends that fit my filter and are not opposed by a valid trend on the other side. I'm sure this could get even better if I knew each trend inside and out and took the time to cap each trend for each game, but I just don't have the skill (or the time) to do that at this point.

JMon, your smaller trends are absolutely golden, but imho this simply isn't the case with some of the other smallish trends that have really been massaged. I look at it from a statistical standpoint (it was a many years ago, but I lived and breathed the scientific method for a long time, and I did take statistics along the way): the smaller the sample size, the more volatility there is likely to be. This is statistics 101, doesn't matter if we're talking about what % of dogs like to eat their own poop or if the Nuggets are going crap the bed (again). That doesn't mean small trends should be shunned, it just means they should probably be looked at with a little more caution. I actually won the largest bet I've ever made last month based on a trend with a sample size less than 40, but the situation was perfect. I knew about it from before I found SDQL and had actually PMed you asking about a start time filter, as I was trying to come up with the correct query for it. Anyway, sorry if I got your dander up with my posts.

Uh i'm not sure who his hectoring was targeted to. It has all the makings of a drunken rant so hopefully we can chalk it up to that and move on.

I've started filtering my NBA queries by filtering on current Day, Month, Season, rest, and o:rest and over the past week the queries aren't hitting. I only started with a subset of the queries in the spreadsheet since I think a lot of them were "forced" queries and use only the ones that make sense to me why they would hold an advantage. If the books adjusted I don't think they would over adjust to the point where fading the picks would be profitable.

Fading the pip query library:

mem beats bkn 1
cha/det U 1
lal/den U 3
den beats lal 3
phx beats hou 1

Originally Posted by Heart

Uh i'm not sure who his hectoring was targeted to. It has all the makings of a drunken rant so hopefully we can chalk it up to that and move on.

I've started filtering my NBA queries by filtering on current Day, Month, Season, rest, and o:rest and over the past week the queries aren't hitting. I only started with a subset of the queries in the spreadsheet since I think a lot of them were "forced" queries and use only the ones that make sense to me why they would hold an advantage. If the books adjusted I don't think they would over adjust to the point where fading the picks would be profitable.

No rant, I wasn't targeting anyone that contributes to this thread. Just been getting pms from lurkers I suppose.

Originally Posted by Cutler'sThumb

I'll freely admit that I'm nowhere near the expert level of many of the guys on this thread with regards to constructing my own queries. As JMon correctly states, it takes years of hard work to really be good at that, and I only discovered SDQL 3 months ago. The concept of trends and SDQL appealed greatly to the way I approach this game, and I'm sure I'll pick up the whole package in due time. In the meantime, however, I joined the group just as there was a massive amount of info being uploaded, and I've spent a lot of time trying to work out the best possible way to use all that info. JMon, you obviously have a successful system down, so feel free to ignore my efforts. If I crash and burn trying it my way, it'll just be an expensive lesson.

It may well be a waste of time to back test all the trends, but doing it has allowed me to familiarize myself with the language and see how individual trends behave over time, and which ones have flat lined recently and should be put on the bench. The NBA is still a work in progress (still over 1/2 of the trends to work thru), but I've completed this process in the NHL, and have seen great results (thanks Oilers!). I don't play every trend, but rather the trends that fit my filter and are not opposed by a valid trend on the other side. I'm sure this could get even better if I knew each trend inside and out and took the time to cap each trend for each game, but I just don't have the skill (or the time) to do that at this point.

JMon, your smaller trends are absolutely golden, but imho this simply isn't the case with some of the other smallish trends that have really been massaged. I look at it from a statistical standpoint (it was a many years ago, but I lived and breathed the scientific method for a long time, and I did take statistics along the way): the smaller the sample size, the more volatility there is likely to be. This is statistics 101, doesn't matter if we're talking about what % of dogs like to eat their own poop or if the Nuggets are going crap the bed (again). That doesn't mean small trends should be shunned, it just means they should probably be looked at with a little more caution. I actually won the largest bet I've ever made last month based on a trend with a sample size less than 40, but the situation was perfect. I knew about it from before I found SDQL and had actually PMed you asking about a start time filter, as I was trying to come up with the correct query for it. Anyway, sorry if I got your dander up with my posts.

With your learning you will find that the majority of sdql (not all) are unstable-always changing. For instance, most of the queries I have posted here, I don't even use or have been personally deleted. Yet as you stated, I can see how backtesting them would be beneficial to the learning process.

Originally Posted by Heart

Uh i'm not sure who his hectoring was targeted to. It has all the makings of a drunken rant so hopefully we can chalk it up to that and move on.

I've started filtering my NBA queries by filtering on current Day, Month, Season, rest, and o:rest and over the past week the queries aren't hitting. I only started with a subset of the queries in the spreadsheet since I think a lot of them were "forced" queries and use only the ones that make sense to me why they would hold an advantage. If the books adjusted I don't think they would over adjust to the point where fading the picks would be profitable.

I believe that you can find a query that will fit any bet, if you look long enough.
Under, Over, backing the home team, fading it - all in one game.

I also believe that any query can be found unfit - if you spend enough time testing it.

I'm not an expert in SDQL by any means, but I believe that you shouldn't blindly bet on a query, but I also don't believe that you should dissect the life out of it.
If you look at month, season, rest, o:rest, conference, wp - you will find some spot where the query doesn't work well.

I can tell you how I approach queries.

ATS queries - month and season and home/ away & fav/dog if the query didn't specify it.
I don't look at the query, but on the teams in the game - how they play with such rest and how they perform on this day of the week either this season or take it one season back if the results are too small sample (0 results or 1 result).
I usually play with the range of line given. If for example line is -5, I will set the range on -2.5 to -7.5 to see how query performs.
Then I look at the game for special angles - revenge, look ahead the next game stuff like that - if it's possible, I ran query to see how it did in this special angle.

Totals:
I don't care about D or F. I'm much more interested in month and season.
The rest is more or less the same.
I can play with the totals but casting a larger net. If the total is 205, I will set the range 200 - 210 to see how it responds.

One more thing I like to look in to, when I'm looking at season results - how the teams in question played in this query.
For example, big samples can have 30 results in 2014 season or more and I can see that query suggests to play Team A here and the query has 60% hitting range and all tests are good.
But, if Team A, fit this query three times this season before and lost ATS all three - I won't play it.

Just an example - the game between Lakers and Nuggets. Three queries suggest we play the Over. But, both teams in a huge drop scoring wise, drop that the queries don't take in to account.
They also don't take in to account the fact that Nuggets on the road have much much lower scores than at home.
If you play with number for Nuggets and with the Lakers, I think you won't play the Over here.
Can the Over hit? For sure. But I think that it would be smart not to touch here.

Two queries point to the Rockets tonight and this is much harder case.
Suns lost to Rockets this season already at home, also a play that had support from the queries.
Suns also off a loss to the Kings and this is the last game before ASG break, while Rockets will play one more game.
But, both queries seem legit and went through my tests and came out ok.
This one I still don't know what to do with...

Good breakdown dmitean.

I follow that thread and the NHL one closely because the information provided is very valuable. There is a lot of talk about which trends to play or not. As some said, the backtest will be mostly profitable because we are looking at profitable trends. Past Performance Is Not A Guarantee Of Future Returns.

What is important in a trend is the parameters. I think some of the parameters are added just to improve the ROI, but they are not explainable parameters. Let me explain. Let’s take the NHL trend F and o:streak > 3. To me this is a very good trend. Does it make sense for a hot team (streak > 3) being an underdog? The public is going to jump on the underdog. This is where the educated bettors are smarter, the bookmaker sets the “worse” team as a favorite. This trend is a typical, against the public trend which is usually profitable.

On the contrary a trend like AF and line < -3 and line > -10 and Average(margin@team and season) >= 3 and p: points > 104 and pp: points > 104 and ppp: points > 104 and rest < 2 and WP > 64.1 and game number > 16 is not good at all because there are too many parameters that are not explainable. Why would it be a play at -3.5 but not at -2.5. Why the number of points is 104 and not 105?

Basically I am not considering trends with too many parameters, and also the trends with parameter involving line, total, WP and others parameters that are too random to me.

My 2 cents
Keep up the good work

In my humble opinion, moisiFr has valid points. I am not an expert in this stuff but I would've cleaned all the less sensible trends with weirdo parameters attached. Some trend mathematically may present a very good percentage but it would be way better if it has a good rationale beyond the maths and numbers. Just a thought.

Dmitean is doing this the right way but with the right set of mind, tools and most importantly with a good bankroll management system, we can turn this system into a brainless investment especially for the ones who do not have extensive times to put in to analyze all the stuff daily and beat the bookies in the long run.

Originally Posted by TheLineShifter

In my humble opinion, moisiFr has valid points. I am not an expert in this stuff but I would've cleaned all the less sensible trends with weirdo parameters within. Some trend mathematically may present a very good percentage but it would be way better if it has a good rationale beyond the maths and numbers. Just a thought.

Dmitean is doing this the right way but with the right set of mind, tools and most importantly with a good bankroll management system, we can turn this system into a brainless investment just to beat the bookies in the long run.

Just because you don't understand the rationale for queries with many variables does not mean it's not valid or even that they're over-fitted. Yes, certainly the most intuitive ones are more face valid, and therefore the results are likely attributable to variables that make sense to you. But variables that predict the outcomes of sports games are very often counter-intuitive or even entirely escape any obvious, logical rationale. This very likely may mean that you (or anyone for that matter) don't understand the influence of certain variables that by themselves may mean nothing but when interacting with others may be very predictive.o

In statistics we use the neural networks to create patterns and strategies for certain situations. In macro economics there are 1000s of variables in a equation and tweaking one and wighting the others is essential. same here. the more you dig into this field the more crossroads will lead to loopholes, dead ends among other things.

my second field of analyzing games is by using Rating Systems like Massey, Dunkel Index and DCI. That works well too.