Messages

Forum Index : Systems & Strategies : Messages Page 1 of 7  1 2 3 4 5   »
Author: [Systems & Strategies] Topic: Excel Spreadsheets - Systems, Tools, Utilities and More
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#1
Posted: 6/24/2012 8:30:24 PM

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.

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#2
Posted: 6/24/2012 8:31:12 PM

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

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#3
Posted: 6/24/2012 8:32:08 PM

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

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#4
Posted: 6/24/2012 8:32:40 PM

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

 

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#5
Posted: 6/24/2012 8:33:09 PM

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

 

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#6
Posted: 6/24/2012 8:33:22 PM

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

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#7
Posted: 6/24/2012 8:35:28 PM

-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

quote
Stake24 send a private message View Space | Friends | Playbook |
Stake24
Participation Meter
Prospect
Joined: Apr 2007
Posts: 346
Location: Nevada
#8
Posted: 6/24/2012 8:58:43 PM
Nice work!
quote
oilcountry99 send a private message View Space | Friends | Playbook |
oilcountry99
Participation Meter
Prospect
Joined: Jan 2010
Posts: 497
Location: Ontario
#9
Posted: 6/24/2012 10:02:19 PM
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!
Posted using a mobile device.
quote
oilcountry99 send a private message View Space | Friends | Playbook |
oilcountry99
Participation Meter
Prospect
Joined: Jan 2010
Posts: 497
Location: Ontario
#10
Posted: 6/24/2012 10:06:36 PM
http://www.guide-to-baseball-betting.com

The link is on the left side "ebook revisions"
Posted using a mobile device.
quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#11
Posted: 6/24/2012 11:08:00 PM
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.....

quote
Alldaygambler28 send a private message View Space | Blog | Friends | Playbook |
Alldaygambler28
Participation Meter
Veteran
Joined: Feb 2008
Posts: 1440
Location: South Dakota
#12
Posted: 6/25/2012 1:46:57 AM
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. 
quote
oilcountry99 send a private message View Space | Friends | Playbook |
oilcountry99
Participation Meter
Prospect
Joined: Jan 2010
Posts: 497
Location: Ontario
#13
Posted: 6/25/2012 8:55:12 AM
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.

 

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#14
Posted: 6/25/2012 10:23:26 AM
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.

quote
Alldaygambler28 send a private message View Space | Blog | Friends | Playbook |
Alldaygambler28
Participation Meter
Veteran
Joined: Feb 2008
Posts: 1440
Location: South Dakota
#15
Posted: 6/25/2012 10:25:48 AM
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. 







quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#16
Posted: 6/25/2012 1:30:18 PM

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

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#17
Posted: 6/27/2012 2:29:39 PM

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

 

quote
irage
RSI Wagerline RSI Rating
send a private message View Space | Blog | Friends | Playbook |
irage
Participation Meter
Veteran
Joined: Nov 2005
Posts: 3971
Location: Utah
#18
Posted: 6/30/2012 3:54:14 PM
Degan,

Which system seems to be doing the best?
quote
bruin95 send a private message View Space | Friends | Playbook | My Sportsbook: Station |
bruin95
Participation Meter
Prospect
Joined: Mar 2001
Posts: 343
Location: Nevada
#19
Posted: 7/1/2012 4:43:25 AM
Not one of these links works for me.  It just takes me to the google drive sign up page.
quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#20
Posted: 7/1/2012 12:22:12 PM
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.

 

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#21
Posted: 7/1/2012 12:25:12 PM
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.

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#22
Posted: 7/8/2012 3:14:04 PM

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

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#23
Posted: 7/8/2012 3:20:22 PM

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

quote
BigTenWatto send a private message View Space | Friends | Playbook | My Sportsbook: bet365 |
BigTenWatto
Participation Meter
Rookie
Joined: Dec 2009
Posts: 774
Location: Canada
#24
Posted: 7/10/2012 5:01:17 PM
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
quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#25
Posted: 7/10/2012 7:20:08 PM
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.
quote
Forum Index : Systems & Strategies : Messages Page 1 of 7  1 2 3 4 5   »
You have entered the forum as a GUEST. 
You must login/register to post or reply.