Stuck with teaser issue

[Earlie Smith III]

Evening, Could I get assistance on the code to create 6 pt teaser data for teams vs the lines. I know the number can be changed is the normal base line for me. There used to be a site for this gave it to me with out the code dialog. Has been a few years ago. I come back site is gone. Any advice would be awesome. Thanks and hope this reaches you in good spirits and health. 

[Joe Meyer]

Earlie Smith III,

to see the 6 point teaser record for each team this season, use the SDQL:

R(team),S(points+6>o:points),S(points+6<o:points),S(points+6=o:points)@team and season=2023|

Best regards,

Joe Meyer

Eyeball Communications LLC

On Tue, Oct 17, 2023 at 10:17 AM Earlie Smith III <e3p0...@gmail.com> wrote:

Evening, Could I get assistance on the code to create 6 pt teaser data for teams vs the lines. I know the number can be changed is the normal base line for me. There used to be a site for this gave it to me with out the code dialog. Has been a few years ago. I come back site is gone. Any advice would be awesome. Thanks and hope this reaches you in good spirits and health. 

--
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/CAHA2u3rOX74Wi1d42ucMr57%3Dx927xy6BEXc2M%3DCzq3ShBbbJdg%40mail.gmail.com.

[Earlie Smith III]

Thank you sir trying in a few and update results tomorrow 

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/CAJEcYFiay3nm%3DG%3DG1n05C8gB2QQmYdRvfuLLPQY5xoWvpDvRAA%40mail.gmail.com.

[Earlie Smith III]

[Trey Hoos]

If I'm reading this correctly, this is taking the points scored + 6, rather than the spread moving 6.  Am I misunderstanding as a newby?

How could this be modified to see how a team does vs a spread+6 ?

[Joe Meyer]

Trey,

thank you for pointing out my error there!

To see the 6 point teaser record for each team in 2023, use the SDQL:

R(team),S(points+line+6>o:points),S(points+line+6<o:points),S(points+line+6=o:points)@team and season=2023|

best regards,

Joe Meyer

Eyeball Communications

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/8aacbc85-6843-4b62-a263-8668221e1fa8n%40googlegroups.com.

[Trey Hoos]

Joe -  thanks for the quick confirmation there.

I am not sure about this one other item - how could I add to this to limit it to lines that fall between specific values (say -9, and +3)
would it look like this?

R(team),S(points+line+6>o:points),S(points+line+6<o:points),S(points+line+6=o:points)@team and season>=2023 and line>-9 and line<3|

also, if I am on the right track is there a way to find the average number of points differential from these matchups?

[Joe Meyer]

Trey,

yes, that looks good.

 

To add the average points differential use:

R(team),S(points+line+6>o:points),S(points+line+6<o:points),S(points+line+6=o:points), A(points-o:points)@team and season>=2023 and -9<line<3|

Best regards,

Joe Meyer

http://sdql.com

Eyeball Communications LLC

To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/dbce7649-8ddc-4178-80fa-e74ff83cd918n%40googlegroups.com.

[Nadir Khan]

Hello world I am Nadir khan 
To click the URL to watch the very games 

https://zireemilsoude.net/4/8569033