MLB - Situation Plays - SDQL

[JMon]

what website do you get your stats from

w/o linking a site as per sbr, just google sdql

[JMon]

Want 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<9

[JR007]

I guess it depends on how well the situation had done in the past with a similar wind conditions. It appears to be more of a personal preference regarding a play or not.

think that would be a tough find, thanks for the winners today JMon

[JMon]

think that would be a tough find, thanks for the winners today JMon

across the street they have wind parameters per stadium..or at least they used too.

[Capper1124]

[MarcM_Flynn]

w/o linking a site as per sbr, just google sdql

thanks

[Allsportscapper]

how do i understand what the play is

[Roadkill86]

I 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 >= 2008

[nash13]

I 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.75

[JR007]

I 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.75

.....so do you think that the -150 and under would be not worth it

[nash13]

no these are avg odds. some of them are higher some lower. mosty favs though.

[JMon]

Tuesday 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 play

[Mako-SBR]

I 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 >= 2008

Nice, any excuse to take a dog in April is a good one.

Tuesday 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 play

Like this one as well buddy, thanks for sharing. MLB has been a learning experience thus far, first time I've ever bet the sport as I usually stick to NFL/NBA. If I see anything out there or piece anything together I'll post it in the thread asap.

[figue]

o:run line>170 and line>100 and season=2014 and month=4

st louis ,colorado.

[JMon]

I 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 >= 2008

[JMon]

Noticed some of my situations I post here are being saved in the KS database..I hope they are coming to good use

[Nick Nacho]

What is SDQL-based research? How can I learn about this? I'm confused about this whole thing

[JMon]

Contrarian 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=AL

[zert]

Has anybody been tracking the plays they give out on their website?

[JMon]

Check 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<=season

[emceeaye]

clarify 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.

[TCU]

Check 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<=season

How do you get it to show run line ROI? It would've cashed 10/14.

[JMon]

How do you get it to show run line ROI? It would've cashed 10/14.

I 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%

[JMon]

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.

line<=-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.

[19th Hole]

Contrarian 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=AL

~~~~~~~~~~~~~~~~~~~~~~~~``
JMON
This play comes up as Sept 27, 2013 when processed??
Did I do something wrong...

Thank you very much.

[JMon]

~~~~~~~~~~~~~~~~~~~~~~~~``
JMON
This play comes up as Sept 27, 2013 when processed??
Did I do something wrong...

Thank you very much.

it was on Tor, which was PPD.

[19th Hole]

it was on Tor, which was PPD.

Okay
Thank You...

[emceeaye]

line<=-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.

Thanks for your help Jmon.

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.

[nash13]

Has anybody been tracking the plays they give out on their website?

i do in my google doc

[figue]

o:run line>170 and line>100 and season=2014 and month=4

oak sea atl pit

[zert]

Is it ok to look at your google document? Or is it some kind of private thing? thanks

[emceeaye]

legitimate?

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.

[JR007]

unders, unders, unders, on getaway games...no brainer on the Phillies today...they are in Colorado tomorrow night, fast paced game.....

[green7]

HD 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%

[JMon]

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.

I would google "trend analysis" as one would see in investment/stock reason. Much of what sdql users do is exactly what trend analysis is; using past results to predict future outcomes. Perhaps no rhythm or reason, things trend; either short, intermediate or long. Finding a trend before it trends and stopping before it regresses it what is problematic and certainly takes an eye of practice to see. Thus becomes second nature if practiced enough. For example, on the trend you posted above, if you followed and won three times in the start of 2013, then lost two times; would it be wise to monitor the trend before playing it again? Your investment has paid off going 3-2. If it continues to lose...move on.

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.