MLB - Situation Plays - SDQL

[Mako-SBR]

click on "my contests" top right of screen

You and figgy aren't foolin' around in there, 8+ picks per day, wow...

[b1slickguy]

Look how AL home favs do after a big win shutout in series game 2 or 3.

HF and p:margin > 7 and op:runs = 0 and (SG=2 or SG=3) and conference = AL

Royals winners of 5 straight.

[figue]

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

3-0 yesterday
today reds,mariners,brewers,angels

18-10 (0.57, 64.3%)

avg line: 109.5 / -119.5

on / against: +$988 / -$1,168

ROI: +35.3% / -34.8%

2-0 today

[JMon]

2-0 today

fig why is this trending now?

[figue]

fig why is this trending now?

sorry ,dont understand the question ,what you mean ??

[Roadkill86]

team=Tigers and day=Saturday and site=home and season>2011 and p:L

parlay the Tigers with the under anyone?

H and 9 < p:margin and WP <= 50 and -200 < line <-105 and o:WP >50
I don't know when the site loads the next day's games, but I expect this query to indicate a bet on the Rays tomorrow

[green7]

Good luck today guys.

[JMon]

Sunday Easter Total

H and 10>=total>=8.5 and 54>=WP>=51 and o:WP<50 and day=Sunday and 2009<=season

[JMon]

starter='Homer Bailey' and F and S:W and 2011<=season and So:runs>0 and o:team=Cubs

[green7]

The text of this is not totally copying and pasting.

1) Home Favorite
2) AL Conference game
3) April
4) DAY game
5) Total between 7.5 and 9.5

HF and conference=AL and DAY and month=4 and
9.5>total>7.5

[tarosill]

This query gives the actual schedule along with some basic informations.

start time as Time, o:team as Away Team, o:line as Away Line, o:streak as Streak, team as Home Team, line as Home Line, streak as Streak@date=today and H

I found it useful especially when I want to know if the sports database is up to date.

[figue]

we do it again 2-1 ML dogs 3-0 RL
19-3 last 4 days ML/RL

[Coach Potato]

Can someone explain wats going on in this thread? LOL

[emceeaye]

already obvious or useful nonetheless?

A and 2009<=season and 150<=line and p:runs>=9 and WP<48 and o:WP>=59

Is this query supporting a play on Detroit, even though the heavy favorite, useful?

[Meestermike]

A and 2009<=season and 150<=line and p:runs>=9 and WP<48 and o:WP>=59

Is this query supporting a play on Detroit, even though the heavy favorite, useful?

Yes the query play is on DET but IMO at -200, not a wise play financially.

[Meestermike]

Can someone explain what's going on in this thread? LOL

This thread is absolutely full of scenarios and situation plays based on the sdql database. These are based on past performance in most ways. Historically they have proven to be a great eye opener when handicapping games but are not meant as a blind play or play against. Tools of the trade so to speak and very useful in decision making.

[Roadkill86]

team=Tigers and site=home and o:team=White Sox and starter=Justin Verlander

For Tuesday. Carefully review the run line ROI.

[emceeaye]

team=Tigers and site=home and o:team=White Sox and starter=Justin Verlande
For Tuesday. Carefully review the run line ROI.

Yes, but more importantly, pay more careful attention to the small.sample size.

[JMon]

Total play

-105 <line and line<180 and division=o:division and p:runs>0 and (month=4 or month=5 or month=9 or month=10) and team=Rockies and H and o:team=Giants

[Roadkill86]

Yes, but more importantly, pay more careful attention to the small.sample size.

Thanks, professor. Exactly how many home starts should a guy have vs. a particular opponent before you start drawing conclusions? When I posted this, the line hadn't been released yet, and at -115, the value isn't there like it'd be at +1xx. In any event, I found it interesting that it's almost never a tight victory when Verlander pitches at home vs. the Sox. Do as you will.

[emceeaye]

Total play

-105 <line and line<180 and division=o:division and p:runs>0 and (month=4 or month=5 or month=9 or month=10) and team=Rockies and H and o:team=Giants

Thanks Jmon,

The query gave an error...Do you happen to have the full query?
Thanks in advance.

[Tillos]

From the SDQL e-mail

When Verlander starts the Tigers are 10-0 since July 09 at home vs a team that has won at least their last two games and its not the 1st game of the series.

With Sale out, and the White Sox cashing as big dogs yesterday, I like the Tigers runline tonight

[Tillos]

Ok so I hate Danny Salazar, he's allowing batters to bat .345 and has an era over 7...but line movement is still favoring Cleveland. Kind of turning my head when Shields is on the mound for KC. Love this sdql though

WP>49 and A and o:STDSERA>7.00 and o:WP<50 and total<8 and season>=2012

[Tillos]

Last one

line<-105 and p:HW and p:hits>8 and o:STDSERA>7.00 and op:L and total<8.5 and season>=2009

[JMon]

Total play

-105 <line and line<180 and division=o:division and p:runs>0 and (month=4 or month=5 or month=9 or month=10) and team=Rockies and H and o:team=Giants

ugg..try again

180> line>-105 and division=o:division and p:runs>0 and (month=4 or month=5 or month=9 or month=10) and team=Rockies and H and o:team=Giants

[JMon]

Thanks Jmon,

The query gave an error...Do you happen to have the full query?
Thanks in advance.

damn interface...I fixed it. The original situation is w/o o:team=Giants.

[JR007]

......

[figue]

we do it again 2-1 ML dogs 3-0 RL
19-3 last 4 days ML/RL

any query better than this for april ??

4-1 today 8-2 ML/RL

26-13 (0.79, 66.7%)	avg line: 108.8 / -118.8	on / against: +$1,536 / -$1,796	ROI: +39.4% / -38.7%
32-7 (2.29, 82.1%)	avg line: -199.0 / 182.2	on / against: +$1,816 / -$1,931	ROI: +23.5% / -49.5%

[figue]

This thread is absolutely full of scenarios and situation plays based on the sdql database. These are based on past performance in most ways. Historically they have proven to be a great eye opener when handicapping games but are not meant as a blind play or play against. Tools of the trade so to speak and very useful in decision making.

“Study the past, if you would divine the future.”
~ Confucius

[Roadkill86]

any query better than this for april ??

4-1 today 8-2 ML/RL

26-13 (0.79, 66.7%)	avg line: 108.8 / -118.8	on / against: +$1,536 / -$1,796	ROI: +39.4% / -38.7%
32-7 (2.29, 82.1%)	avg line: -199.0 / 182.2	on / against: +$1,816 / -$1,931	ROI: +23.5% / -49.5%

Nope, That one was totally solid. I'm kicking myself for not ramping up my bet size, on those situations! Do have any encores for May planned?!?

[b1slickguy]

any query better than this for april ??

4-1 today 8-2 ML/RL

26-13 (0.79, 66.7%)	avg line: 108.8 / -118.8	on / against: +$1,536 / -$1,796	ROI: +39.4% / -38.7%
32-7 (2.29, 82.1%)	avg line: -199.0 / 182.2	on / against: +$1,816 / -$1,931	ROI: +23.5% / -49.5%

Great work, Figue!
Bringing them doggies home.
Good luck.

[Alex Vaile]

I would love to start researching these trends as well. It sounds like you guys found some very useful tools. Could someone please explain how a newbie could start accessing this info?

[green7]

Read through the threads, there are numerous explanations on how to go onto the the website to enter the angles mentioned above and there are many angles/trends that haved work very well historically...there is a way to save them on the website for you to enter in daily to see what plays are in play for that day.

[green7]

AD and day!= Saturday and day!= Sunday and SG=3 and month=4 and C and season>2008


The only time this hasn't worked well is when a team is off 2 consecutive away wins, which would filter out Texas, Houston, and the Phillies.

Biggest day of the season for me.

Good fortune.

[Alex Vaile]

Thanks for the info I'll give it a try. Is the worksheet available on this site?