Search:

Am very curious how the game 2's will shake out, given all the upsets thus far. Thought this was interesting:

playoffs = 1 and season >= 2005 and series game = 2 and p:AW

Question about evaluating the "strength" of a trend...

Do you guys ever look at the "avg line, avg total" and compare that to the stat breakdowns of "Team, Opp"? So, for instance, in the trend...

Taking it back to 2009 shows a 65%+ on the Over and a 68%+ on the Away team to win SU.

Here's one I like for today:

AF and streak=3 and WP>50 and o:WP<50 and season>=2009

What about:

HD and p:ADW and season >= 2009 and conference = o:conference = po:conference = Eastern

The road faves in this trend are winning by over 6.5 points on average (and covering nearly...

Thanks. :) If you need a losing streak, use an negative number. And of course > and < work with it too. I've been using "streak" and "ats streak" routinely to look for trends.

There's a cleaner way to include that streak in this case:

o:streak = 4

Saves you the trouble of putting all those oppppppp entries. :)

I was wondering about that NHL query, too Clover. I'm not seeing a matchup to play with that trend...

One of my criteria is "don't try to guess when a team will break out of a slump". We read all the time about how "Team X should be able to right the ship against Team Y tonight". That's why I don't...

So... in the interest of education, can you share why you do or don't think your 187 <= total <= 212 query might be overrigged? :)

Well, I wasn't talking about "picks" either. I was positing a question about the query (ie. is it too specific/tailored?), which seems reasonable and appropriate. I'm specifically addressing...

Mako - that first one seems incredibly specific. Between the previous margin, the current line, and the window of total points... it feels a little like a forced trend that happens to generate a...

Oh, believe me, there's been LOTS of trial and error. :) That's why I'm reaching out...





Thanks for that reference. You might be right about at least looking at the first half and then...

I've read through the manual you guys are referring to and I'm still not seeing how to use operands. I tried using the Sum feature on points (ie per quarter) to do some 1st half / 2nd half...

JAnthony & Mako, I truly appreciate this kind of conversation. I'm still learning & developing as a bettor, so I'm pretty open to molding & re-molding my methods.

My biggest lesson so far is: ...

I absolutely agree with what you're saying. I don't believe spreads or over/unders have any real impact on games or actual outcomes.

I was mostly looking at the spread results, as a...

Is this too specific a query to consider? I was curious about "what does it take to get them back on track ATS"...

team = Pacers and ats streak <= -3 and rest = 1 and H and season >=2004 and o:WP...

Can we use operands in the query language? Maybe we can do something with 1Q+2Q scoring compared to 3Q+4Q scoring? I keep getting errors when I try to use parentheses & plus/minus, but maybe I'm...

I don't know if my prior question wasn't clear, but I'm having trouble coming up with the query language for 2H scoring comparisons/trends.

Specifically, I'd like to look at 2nd half scoring when...

So, I took a shot at the 2H over 106 on the Was/Phi game tonight. They scored 136 in the first half... then only 89 in the second half.

I'm not seeing how to run a query to show 2nd half scoring...

Question about JMon's query: there were no such games between Dec 2012 and today? Seems like that would at least sort of violate the consistency rule.

How does that factor in to the query's...

Gotcha. I definitely never bet without checking other mitigating factors - injuries, officials (there's a few I'm REALLY leery of), other completely crazy trends that might override a situation...

JMon - are those the kinds of situations that "pro" cappers are referring to when they talk about "situation X with team A is UNDEFEATED since 1995"? Any "perfect" filter certainly makes my betting...

I want to say THANK YOU to anyone that does post any sdql statements here. It's helping me to learn how to type things in even more than my own trial and error.

For those that use the system a...

Question about using any of these situations: if it's a great ATS situation, should we ONLY play the "picks" if the spread matches (or is better) than posted? What if our best available spread is...

Thanks, clover. I appreciate that.

Hey guys. Just found this thread; I'm going to play in the SDQL (it really appeals to the former programmer in me), but I wanted to see if someone wouldn't mind posting the queries from post #1 and...