MLB - Last 10 games (w/l) from a specific date

[Robert Carnatz]

New to the SDQL, Trying to figure out how to get the last 10 win/loss record as of a certain date for each team 

Example: As of 04/30/23 the Rays had a last 10 record of 7-3, Pirates 8-2, and Oriels 8-2 

Thanks 

[Joe Meyer]

R(team),S(W,N=10),S(L,N=10)@team|

https://sportsdatabase.com/MLB/query.html?sdql=R%28team%29%2CS%28W%2CN%3D10%29%2CS%28L%2CN%3D10%29%40team%7C&submit=++S+D+Q+L+%21++

--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/f429b429-5a85-497e-8581-810b03f15ed7n%40googlegroups.com.

[Robert Carnatz]

Thank you Joe, this is a great start. Do have more questions. What does the R mean in R(team)  and S in S(W,N=10)?  Also i need this for a specific date so i added the date at the end of your example and got dashes where the Win Loss would be 

R(team),S(W,N=10),S(L,N=10)@team and date = 20230430

Thanks again 

[Joe Meyer]

The SDQL manual is useful at:

 

http://SDQL.com

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/0f92501d-7836-4e6e-afdc-17061c4b0ee1n%40googlegroups.com.

[Gambrinus]

Robert, 

To see the last 10 win/loss record as of a certain date for each team, add " and date<20240501" to Joe's query to see the teams records in their last 10 games as of 5/1/2024 as an example.

MLB Team records over the last 10 games as of 5/1/2024

[mrpi...@gmail.com]

To add to this, last 10 games with won/loss record, if I also wanted to see the ML ROI I tried adding tS(su_profit/su_invest) and got no error but all zeroes for results

R(team), tS(W), tS(L), tS(su_profit/su_invest)@team and n15:date>=today

https://gimmethedog.com/MLB?q=R(team)%2C%20tS(W)%2C%20tS(L)%2C%20tS(su_profit%2Fsu_invest)%40team%20and%20n15%3Adate%3E%3Dtoday 

[Gambrinus]

Hey Mr. Pickem, I hope you're well buddy. Try it this way:

https://www.gimmethedog.com/MLB?q=team%20and%20n15%3Adate%3E%3Dtoday

[mrpi...@gmail.com]

Thanks Gambrinus

I am aware it's possible like that in the generic form, but I like to return custom tables to fit my needs,  It works at killersports which was down Friday morning and I was scrambling :)  Is there no parameter like su_profit, su_invest, su_roi, ml_profit...

I fit the results into my spreadsheet to draw from for a small piece of my model, I look to return something I can copy/paste and get this and a few others

https://i.imgur.com/WGnQj0x.png 

[Gambrinus]

I see, GimmeTheDog calculates those values as needed, but now I see the value of adding them to the database. I'll get that done soon.

Also, if you're interesting in a trick to no longer have to cut-and-paste to get the data you want into your spreadsheets, email me at in...@gimmethedog.com.  

[Robert Carnatz]

A little off topic, is there a way control the order in Ascending or Descending order? In SQL it would be ORDER BY blaaa ASC

[Gambrinus]

It's not exactly what you're asking, but at GimmeTheDog.com, using the column output option (i.e., the SDQL has a "@"), the first column auto-sorts from lowest to highest. So, if you want to see the average points per game in the WNBA, use this.

• tA(points),R(team)@team and season=2024

https://www.gimmethedog.com/WNBA?q=tA(points)%2CR(team)%40team%20and%20season%3D2024