Giving this another shot

Forum: Systems & Strategies Page 3 of 19 «  1 2 3 4 5   »
Author: [Systems & Strategies] Topic: Giving this another shot
orhane PM orhane
Joined: Dec 2012
Posts: 234
 
orhane
Participation Meter
Prospect
Posted: 4/2/2014 7:58:07 AM
hi bcap do we need permission to get a look at your spreadsheet?
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/2/2014 8:41:24 AM
Orhan - I didn't intend for that to be the case, but I must have screwed up the link. Do you know how to make it accessible?

And I'll have a few more games today here in a little bit.
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/2/2014 8:43:41 AM
Never mind, I think this should work.

https://docs.google.com/spreadsheet/ccc?key=0ApLP376rI_G-dHZQZVdvRDJncDhlUFoyeElDaF9ya1E&usp=sharing
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/2/2014 8:57:51 AM
4/2/2014

April

Rockies +100 : 1 to win 1

Blue Jays +157 : 1 to win 1.57

Twins +123 : 1 to win 1.23

Rockies / Marlins O7 (-120) : 1.2 to win 1

Other

Braves +114 : 1 to win 1.14


YTD - 3-0-1 - +3.06 Units

BOL everybody.
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/2/2014 10:44:05 PM
4/2/2014

April

Rockies +100 : 1 to win 1  CA$H

Blue Jays +157 : 1 to win 1.57  CA$H

Twins +123 : 1 to win 1.23  LOSER

Rockies / Marlins O7 (-120) : 1.2 to win 1  CA$H

Other

Braves +114 : 1 to win 1.14  CA$H

4/2/2014 - 4-1 - +3.71 Units

YTD
- 7-1-1 - +6.76 Units

If the Twins hadn't given the Sox a few extra bases, we'd still be unbeaten. All plays also available on Twitter @Brian8CAP.
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/3/2014 11:17:34 AM
4/3/2014

April

Cubs +150 : 1 to win 1.5

Giants +107 : 2 to win 2.14

Royals +140 : 1 to win 1.4

Red Sox / Orioles O9 (+105) 1 to win 1.05

YTD - 7-1-1 - +6.76 Units
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/3/2014 10:23:25 PM
4/3/2014

April

Cubs +150 : 1 to win 1.5  CA$H

Giants +107 : 2 to win 2.14  CA$H

Royals +140 : 1 to win 1.4  RAIN

Red Sox / Orioles O9 (+105) 1 to win 1.05  LOSER

4/3 - 2-1-1 - +2.64 Units

YTD
- 9-2-2 - +9.40 Units - 65.3% ROI

Another good day for us. 81% winners so far on an average line of +115. 7-1 on the Dog sides. More winners for us in the morning.
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/4/2014 11:55:20 AM
4/4/2014

April

Brewers +145 : 1 to win 1.45

Giants +156 : 1 to win 1.56

Twins +170 : 1 to win 1.70

Marlins +105 : 1 to win 1.05

Cardinals +107 : 1 to win 1.07

Rangers +132 : 1 to win 1.32

Indians/Twins O8 : 1 to win 1.10

YTD - 9-2-2 - +9.40 Units - 65.3% ROI

BOL Everybody.
orhane PM orhane
Joined: Dec 2012
Posts: 234
 
orhane
Participation Meter
Prospect
Posted: 4/4/2014 12:29:04 PM
great job so far. i combine your picks with mine. if they go in the same direction.
Sammy116 PM Sammy116
Joined: Apr 2014
Posts: 12
 
Sammy116
Participation Meter
Prospect
Posted: 4/4/2014 1:06:03 PM
hey BCap...I just started following your system...its HOT!!!
Sammy116 PM Sammy116
Joined: Apr 2014
Posts: 12
 
Sammy116
Participation Meter
Prospect
Posted: 4/4/2014 1:06:36 PM
Is it only for Baseball?
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/4/2014 1:29:25 PM
I only post for baseball, but I have a few queries for NFL, NBA and NHL as well. I hope we can keep it going now that you've joined! GL
Sammy116 PM Sammy116
Joined: Apr 2014
Posts: 12
 
Sammy116
Participation Meter
Prospect
Posted: 4/4/2014 1:46:58 PM
OK great....excited for today's picks...
Sammy116 PM Sammy116
Joined: Apr 2014
Posts: 12
 
Sammy116
Participation Meter
Prospect
Posted: 4/4/2014 1:47:15 PM
Do you have spreadsheet for other sports?
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/4/2014 1:59:47 PM
No I just created that one a couple days ago to track these plays.
Buford1 PM Buford1
Joined: Aug 2009
Posts: 56
 
Buford1
Participation Meter
Prospect
Posted: 4/4/2014 3:10:18 PM
BCap,

Would you please explain what the exclamation points denote at the tail end of your April Dogs query?

I'm just starting to give SDQL a whack and can't find the answer in the manual.

Thanks.

Pat


BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/4/2014 9:29:35 PM
Yeah, sure Pat. That means all results except that number are returned. For instance, p:runs!=4 means the team didn't score 4 runs in the previous game.

The SDQL is such a useful and fun tool for handicapping. I hope you can find some gems!

Cap
Posted using a mobile device.
Danrules24 PM Danrules24
Joined: May 2012
Posts: 4439
 
Danrules24
Participation Meter
Veteran
Posted: 4/4/2014 10:41:26 PM

BCap, I'm trying to get my head around this SDQL stuff but just can't seem to get what I'm looking for. I'm trying to see the record of all Home Dogs when their opponent win % is .470 or less for 2013.

Any chance I can bother you to com up with that query? I think if I can see the string I canmakadjustments from there going foward.

jcpicos PM jcpicos
Joined: Dec 2010
Posts: 192
 
jcpicos
Participation Meter
Prospect
Posted: 4/4/2014 10:57:17 PM
nice work BCap ,thanks !!
pinch PM pinch
Joined: Mar 2011
Posts: 63
 
pinch
Participation Meter
Prospect
Posted: 4/4/2014 11:21:25 PM
good stuff b cap==good luck
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/4/2014 11:33:59 PM

BCap, I'm trying to get my head around this SDQL stuff but just can't seem to get what I'm looking for. I'm trying to see the record of all Home Dogs when their opponent win % is .470 or less for 2013.

Any chance I can bother you to com up with that query? I think if I can see the string I canmakadjustments from there going foward.



Yeah Dan, here's what you can do:
HD and o:WP<=47 and season=2013

But reading your question again I think maybe you are asking about this season, 2014? If so I think the only thing you can do is make yourself a list of all the teams that went .470 or lower last season. Then input something like this "team=Astros and AF" This will give you all the games where the Astros are road favs, which is the same as finding a home dog to a .470 or lower team from the previous year. You can make that query for all the teams on your list, then bookmark each individual page for easy access.

I don't think you can reference the previous season in a query, but I may be wrong. Hopefully this helped! BOL in your searching!
BCap888 PM BCap888
Joined: Apr 2012
Posts: 820
 
BCap888
Participation Meter
Rookie
Posted: 4/4/2014 11:39:09 PM
4/4/2014

April

Brewers +145 : 1 to win 1.45  CA$H

Giants +156 : 1 to win 1.56  CA$H

Twins +170 : 1 to win 1.70  LOSER

Marlins +105 : 1 to win 1.05  CA$H

Cardinals +107 : 1 to win 1.07  LOSER

Rangers +132 : 1 to win 1.32  LOSER

Indians/Twins O8 : 1 to win 1.10 CA$H

4/4 - 4-3 - +2.16 Units

YTD
- 13-5-2 - +11.56 Units - 54% ROI

Always scary when you have that many underdogs going on one day, but we managed another +.500 day. Built up a nice cushion to protect against that one bad day we all have, which is nice. More winners in the morning.
Danrules24 PM Danrules24
Joined: May 2012
Posts: 4439
 
Danrules24
Participation Meter
Veteran
Posted: 4/5/2014 1:54:40 AM
Thanks BCap, the 2013 info is what I needed and has given me a good start to search things. That specific query worked. Wasn't great results but the query worked!
Buford1 PM Buford1
Joined: Aug 2009
Posts: 56
 
Buford1
Participation Meter
Prospect
Posted: 4/5/2014 4:06:06 AM
QUOTE Originally Posted by BCap888:

Yeah, sure Pat. That means all results except that number are returned. For instance, p:runs!=4 means the team didn't score 4 runs in the previous game.


Thank You, Sir.

Appreciate it.

Pat


1958a PM 1958a
Joined: Apr 2008
Posts: 142
 
1958a
Participation Meter
Prospect
Posted: 4/5/2014 7:18:32 AM
Thank you
Forum: Systems & Strategies Page 3 of 19 «  1 2 3 4 5   »
You have entered the forum as a GUEST. 
You must login/register to post or reply.