MLB - Situation Plays - SDQL

[Emancipator]

10>=total>=8.5 and Sum(hits@team and season)/Sum(at bats@team and season)<=265 and o:STDSERA<=3.5 and o:conference=AL and s:SWA>=4 and ss:SWA>=4 and 20100828<=date

I was liking that under anyways, gonna put something on it now.

[JMon]

To add to the Det/Twins play, look and see how the twins fair

H and -130<=line<=180 and sA(SHA)>=7 and month=4 and 2005<=season and conference=o:conference and total<10

[Mako-SBR]

Fade a team where the starting pitcher is an away favorite, and won his last outing while striking out 10 or more batters.

played around with one a bit...never a losing season in DB..nice find!

s:SO > 9 and s:W and A and season > 2005 and -185 <= line <= -110 and conference = o:conference and starter rest < 10 and rest = 0 and SG<3 and month<9 and 10>=total>=7.5

Good job guys, very nice. J you sharpened that one up big time...

[JMon]

starter='Paul Maholm' and o:conference=NL and oA(runs)>=5.3

Maholm against NL teams ave 5.3 runs or more. (total)

[JR007]

appreciate all the help guys, and your willingness to share, not trying to be a dick, and please to not take this the wrong way....
could you give an overview of your plays to date....not looking for exact numbers, but a general drift so to speak, are totals doing better than sides dogs better than favs, runlines ???...I know it depends on the querys used, but as in any other kind of system.....you would have to measure it's effectiveness by it's results....thanks....would be helpful to your followers....

[JMon]

appreciate all the help guys, and your willingness to share, not trying to be a dick, and please to not take this the wrong way....
could you give an overview of your plays to date....not looking for exact numbers, but a general drift so to speak, are totals doing better than sides dogs better than favs, runlines ???...I know it depends on the querys used, but as in any other kind of system.....you would have to measure it's effectiveness by it's results....thanks....would be helpful to your followers....

I only spot play in here, mainly try to help with different kinds of sdql queries. I play more dogs, than favs or totals. I'm a volume player in bases currently have played 170 plays (roughly 49-50% win rate) a little over 1 unit to date. Currently on a bad run losing 6.5 units in the last two weeks. This is normal for me though. I go on bad runs and heaters; thus money management is key for me. In the last three years, using solely sdql I have hit 30+ units each year in bases.

[Roadkill86]

Today is the biggest day of the month for Figue's April line (posted upthread). 5 plays ATM.

[Alex Vaile]

Could u please point out which games those 5 are based on Figues trend. I played that twins one from yesterday but it didn't pan out too well.
So it's looking for a run line greater than 170 and line greater than 100 correct?

[Alex Vaile]

I found Marlins, reds, and rockies is that correct?

[Roadkill86]

That's the one. Though the lines keep moving and changing what the plays are. So, this may be one of those things where it pays to wait until game time.

[Alex Vaile]

Ok cool thanks. I am very interested in learning more about these things. Good luck

[green7]

tA(BPRA) < oA(BPRA) and HD and division=o:division and tA(runs) > oA(runs) and game number>10 and C and total>7

[Roadkill86]

p:runs<4 and pp:runs<4 and ppp:runs<4 and pppp:runs<4 and op:runs<4 and opp:runs<4 and oppp:runs<4 and opppp:runs<4 and total>7

Under in PIT@STL

[Mako-SBR]

p:runs<4 and pp:runs<4 and ppp:runs<4 and pppp:runs<4 and op:runs<4 and opp:runs<4 and oppp:runs<4 and opppp:runs<4 and total>7

Slight tweak:

p:runs<4 and pp:runs<4 and ppp:runs<4 and pppp:runs<4 and op:runs<4 and opp:runs<4 and oppp:runs<4 and opppp:runs<4 and total>8

0-20-2 (-3.14, 0.0%) avg total: 8.8 over / under: -$2,050 / +$2,000 ROI: -91.1% / +77.2%

Nice RK, would play it.

[JMon]

nice work guys

poor BA, with a solid pitcher era; against a solid BP

A and 10 >= total >= 7 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.33 and conference = NL and Sum(hits@team and season) / Sum(at bats@team and season) <= .250 and o:conference = NL and STDSERA <= 2.70 and 2011<=season and SG!=2

[Alex Vaile]

1 and 3 today on Figues road dog trend

[Roadkill86]

Slight tweak:

p:runs<4 and pp:runs<4 and ppp:runs<4 and pppp:runs<4 and op:runs<4 and opp:runs<4 and oppp:runs<4 and opppp:runs<4 and total>8

0-20-2 (-3.14, 0.0%) avg total: 8.8 over / under: -$2,050 / +$2,000 ROI: -91.1% / +77.2%

Nice RK, would play it.

Ship it

[JMon]

After watching Danny Duffy's implosion last night I came up with this. Not active today, but very nice dog with big rewards . Fade home favs after two or more errors that went into extras innings.

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

[Meestermike]

p:runs<4 and pp:runs<4 and ppp:runs<4 and pppp:runs<4 and op:runs<4 and opp:runs<4 and oppp:runs<4 and opppp:runs<4 and total>7

Under in PIT@STL

Results are actually double because the database lists both home and away in results

[Meestermike]

Slight tweak:

p:runs<4 and pp:runs<4 and ppp:runs<4 and pppp:runs<4 and op:runs<4 and opp:runs<4 and oppp:runs<4 and opppp:runs<4 and total>8

0-20-2 (-3.14, 0.0%) avg total: 8.8 over / under: -$2,050 / +$2,000 ROI: -91.1% / +77.2%

Nice RK, would play it.

Results are actually double because the database lists both home and away in results

[Mako-SBR]

Results are actually double because the database lists both home and away in results

Yep, we're aware, but thx though.

[Mako-SBR]

Nothing showing for me today, no action. Anyone have anything they're looking at?

[Roadkill86]

If I'm concerned about counting the number of plays, that would matter. But my concern is ROI, so it makes no difference. DUCY?

[green7]

Anyone have a thread or a website that gives the formula for making a -1 line.....combining run line and money line? Thought I read a reference to it on this forum somewhere.

[JMon]

Anyone have a thread or a website that gives the formula for making a -1 line.....combining run line and money line? Thought I read a reference to it on this forum somewhere.

google this

bangthebook run line calculator

[cash$bro91]

Anyone have a thread or a website that gives the formula for making a -1 line.....combining run line and money line? Thought I read a reference to it on this forum somewhere.

http://forum.sbrforum.com/baseball-betting/484097-1-rl-calculator-spreadsheet.html

[green7]

Thanks Casb.

[green7]

AD and DIV and p:ADW and pp:ADW and DAY and p:margin=1 and series game=3

[JMon]

Under play [btwn 10-8] on Wednesday..after 6 straight games of interleague play in months (4,5,6) gl

H and 10 >= total >= 8 and day = Wednesday and p:conference != o:conference and p2:conference != o:conference and p3:conference != o:conference and p4:conference != o:conference and p5:conference != o:conference and p6:conference != o:conference and 2009<=season and month<7

[Alex Vaile]

Green 7 I was wondering what game your query refers to? Is it Milwaukee St louis?

[Alex Vaile]

And JMON I see the great info on the under play when I did the query. Unfortunately I don't know yet how to read the info to see which game or games it applies to. Could u please give me some insight on the play?

[green7]

The query showed that teams in the Brewers' situation had 11 wins and 32 losses.

[JMon]

And JMON I see the great info on the under play when I did the query. Unfortunately I don't know yet how to read the info to see which game or ga it applies to. Could u please give me some insight on the play?

the game will show active towards the bottom after the query is ran

[JMon]

Hammer play is active tonight. Post 280. Good luck if you play

[green7]

Rolling with you on the Marlins.

Nice query,...good fortune.