Messages

Forum Index : Systems & Strategies : Messages Page 3 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: 112
Location: Texas
#51
Posted: 5/4/2012 2:14:38 PM
QUOTE Originally Posted by DegenGamble:

One thing.  I can look into it if you don't have time - let me me know.

If looking at today's date or fute dated data AND the RPI / Standings is not updated to today - you get N/A in most of the data columns.  It's fine once you run it thr first time for the day - but it looks like it will look like that every day until you run it for the first time

Yes, thanks DG.  I noticed this myself when I opened mine up this morning.  That's the problem with not testing for a full day before posting it.

I will get this fixed this weekend.  I'll wait until Monday to post a new version in case any other bugs come up over the weekend.

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#52
Posted: 5/7/2012 9:22:43 AM

The FINAL version of the RPI Chase Picks and Tracking Spreadsheet is now available.

Fixes:

  • Eliminates cells that show errors due to unavailable data.

New:

  • Automatically refreshes the pivot table data after each update
  • Contains data from 4/30/2012 through end of games on 5/6/2012 (updated 5/7/2012 AM)

While I do not anticipate any further revisions this season I welcome any feedback and suggestions for improvement.

Download Here

quote
Jaycut send a private message View Space | Friends | Playbook |
Jaycut
Participation Meter
Prospect
Joined: Aug 2009
Posts: 186
Location: United Kingdom
#53
Posted: 5/7/2012 3:14:06 PM
CanisMajor good job... Thanks to Guys like you, B2W, Irage, Dgen (Superman)... Been losing with MLB every year and last year B2W made a change.. you guys have made it easy to follow...

It's like helping a person to grow he's own food... by given him the tools...

 
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#54
Posted: 5/7/2012 3:40:04 PM

Update to Schedule

Just noticed there is a two game series coming up that is not properly noted in the schedule.  Please be aware of this and if you like you can change this on the Schedule worksheet.

The series is the Blue Jays at Oakland which starts tomorrow.

You will find row 732 and row 733 look like this:

Current Schedule

Change them so that they look like this to denote a 2 game series:

Correct Schedule

 

quote
parlay100 send a private message View Space | Friends | Playbook |
parlay100
Participation Meter
Prospect
Joined: Dec 2010
Posts: 34
Location:
#55
Posted: 5/11/2012 4:45:58 PM
i have been searching, but i still cant find the system rules.  Any help?
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#56
Posted: 5/12/2012 10:39:24 AM
QUOTE

Originally Posted by parlay100:

i have been searching, but i still cant find the system rules.  Any help?

The MLB RPI System thread is located here.

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#57
Posted: 5/12/2012 3:30:42 PM
Canis - FYI - Texas next couple of 2 game series with KC and OAK are not reflected as such. I changed them in my version - and will go through the rest - you may want to do the same
Posted using a mobile device.
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#58
Posted: 5/12/2012 10:49:20 PM

Update to Schedule

For those using my version of the spreadsheet, rows 974 through 977 and rows 1054 and 1055 need to be changed on the Schedule worksheet to reflect two game series.

See post #54 above to see how to do this.

 

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#59
Posted: 5/17/2012 9:34:19 AM

NEW, Version 3 of the RPI Chase and Tracking spreadsheet is now available.

Fixes:

  • Schedule has been updated - thanks go to meganbob for doing the work

New:

  • MLB DB now includes bet performance by team
  • Results of RL, ML, O/U, Home, and Away records are now shown on the MLB Results tab
  • Top and bottom three performing teams are now shown on the MLB Resutls tab
  • Import button added to help in moving your old tickets over from a previous version
  • Notes column added for keeping notes on bets
  • History current from 4/30/2012 to 5/17/2012

Screen Shot #1

Screen Shot #2

Download Here

Notes:

  • International users need to set Windows to use the US Date/Time format.
  • 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.
  • 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 or Import button as they run macros and copy necessary formulas.
  • Inserting new rows or columns may cause unpredictable results.  Exercise caution if you choose to do this.

* 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.

See the MLB RPI System thread for information on the system.

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#60
Posted: 5/17/2012 9:46:54 AM

Using the Import Feature

The import button makes it easier to move your bets (tickets) from an older version of the spreadsheet into the newest version.

If you have 60 tickets in the old version, you would click the Import button and enter 60 when prompted for the number of tickets to add.

A macro will then insert 60 rows and copy all the necessary formulas.  After it finishes, you simply copy columns 'B' through 'K' and column 'M' from the old version and paste them into the new version.

quote
SoCal311 send a private message View Space | Friends | Playbook |
SoCal311
Participation Meter
Prospect
Joined: Feb 2012
Posts: 357
Location: California
#61
Posted: 5/17/2012 10:58:04 AM
Nice work dude... Keep it up
quote
bigdog56 send a private message View Space | Friends | Playbook |
bigdog56
Participation Meter
Prospect
Joined: Apr 2006
Posts: 35
Location:
#62
Posted: 5/21/2012 1:33:16 PM
B2W is stating the plays are NYY, MIA & BAL.  You're spreadsheet (which is amazing by the way) only shows Miami.

Can you remind me again, why it might now show NYY & BAL?
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#63
Posted: 5/21/2012 4:18:53 PM
QUOTE

Originally Posted by bigdog56:

B2W is stating the plays are NYY, MIA & BAL.  You're spreadsheet (which is amazing by the way) only shows Miami.

Can you remind me again, why it might now show NYY & BAL?

No problem.

BAL - he is fudging on the RPI edge number.  Required is 42 and Baltimore value today is 41.

NYY - depends on what you have Wins in LAST 10 set to.  One of the rules is that teams you are betting on should have some momentum.  With this filter set at >4, then a team needs to be 5-5 or better over the last ten.  The Yankees are 4-6 going in to tonights game.

 

quote
lowkee00 send a private message View Space | Friends | Playbook |
lowkee00
Participation Meter
Prospect
Joined: Jul 2011
Posts: 63
Location:
#64
Posted: 5/21/2012 4:54:23 PM

I just can't get this spreadsheet to work. I have excel 2010

it opens in protected view. i click enable editing and get this:

Removed Part: /xl/vbaProject.bin part.  (Visual Basic for Applications (VBA)).

excel was able to open the file by repairing or emoving the unreadable content.

Help!!!!!!

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#65
Posted: 5/22/2012 9:56:27 AM

lowkee,

I googled the error.  The first thing to check is that VBA was installed during the Excel (or Office) installation.  To do that, run setup use the custom option where you can drill down to see if it is installed.

Screen Shot

quote
djknoell send a private message View Space | Friends | Playbook |
djknoell
Participation Meter
Prospect
Joined: Nov 2007
Posts: 79
Location: Minnesota
#66
Posted: 5/22/2012 12:55:21 PM
Thanx Canis for this sheet.Is there a way to get the team u want to wager on over to the results page if its not a RPI play by pushing that bet tab on the RPI page. Example: I want to take the Cards today so when I click on the bet tab it doesnt transfer. Thank you.
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#67
Posted: 5/22/2012 2:36:35 PM
QUOTE

Originally Posted by djknoell:

Thanx Canis for this sheet.Is there a way to get the team u want to wager on over to the results page if its not a RPI play by pushing that bet tab on the RPI page. Example: I want to take the Cards today so when I click on the bet tab it doesnt transfer. Thank you.

The easiest way to do this is to edit the macros that are run by the bet buttons.  All you need to do is comment out (by adding a apostrophe ' at the beginning of the line) or delete the If statement and the End If statement.

This screen shot shows the lines.

quote
lowkee00 send a private message View Space | Friends | Playbook |
lowkee00
Participation Meter
Prospect
Joined: Jul 2011
Posts: 63
Location:
#68
Posted: 5/23/2012 3:08:51 AM
QUOTE Originally Posted by CanisMajor:

lowkee,

I googled the error.  The first thing to check is that VBA was installed during the Excel (or Office) installation.  To do that, run setup use the custom option where you can drill down to see if it is installed.

Screen Shot

You'd think I could have done that myself. I thought maybe it was something deeper. Thank you Canis, it's a totally sick worksheet.

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: 2148
Location: California
#69
Posted: 5/23/2012 10:36:22 PM
QUOTE Originally Posted by CanisMajor:

No problem.

BAL - he is fudging on the RPI edge number.  Required is 42 and Baltimore value today is 41.

NYY - depends on what you have Wins in LAST 10 set to.  One of the rules is that teams you are betting on should have some momentum.  With this filter set at >4, then a team needs to be 5-5 or better over the last ten.  The Yankees are 4-6 going in to tonights game.

 

Actually, let me correct this just a little Canis,,
The RPI requirements is/are 40-42 for a home team.  It's an executive decision. I didn't nec fudge it I really just saw that BAL is playing good ball.Their RPI was at 41+ over bos at the time. 
Bos is playing good ball but BAL right now is the hottest team in MLB next to the LAD. 

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#70
Posted: 5/23/2012 11:14:23 PM
QUOTE Originally Posted by bettor2win:

Actually, let me correct this just a little Canis,,
The RPI requirements is/are 40-42 for a home team.  It's an executive decision. I didn't nec fudge it I really just saw that BAL is playing good ball.Their RPI was at 41+ over bos at the time. 
Bos is playing good ball but BAL right now is the hottest team in MLB next to the LAD. 

That's cool.  I stand corrected.

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 112
Location: Texas
#71
Posted: 5/28/2012 11:04:43 AM

If you have any missing days in your MLB History, you can use this worksheet to update it.

Download History

Instructions for completing the update are in the workbook. 

History from April 30 to May 28 is included.

quote
Kennyman send a private message View Space | Friends | Playbook |
Kennyman
Participation Meter
Prospect
Joined: May 2012
Posts: 7
Location:
#72
Posted: 5/31/2012 2:37:32 PM
QUOTE Originally Posted by bettor2win:

Can you make the most updated RPI system available to download again, please?

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
Kennyman send a private message View Space | Friends | Playbook |
Kennyman
Participation Meter
Prospect
Joined: May 2012
Posts: 7
Location:
#73
Posted: 5/31/2012 2:39:38 PM
B2W, can you provide me with the most updated RPI system worksheet to download, please?
quote
hansivonmueller
RSI Wagerline RSI Rating
send a private message View Space | Friends | Playbook | My Sportsbook: bet365 |
hansivonmueller
Participation Meter
Veteran
Joined: Apr 2007
Posts: 1884
Location: British
              Columbia
#74
Posted: 7/7/2012 3:34:48 PM
My version comes up as READ ONLY, is their a way to get a workable sheet that allows date in-put? Cheers
quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#75
Posted: 7/7/2012 7:23:54 PM
QUOTE Originally Posted by hansivonmueller:

My version comes up as READ ONLY, is their a way to get a workable sheet that allows date in-put? Cheers


Did you download the file?  After downloading - once opening there should be a message in the yellow ribbon - right below the file menu - that says "Enable Content" and "Enable Macros" - make sure you say yes to both if prompted.
quote
Forum Index : Systems & Strategies : Messages Page 3 of 4  1 2 3 4  
You have entered the forum as a GUEST. 
You must login/register to post or reply.