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?
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).
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?