Giving this another shot

Here is my favorite playoff system for you guys. Not really relevant now but when the time comes it''ll be good for a couple units.

playoffs=1 and D and 55.03<WP<63 and SG<5 and -4<o:streak<6 and -2<streak<8 and -9<p:margin<7 and 105<line<145 and p:HR<3 and po:HR<4 and o:rest<5 and 2<starter rest<14 and s:SHRA<3 and 0<s:SHA and s:SSO<11 and os:SHRA<3 and os:SSO<11

It's 46-12 on DOGS, and amazingly it's 23-6 in each league. Hasn't had a losing postseason in the history of the database.

And my other one:

playoffs=1 and D and -2<streak<3 and 0<p:runs<7 and league=NL and -5<site streak<9 and total<10 and line<180 and starter rest<18 and matchup wins<10 and matchup losses<7 and date>20061014

Since Oct. 14, 2006 we have a 30-5 record on DOGS for a 97.9% ROI.
4-1 last season including the Michael Wacha vs. Clayton Kershaw 9-0 win by the Cardinals as underdogs.

Getting super hyped for the season to start!

great work. i am pumped as well. twitter isn't active yet?

btw here are my picks based on sdql trends

https://docs.google.com/spreadsheets/d/1OzPC3WmCK6UgZVY-aLaoSkH3L9VjaAKa5Rtqky7OY4w/edit#gid=0

I'm just going to wait until the season starts. After that I'll probably post a few times a day.

Nice, I'm going to set up something very similar to that if I can figure out how haha.

i posted new picks. if anyone is interested. or maybe i should start another thread, not to occupy yours.

Hey BCAP how the F do i sdql for "home favorite after under dog loss on the road of 3 of more games"  And also .Home favorite after underdog loss , and home favorite that was a underdog losser on the road and now just lost their first game at home as a fave .... So basically what I am saying . What is the sdql for a team that came home after a road trip as a dog in their last game, is now a fav and lost the first game as a fav.. I would like the results or query for those stats.. I am sure they are very good..

"home favorite after under dog loss on the road of 3 of more games"

HF and p:DL and p:A and pp:A and ppp:A and SG=1

I believe that's the one you were asking for with the first one.

"And also .Home favorite after underdog loss"

HF and p:DL

"and home favorite that was a underdog losser on the road and now just lost their first game at home as a fave"

HF and pp:ADL and SG=2 and p:HFL and ppp:A and pppp:A

If you pick your spots with the last one you can make some money, but blindly betting them wouldn't have been profitable.

I hope that's what you were looking for, if not send me a message and I can work on it for you.

April

Indians +122 - 1 to win 1.22

Braves +106 - 1 to win 1.06

Other

Marlins +100 - 1 to win 1

Padres / Dodgers U6.5 (-120) - 1.2 to win 1

Away we go. Let's cash some tickets everybody. BOL

4/1/2014

April

Indians +122 - 1 to win 1.22  RAIN

Braves +106 - 1 to win 1.06  CA$H

Other

Marlins +100 - 1 to win 1  CA$H

Padres / Dodgers U6.5 (-120) - 1.2 to win 1  CA$H

Don't get much better than that!

4/1/2014

3-0-1
+3.06 Units

Here is the link to my spreadsheet to track results:

https://docs.google.com/spreadsheet/ccc?key=0ApLP376rI_G-dHZQZVdvRDJncDhlUFoyeElDaF9ya1E&usp=drive_web#gid=0

See you in the morning if I have anything pop up.

good work

I believe you pushed on the Marlins so 2-0-1

Never mind it looks like your laying -1 but I don't  think you are. Nice day! 

Yeah that's oddly formatted, I'll fix that next time. Thanks.

RD and series game=3 and p:L and pp:L and SWHIP<1.2 and season

short but sweet. high volume, consistent winners across ml, rl and under. doesn't get much better than this :)

love this thread bcap, ive been using sdql in nba with mixed results, but im ready to own some bases this year. ill drop any goodies I come across in here

RD and series game=2 and p:L and pp:L and SWHIP<1.2 and season

RD and series game=1 and p:L and pp:L and SWHIP<1.2 and season

wow

MakeItRain - I'm not absolutely sure about this but I believe the "SWHIP" function refers to the starting pitcher's WHIP in the current game. So if his WHIP is less than 1.2 in the given game then the team is probably going to win and there's a good chance of very few runs being scored. Again, I don't know for certain, and if I'm wrong I'll be the first to point it out, but I don't think you'll get any active plays with this, as they will only show up after the game has been played.

And actually having looked at it if you query "D and SWHIP<1.2" you get some crazy results. 62% winners. I'm fairly sure if the SWHIP<1.2 was referring to the starter's WHIP on the season this system would be much more average.

Thanks for the support though, man!

There's seems to be something off in regards to those query results.  RD stands for road dog, I presume.  So the wins that show up should all be road dogs, correct?  Well, that's not the case.  I would say close to half the winners are favorites, mixed in with home and away.  Shouldn't all the winners be road dogs with those queries? 

yep, numbers were too good to be true

some fave RL action here

AD and STDSERA<3 and os:BS

yeah, RD was supposed to reference road dog, when the correct reference is AD. also the whip stats were for that game only...