Messages

Forum Index : Systems & Strategies : Messages Page 1 of 4  1 2 3 4  
Author: [Systems & Strategies] Topic: RPI Chase Picks and Tracking Spreadsheet
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#1
Posted: 4/27/2012 10:48:45 AM

First, a big "thank you" is due to DegenGamble for creating the original MLBRPI spreadsheet based on Bettor2win's RPI Chase system.  It served as the inspiration and is the heart of my RPI Chase 2012 Picks and Tracking Spreadsheet.  Additional thanks go to meganbob for his input in the design and functionality of the tracking worksheet.

This spreadsheet was created in Excel 2010.  It has macros and they are safe.  Any sheets that are protected can be unlocked with the password, 'rpi'.  I recommend leaving the protection turned on to keep things running smooth.

This spreadsheet does not contain the pitching data and I have no current plans to add that.

I will provide support and fix any bugs, if found, when time permits.

I hope you find this a useful tool as-is or, using it as a starting point for modifying it to fit your own needs.

Screen Shot #1

Screen Shot #2

Download Here

* No guarantees of any kind as to accuracy or functionality.  This will not make you a winning bettor.  Losses will occur.  Use at your own risk.

quote
irage
RSI Wagerline RSI Rating
send a private message View Space | Blog | Friends | Playbook |
irage
Participation Meter
Veteran
Joined: Nov 2005
Posts: 3970
Location: Utah
#2
Posted: 4/27/2012 11:01:16 AM
1. Incredible
2. Beautiful work
3. Great Design

I look forward to putting it through it's paces.
quote
fkulak888 send a private message View Space | Friends | Playbook |
fkulak888
Participation Meter
Prospect
Joined: Mar 2012
Posts: 7
Location:
#3
Posted: 4/27/2012 11:19:37 AM
Like what I see, Thanks!!! 
quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#4
Posted: 4/27/2012 11:35:37 AM

Very nice CanisMajor - I can see you spend a lot of time on design.

Excellent!

One thing I did notice though - I opened both spreadsheets side by side and even though the RPI's for each matchup is correct - the plays that are displayed don't match up.  I see you are filtwering by Win% and games won too, but even with that factored in - it appears that your spreadsheet had less RPI plays.  Are you filtering with any other criteria that i'm missing?

 

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#5
Posted: 4/27/2012 11:57:14 AM
QUOTE Originally Posted by DegenGamble:

One thing I did notice though - I opened both spreadsheets side by side and even though the RPI's for each matchup is correct - the plays that are displayed don't match up.  I see you are filtwering by Win% and games won too, but even with that factored in - it appears that your spreadsheet had less RPI plays.  Are you filtering with any other criteria that i'm missing?

 

Thank you Degen!

If you change the filters to both be zero (0), you should see all the same plays as your V2 spreadsheet.  Alternately, unhide column 'L' and you will see the plays without any filtering being done as well.

Both methods are agreeing with your spreadsheet (V2 as posted).

See Comparison

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#6
Posted: 4/27/2012 12:02:50 PM
QUOTE Originally Posted by CanisMajor:

Thank you Degen!

If you change the filters to both be zero (0), you should see all the same plays as your V2 spreadsheet.  Alternately, unhide column 'L' and you will see the plays without any filtering being done as well.

Both methods are agreeing with your spreadsheet (V2 as posted).

See Comparison

Ahhh - now I see what you did - very nice.  Love the formatting.  Great Job.

 

quote
meganbob send a private message View Space | Friends | Playbook |
meganbob
Participation Meter
Prospect
Joined: Jan 2012
Posts: 19
Location: Texas
#7
Posted: 4/27/2012 12:10:26 PM
Yes, everyone who uses the chase system will thoroughly enjoy this workbook.  Just make sure you save a template so you will have a fresh workbook to use year after year.  Once again, excellent work Canis.  You da man. 

And remember, "If you bail, it's sure to fail; hold your stance and it's got a chance."  ~anonymous  
quote
irage
RSI Wagerline RSI Rating
send a private message View Space | Blog | Friends | Playbook |
irage
Participation Meter
Veteran
Joined: Nov 2005
Posts: 3970
Location: Utah
#8
Posted: 4/27/2012 12:50:28 PM
Both you guys have done a great job.

One other thing that I would like to see is the Juice for a given game and a betting amount with calc showing the profit or loss from the game.

The goal being to show the hard value of the strategy.
quote
irage
RSI Wagerline RSI Rating
send a private message View Space | Blog | Friends | Playbook |
irage
Participation Meter
Veteran
Joined: Nov 2005
Posts: 3970
Location: Utah
#9
Posted: 4/27/2012 2:59:49 PM
Retract that last statement. You guys have already thought that too.

I love it.
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#10
Posted: 4/27/2012 4:01:05 PM

Thanks to everyone for the kudos.

I want to take a second to point out a couple of things that could end up being common questions.

  • Series games that end with an asterisk ' * ' indicate a four game series
  • Series games that end with a double asterisk ' ** ' indicate a two game series
  • The Streak on the MLB Results worksheet is accurate to the last consecutive result.  (see image)  In this example, the streak will be updated when the other results are entered.
  • The Last 10 on the MLB Results page will not update until there are at least 9 results.
  • As noted on the MLB Results worksheet, do not delete the last line, it is needed.
  • Do not manually insert lines.  Use the Add Ticket button as it runs a macro and copies necessary formulas.
  • Inserting new rows or columns may cause unpredictable results.  Exercise caution if you choose to do this.
quote
meganbob send a private message View Space | Friends | Playbook |
meganbob
Participation Meter
Prospect
Joined: Jan 2012
Posts: 19
Location: Texas
#11
Posted: 4/27/2012 6:27:14 PM
Spend some time playing around with it.  You'll begin to discover all of the little intricacies within the workbook and specifically the MLB and rpi tabs.  Of course, the NHL and NBA tabs are for merely tracking bets in those sports as well, just a little less intuitively since they are not system-based.  I'm sure as we near the upcoming seasons, NFL, NCAA-F & eventually NCAA-B will be added similar to the NHL & NBA tabs.
The workbook has proven to this point to be a work-in-progress as we are constantly thinking of ways to improve upon it.
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#12
Posted: 4/27/2012 7:29:22 PM
Meganbob is referring to the version he and I use.  The linked version above only has the MLB related worksheets as it was meant for B2W rpi chase system.
quote
bettor2win
RSI Wagerline RSI Rating
send a private message View Space | Blog | Friends | Playbook | My Sportsbook: M Resort |
bettor2win
Participation Meter
Veteran
Joined: Dec 2009
Posts: 2149
Location: California
#13
Posted: 4/27/2012 10:13:03 PM

GOOD JOB CANIS!!

Will this be able to capture the RPI numbers for everyday of the season so we can do backtesting later on for modifications? Ive tried to capture the RPI but it seems to be a pain in the neck since I'm not an I.T. guy. There has got to be an easy way, I'm sure. 

quote
alense send a private message View Space | Friends | Playbook |
alense
Participation Meter
Prospect
Joined: May 2007
Posts: 4
Location:
#14
Posted: 4/28/2012 5:31:17 AM
Thanks for all the hard work guys. Much appreciated.
quote
RealRedDragon
RSI Wagerline RSI Rating
send a private message View Space | Friends | Playbook |
RealRedDragon
Participation Meter
Prospect
Joined: Feb 2009
Posts: 296
Location:
#15
Posted: 4/28/2012 7:22:59 AM
CanisMajor, thank you! Great work with excell!
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#16
Posted: 4/28/2012 9:08:40 AM

B2W,

Thank you, and thanks for a great system!

If I understand you correctly, you would like to have the ability to store each days RPI value for each team.  Then when going back via the date button you see the acual RPI value as it was on that date and not just the current RPI.

If this is correct, I will put it on my to-do list.

I'm not sure how the backtesting would easily be accomplished but having the RPI history would be the place to start.

Ideally this would all (RPI history, bet tracking) be in a database and then we could query results based on any criteria we specify.  This will be my next project but it's still in the planning stage.

quote
xX80Xx send a private message View Space | Friends | Playbook | My Sportsbook: Pinnacle Sports |
xX80Xx
Participation Meter
Prospect
Joined: Apr 2012
Posts: 37
Location: Poland
#17
Posted: 4/29/2012 11:56:49 AM
What a great job! CanisMajor you are a master in excel
Looks great, work great plus own spreadsheet with chases!

Everything look really like masterpiece!

PS. could you tell me please why when I want to update RPI it doing that BUT making #ARGs in RPI playes + Bet button wont work... it work but excel what to debug something.

Thanks for help :)
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#18
Posted: 4/29/2012 1:17:12 PM
QUOTE

Originally Posted by xX80Xx:

when I want to update RPI it doing that BUT making #ARGs in RPI playes + Bet button wont work... it work but excel what to debug something.

Thanks XBox, you are welcome.

I'm sorry for the trouble you are having.  Unfortunately, nobody else has reported this issue.

Your problem could be due to differences in versions.  What version of Excel (2003, 2007, 2010) are you using and is it the English language version or a different language option?

Also, please note that the Bet button will not do anything on any lines that do not have a valid RPI play.  Valid means the game has the minimum RPI differential and all filters are true.

I hope this helps.

quote
xX80Xx send a private message View Space | Friends | Playbook | My Sportsbook: Pinnacle Sports |
xX80Xx
Participation Meter
Prospect
Joined: Apr 2012
Posts: 37
Location: Poland
#19
Posted: 4/29/2012 1:31:55 PM
Ahhh that I think... I have Excel 2007 and Polish version.

Hmm maybe I will find on the internet a 2010 trial version and then everything will be ok.

Anyways thanks for fast help. One more time WELL job!
quote
xX80Xx send a private message View Space | Friends | Playbook | My Sportsbook: Pinnacle Sports |
xX80Xx
Participation Meter
Prospect
Joined: Apr 2012
Posts: 37
Location: Poland
#20
Posted: 4/29/2012 3:33:03 PM
@CanisMajor
Its not my version and language problem

Any other propositions to solve my problem?

Thanks in advance.
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#21
Posted: 4/29/2012 3:39:29 PM

@XBox

Save the file that has the errors and post it somewhere that I can retrieve it from and I will take a look at it.

 

quote
xX80Xx send a private message View Space | Friends | Playbook | My Sportsbook: Pinnacle Sports |
xX80Xx
Participation Meter
Prospect
Joined: Apr 2012
Posts: 37
Location: Poland
#22
Posted: 4/29/2012 3:53:20 PM
Here you are:
http://speedy.sh/HgaXV/RPI-Chase-2012.xlsm
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#23
Posted: 4/29/2012 4:51:55 PM

@XBox

Somehow, on the RPI sheet, column B, E, F and K, were showing errors (little green triangle on upper left of each cell).

To fix this, all I did was click the Update RPI button again and then everything displayed correctly on the RPI Chase worksheet.

 

 

quote
xX80Xx send a private message View Space | Friends | Playbook | My Sportsbook: Pinnacle Sports |
xX80Xx
Participation Meter
Prospect
Joined: Apr 2012
Posts: 37
Location: Poland
#24
Posted: 4/29/2012 5:26:21 PM
@CanisMajor

So could you please resend me MY file but working now?
Because I try to click update RPI and nothing...
I swear it will be my last ask
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 185
Location: Texas
#25
Posted: 4/29/2012 6:33:30 PM

For XBox

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