Excel Spreadsheets - Systems, Tools, Utilities and More

The "Buddah System"

So this is a test of this system developed by Buddah - here is the link to a word doc that has the links to the threads on covers and I consolidated it into the word doc as well

DeGen, for the Buddah System, exactly how do I do this?  Do I just hit "update" everyday to update the database or do I have to hit the "Add to DB" first?

Buckeye - yeah just click update each day and make sure you are looking at the right date (ie today's games) - then click add to DB. This just copies the games to the DB tab - then at the end of night go to the DB tab and manually record the result of the game - win or loss. If there are any plays listed that day it is listed in the Summary tab under potential plays column - I set it up so you can vary the range or how close you are to the play in the DB in the yellow cell listed as range on top which is now set to three - which means it will l

Look for records within 3 - ie its a SF 50 vs 40 then it will look for results of SF of 47 to 53 vs 37 to 43. You would use zero if you want exact matches

Yeah it may take awhile to get the DB built too bad we started late - and yeah keep a copy and start new after all star break. Maybe even keep 2 version - one for all year and one that has the breaks as suggested by Buddah

Lucky-

Just wanted to say what I did here was minimal...Degen deserves 100% of the credit for these spreadsheets.  I only made a few tiny fixes that almost anyone with a little programming knowledge could have done.

I don't have much interest in building a website...I've done several and it always ends up being 10 times the work it seems like from the beginning. Also, I have a fair amount of side projects that keep my plate very full at the moment.  Degen's reference above is a good one.  If you really want to pay somebody, there are an unlimited number of programmers that do contract work around the internet.

Leprechaun

thx 

Degen, after I went and changed all the odds, I went and reread Buddah's comments again for a refresher and saw that he uses "Opening Lines" as his basis odds, which you have being pulled from whatever website (btw, because its the opening odds, the refresh button doesn't do anything!)

Vegas insider should have opening lines for those dates - ill fix the spreadsheet

Ok, I found it.  Uhm, we want to KEEP the opening line and have that go into the DB.  Having the current line also (like the UD sys) would help decide/comfirm the plays, but we need the opening line for the DB. 

Well you won't have Sagarin rankings prior to 5/7 - that's why we can't backtest and have to track for the season - ill fix the sheet and send another version

Buckeye - I uploaded a new version of the Buddah system spreadsheet (V2)

Hi Leprechaun and degengamble.

Degen...after I posted that last post, I realized that about all the pitchers stats!  I wish we could edit our posts.  Cool about the opening/current lines...follow the money.  I've been busy with painting a bathroom, best man at my wife's brothers wedding, and just being a father to get it started (the new thread), Oh and I do have a full time job.

Recycle-

Good to see you on here...I remember you from a couple years back.  Looks like Buckeye answered your question.  I'm still running my series system...although I've tweaked things quite a bit.  It's going VERY well so far this season, although that's probably because I'm not posting it  I just don't have time at the moment.  My automated sheets are nowhere near ready for general use (i.e. not user friendly).  I've been optimizing the code and incorporating some of Degen's code and the underdog system to improve my system.  Maybe I'll post plays and the sheet the second half of the season if I have enough free time to get it ready.

As far as what's going on in this forum at the moment, what Degen and DanRules are doing is fantastic.  It's a lot of work that has been paying great dividends and those guys deserve all the credit for their hard work.  Follow that underdog thread...it's one of the best that has been on here in awhile.

Leprechaun

Great thanks

But my spreadsheet is still giving me the same #value could it be the version of excel I'm using? Excel 2007

Buckeye would u mind sending me the plays it would be greatly appreciated.

Thanks

Recycle...^^^...that first part about the 2007 excel, was from me, don't know how it got in the quotes.

As far as Supersytems - use it any which way you want - I posted the PDF and links to the website for the revisions that bob bies posted - the reason why I didn't update the spreadsheet for this year is most of the time the plays coincided with the RPI system - so why go through updating them
When most of the plays matched the RPI system - on a side note i was thinking about a chase system that looked at the next 3 days of match ups for each team - then use criteria like RPI, starting pitchers whip, obp for each team, etc. the idea is if a team has better stats than their opponent in the next 3 games for ALL those games you would start a 3 game chase. This will allow you to take advantage of winning streaks - thoughts?

I haven't fully updated my stats on the SuperSystems fully, I'm about a week behind, but I'm checking out a 3g chase using the RPI spreadsheet, starting on the A game (no 2g series).  Since Apr 29th, it's 21-1, +20.84 units, not including yesterdays A games.  If you filter it with a no -150 or higher play (on the A play), it's +9.84u.  This is using Cover's final lines.

Another note, I've gone through and tried a 3g chase on ALL the games that come up on the RPI sheet, whether an A game or not.  That doesn't work, everything is in the negative.  Start a chase on the A game only.  Same with the TR rankings.