streak, ats streak, ou streak, wins, losses are all "None" for upcoming week

[A.A. West]

https://sportsdatabase.com/NCAAFB/query.html?sdql=team%2C+o%3Ateam%2C+date%2C+o%3Adate%2C+streak%2C+ats+streak%2C+ou+streak%2C+rest%2C+o%3Arest%2C+wins%2C+losses+%40+date%3E20240917+and+week%3D4&submit=++S+D+Q+L+%21++

This query shows None for all of the fields referenced in the subject. We should be able to get the fields populated with values for the current week.

If you go to killersports.com (https://killersports.com/query) and enter:

streak, ats streak, ou streak, wins, losses @ week=4 and date>20240918

these values are populated, so they are available.

Thanks,

Andrew

[Joe Meyer]

Andrew,

this looks like a data issue - not an API issue.

From what I can tell, it looks like the streak parameter at sportsdatabase is not updated until after the game,

Perhaps this gives you what you are after: 

team, o:team, date, o:date,p:streak, p:ats streak, p:ou streak, rest, o:rest, wins, losses @ season=2024 and week=4

You can also avoid the 'synthetic' streak parameters by calculating them on the fly using this form:

R(team),Streak(W) @ team and season=2024|

Best regards,

Joe Meyer

Eyeball Communications

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/152f0bd8-a2df-4af5-baa4-2ef6749f9456n%40googlegroups.com.

[A.A. West]

Hey Joe, using "p:streak" will tell me what the team's streak was going into the last game, but I want to know their streak going into the current/upcoming matchup. This way, I can see how the team has performed with similar streaks in the past.

This query:

streak, p:streak @ date>20240917 and week=4 and team=TEX

Give me the values 2 and 3 when I execute it at:

https://killersports.com/query.

Running this query at the sports database api: 

https://sportsdatabase.com/NCAAFB/query.html?sdql=streak%2C+p%3Astreak+%40+date%3E20240917+and+week%3D4+and+team%3D%27TEX%27&submit=++S+D+Q+L+%21++

gives me "None" for the current streak and 2 for the p:streak. It would seem that we could get streak updated for the upcoming contest.

Thanks for looking into this,

Andrew

[Joe Meyer]

Andrew,

this looks like a data issue and, since we host peer-to-peer databases, out of my domain.

Best regards,

Joe

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/cbb81af9-ca8f-4bf8-bc85-cc985ed6a3a1n%40googlegroups.com.

[A.A. West]

I appreciate the response, Joe. Last question - who controls the data that the $25 basic members are accessing?

My plan is to get my front end working and tested using the basic membership, and then upgrade to build my own SDQL database.

[Joe Meyer]

Andrew,

You can see the data maintainers at each query page.

For example, the NBA at https://sportsdatabase.com/NBA/query.html

shows data fields from GimmeTheDog, Joseph, and AWang.

You can select which users to follow using the settings API described at

https://sportsdatabase.com/about_sapi

best regards,

Joe Meyer

eyeball communications llc

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/f985552a-f6e9-4457-9d54-ee3bf518f7ean%40googlegroups.com.