Quote Originally Posted by theclaw:
Quote Originally Posted by DogbiteWilliams: My queries are all over the place in Game 7, and my confidence took a hit losing 2.5 units on OKC -1.5 games. While most of my queries favor OKC SU, I just had one that could be an outlier - it has IND 29-10 ATS. As of now I passed on the side, but I might just take OKC and sell some points because, surprisingly, despite getting clobbered in Game 6, my efficiency factor metric makes OKC's DEF effort in Game 6 look like the best of the series. I did bet the Under. Good luck everybody. How is that possible dog ? Pacers I think shot their highest shooting efficiency % of any game. According to my meterics OKC defense was not good
Your efficiency stats are undoubtedly better than mine; your pointspread record is better than mine most of the time.
I compute my Efficiency Factor (EF or EFF FAC) like this:
points/FGAs
The OFF EF can be bolstered by 3 ways: higher FG%, greater proportion of made FGs are 3s, or lots of made free throws. A sound DEF EF keeps the opponent low in the same 3 ways. While this does not consider net chances, this ratio can be used in queries and, to the best of my knowledge, I have never seen anyone else discuss this, so it gives me a unique perspective.
Parameters such as ORBs, TOs, DEF TAs and many other fundamental factors affecting net chances can also be added to queries. Sport Data Query Language is thought of as "Technical Handicapping," but I now think of it as just a VERY efficient way of researching fundamentals stats and their relationships to lines and totals. I can get an answer in just a few seconds rather than searching through newspapers, magazines and websites for hours.
This is one of the queries that got me to take the Under in Game 7 and it does include IND's Game 6 OFF EF which is the same as OKC's Game 6 DEF EF:
PO = 1 and HF and p:TOM - pp:TOM > 9.5 and op:points/op:FGA < 1.22
OU = 12-39-0 (-6.5,23.5%)
By parts:
Playoffs/HF/in the previous game OKC's turnover margins was at least 10 worse than the previous previous game/IND's Game 6 points div by its Game 6 FGAs was less than 1.22 (league avg this season is 1.28 and 1.27 in the playoffs. IND's Game 6 EF was a weak 1.17; in Game 2 OKC's was a whopping 1.50).
The closing total was 215.5 which was a shockingly low total for lightning-paced IND whose OFF is much better than its DEF. This season before today's game IND has had 103 games with posted totals over 218.2 and just one below 218.2. There is NO way I could have come up with an Under wager without the above query (as well as others).
SDQL is worth investigating. It's still about 2 1/2 months until the NFL kicks off.