Excel Spreadsheets - Systems, Tools, Utilities and More

Forum: Systems & Strategies Page 3 of 9 «  1 2 3 4 5   »
Author: [Systems & Strategies] Topic: Excel Spreadsheets - Systems, Tools, Utilities and More
DegenGamble PM DegenGamble
Joined: Oct 2011
Posts: 1070
 
DegenGamble
Participation Meter
Veteran
Posted: 1/28/2013 4:04:42 PM
QUOTE

Originally Posted by blenaghan:

any word on the stifler spreadsheet being fixed??

Sorry guys - I have been super busy with work.  I mean really busy - so have not been able to keep up with emails, or PMs

I apologize to all that have emailed / PM'd me and I have not responded.  Work has been kicking my butt.

Well here is Stiflers system spreadsheet.  I did not have time to fix the Today's Odds issue - i just commented it out so it doesn't try to pull it from the web - so you won't get errors but you will have to get the lines yourself - for now.

 

Stiflers NBA Chase Systems

He has a thread on SBR with the details, but I automated it

you can download from Google Docs - link below:

https://docs.google.com/open?id=0B5dydT9Oe6JbeDQzRm1keGYzWTQ

DegenGamble PM DegenGamble
Joined: Oct 2011
Posts: 1070
 
DegenGamble
Participation Meter
Veteran
Posted: 1/28/2013 4:07:47 PM
QUOTE Originally Posted by BuckeyeKaptn:

DeGen, are you able to do for NHL as you did for NBA in post #36? That's an awesome spreadsheet.  I'm unable to figure out how to do it myself.
Thanx

BK

I can do it for NHL - but I have not, I am just way too busy right now with work to get anything else done.  My apologies - maybe i'll free some time later but as of right now - i'm just too swamped.

Hopefully in the next couple weeks or so it may die down and I can get back to what I like to do at work - which is all this gambling stuff :)

BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
 
BuckeyeKaptn
Participation Meter
Rookie
Posted: 1/29/2013 1:13:37 AM
Np I'm on vacation this week, and will continue the copy and past!!!
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
 
BuckeyeKaptn
Participation Meter
Rookie
Posted: 1/29/2013 10:25:09 AM
How did you get your google docs to be just downloaded?  I put a spreadsheet up of the 2013 NHL Schedule that I made, and it has it set that a person can view and download the sheet.

https://docs.google.com/file/d/0Bynr1eDtdk5ZUkxWWXFyd0JJaGM/edit


blenaghan PM blenaghan
Joined: Mar 2011
Posts: 2
 
blenaghan
Participation Meter
Prospect
Posted: 1/30/2013 7:18:45 AM
QUOTE Originally Posted by DegenGamble:

Sorry guys - I have been super busy with work.  I mean really busy - so have not been able to keep up with emails, or PMs

I apologize to all that have emailed / PM'd me and I have not responded.  Work has been kicking my butt.

Well here is Stiflers system spreadsheet.  I did not have time to fix the Today's Odds issue - i just commented it out so it doesn't try to pull it from the web - so you won't get errors but you will have to get the lines yourself - for now.

 

Stiflers NBA Chase Systems

He has a thread on SBR with the details, but I automated it

you can download from Google Docs - link below:

https://docs.google.com/open?id=0B5dydT9Oe6JbeDQzRm1keGYzWTQ




You are the man
Rocksaki PM Rocksaki
Joined: May 2009
Posts: 219
 
Rocksaki
Participation Meter
Prospect
Posted: 2/3/2013 11:26:35 AM
Hey DG, thanks for all the work that you do on here.

I have a favor to ask:
1) Me, and quite a few other handicappers find Hollinger's Team Stats very beneficial when handicapping games...
http://espn.go.com/nba/hollinger/teamstats/_/sort/defensiveEff/order/false

It's not that I'd like these stats to be automated onto an excel file (that would still be nice nonetheless, bc I just copy and paste), but if you could automate a spreadsheet that gathers its own data from boxscores. 
I ask, b/c Holinger's team stats are for the entire season, but I could see it being very beneficial cutting those stats into 10-day periods to see who's hot at the moment, ect.
BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
 
BuckeyeKaptn
Participation Meter
Rookie
Posted: 2/10/2013 1:53:27 PM
DeGen...are all these MLB automated systems good to go for the 2013 season?
Awesome work
DegenGamble PM DegenGamble
Joined: Oct 2011
Posts: 1070
 
DegenGamble
Participation Meter
Veteran
Posted: 2/14/2013 3:58:15 PM

All Sports Game / ATS past results from Covers

Here are 4 excel spreadsheet that will allow you to import NBA, NHL, MLB, NHL Game / ATS results from Covers. All you have to do is select the SEASON you want to import from the dropdown and click the "IMPORT" button. The game logs for all the teams will be downloaded to the Covers Data tab.

if you want you can clear the blue cells in the Covers Data tab and start over or add to it. Anytime you import a season it is pasted below the last row.

You can download from the link below:

https://docs.google.com/file/d/0B5dydT9Oe6JbU1BVMlJqVXA0VkU/edit?usp=sharing

orhane PM orhane
Joined: Dec 2012
Posts: 234
 
orhane
Participation Meter
Prospect
Posted: 3/16/2013 9:52:47 PM
First of all great work again, I want to import what the experts and consensus number for each match are (@covers.com) is that possible too?
Layne PM Layne
Joined: Nov 2007
Posts: 0
 
Layne
Participation Meter
Prospect
Posted: 3/28/2013 4:13:47 AM
QUOTE Originally Posted by orhane:

First of all great work again, I want to import what the experts and consensus number for each match are (@covers.com) is that possible too?

+1

These spreadsheets are really useful, thanks DegenGamble for sharing them. I would love to import experts % also, any quick fix?
Cuntchaser PM Cuntchaser
Joined: Jun 2012
Posts: 36
 
Cuntchaser
Participation Meter
Banned
Posted: 4/15/2013 7:15:37 AM

will you update MLB super systems for this season?


DegenGamble PM DegenGamble
Joined: Oct 2011
Posts: 1070
 
DegenGamble
Participation Meter
Veteran
Posted: 4/15/2013 10:32:09 AM
QUOTE Originally Posted by Cuntchaser:

will you update MLB super systems for this season?


Sorry but at the moment I am working on other projects - if I have time later in the season I may update the spreadsheet.  For now you will have to track manually.

bigdog56 PM bigdog56
Joined: Apr 2006
Posts: 37
 
bigdog56
Participation Meter
Prospect
Posted: 4/15/2013 12:55:52 PM
Types of projects you'll be sharing with all of us? 
DegenGamble PM DegenGamble
Joined: Oct 2011
Posts: 1070
 
DegenGamble
Participation Meter
Veteran
Posted: 4/15/2013 5:07:52 PM
QUOTE

Originally Posted by bigdog56:

Types of projects you'll be sharing with all of us? 

Of course - and the next post is the first one.  I am asking for volunteers to track for the season

DegenGamble PM DegenGamble
Joined: Oct 2011
Posts: 1070
 
DegenGamble
Participation Meter
Veteran
Posted: 4/15/2013 5:18:56 PM

MLB Underdog Systems

This spreadsheet automates the MLB underdog systems listed on the the following websites:

http://www.betfirms.com/baseball-betting-systems-underdogs/

http://www.vegasinsider.com/mlb/story.cfm/story/571442/

Now the Vegas Insider link just goes into more detail of the last system of the Bet Firms Link

https://docs.google.com/file/d/0B5dydT9Oe6JbRXhKaVRGT2lkSXc/edit?usp=sharing

It takes a good 3-5 minutes to pull all the data needed but it shows what teams it's downloading in the lower left hand corner of excel - so just grab a cup of coffee in the mean time.  You only need to run it once each morning.  In addition, for the <6 hits system - you just have to manually check if the team allowed less than 6 hits in their privious game and enter it in the field.  I didn't automate it because I didn't want to slow it down any more for data that would only be used IF the team happens to be a play for that system.

Features:

·         All plays and data needed for the day are updated upon clicking the “Update” button

·         You can download from the link above:

*Just a reminder that the <6 hits system needs some manual inputs

BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
 
BuckeyeKaptn
Participation Meter
Rookie
Posted: 4/18/2013 11:18:38 PM
Just to make sure...for the <6, we just need to look to see if that team gave up 5 or less hits....not actually input it into the spreadsheet?  If we do need to input, where?  
It's an awesome job, didn't take that long to update, and the plays (which I didn't play) went 4-1 (Thu 4/18).
Danrules24 PM Danrules24
Joined: May 2012
Posts: 4444
 
Danrules24
Participation Meter
Veteran
Posted: 4/19/2013 12:03:00 AM
QUOTE Originally Posted by BuckeyeKaptn:

Just to make sure...for the <6, we just need to look to see if that team gave up 5 or less hits....not actually input it into the spreadsheet?  If we do need to input, where?  
It's an awesome job, didn't take that long to update, and the plays (which I didn't play) went 4-1 (Thu 4/18).

It's actually 6 or less hits. Been tracking it on Degen's other thread.

BuckeyeKaptn PM BuckeyeKaptn
Joined: Jan 2013
Posts: 656
 
BuckeyeKaptn
Participation Meter
Rookie
Posted: 4/19/2013 2:10:06 PM
Dan, now that I found DenG's other thread, can you explain about the 6 hit rule, and how to adjust it etc, on the spreadsheet?  Not the system, but the spreadsheet.
luckywayne001 PM luckywayne001
Joined: Apr 2013
Posts: 5
 
luckywayne001
Participation Meter
Prospect
Posted: 4/20/2013 8:02:15 AM
Hey DG sent you a friend request need to ask you a question through PM.  Thanks
luckywayne001 PM luckywayne001
Joined: Apr 2013
Posts: 5
 
luckywayne001
Participation Meter
Prospect
Posted: 4/20/2013 12:35:02 PM

DG,

I have MLB_RPI_2012_v2___BTW excel spreadsheet.  I click update standing and then I click update RPI and they update.  Then I click on today and it does not display any games.  Is there something else I have to update to get the games to show up?  Thanks for help and you are doing wonderful things.  I do want to PM you to ask you a question.  Thanks

DegenGamble PM DegenGamble
Joined: Oct 2011
Posts: 1070
 
DegenGamble
Participation Meter
Veteran
Posted: 4/20/2013 1:12:45 PM
QUOTE Originally Posted by luckywayne001:

DG,

I have MLB_RPI_2012_v2___BTW excel spreadsheet.  I click update standing and then I click update RPI and they update.  Then I click on today and it does not display any games.  Is there something else I have to update to get the games to show up?  Thanks for help and you are doing wonderful things.  I do want to PM you to ask you a question.  Thanks

yeah - the schedule is for 2012.  You will have to unhide the schedule tab and copy and paste to 2013 schedule into the tab.

luckywayne001 PM luckywayne001
Joined: Apr 2013
Posts: 5
 
luckywayne001
Participation Meter
Prospect
Posted: 4/20/2013 2:26:15 PM
Thanks.  What is the best website to copy and paste from to match the way your schedule is set up.
DegenGamble PM DegenGamble
Joined: Oct 2011
Posts: 1070
 
DegenGamble
Participation Meter
Veteran
Posted: 4/20/2013 3:01:14 PM
Search google for 2013 MLB schedule excel - you should find the schedule in excel format to cut and paste
Posted using a mobile device.
Dell73 PM Dell73
Joined: Apr 2009
Posts: 17
 
Dell73
Participation Meter
Prospect
Posted: 4/21/2013 1:55:21 AM
QUOTE Originally Posted by DegenGamble:

Sorry but at the moment I am working on other projects - if I have time later in the season I may update the spreadsheet.  For now you will have to track manually.


Please DegenGamble

see MLB super systems and try to update it .. It was extremely useful to me because without it I lose the hours until I find everything I need to place a bet

Thanks in advance
luckywayne001 PM luckywayne001
Joined: Apr 2013
Posts: 5
 
luckywayne001
Participation Meter
Prospect
Posted: 4/21/2013 10:47:24 AM

DEGEN,

I am sending you a friend request.  I am also trying to get Canis to help so we could all get the BTW RPI Spreadsheet going this year. I have the schedule completed in the correct format with all the A/B/C games. I think I have an old version (version2 of BTW RPI) because the Standings tab updates incorrectly.  Whats your thoughts.  Thanks

Forum: Systems & Strategies Page 3 of 9 «  1 2 3 4 5   »
You have entered the forum as a GUEST. 
You must login/register to post or reply.