MLB - Situation Plays - SDQL
Collapse
X
-
JMonSBR Hall of Famer
- 12-11-09
- 9800
#211Comment -
JMonSBR Hall of Famer
- 12-11-09
- 9800
#212Want to play against a conference AL road team ave 4.7 runs or less a game off two losses of 4 or more. Look how team=Royals do in this situation.
A and 165>=line>=-125 and tA(runs)<=4.7 and conference=AL and p:margin<=-4 and pp:margin<=-4 and rest=0 and (SG=1 or SG=3) and conference=o:conference and month<9Comment -
JR007SBR Hall of Famer
- 02-21-10
- 5279
-
Capper1124SBR MVP
- 11-23-13
- 1914
#215Comment -
AllsportscapperSBR Sharp
- 12-12-13
- 275
#217how do i understand what the play isComment -
Roadkill86SBR High Roller
- 02-18-13
- 138
#218I think I'm getting the hang of this...
tA(runs) >= 3.7 and oA(runs) <= 3.8 and conference = AL and o:conference = AL and month=4 and SG=2 and -105 < line < 170 and season >= 2008Last edited by Roadkill86; 04-15-14, 08:53 AM.Comment -
nash13SBR MVP
- 01-21-14
- 1122
#219I had an interesting observation. Most of the plays we generate are based on Dog Wins. So these are predicting highly value on one side. As the averrages would show us that still Favs are winning too, reverse strategy would be to bet the games left out on the Favs to win.
I tried it with my MLB plays.
55 W - 32 L so far
+8.69 Units
on averrage odds of 1.75Comment -
JR007SBR Hall of Famer
- 02-21-10
- 5279
#220I had an interesting observation. Most of the plays we generate are based on Dog Wins. So these are predicting highly value on one side. As the averrages would show us that still Favs are winning too, reverse strategy would be to bet the games left out on the Favs to win.
I tried it with my MLB plays.
55 W - 32 L so far
+8.69 Units
on averrage odds of 1.75Last edited by JR007; 04-15-14, 12:39 PM.Comment -
nash13SBR MVP
- 01-21-14
- 1122
#221no these are avg odds. some of them are higher some lower. mosty favs though.Comment -
JMonSBR Hall of Famer
- 12-11-09
- 9800
#222Tuesday Night Over
A and 9 >= total >= 8.5 and tA(o:runs) <= 3.7 and conference = AL and day = Tuesday
Want a road AL team, with a total of 9-8.5; that allows less than 3.7 runs a game. High total, but allow less than 3.7, hmmm
gl if you chose to playComment -
Mako-SBRSBR Sharp
- 10-15-13
- 492
#223
Comment -
figueSBR MVP
- 07-23-10
- 2524
#224o:run line>170 and line>100 and season=2014 and month=4
st louis ,colorado.Comment -
JMonSBR Hall of Famer
- 12-11-09
- 9800
#226Noticed some of my situations I post here are being saved in the KS database..I hope they are coming to good useComment -
Nick NachoSBR High Roller
- 04-14-14
- 144
#227What is SDQL-based research? How can I learn about this? I'm confused about this whole thingComment -
JMonSBR Hall of Famer
- 12-11-09
- 9800
#228Contrarian fav; playing on a road AL fav, with a starter having a high season to date era; against a conference oppt.
A and -110>line>-165 and conference=o:conference and 5.7>=STDSERA>=5.2 and conference=ALLast edited by JMon; 04-16-14, 07:58 AM.Comment -
zertSBR MVP
- 09-22-09
- 1274
#229Has anybody been tracking the plays they give out on their website?Comment -
JMonSBR Hall of Famer
- 12-11-09
- 9800
#230Check out how the Braves do since 2009 after scoring 8 or more runs in their past two games.
team=Braves and p:runs>=8 and pp:runs>=8 and 2009<=seasonComment -
emceeayeSBR Wise Guy
- 08-20-13
- 704
#231clarify correct terms of query
Hi SDQL experts,
I'm trying to create a query to determine how the diamondbacks do as a home favorite with a line of -130 or lower after a 5-game losing streak since 2004. Can someone please clarify if the below query correctly expesses the above criteria?
HF and team=Diamondbacks and date>=20040801 and line<=-130 and streak>=-5.
If not, what am I missing? When I say -130 or lower I'm trying to say "a favorite of -130 or better".
Thanks in advance.Comment -
JMonSBR Hall of Famer
- 12-11-09
- 9800
#233I guess I'm not sure what you are asking all queries show a ML and RL ROI in MLB
13-1 (3.64, 92.9%) avg line: -136.8 / 123.4 on / against: +$1,220 / -$1,240 ROI: +60.4% / -84.9% 10-4 (2.36, 71.4%) avg line: 126.3 / -138.7 on / against: +$869 / -$959 ROI: +59.9% / -46.1% 7-5-2 (0.29, 58.3%) avg total: 8.4 over / under: +$155 / -$265 ROI: +10.1% / -17.1% Comment -
JMonSBR Hall of Famer
- 12-11-09
- 9800
#234Hi SDQL experts,
I'm trying to create a query to determine how the diamondbacks do as a home favorite with a line of -130 or lower after a 5-game losing streak since 2004. Can someone please clarify if the below query correctly expesses the above criteria?
HF and team=Diamondbacks and date>=20040801 and line<=-130 and streak>=-5.
If not, what am I missing? When I say -130 or lower I'm trying to say "a favorite of -130 or better".
Thanks in advance.
line>=-130 (is a fav of no more than 130, but you may need to use the shortcut, F, if you don't want to capture the dogs). Note you have does this in your query by using, HF
If you want just a losing streak of 5, just use streak=-5, streak<=-5 would be a 5 or more game losing streak.Comment -
19th HoleSBR Posting Legend
- 03-22-09
- 18925
#235
JMON
This play comes up as Sept 27, 2013 when processed??
Did I do something wrong...
Thank you very much.Comment -
emceeayeSBR Wise Guy
- 08-20-13
- 704
#238line<=-130 (is a fav of 130 or more)
line>=-130 (is a fav of no more than 130, but you may need to use the shortcut, F, if you don't want to capture the dogs). Note you have does this in your query by using, HF
If you want just a losing streak of 5, just use streak=-5, streak<=-5 would be a 5 or more game losing streak.
This one night be of some use:
HF and date>=20040801 and line>=-132 and streak<=-5 and o:streak=2
If I knew how to add the correct terms to express that the opponent's last 8 games were Away, I would add it to see if it adds any more predictive value.Comment -
figueSBR MVP
- 07-23-10
- 2524
#240o:run line>170 and line>100 and season=2014 and month=4
oak sea atl pitComment -
zertSBR MVP
- 09-22-09
- 1274
#241Is it ok to look at your google document? Or is it some kind of private thing? thanksComment -
emceeayeSBR Wise Guy
- 08-20-13
- 704
#242legitimate?
SDQL experts,
What do you think of the following query that was among the trends listed on that website?
team=Royals and date>=20100709 and NGT and A and 6<=p:runs and p:NGT
Although by surface examination it looks useful, when you remove the terms "team=Royals" and add that the team is an away favorite ("AF") instead of just playing away ("A"), the SU effect disappears. Based on intuition, doesn't it seem like having an away night game and coming off a night game in which the team scored at least 6 runs would yield the same effect regardless of the team? Why would this only be true of the Royals? Also, shouldn't the fact that Royals are the favorites interfere with the reliability of the query above?
It would be great to get your thoughts on this.Comment -
JR007SBR Hall of Famer
- 02-21-10
- 5279
#243unders, unders, unders, on getaway games...no brainer on the Phillies today...they are in Colorado tomorrow night, fast paced game.....Comment -
green7SBR High Roller
- 10-21-10
- 190
#244HD and tA(W)<.42 and month<7 and C and division!=o:division and NGT and SG = 3
SU: 34-30 (-0.23, 53.1%)
avg line: 125.3 / -136.0
on / against: +$1,272 / -$1,652
ROI: +19.9% / -19.0%
RL: 28-22 (0.68, 56.0%)
avg line: -138.2 / 126.1
on / against: -$199 / -$92
ROI: -2.9% / -1.8%
OU: 28-34-2 (0.14, 45.2%)
avg total: 8.6
over / under: -$880 / +$260
ROI: -12.7% / +3.6%Comment -
JMonSBR Hall of Famer
- 12-11-09
- 9800
#245SDQL experts,
What do you think of the following query that was among the trends listed on that website?
team=Royals and date>=20100709 and NGT and A and 6<=p:runs and p:NGT
Although by surface examination it looks useful, when you remove the terms "team=Royals" and add that the team is an away favorite ("AF") instead of just playing away ("A"), the SU effect disappears. Based on intuition, doesn't it seem like having an away night game and coming off a night game in which the team scored at least 6 runs would yield the same effect regardless of the team? Why would this only be true of the Royals? Also, shouldn't the fact that Royals are the favorites interfere with the reliability of the query above?
It would be great to get your thoughts on this.
Other sdql users use it merely on logic, and pay no attention to trending situations as what you posted. It's a personal preference. I use both and have success at both.Last edited by JMon; 04-17-14, 04:39 PM.Comment
SBR Contests
Collapse
Top-Rated US Sportsbooks
Collapse
#1 BetMGM
4.8/5 BetMGM Bonus Code
#2 FanDuel
4.8/5 FanDuel Promo Code
#3 Caesars
4.8/5 Caesars Promo Code
#4 DraftKings
4.7/5 DraftKings Promo Code
#5 Fanatics
#6 bet365
4.7/5 bet365 Bonus Code
#7 Hard Rock
4.1/5 Hard Rock Bet Promo Code
#8 BetRivers
4.1/5 BetRivers Bonus Code