All Forums | Systems & Strategies

How do you cap your baseball games?

...
Participants:
Search model icon
Views: 5093
Posts: 79
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #26
Sorry never mind. There are to many #'s to do it. I'd be just as good typing or cut and paste. A real BIG THANKS!!!



 
Veteran
Participation Meter
Joined: Jul, 2002
Posts: 1799
Posted: #27
Thanks for the info guys
 
playing around with excel now and figuring out some great stuff
 
thanks!!!
 
 
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #28
No problem. If you find some good info not described in this thread please post.
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #29
I found that ESPN seems to have the best stats to load. I like USA todays stats but they must have them copy written. https://sports.espn.go.com/mlb/statistics
 
Veteran
Participation Meter
Joined: May, 2008
Posts: 1150
Posted: #30
hey all,
i have a couple of questions about handicapping and would love some input.
lan-you mentioned OBP (and SLG) needed to be analyzed by the right/left of the opposing starter.  it seems to me that home/away OBP (or OPS) are also very important.  would you just average those different filters or filter both criteria at the same time.  if this is the case, where can i find a site that i can do two filters at once?
i guess i will leave it at this for now.  thanks for any input from all.
 
Captain
Participation Meter
Joined: May, 2006
Posts: 6770
Posted: #31
Quote Originally Posted by str8_chaser:

hey all,
i have a couple of questions about handicapping and would love some input.
lan-you mentioned OBP (and SLG) needed to be analyzed by the right/left of the opposing starter.  it seems to me that home/away OBP (or OPS) are also very important.  would you just average those different filters or filter both criteria at the same time.  if this is the case, where can i find a site that i can do two filters at once?
i guess i will leave it at this for now.  thanks for any input from all.


Good question. I personally have never had anything but stellar results using the overall SLG and OBP of a player, keeping vs LHP and vs. RHP separate. Is it possible things might work even better by separating for road and home? Maybe, but I have had no issues and like you said, it's tough to find a site that filters both.
 
Captain
Participation Meter
Joined: May, 2006
Posts: 6770
Posted: #32
Quote Originally Posted by TheStugots:

Sorry never mind. There are to many #'s to do it. I'd be just as good typing or cut and paste. A real BIG THANKS!!!





So you are giving up on importing data into excel from web sites? If so, I really suggest you reconsider this for you own convenience.

I understand it is human nature to not want to mess with setting up the framework for importing data, but once you set it up, you will be so glad it did. When I first started capping baseball, I used to spend 8 hours a day on it. Now it's down to 1-3 hours. It's made the biggest difference. Good luck.
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #33
no not at all I set it up already. I have the formulas for my capping on one sheet of excel and my web query in another sheet. I was wanting to transfer a cell from one sheet to the other automatic somehow but I don't think what I wanted to do would be any easer. I much appreciate your help and I will give this refresh stats in excel a shot tomorrow. Thanks
 
Captain
Participation Meter
Joined: May, 2006
Posts: 6770
Posted: #34
Quote Originally Posted by TheStugots:

no not at all I set it up already. I have the formulas for my capping on one sheet of excel and my web query in another sheet. I was wanting to transfer a cell from one sheet to the other automatic somehow but I don't think what I wanted to do would be any easer. I much appreciate your help and I will give this refresh stats in excel a shot tomorrow. Thanks



 
Veteran
Participation Meter
Joined: May, 2008
Posts: 1150
Posted: #35
OPS on the road vs home is wildly different so it seems like it would be important to capping but i have not resolved how i would incorporate it.
also, do you guys use general ERA, sagarin ERA or home/away ERA differences between starters?
thanks for all the help.
btw, the importing stats to excel has been good but finding sites that have the exact stats i want is the difficult part.  again, thanks to all.
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #36
str8_chaser I use general ERA. and I'm using https://sports.espn.go.com/mlb/statistics It has all I am using.
 
Banned
Participation Meter
Joined: Jan, 2006
Posts: 249
Posted: #37
Great info guys, looks like my excel spreadsheet needs some major tweaking to get it to where it needs to be. Thanks again everyone!

 
Veteran
Participation Meter
Joined: May, 2008
Posts: 1150
Posted: #38
the espn stats page only list ~50 pitchers for each league and they are separated by pages.  how are you resolving this on the excel download?
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #39
My use for the pitching stats are minimal. So I didn't load any. I just use the stats from covers team match ups.
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #40
I take that back. I am now loading relievers from espn.com. From the home page click on MLB then click on teams then click on stats for whatever team then click on pitching then in the little drop down box to the right labeled (Splits) from here click on whichever one you need.

 
Veteran
Participation Meter
Joined: May, 2008
Posts: 1150
Posted: #41
i was hoping not to have to have a pitching sheet for every team but i guess that in the end that is better
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #42
You can load them on one sheet spread out. Or break them up in divisions. I'm splitting them American and National.
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #43
I'm sure there is a site out there that has it the way your looking for it. Just google baseball stats or what ever. It may be a lot of leg work but it should pay off.
 
Veteran
Participation Meter
Joined: Nov, 2007
Posts: 1339
Posted: #44
All of  a sudden I'm now getting a invalid web query. Anyone know about this. I'm down to my last 3 pitching staffs. What the f*%k?
 
Captain
Participation Meter
Joined: May, 2006
Posts: 6770
Posted: #45
Quote Originally Posted by str8_chaser:

OPS on the road vs home is wildly different so it seems like it would be important to capping but i have not resolved how i would incorporate it.
also, do you guys use general ERA, sagarin ERA or home/away ERA differences between starters?
thanks for all the help.
btw, the importing stats to excel has been good but finding sites that have the exact stats i want is the difficult part.  again, thanks to all.


Everyone should use XERA, but this will take some more time. ERA can be very skewed from bad defense and other variables. XERA weeds all of the crap out and can tell you whether a pitcher has been lucky or unlucky.

Also, about the web queries for pitchers, I personally have a web query for every single pitcher. For every individual game matchup, I put in the starting pitchers' names and do a vlookup from my web stats in another web sheet and "Bam!" all those pitchers stats pop up.

I know it might seem like a pain, but the more time you put in now for these shortcuts, the happer and quicker things will be later.
 
Captain
Participation Meter
Joined: May, 2006
Posts: 6770
Posted: #46
Quote Originally Posted by TheStugots:

All of  a sudden I'm now getting a invalid web query. Anyone know about this. I'm down to my last 3 pitching staffs. What the f*%k?


Make sure you clear the cache and cookies in Windows Explorer every time before you add web queries and/or refresh them. This will help a lot. Chances are, you will still get these errors, but some of them aren't anything.

I have to refresh my data three times at the beginning of the day to make sure all the queries are updated, but it's worth it. Good luck.
 
Veteran
Participation Meter
Joined: Jan, 2008
Posts: 1169
Posted: #47
Where do you find XERA stats at?
 
Captain
Participation Meter
Joined: May, 2006
Posts: 6770
Posted: #48
https://www.xera-baseball.com/Xstat.htm
 
Veteran
Participation Meter
Joined: Jul, 2002
Posts: 1799
Posted: #49
Lan
 
It seems as though you compare each player in a starting lineup to see how they do against lefty/righty with xera and ops?
 
so i would assume you wait unitl starting line ups are "announced" to really dig in and start your capping?
 
thanks...
 
 
 
 
Captain
Participation Meter
Joined: May, 2006
Posts: 6770
Posted: #50
Quote Originally Posted by LongTermProfits:

Lan
 
It seems as though you compare each player in a starting lineup to see how they do against lefty/righty with xera and ops?
 
so i would assume you wait unitl starting line ups are "announced" to really dig in and start your capping?
 
thanks...
 
 


I try to almost never a play a game until I see the starting lineups, correct.
All Forums | Systems & Strategies
About Us
Contact Us
Careers
Our Team
Brand
Testimonials
Betting Guides
Sportsbook Reviews
Sports Betting News
Podcasts
Responsible Gaming
Sports Betting
US Betting Sites
Canada Betting Sites
Canada Casinos
Best Betting Apps
Contests
Streak Survivor
King of Covers
Ultimate Race
Office Pools
The Covers community has
618,670
lifetime members worldwide
Covers 25 Years Logo Established in 1995,
Covers is the world
leader in sports
betting information.
Site Map Help Privacy Terms of Service youtube logo facebook logo twitter logo instagram logo linkedin logo google news logo
Covers is verified safe by: Evalon Logo GPWA Logo GDPR Logo GeoTrust Logo Evalon Logo
Copyright © 1995 - 2025 CS Media Limited All Rights Reserved.

If you choose to make use of any information on this website including online sports betting services from any websites that may be featured on this website, we strongly recommend that you carefully check your local laws before doing so.It is your sole responsibility to understand your local laws and observe them strictly.Covers does not provide any advice or guidance as to the legality of online sports betting or other online gambling activities within your jurisdiction and you are responsible for complying with laws that are applicable to you in your relevant locality.Covers disclaims all liability associated with your use of this website and use of any information contained on it.As a condition of using this website, you agree to hold the owner of this website harmless from any claims arising from your use of any services on any third party website that may be featured by Covers.