Excel Spreadsheets - Systems, Tools, Utilities and More

Cisco's Chase / Fade Systems

This spreadsheet automates 3 of Cisco's systems that he has posted in his various threads.

Features:

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

·         You can download from the link above:

*Please note - that I am still tweaking this spreadsheet - as I have noticed some areas of improvement - the version posted is V1, newer versions will be uploaded and can be downloaded using the same link

Quote Originally Posted by Leprechaun:

MLB Super Systems 2013 Spreadsheet

Hi guys.  Your friendly neighborhood Leprechaun here.  I had to take last year off for family reasons but I still spend plenty of time in the forums.  Love the work you did here last year Degen.  I'm also quite handy with excel and VBA and I automate my systems much like you have here.  I haven't decided if I'll post regularly yet this year, but I'm here in this forum pretty much everyday and hopefully at the very least I can help out with spreadsheets and system ideas.

I've fixed the standings bug (and another bug on the sagarin rating page) and updated Degens spreadsheet for 2013.  It should be working exactly as it did last year.  Here's the link for you guys:

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

I'll be working on more stuff in the coming weeks.  Anybody who remembers me on here knows I'm a numbers man, but they also know I don't start any MLB systems until May while I gather data and let the teams settle in for the season.  Hopefully I can get my system going again and actually make it successful.  Good luck to all.

Leprechaun

Great work Leprechaun! - nice to have another excel jockey here on Covers!

Thanks for updating Super Systems!

2013 B2W's RPI SYSTEM

The much awaited NEW and IMPROVED B2W RPI system spreadsheet.

Features:

·         Added Sagarin Rankings, Starting Pitchers, Current Odds

Buckeye,

Don't agree until you are sure you believe in the methodology of the system

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

I uploaded a file that has the system details all in one document and the URL's of the original threads on Covers.

The system is based on Sagarin Ratings, which makes it difficult to backtest since they are not archived and the math involved to calculate Predicted ERA, MOB and RICKEY is highly advanced - so to recreate the formulas in excel may be difficult - but that being said - if someone does know how to calculate those 3 things then this system can be backtested.  (but I doubt it)

So if this cannot be backtested - the only option is to test for the season.

The premise of the system is to look at the results of like situations using Starting Pitcher Stats and Odds.  The author uses the theory that in the same situation similar teams will perform the same (i.e Win or Lose)

He uses the Sagarin Stats to come up with a Composite Score for both pitchers and classifies the FAV team as Low, Med, High Fav. and records the result of the game (Win or Loss).  He builds a DB of these type of games until he has a enough games to use to predict the outcome of a game with similar numbers.

Example:

Outcome: WIN

Favorite Type: HIGH

Dog Pitcher Score: 40

Home Pitcher Score 50

Let's say the above situtation has come up 5 times and all resulted in a WIN for the home favorite and a game comes up that has the exact same numbers.  He would bet on the Favorite - since in those situations - it has yielded a high win rate.  (100% to be exact)

Now I have no idea if this works or not.  The premise is interesting - and it sounds logical.  Does it work? No freakin' clue.  Would like to know if it works?  Defintely.  Do I have the time to run a thread and track the results with all the other projects on my plate?  Unfortunately no.

So before you jump in and say you are willing to track this (which I highly commend by the way - I admire people who don't sit back and expect things to be spoon fed to them, give them some guidance, advice, tips and support and let them run with it.  You will learn more in process and it may spark creattive constructive thought in the forums) - I advise you to read the system doc, and then read the orginal posts on covers, then read it again. 

Then ask yourself - "Will I devote the entire season tracking this, and share any insights them comes out of it with the group on a daily basis"

Remember - I will provide the spreadsheet - you will just have to click update each day - and look at what the plays should be and record if the predicted plays win or lose.

If the answer is "YES" let me know.  Just writing this post got me even more intrigued if this works or not - so I hope the anwer is "YES"

Hi DegenGamble! Great job! Do you have this file MLB_RPI_2012_v2.xlsm updated till the end of 2012 season? I need RPI daily history from it.

Degen &  Leprechaun,

Thanks for what you do with the spreadsheets.  This is great work.  Do either one of you do work for websites.  I have something I think either of you might be interested in or even pay you.