Giving this another shot

Forum: Systems & Strategies Page 2 of 19 «  1 2 3 4 5   »
Author: [Systems & Strategies] Topic: Giving this another shot
BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 3/29/2014 7:22:48 PM
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.
BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 3/29/2014 7:28:43 PM
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!
orhane PM orhane
Joined: Dec 2012
Posts: 234
 
orhane
Participation Meter
Prospect
Posted: 3/29/2014 7:56:21 PM
great work. i am pumped as well. twitter isn't active yet?
orhane PM orhane
Joined: Dec 2012
Posts: 234
 
orhane
Participation Meter
Prospect
Posted: 3/29/2014 8:01:34 PM
btw here are my picks based on sdql trends
orhane PM orhane
Joined: Dec 2012
Posts: 234
 
orhane
Participation Meter
Prospect
Posted: 3/29/2014 8:01:44 PM
https://docs.google.com/spreadsheets/d/1OzPC3WmCK6UgZVY-aLaoSkH3L9VjaAKa5Rtqky7OY4w/edit#gid=0
BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 3/29/2014 8:05:12 PM
I'm just going to wait until the season starts. After that I'll probably post a few times a day.
BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 3/29/2014 8:11:42 PM
Nice, I'm going to set up something very similar to that if I can figure out how haha.
Bart_ PM Bart_
Joined: Mar 2008
Posts: 3547
 
Bart_
Participation Meter
Veteran
Posted: 3/29/2014 9:12:02 PM
QUOTE Originally Posted by orhane:

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

cool

orhane PM orhane
Joined: Dec 2012
Posts: 234
 
orhane
Participation Meter
Prospect
Posted: 3/30/2014 11:49:54 AM
i posted new picks. if anyone is interested. or maybe i should start another thread, not to occupy yours.
Knoxpoker PM Knoxpoker
Joined: Dec 2011
Posts: 1244
 
Knoxpoker
Participation Meter
Veteran
Posted: 3/30/2014 11:58:34 AM
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..
BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 3/30/2014 9:43:32 PM
"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.
BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 4/1/2014 11:01:18 AM
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
BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 4/1/2014 10:58:37 PM
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.
orhane PM orhane
Joined: Dec 2012
Posts: 234
 
orhane
Participation Meter
Prospect
Posted: 4/1/2014 11:14:58 PM
good work
JEFFTHEHAT PM JEFFTHEHAT
Joined: Aug 2010
Posts: 3843
 
JEFFTHEHAT
Participation Meter
Banned
Posted: 4/2/2014 12:03:19 AM
I believe you pushed on the Marlins so 2-0-1
JEFFTHEHAT PM JEFFTHEHAT
Joined: Aug 2010
Posts: 3843
 
JEFFTHEHAT
Participation Meter
Banned
Posted: 4/2/2014 12:05:07 AM
Never mind it looks like your laying -1 but I don't  think you are. Nice day! 
BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 4/2/2014 12:20:58 AM
Yeah that's oddly formatted, I'll fix that next time. Thanks.
Posted using a mobile device.
MakeItRain88 PM MakeItRain88
Joined: Jan 2014
Posts: 11
 
MakeItRain88
Participation Meter
Prospect
Posted: 4/2/2014 1:11:25 AM

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

MakeItRain88 PM MakeItRain88
Joined: Jan 2014
Posts: 11
 
MakeItRain88
Participation Meter
Prospect
Posted: 4/2/2014 1:22:15 AM
RD and series game=2 and p:L and pp:L and SWHIP<1.2 and season
MakeItRain88 PM MakeItRain88
Joined: Jan 2014
Posts: 11
 
MakeItRain88
Participation Meter
Prospect
Posted: 4/2/2014 1:25:32 AM

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

wow

BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 4/2/2014 2:39:55 AM
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.
BCap888 PM BCap888
Joined: Apr 2012
Posts: 822
 
BCap888
Participation Meter
Rookie
Posted: 4/2/2014 2:46:09 AM
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!
bruin95 PM bruin95
Joined: Mar 2001
Posts: 376
 
bruin95
Participation Meter
Prospect
Posted: 4/2/2014 3:14:31 AM
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? 
MakeItRain88 PM MakeItRain88
Joined: Jan 2014
Posts: 11
 
MakeItRain88
Participation Meter
Prospect
Posted: 4/2/2014 3:18:55 AM

yep, numbers were too good to be true

some fave RL action here

AD and STDSERA<3 and os:BS

MakeItRain88 PM MakeItRain88
Joined: Jan 2014
Posts: 11
 
MakeItRain88
Participation Meter
Prospect
Posted: 4/2/2014 3:20:36 AM
yeah, RD was supposed to reference road dog, when the correct reference is AD. also the whip stats were for that game only... 
Forum: Systems & Strategies Page 2 of 19 «  1 2 3 4 5   »
You have entered the forum as a GUEST. 
You must login/register to post or reply.