MLB - Situation Plays - SDQL

**emceeaye** · 05-24-14, 11:34 AM

Originally posted by JMon

indeed...

not much action for me today.. like Balt, Laa and Balt ov.

not a lot of action for me today either. But what about the following query that you posted earlier?

A and line>=130 and STDSERA<=3.50 and t:conference=AL and A(Starter

:innings pitched@o:starter and season) >6.5 and 2009<=season

And
league = o:league and WP < 50 and o:WP < 50 and streak <= -2 and o:streak >= 1 and AWP > o:HWP and AD and season > 2010 and month > 4

**posey** · 05-24-14, 02:31 PM

Originally posted by emceeaye

And
league = o:league and WP < 50 and o:WP < 50 and streak <= -2 and o:streak >= 1 and AWP > o:HWP and AD and season > 2010 and month > 4

That's the one from me, isn't it? Picked the Mets because of it, but didn't like the Red Sox too much somehow.

This one already cashed, lol: http://forum.sbrforum.com/baseball-b...l#post21911041

**JMon** · 05-24-14, 02:51 PM

Originally posted by emceeaye

not a lot of action for me today either. But what about the following query that you posted earlier?

A and line>=130 and STDSERA<=3.50 and t:conference=AL and A(Starter

:innings pitched@o:starter and season) >6.5 and 2009<=season

And
league = o:league and WP < 50 and o:WP < 50 and streak <= -2 and o:streak >= 1 and AWP > o:HWP and AD and season > 2010 and month > 4

had to much against det

**JR007** · 05-24-14, 03:24 PM

**nbilln** · 05-24-14, 04:34 PM

looks like the trend working against Danks didnt work out well, but fading the team itself ended up well with the Yankees winning earlier.

season >= 2014 and A and (-105 <= line <= 185) and p:AL and pp:AL and op:W and opp:W and SG=3 and o:WP>50 and WP<50

15-3 (2.22, 83.3%)	avg line: 138.0 / -149.8	on / against: +$1,812 / -$1,992	ROI: +100.4% / -73.2%
16-2 (3.72, 88.9%)	avg line: -161.0 / 148.2	on / against: +$1,281 / -$1,306	ROI: +44.5% / -72.6%
6-11-1 (0.11, 35.3%)	avg total: 7.9	over / under: -$575 / +$430	ROI: -29.5% / +21.3%

Playing on the Astros here. In 2014, road teams on the verge of getting swept that are below 0.500 and are facing a team above 0.500 are performing well.
Combine this with JMon's query and I like the Astros as a dog here.

**green7** · 05-24-14, 06:26 PM

Good find Nbilin I was liking the 'stros and this query is a gentle push to the betting window.

Never seen Danks pitch so well,....there's been plenty of late inning rallies that have gone the wrong way lately, so perhaps there will be a trend towards fortunate results now.

Since we're talking a lot of this season's trends, check out how NL day games have played out this year....a plethora of UNDERS.

Another observation...especially for dog queries,....they often aren't that strong on weekends, over the time the database has been around favorites win during the weekend and dogs' ROI are good during the week.

season=2014 and H and DAY and conference and total>=7

**emceeaye** · 05-25-14, 01:06 AM

This one is pretty sweet

Here's one I came up with. Please feel free to tweak in order to increase sample size while eliminating irrelevant variables or variables that add only limited increase in win/loss ratio or ROI relative to a dramatic decrease in sample size:

HF and WP>o:WP and tA(hits)>9 and tS(hits,N=8)>=70 and tA((hits+walks)@team and season)/tA(runs@team and season)>A((o:hits+o:walks)@team and season)/A(o:runs@team and season) and op:L and opp:L and p:W and SG>1 and tA(margin, N=10)>0 and tA(margin)>0

**green7** · 05-25-14, 04:29 AM

Nice query Em

I am not seeing any plays with this today, is that correct?

**emceeaye** · 05-25-14, 07:54 AM

Hi Green,
Unfortunately not, at least when I tried it last night. But, I noticed that sometimes it takes a really long time for the database to update after the previous day's games. So who knows it may become active, but I suspect not due to infrequency with which it applied until now at least this year. But that's partly why an increased sample size would be good--to increase the frequency with which its active.

**posey** · 05-25-14, 08:29 AM

Don't know how relevant or reliable both queries are (and I think another user has posted something similar earlier, so sorry and please don't feel robbed!), but I found those:

7-12 (-0.26, 36.8%)	avg line: 171.2 / -188.1	on / against: -$30 / -$65	ROI: -1.6% / -1.8%
10-9 (1.24, 52.6%)	avg line: -124.0 / 114.2	on / against: -$107 / +$37	ROI: -4.5% / +1.9%
12-6-1 (1.76, 66.7%)	avg total: 8.1	over / under: +$535 / -$800	ROI: +26.4% / -37.1%

42-29 (0.70, 59.2%)	avg line: -124.9 / 114.2	on / against: +$804 / -$1,167	ROI: +8.8% / -15.4%
34-37 (0.01, 47.9%)	avg line: 133.2 / -147.1	on / against: +$429 / -$684	ROI: +5.3% / -6.1%
21-44-6 (-1.02, 32.3%)	avg total: 7.3	over / under: -$2,585 / +$1,970	ROI: -34.1% / +24.4%

**posey** · 05-25-14, 09:20 AM

Hm, maybe an under in Toronto?

6-6 (-0.75, 50.0%)	avg line: -103.3 / -108.0	on / against: -$56 / -$2	ROI: -4.0% / -0.1%
5-7 (-0.75, 41.7%)	avg line: -104.8 / -107.6	on / against: -$136 / +$79	ROI: -9.0% / +5.0%
2-9-1 (-0.83, 18.2%)	avg total: 8.9	over / under: -$750 / +$690	ROI: -58.1% / +51.1%

5-9 (-1.14, 35.7%)	avg line: 109.3 / -119.3	on / against: -$289 / +$221	ROI: -19.2% / +12.8%
6-8 (-0.71, 42.9%)	avg line: 101.3 / -113.6	on / against: -$304 / +$193	ROI: -17.9% / +10.4%
2-12-0 (-1.89, 14.3%)	avg total: 8.9	over / under: -$1,120 / +$990	ROI: -72.3% / +64.7%

4-7 (-1.73, 36.4%)	avg line: -100.5 / -109.5	on / against: -$322 / +$280	ROI: -27.7% / +22.5%
3-8 (-1.59, 27.3%)	avg line: -118.8 / 105.3	on / against: -$749 / +$681	ROI: -47.4% / +49.1%
2-8-1 (-1.14, 20.0%)	avg total: 8.5	over / under: -$695 / +$570	ROI: -57.4% / +47.1%

**Roadkill86** · 05-25-14, 11:28 AM

A previous JMon-generated trend is active today;

p:X and p:errors>=2 and H and -260<=line<=-145 and 10>total>7 and rest<2

**zorba74** · 05-25-14, 12:43 PM

Originally posted by Roadkill86

A previous JMon-generated trend is active today;

p:X and p:errors>=2 and H and -260<=line<=-145 and 10>total>7 and rest<2

Interesting. I went to the "MLB Trends" page and filtered for today's games (20142505) and this one didn't pop up so I take it that you have this saved under "My MLB Trends"?

It doesn't seem as if the generic daily filters are of much use. Has anyone had a different experience?

Great thread btw. Thanks to everyone who is participating.

**posey** · 05-26-14, 01:45 AM

One question. Would you dislike it if I posted my plays that I chose based on the queries and posting the results here?
Based on my queries from yesterday I played 6 bets and won 5 on a flat stake base (W: ATL ML, LAD@PHI u8, COL@ATL u7.5, TEX@DET o8.5, OAT@TOR u9.5; L: HOU@SEA o6.5; profit: +3.25 u). Or would you like it better if we only continue to post the queries all alone? Otherwise I could open a fresh thread in which I post my queries, picks and results and still continue posting my queries parallel here?

Edit:
Nevermind, I start a new thread and post my queries in both threads for keeping it clear.

**posey** · 05-26-14, 02:44 AM

Possible UNDER for BOS @ ATL:

9-5 (1.29, 64.3%)	avg line: -165.2 / 148.3	on / against: +$55 / -$155	ROI: +2.3% / -10.9%
7-7 (0.00, 50.0%)	avg line: 131.2 / -143.3	on / against: +$160 / -$207	ROI: +10.8% / -10.1%
4-9-1 (-0.04, 30.8%)	avg total: 7.5	over / under: -$555 / +$450	ROI: -36.8% / +28.6%

6-8 (-0.29, 42.9%)	avg line: 120.7 / -130.7	on / against: -$73 / -$2	ROI: -5.2% / -0.1%
9-5 (0.57, 64.3%)	avg line: -145.4 / 131.0	on / against: +$283 / -$312	ROI: +12.9% / -19.6%
2-12-0 (-2.07, 14.3%)	avg total: 8.1	over / under: -$1,095 / +$980	ROI: -72.3% / +62.6%

5-4 (0.78, 55.6%)	avg line: 100.3 / -110.3	on / against: +$98 / -$143	ROI: +9.8% / -13.9%
4-4 (0.12, 50.0%)	avg line: -104.8 / -108.4	on / against: -$4 / -$32	ROI: -0.4% / -3.0%
2-5-1 (-0.25, 28.6%)	avg total: 7.8	over / under: -$350 / +$260	ROI: -40.7% / +28.9%

21-12 (0.39, 63.6%)	avg line: -167.4 / 150.8	on / against: +$218 / -$408	ROI: +3.9% / -12.4%
11-22 (-1.11, 33.3%)	avg line: 142.1 / -154.5	on / against: -$819 / +$714	ROI: -24.5% / +14.0%
8-23-2 (-1.09, 25.8%)	avg total: 7.3	over / under: -$1,655 / +$1,405	ROI: -46.3% / +37.8%

**posey** · 05-26-14, 03:03 AM

Possible UNDER for MIA @ WSH:

12-17 (-0.28, 41.4%)	avg line: 147.1 / -161.9	on / against: +$111 / -$303	ROI: +3.8% / -6.4%
19-10 (1.12, 65.5%)	avg line: -146.2 / 134.0	on / against: +$431 / -$555	ROI: +10.0% / -18.5%
10-18-1 (-0.69, 35.7%)	avg total: 8.0	over / under: -$960 / +$685	ROI: -30.5% / +21.2%

3-2 (1.60, 60.0%)	avg line: -128.0 / 118.0	on / against: +$45 / -$65	ROI: +7.0% / -13.0%
3-2 (0.10, 60.0%)	avg line: 173.6 / -189.2	on / against: +$327 / -$374	ROI: +65.4% / -39.5%
0-4-1 (-2.60, 0.0%)	avg total: 7.4	over / under: -$435 / +$400	ROI: -77.7% / +73.4%

6-8 (-1.21, 42.9%)	avg line: 108.8 / -119.5	on / against: -$215 / +$183	ROI: -14.2% / +10.5%
5-9 (-0.57, 35.7%)	avg line: -128.6 / 114.4	on / against: -$692 / +$627	ROI: -33.2% / +35.9%
4-9-1 (-1.21, 30.8%)	avg total: 7.6	over / under: -$545 / +$440	ROI: -36.6% / +27.4%

6-5 (0.73, 54.5%)	avg line: -141.8 / 130.1	on / against: -$83 / +$28	ROI: -5.3% / +2.5%
3-8 (-0.77, 27.3%)	avg line: 164.0 / -178.7	on / against: -$359 / +$320	ROI: -32.6% / +16.3%
2-8-1 (-1.68, 20.0%)	avg total: 7.1	over / under: -$685 / +$560	ROI: -56.6% / +45.9%

**posey** · 05-26-14, 04:26 AM

Fade the White Sox today:

5-10 (-1.47, 33.3%)	avg line: -137.8 / 126.5	on / against: -$882 / +$762	ROI: -42.1% / +50.8%
5-10 (-2.77, 33.3%)	avg line: 138.4 / -151.1	on / against: -$329 / +$252	ROI: -21.0% / +10.9%
8-7-0 (-0.47, 53.3%)	avg total: 8.9	over / under: +$60 / -$180	ROI: +3.7% / -10.7%

5-16 (-2.29, 23.8%)	avg line: -131.8 / 121.8	on / against: -$1,592 / +$1,434	ROI: -57.1% / +68.2%
5-16 (-3.79, 23.8%)	avg line: 157.3 / -171.4	on / against: -$848 / +$781	ROI: -40.4% / +21.7%
14-6-1 (3.81, 70.0%)	avg total: 8.6	over / under: +$740 / -$985	ROI: +32.6% / -41.9%

4-14 (-2.00, 22.2%)	avg line: -110.4 / 100.4	on / against: -$1,245 / +$1,160	ROI: -57.6% / +57.2%
1-17 (-2.50, 5.6%)	avg line: 130.1 / -143.1	on / against: -$1,746 / +$1,701	ROI: -87.3% / +62.6%
7-11-0 (1.47, 38.9%)	avg total: 8.3	over / under: -$470 / +$315	ROI: -24.4% / +15.5%

11-3 (2.93, 78.6%)	avg line: -111.3 / -100.7	on / against: +$903 / -$948	ROI: +51.2% / -56.8%
10-4 (2.93, 71.4%)	avg line: -128.6 / 116.4	on / against: +$547 / -$602	ROI: +28.1% / -37.6%
6-8-0 (2.18, 42.9%)	avg total: 8.3	over / under: -$260 / +$150	ROI: -17.0% / +9.7%

7-20 (-2.67, 25.9%)	avg line: 120.7 / -131.8	on / against: -$1,123 / +$993	ROI: -40.5% / +27.4%
12-15 (-1.61, 44.4%)	avg line: -116.5 / 105.3	on / against: -$656 / +$533	ROI: -19.0% / +17.2%
13-13-1 (1.19, 50.0%)	avg total: 8.1	over / under: -$120 / -$120	ROI: -4.0% / -4.0%

19-6 (2.28, 76.0%)	avg line: -131.1 / 119.2	on / against: +$1,266 / -$1,341	ROI: +36.8% / -49.8%
15-10 (1.50, 60.0%)	avg line: 104.2 / -116.5	on / against: +$767 / -$885	ROI: +25.4% / -26.7%
14-10-1 (1.94, 58.3%)	avg total: 8.0	over / under: +$310 / -$550	ROI: +11.4% / -19.9%

13-7 (0.55, 65.0%)	avg line: -116.2 / 104.8	on / against: +$648 / -$738	ROI: +25.6% / -32.3%
10-10 (0.40, 50.0%)	avg line: -109.2 / -103.6	on / against: -$55 / -$16	ROI: -2.1% / -0.6%
12-7-1 (2.48, 63.2%)	avg total: 8.2	over / under: +$415 / -$600	ROI: +18.6% / -27.7%

**green7** · 05-26-14, 06:57 AM

Memorial day DAY games as away dogs

day=Monday and AD and month=5 and DAY and not DIV and C and series game=1

14-12 (1.12, 53.8%)	avg line: 125.0 / -135.3	on / against: +$575 / -$715	ROI: +22.1% / -20.1%
13-6 (2.29, 68.4%)	avg line: -171.1 / 156.5	on / against: +$311 / -$397	ROI: +9.6% / -20.9%
12-11-3 (0.63, 52.2%)	avg total: 8.7	over / under: $0 / -$225	ROI: 0.0% / -7.8%

**posey** · 05-26-14, 06:59 AM

Fading the Rockies and Chacin:

3-13 (-1.81, 18.8%)	avg line: 128.6 / -139.8	on / against: -$923 / +$873	ROI: -56.3% / +38.0%
8-8 (-0.69, 50.0%)	avg line: -151.4 / 138.2	on / against: -$438 / +$354	ROI: -17.5% / +20.8%
3-11-2 (-1.84, 21.4%)	avg total: 7.8	over / under: -$875 / +$770	ROI: -50.4% / +43.0%

6-2 (3.25, 75.0%)	avg line: -158.3 / 141.7	on / against: +$290 / -$320	ROI: +21.6% / -38.6%
5-2 (2.36, 71.4%)	avg line: 115.0 / -125.6	on / against: +$397 / -$457	ROI: +54.0% / -50.8%
6-2-0 (1.88, 75.0%)	avg total: 8.4	over / under: +$385 / -$450	ROI: +43.5% / -51.4%

3-12 (-1.60, 20.0%)	avg line: 127.5 / -140.6	on / against: -$888 / +$868	ROI: -55.8% / +39.3%
10-5 (-0.70, 66.7%)	avg line: -135.2 / 123.5	on / against: +$453 / -$511	ROI: +21.4% / -31.4%
3-9-3 (-0.77, 25.0%)	avg total: 8.5	over / under: -$705 / +$570	ROI: -42.1% / +35.1%

6-1 (1.86, 85.7%)	avg line: -128.8 / 118.8	on / against: +$540 / -$550	ROI: +54.5% / -70.5%
2-5 (1.21, 28.6%)	avg line: 115.6 / -127.7	on / against: -$315 / +$295	ROI: -41.7% / +31.8%
4-2-1 (0.21, 66.7%)	avg total: 9.1	over / under: +$175 / -$240	ROI: +22.6% / -31.4%

6-17 (-2.09, 26.1%)	avg line: 125.0 / -139.6	on / against: -$1,056 / +$936	ROI: -41.9% / +27.4%
8-15 (-1.37, 34.8%)	avg line: -130.0 / 118.6	on / against: -$1,071 / +$970	ROI: -34.3% / +38.9%
6-17-0 (-0.85, 26.1%)	avg total: 8.3	over / under: -$1,315 / +$1,055	ROI: -50.8% / +42.7%

**posey** · 05-26-14, 07:27 AM

Fading the Mariners

33-8 (3.15, 80.5%)	avg line: -118.5 / 108.5	on / against: +$2,430 / -$2,590	ROI: +48.7% / -59.5%
21-7 (2.32, 75.0%)	avg line: 100.1 / -113.9	on / against: +$1,751 / -$1,957	ROI: +51.3% / -53.2%
20-20-1 (0.54, 50.0%)	avg total: 8.1	over / under: -$180 / -$230	ROI: -4.0% / -5.0%

7-0 (4.43, 100.0%)	avg line: -108.1 / -101.9	on / against: +$722 / -$767	ROI: +94.8% / -100.0%
6-1 (4.64, 85.7%)	avg line: -125.7 / 110.4	on / against: +$628 / -$657	ROI: +59.0% / -70.9%
5-2-0 (1.07, 71.4%)	avg total: 8.5	over / under: +$270 / -$345	ROI: +34.4% / -45.7%

8-18 (-1.15, 30.8%)	avg line: 125.9 / -136.8	on / against: -$822 / +$730	ROI: -31.6% / +20.5%
12-14 (0.23, 46.2%)	avg line: -130.6 / 118.8	on / against: -$656 / +$522	ROI: -18.7% / +18.9%
14-12-0 (0.54, 53.8%)	avg total: 7.9	over / under: +$90 / -$325	ROI: +3.2% / -11.4%

17-7 (1.92, 70.8%)	avg line: -142.2 / 132.2	on / against: +$783 / -$853	ROI: +22.8% / -35.5%
13-11 (0.42, 54.2%)	avg line: 117.5 / -127.7	on / against: +$368 / -$497	ROI: +15.3% / -16.2%
13-11-0 (0.60, 54.2%)	avg total: 8.1	over / under: +$75 / -$370	ROI: +2.9% / -13.9%

**sunshine11** · 05-26-14, 07:43 AM

HI Posey. Keep up the good work! I will be looking for your new thread. Good luck to you today!

**posey** · 05-26-14, 07:49 AM

Go with the Cardinals and M. Wacha

5-1 (2.00, 83.3%)	avg line: -155.0 / 142.1	on / against: +$340 / -$350	ROI: +36.6% / -58.3%
4-2 (0.50, 66.7%)	avg line: 150.0 / -163.0	on / against: +$419 / -$473	ROI: +69.8% / -48.4%
4-2-0 (0.00, 66.7%)	avg total: 7.0	over / under: +$180 / -$225	ROI: +26.7% / -34.9%

6-18 (-1.67, 25.0%)	avg line: 143.9 / -155.1	on / against: -$876 / +$806	ROI: -36.5% / +21.5%
11-13 (-0.17, 45.8%)	avg line: -154.9 / 142.6	on / against: -$969 / +$805	ROI: -26.1% / +33.5%
7-16-1 (-1.21, 30.4%)	avg total: 7.7	over / under: -$1,065 / +$820	ROI: -40.2% / +31.1%

45-13 (1.84, 77.6%)	avg line: -174.5 / 158.8	on / against: +$2,407 / -$2,569	ROI: +23.7% / -44.3%
34-24 (0.34, 58.6%)	avg line: 132.1 / -144.0	on / against: +$2,097 / -$2,473	ROI: +35.7% / -29.5%
26-28-4 (0.25, 48.1%)	avg total: 7.8	over / under: -$470 / -$150	ROI: -7.5% / -2.3%

**posey** · 05-26-14, 08:03 AM

Originally posted by sunshine11

HI Posey. Keep up the good work! I will be looking for your new thread. Good luck to you today!

Thanks.

Unfortunately I will have to start working again next monday as my vacation will be over, but I try to post at least a few queries e/d as far as possible.
My thread is already opened: http://forum.sbrforum.com/baseball-b...l#post21924423

**posey** · 05-26-14, 08:43 AM

Riding the Blue Jays

8-2 (2.40, 80.0%)	avg line: 102.3 / -112.3	on / against: +$680 / -$743	ROI: +65.2% / -63.5%
8-2 (2.70, 80.0%)	avg line: -111.2 / -103.0	on / against: +$719 / -$780	ROI: +51.5% / -58.0%
6-4-0 (0.10, 60.0%)	avg total: 8.7	over / under: +$155 / -$275	ROI: +14.0% / -25.0%

6-14 (-1.25, 30.0%)	avg line: 130.0 / -140.0	on / against: -$670 / +$610	ROI: -33.5% / +21.8%
10-10 (0.25, 50.0%)	avg line: -164.2 / 151.1	on / against: -$584 / +$458	ROI: -17.8% / +22.9%
11-7-2 (0.70, 61.1%)	avg total: 8.4	over / under: +$350 / -$545	ROI: +16.2% / -24.3%

1-9 (-3.70, 10.0%)	avg line: 136.5 / -147.5	on / against: -$805 / +$785	ROI: -78.2% / +52.1%
2-8 (-2.50, 20.0%)	avg line: -144.3 / 132.3	on / against: -$917 / +$839	ROI: -62.1% / +80.2%
6-4-0 (1.20, 60.0%)	avg total: 8.1	over / under: +$165 / -$275	ROI: +15.1% / -24.7%

**JMon** · 05-26-14, 10:41 AM

H and -175<=line<-130 and 5.2>=tA(runs)>=4.7 and o:STDSERA<=4.2 and o:conference=AL and p:runs+po:runs<=4 and total>7 and month!=9

observe the DAY parameter

**zorba74** · 05-26-14, 11:49 AM

Originally posted by JMon

H and -175<=line<-130 and 5.2>=tA(runs)>=4.7 and o:STDSERA<=4.2 and o:conference=AL and p:runs+po:runs<=4 and total>7 and month!=9

observe the DAY parameter

Good stuff. Thank you.

Why the exclamation point after month in "month!=9." What do you mean observe the DAY parameter as I don't see it in the query?

**emceeaye** · 05-26-14, 12:13 PM

previously posted query by someone else in this thread

team=Dodgers and season>=2011 and line<=-110 and p:margin>=5 and pp:margin<=5 and p:M6>=3

Although last two games went against team favored in this query, they have gone 8-4 overall this year, and since 2012, win percentage and ROI good

**JMon** · 05-26-14, 12:15 PM

You can filter out day and night games by using the parameter DAY or NGT. just type and DAY at the end of the query.

! = not, I wanted to omit Sept in my query.

**Alex Vaile** · 05-26-14, 12:34 PM

Thanks JMON looks great!

**green7** · 05-26-14, 01:14 PM

JMon, I'd say its about time you started trying in the MLB contest

........though having a 15-25 cent line makes things a bit tougher.

Good fortune today to all SDQLers today.

Found that all >=60% winning teams are -EV as favorites in almost every category I could query. Only time there was positive was as an away favorite after winning < 5 out of their last 10 games. Especially good versus those teams in April and May....

AF and tA(W)>=.6 and playoffs=0 and month

Going against home favorites >=60 WP was +EV too....most of all in May, April, June and September.

HF and tA(W)>=.6 and playoffs=0 and month

**nbilln** · 05-26-14, 01:36 PM

16-5 (1.24, 76.2%)	avg line: -138.8 / 126.5	on / against: +$924 / -$974	ROI: +31.0% / -45.1%
10-3 (0.27, 76.9%)	avg line: 144.8 / -160.0	on / against: +$1,184 / -$1,344	ROI: +87.7% / -64.9%
6-12-3 (-0.55, 33.3%)	avg total: 8.9	over / under: -$675 / +$545	ROI: -29.8% / +23.1%

wow look at this

**zorba74** · 05-26-14, 01:51 PM

Originally posted by JMon

You can filter out day and night games by using the parameter DAY or NGT. just type and DAY at the end of the query.

! = not, I wanted to omit Sept in my query.

Gotcha. Thank you very much. Not a complete newbie to the SDQL but not as advanced as you guys.

I figured that is what you meant by using the "DAY" parameter.... Trust but verify

**posey** · 05-27-14, 05:34 AM

23-7 (1.60, 76.7%)	avg line: -124.7 / 113.8	on / against: +$1,505 / -$1,585	ROI: +39.0% / -49.5%
11-13 (0.88, 45.8%)	avg line: 126.6 / -140.8	on / against: +$116 / -$287	ROI: +4.2% / -8.0%
13-17-0 (0.02, 43.3%)	avg total: 8.7	over / under: -$620 / +$335	ROI: -18.2% / +10.5%

11-2 since 2010.

**posey** · 05-27-14, 05:44 AM

7-24 (-1.81, 22.6%)	avg line: 133.5 / -145.7	on / against: -$1,505 / +$1,414	ROI: -48.5% / +31.1%
17-14 (-0.40, 54.8%)	avg line: -161.6 / 148.3	on / against: -$403 / +$250	ROI: -8.0% / +7.9%
12-17-2 (-0.34, 41.4%)	avg total: 8.2	over / under: -$645 / +$390	ROI: -19.1% / +11.4%

Take a look at 'season > 2010', too!

**posey** · 05-27-14, 05:57 AM

4-11 (-1.73, 26.7%)	avg line: 132.8 / -143.4	on / against: -$606 / +$566	ROI: -40.4% / +26.0%
7-8 (-0.23, 46.7%)	avg line: -170.2 / 156.4	on / against: -$642 / +$533	ROI: -25.1% / +35.5%
8-7-0 (0.80, 53.3%)	avg total: 7.2	over / under: +$15 / -$200	ROI: +0.9% / -12.1%