Need Help on Query

Updated on August 17, 2015 in SDQL Questions
6 on August 9, 2015

I want to see if momentum from last season carries over to week 1.

Does anyone know how to query, for example, team ended last season with 3 straight wins?

  • Liked by
Reply
0 on August 9, 2015

Check and see if this is right:

game number=1 and Replace(season@team and pp:W and p:W and W)=season -1 
  • Liked by
Reply
Cancel
0 on August 11, 2015

This code reveals teams who won in Week 17 last year, extending thier win streak to at least three games:  

season=2014 and week=17 and streak>=2 and W

All four of those teams made the playoffs (Hawks, Boys, Cats and Steelers) and only one (Pittsburgh) lost its first playoff game (vs Baltimore). 

This code seems to account for teams who won at least three straight games and DID NOT make the playoffs (Steelers in 2013):

week=1 and tpS(W, N=3)=3 and tpS(playoffs, N=1)=0

To try and account for teams who went into the playoffs hot and then lost, thus ending their streak, I’m thinking: 

week=1 and tpS(W, N=4)>=3 and tpS(playoffs, N=2)=1

Steelers show up live in Week 1, 2015 (at NE) and they were the only team of those four listed above who went into the playoffs hot and then lost their first playoff game (vs Ravens).

  • Liked by
Reply
Cancel
0 on August 11, 2015

I like that “tpS(…” 

Does that expand to:
Sum(W@team and season)[team and season-1] ?

  • Liked by
Reply
Cancel
0 on August 12, 2015

Yeah, pretty much. And tppS would get you results based on what a team did two years ago.

tp3S (three seasons ago)

This also works with averages (Ie. tp3A)

  • Liked by
Reply
Cancel
0 on August 12, 2015

Thanks guys! What do you think of this?

game number=1 and -3 < = line < = 8  and Replace(season@team and WP>50 and ppp:W and pp:W and p:W and W)=season -1 and H

NCAAF Home team finished last season with 4+ wins and whole season above .500
It is game number 1 for them
They’re a small -3 favorite to +8 dog.

51-36-3 58.6% ATS and looks like profit on the moneyline too.
Anyone know how to see moneyline records with sdql?

  • Liked by
Reply
Cancel
0 on August 17, 2015

Looks good to me. Have you looked to see what happens if it was off of 5+ wins or 3+ wins rather than 4? Not exactly sure how you’d do it.

  • Liked by
Reply
Cancel