Seeing ATS record for a query when adding or subtracting points

[JT]

I know when you enter a query, the section on the top shows you what the record would have been had you bought or sold points (for 6 and 10 points) under the Teaser Records section.

I'm wondering if there is a way to build this type of thing right into the query with any number of points you like.

For example, Chiefs as a home dog since the 2001 season (team = Chiefs and season > 2000 and HD) are 23-22-1 ATS. I would like to know if I had bought 2 points in each of those games, what the ATS record would be.

Thanks

[mrpickem]

I dont believe you can get exactly what you want, but try this:

team and season > 2010 and HD, (HD and ats margin < -2) 

It will give 2 rows for each, one row shows record as HD and other row shows number of losses even after buying 2 points

Bears only team with 5 games since 2010 you would not have lost if buying the 2

games	ATS W - L- P (marg, %win)	Avg Line	OU W - L- P (marg, %over)	Avg Total	SU W - L- P (marg, %win)	SDQL
9	0-9-0 (-11.67, 0.0%)	2.6	5-4-0 (6.44, 55.6%)	48.4	0-9-0 (-14.22, 0.0%)	Bears and season > 2010 and (HD and ats margin < -2)
27	10-14-3 (-0.80, 41.7%)	3.5	11-15-1 (-0.22, 42.3%)	45.4	7-20-0 (-4.26, 25.9%)	Bears and season > 2010 and HD
7	0-7-0 (-11.50, 0.0%)	3.5	4-2-1 (2.36, 66.7%)	45.2	0-7-0 (-15.00, 0.0%)	Bengals and season > 2010 and (HD and ats margin < -2)
16	8-8-0 (-1.03, 50.0%)	3.2	7-7-2 (2.28, 50.0%)	45.5	6-10-0 (-4.25, 37.5%)	Bengals and season > 2010 and HD
11	0-11-0 (-12.73, 0.0%)	5.8	8-3-0 (5.77, 72.7%)	45.0	0-11-0 (-18.55, 0.0%)	Bills and season > 2010 and (HD and ats margin < -2)
28	17-11-0 (1.84, 60.7%)	4.6	17-11-0 (1.54, 60.7%)	44.5	14-14-0 (-2.79, 50.0%)	Bills and season > 2010 and HD
7	0-7-0 (-14.50, 0.0%)	4.8	4-3-0 (0.50, 57.1%)	45.1	0-7-0 (-19.29, 0.0%)	Broncos and season > 2010 and (HD and ats margin < -2)
20	10-8-2 (1.32, 55.6%)	4.1	8-11-1 (-0.72, 42.1%)	44.3	9-11-0 (-2.80, 45.0%)	Broncos and season > 2010 and HD
20	0-20-0 (-9.50, 0.0%)	6.0	6-14-0 (-2.25, 30.0%)	44.4	0-20-0 (-15.45, 0.0%)	Browns and season > 2010 and (HD and ats margin < -2)
40	18-22-0 (-1.90, 45.0%)	5.0	14-25-1 (-3.54, 35.9%)	43.9	10-29-1 (-6.85, 25.6%)	Browns and season > 2010 and HD
16	0-16-0 (-11.91, 0.0%)	4.3	11-5-0 (3.47, 68.8%)	46.3	0-16-0 (-16.19, 0.0%)	Buccaneers and season > 2010 and (HD and ats margin < -2)
33	12-18-3 (-2.59, 40.0%)	3.8	17-16-0 (-1.61, 51.5%)	47.4	8-25-0 (-6.42, 24.2%)	Buccaneers and season > 2010 and HD
11	0-11-0 (-12.32, 0.0%)	6.2	6-5-0 (0.00, 54.5%)	42.0	0-11-0 (-18.55, 0.0%)	Cardinals and season > 2010 and (HD and ats margin < -2)
31	18-12-1 (0.94, 60.0%)	4.2	13-18-0 (-1.44, 41.9%)	42.4	15-15-1 (-3.26, 50.0%)	Cardinals and season > 2010 and HD
8	0-8-0 (-9.56, 0.0%)	3.3	1-7-0 (-11.94, 12.5%)	47.3	0-8-0 (-12.88, 0.0%)	Chargers and season > 2010 and (HD and ats margin < -2)
18	6-12-0 (-0.67, 33.3%)	3.3	6-12-0 (-6.03, 33.3%)	47.6	5-13-0 (-3.94, 27.8%)	Chargers and season > 2010 and HD
4	0-4-0 (-14.50, 0.0%)	2.5	2-2-0 (5.50, 50.0%)	44.5	0-4-0 (-17.00, 0.0%)	Chiefs and season > 2010 and (HD and ats margin < -2)
14	8-6-0 (1.50, 57.1%)	5.1	5-9-0 (-2.75, 35.7%)	44.0	5-9-0 (-3.64, 35.7%)	Chiefs and season > 2010 and HD
8	0-8-0 (-12.06, 0.0%)	4.2	1-6-1 (-6.81, 14.3%)	43.6	0-8-0 (-16.25, 0.0%)	Colts and season > 2010 and (HD and ats margin < -2)
23	14-9-0 (0.93, 60.9%)	5.0	8-14-1 (-1.00, 36.4%)	44.7	10-13-0 (-4.09, 43.5%)	Colts and season > 2010 and HD

[JT]

Thank you. I think I understand. If you flipped it and used (HD and 0 >= ats margin > -2) for the second part, that would return games that pushed and games that lost ATS by less than two points--in other words, games that you would have won (or pushed) had you bought 2 points.

In the Bears example,

team = Bears and season > 2010 and (HD and 0 >= ats margin >= -2)

...returns 0-3-3 ATS. So that would indicate you would have won 6 additional games had you bought two points.

Then you would also have to do ats margin = -2 to find games where buying the 2 points would have caused a push. That returns 2 such games. So adjusting the original record of 10-14-3, buying two points in every game would have caused a record of 16-9-2.