Excel Spreadsheets - Systems, Tools, Utilities and More

First << 1 of 11 >> Last
Views: 111408
Posts: 266
 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#1 Report User
Posted:

This thread is to help my fellow cover’s members as they have helped me.  I have been bouncing around many threads - mostly Irage's and B2W's and I have been automating a bunch of systems - So I figured I would put them all in one place.

So here are the systems, tools or utilities that I have automated.  Any feedback is welcome and appreciated.  I would to thank the following folks for their help and sharing their systems and insights.

bettor2win, Irage, CanisMajor, Marko123, OilCountry99, Sports_Network

 

 

Give a man a fish and he will eat for a day……teach a man to fish and he will eat forever.

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#2 Report User
Posted:

B2W's RPI SYSTEM - WORKBOOK

DegenGamble Latest Version

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

 

CanisMajor Latest Version

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

 

See B2W's RPI thread for picks and details on the system

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#3 Report User
Posted:

IRAGE DOG AND PONY SHOW SYSTEM

Irage’s system that I automated into spreadsheet.

Features:

·         Today’s matchups and lineups are updated from baseballpress.com when you click the “Update Lineup” button

·         Today’s lines are updated from Covers.com (http://scores.covers.com/baseball-scores-matchups.aspx) when you click on the “Refresh Lines” button

·         Lines are automatically saved in Line History tab every time you click the “Refresh Lines” button – IF the lines have been updated or a new game falls into the system.

You can download from the link below:

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

 

See Irages's thread for picks and details on the system

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#4 Report User
Posted:

MLB SUPER SYSTEMS

So I automated the systems contained in the PDF available from this link:

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

Features:

·         Today’s matchups are updated from baseballpress.com when you click the “Update Schedule” button

·         All the data needed for Systems #1, #3 and #4 are updated  when you click on the “Update Data” button

IN Progress

·         May add System #2 – still TBD

·         Additional testing and some tweaking and bug fixing needs to be completed

 

You can download the spreadsheet from the link below:

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

 

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#5 Report User
Posted:

MLB SUPER SYSTEMS

So I automated the systems contained in the PDF available from this link:

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

Features:

·         Today’s matchups are updated from baseballpress.com when you click the “Update Schedule” button

·         All the data needed for Systems #1, #3 and #4 are updated  when you click on the “Update Data” button

IN Progress

·         May add System #2 – still TBD

·         Additional testing and some tweaking and bug fixing needs to be completed

 

You can download the spreadsheet from the link below:

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

 

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#6 Report User
Posted:

MLB LINES FROM VEGAS INSIDER

This spreadsheet displays the current and past lines from Vegas Insider

Features:

·         Current lines can be viewed and refreshed when you click the “Refresh Lines” button

·         Past lines are updated every time you click on the “Update Past Lines” button

You can download from the link below:

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

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#7 Report User
Posted:

-1 Run Line Calculator

Odds calculator to split bets between ML and RL

You can download from the link below:

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

 
Prospect
Participation Meter
Joined: Apr, 2007
Posts: 346
#8 Report User
Posted:

Nice work!
 
Veteran
Participation Meter
Joined: Jan, 2010
Posts: 1294
#9 Report User
Posted:

You the man!
If you look on the website for the baseball systems PDF the author has mad some changes to system 1 and has a added a system 6. You should shoot the guy an email and let him know of the automation he'd probably be forever greatful!

Love your work Degen! Truly awesome!
 
Veteran
Participation Meter
Joined: Jan, 2010
Posts: 1294
#10 Report User
Posted:

http://www.guide-to-baseball-betting.com

The link is on the left side "ebook revisions"
 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#11 Report User
Posted:

Quote Originally Posted by oilcountry99:

You the man!
If you look on the website for the baseball systems PDF the author has mad some changes to system 1 and has a added a system 6. You should shoot the guy an email and let him know of the automation he'd probably be forever greatful!

Love your work Degen! Truly awesome!

Thanks Oil - I missed that.  I will update the systems with the changes he made.

Not sure if he will be that thrilled - it appears (and I could be wrong) - but it looks like he gives the theory behind the systems away for free - but for most people it's a pain to look at all the filters on various websites - i.e ESPN, Statfox, etc - that he charges for subscription to the picks.

I assume they probably have a similar DB / software that gets the data and runs it through the filters to summarize the daily plays - so he can post them on his website.

Hope he does not come after me.....

 
Veteran
Participation Meter
Joined: Feb, 2008
Posts: 1456
#12 Report User
Posted:

Any chance you can take a look at my systems and help me out.  I would love to automate them.  I put in a lot of work with my spreadsheets. 
 
Veteran
Participation Meter
Joined: Jan, 2010
Posts: 1294
#13 Report User
Posted:

Quote Originally Posted by DegenGamble:

Thanks Oil - I missed that.  I will update the systems with the changes he made.

Not sure if he will be that thrilled - it appears (and I could be wrong) - but it looks like he gives the theory behind the systems away for free - but for most people it's a pain to look at all the filters on various websites - i.e ESPN, Statfox, etc - that he charges for subscription to the picks.

I assume they probably have a similar DB / software that gets the data and runs it through the filters to summarize the daily plays - so he can post them on his website.

Hope he does not come after me.....

As far as I know he's doing things manually and hopes to get things automated at some point.  He seems reasonable and very helpful in my dealings with him.  He's always looking to improve the systems and money management to be more profitable.

 

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#14 Report User
Posted:

Quote Originally Posted by Alldaygambler28:

Any chance you can take a look at my systems and help me out.  I would love to automate them.  I put in a lot of work with my spreadsheets. 

ADG - yeah I should be able to help you out.  I want to update the Super Systems spreadsheet.  And I have a another project that i'm continually working on - but after I update the Super Systems stuff - I should be able to automate yours.

They seem straightforward.  I'll PM you when I free up some time and I can start working on them.

 
Veteran
Participation Meter
Joined: Feb, 2008
Posts: 1456
#15 Report User
Posted:

no problem, degen.  Just shoot me a PM when your ready. 

Be more than happy to just have it set up for the the start of next year. 







 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#16 Report User
Posted:

MLB RUN ESTIMATOR

This spreadsheet is based off of Marko123 – MLB Prediction Formula thread.  See covers thread on details on the system and picks.  This is a work in progress in its early stages

Features:

·         Today’s matchups are updated from baseballpress.com when you click the “Update Lineup” button

·         Pitching and Team stats needed to complete the Run Estimation formula are updated when you click on the “Update Pitching Stats” and “Update team Stats” Button

·         NOTE: From time to time a new pitcher (say one called up from AAA) or if a pitcher goes to a different team – an error will occur when updating the pitcher stats.  You will need to update the Pitcher List with the proper links from baseball reference and re-run the query.

You can download from the link below:

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

Please see Marko123’s thread on Covers for more details about the system – MLB Prediction Formula

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#17 Report User
Posted:

So i updated the spreadsheet to include all systems (#1-6) from the PDF and all PDF / E-Book revisions from the website.

MLB SUPER SYSTEMS

So I automated the systems contained in the PDF available from this link:

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

Features:

·         Today’s matchups are updated from baseballpress.com when you click the “Update Schedule” button

·         All the data needed for Systems #1- 6 are updated  when you click on the “Update Data” button

You can download the spreadsheet from the link below:

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

 

 
Banned
Participation Meter
Joined: Nov, 2005
Posts: 4125
#18 Report User
Posted:

Degan,

Which system seems to be doing the best?
 
Prospect
Participation Meter
Joined: Mar, 2001
Posts: 378
#19 Report User
Posted:

Not one of these links works for me.  It just takes me to the google drive sign up page.
 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#20 Report User
Posted:

Quote Originally Posted by irage:

Degan,

Which system seems to be doing the best?

Irage - I really have not been tracking them - I am very bad at tracking.  But I have bet them with positive results.  No losses yet.  I will make the effort to track the systems for one week.

 

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#21 Report User
Posted:

Quote Originally Posted by bruin95:

Not one of these links works for me.  It just takes me to the google drive sign up page.

Bruin - you should be able to just click on the link and it will bring you to a google download page.  I have all the docs shared - so anyone with the link can view.

Maybe try using firefox instead of IE?  I testes the links from a PC that i'm not signed in to - and they work fine.

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#22 Report User
Posted:

JONNYMEGA’s BOTTOM 3 SERIES CHASE

This spreadsheet automates JonnyMega’s Bottom 3 Chase.  See his thread here:

http://www.covers.com/postingforum/post01/showmessage.aspx?spt=79&sub=101374202

Basically, you take the Bottom 3 Teams on www.teamrankings.com overall power rankings and FADE them for the series.  Also added stats from L10 rankings and ESPN OPS data to see if a team you are either going to FADE or a team you are playing to beat the team you are fading are hot or cold.

Features:

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

·         You can save the daily plays to the Play Tracker tab by clicking the “Save Plays” button

You can download from the link below:

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

 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#23 Report User
Posted:

STREAK FINDER

This spreadsheet attempts to find hot and cold batting and pitching teams.

Essentially it tries to find matchups using the teams L10 and L7 stats where:


A good hitting team is facing a lousy pitching team.
A good pitching team is facing a lousy hitting team.
One team has a very leaky bullpen.
Other team has a very good bullpen

Features:

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

You can download from the link below:

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

 
Rookie
Participation Meter
Joined: Dec, 2009
Posts: 818
#24 Report User
Posted:

Hi Degen, I have a system I am using an Excel spreadsheet for that is super cumbersome for me.

I have sent you a friend request, please accept so I can further explain and maybe get some help from you.

Thanks
 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
#25 Report User
Posted:

Quote Originally Posted by BigTenWatto:

Hi Degen, I have a system I am using an Excel spreadsheet for that is super cumbersome for me.

I have sent you a friend request, please accept so I can further explain and maybe get some help from you.

Thanks


I accepted your friend request.
First << 1 of 11 >> Last
Desktop View: Switch to Mobile View