Messages

Forum Index : Systems & Strategies : Messages Page 2 of 4  1 2 3 4  
Author: [Systems & Strategies] Topic: RPI Chase Picks and Tracking Spreadsheet
xX80Xx send a private message View Space | Friends | Playbook | My Sportsbook: Pinnacle Sports |
xX80Xx
Participation Meter
Prospect
Joined: Apr 2012
Posts: 37
Location: Poland
#26
Posted: 4/29/2012 6:46:06 PM
HAHA!

CanisMajor thanks for you support! I done it by myself

For anyone from outside of USA... if you have #ARG! just change date/time in your tray for USA date/time system. I mean AM/PM etc
Thats it
quote
mattymeach31 send a private message View Space | Friends | Playbook |
mattymeach31
Participation Meter
Prospect
Joined: Apr 2012
Posts: 41
Location: New York
#27
Posted: 4/29/2012 8:14:04 PM
I have a question, might be a stupid one. I'm wondering in the RPI play column why some at highlighted in dark green while others are not. Can anyone help me out?
quote
mattymeach31 send a private message View Space | Friends | Playbook |
mattymeach31
Participation Meter
Prospect
Joined: Apr 2012
Posts: 41
Location: New York
#28
Posted: 4/29/2012 8:18:31 PM
Nevermind, it looks like that just notes the A bet
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#29
Posted: 4/29/2012 9:25:08 PM
@XBox glad that you figured it out.  Good information to know.

@Matty yes it was just a way to make the A games stand out.
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
#30
Posted: 4/29/2012 10:50:41 PM
QUOTE Originally Posted by CanisMajor:

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.

 I get asked about 100 times a week if I have back/past RPI numbers, which I don't.  Thanks again for your hard work.

quote
Handsdown send a private message View Space | Blog | Friends | Playbook |
Handsdown
Participation Meter
Rookie
Joined: Mar 2009
Posts: 939
Location:
#31
Posted: 4/29/2012 11:40:39 PM
I do not have Excel.  Are you guys going to post the plays daily in here?  Are these the same exact plays that B2W will be playing?
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#32
Posted: 4/30/2012 9:28:41 AM
QUOTE

Originally Posted by Handsdown:

I do not have Excel.  Are you guys going to post the plays daily in here?  Are these the same exact plays that B2W will be playing?

No, you need to see the MLB RPI SYSTEM 2012 thread for the system plays.  This thread is just for the spreadsheet described in the OP.

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#33
Posted: 4/30/2012 3:48:34 PM

The following modification to the spreadsheet is not necessary but you may want to do it for convenience.

Issue:  When you open the spreadsheet for the first time on a given day, the Schedule Date on the RPI Chase worksheet may or may not be set to the current day.

Solution:  If you would like it to always default to the current day, you will need to add some code to the workbook open routine.

Open the RPI Chase 2012 spreadsheet

Press Alt+F11 to open the Visual Basic editor

Under the Microsoft Excel Object, double-click ThisWorkbook, a window opens

Change (General) to Workbook from the Object dropdown menu

Add this code between the two lines, Private Sub Workbook_Open() and End Sub

    Sheets("RPI Chase").Select
    Range("B4").Value = Range("B24").Value
    Range("B4").NumberFormat = "m/d/yyyy"

Save the changes and close the Visual Basic editor

These steps are summarized in the screen capture here.

quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#34
Posted: 4/30/2012 5:18:19 PM
QUOTE Originally Posted by bettor2win:

 I get asked about 100 times a week if I have back/past RPI numbers, which I don't.  Thanks again for your hard work.

Hey Canis,

Don't want to steal your thunder but I updated your workbook to capture the RPI History that B2W wanted.  Take a look - you may find a more elegant solution - but I think it works well.  I just threw in a pivot table on the RPI DB tab to view the data captured on RPI History.

Basically - everytime you update the RPI - it captured today's RPI values in the RPI History Tab.  You can then view what the RPI for was for each team on any gived day on the RPI DB tab.

I'll let B2W know as well - maybe he may want different information in the pivot table or some sort of running graph or calculation.  I also se tit up so if the RPI is for today is already in there - it does not capture it again or create duplicate values.  So you will have to wait for tomorrow - or mess with the date in cell P4 to force it to capture it again.

Anyway - take a look and let me know what you think.  Here is the link.

https://docs.google.com/open?id=0B5dydT9Oe6JbY0FveThyb1JQMGc

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#35
Posted: 4/30/2012 7:26:07 PM

@DG

No worries DG.  You do very good work and my book wouldn't be what it is without your work.  Great job on the RPI DB.  I will test it over the next few days as new data comes in.

To complete the historical functionality, it was my plan to have the RPI from the history for a particular day be used on the RPI Chase worksheet as the Schedule Date cell is changed.

Feel free to give that a go if you want as it may be a few days before I have time to work on it.

Thanks again DG.

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#36
Posted: 5/1/2012 8:58:31 AM

@ALL

There is an issue today with the standings not updating correctly.  This appears to be due to the data coming from ESPN.

I will look into it this morning to try and verify this but if it is on ESPN's end, then there is nothing I can do.  It will most likely 'fix itself' the next time ESPN updates the standings.

 

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#37
Posted: 5/1/2012 9:28:49 AM

New version of the RPI Chase 2012 workbook is now available for download here.

Fixes:

  • Changed UpdateStandings macro to accomodate ESPN change

New:

  • Schedule Date defaults to current day when opening the workbook
  • Schedule Date cell format updated to be consistant with dates on the Schedule worksheet

 

quote
mattymeach31 send a private message View Space | Friends | Playbook |
mattymeach31
Participation Meter
Prospect
Joined: Apr 2012
Posts: 41
Location: New York
#38
Posted: 5/1/2012 10:10:18 AM
Canis,

Is something still wrong? According to B2W, SF is the only "A" play today but the spreadsheet says that ATL is the only "A" play.
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#39
Posted: 5/1/2012 10:38:16 AM

@matty

I don't think so.  B2W might be using his 'wins' filter of 4 which ruled out Atlanta for him.  The spreadsheet is not using that filter.

If you recall, he mentioned a few days ago that the teams he was betting on needed to have at least 4 more wins than their opponent.

quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#40
Posted: 5/1/2012 10:39:46 AM

@matty

Btw, the spreadsheet is showing Atlanta and SF as 'A' plays.

quote
mattymeach31 send a private message View Space | Friends | Playbook |
mattymeach31
Participation Meter
Prospect
Joined: Apr 2012
Posts: 41
Location: New York
#41
Posted: 5/1/2012 11:09:22 AM
I guess I was mixed up because I thought we only bet on teams with at least .500 record. SF (10-12)
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#42
Posted: 5/1/2012 11:31:30 AM
SF is 12W and 10L, or 54.5%.
quote
mattymeach31 send a private message View Space | Friends | Playbook |
mattymeach31
Participation Meter
Prospect
Joined: Apr 2012
Posts: 41
Location: New York
#43
Posted: 5/1/2012 11:39:42 AM
Got it, apparently I didn't have the most updated spreadsheet because now its fixed. Thanks.
quote
bigdog56 send a private message View Space | Friends | Playbook |
bigdog56
Participation Meter
Prospect
Joined: Apr 2006
Posts: 35
Location:
#44
Posted: 5/2/2012 2:42:11 PM
Today's plays are showing CWS (B), Texas (C), Atlanta, (B), LAD (C).  Why is this? 

Where is SF &  NYM?

I've been using the BET button to track my plays and amounts on the MLB Resuts tab.  As a team wins, I assumed it would not to stop the chase and not show LAD & TEX as C games.
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#45
Posted: 5/2/2012 3:47:38 PM
QUOTE

Originally Posted by bigdog56:

Today's plays are showing CWS (B), Texas (C), Atlanta, (B), LAD (C).  Why is this? 

Where is SF &  NYM?

I've been using the BET button to track my plays and amounts on the MLB Resuts tab.  As a team wins, I assumed it would not to stop the chase and not show LAD & TEX as C games.

bigdog,

The RPI Play column will show RPI plays that meet all the criteria without regard to what game it is (A,B,C, or D).  However, if it is an A game, the RPI Play will be 'boxed' in a darker color and use a white font.  This is just to bring your attention to a series A game that meets the criteria.

The Bet button is just an easy way to move that play over to the results tab.  The results tab does not communicate any results back to the Chase tab.

SF and NYM are not showing today because they do not meet the criteria.  RPI and Standings changed overnight as they always do.  Looking at SF for, RPI Edge is 34, required is 42.

I hope this clears up any confusion.

 

quote
bigdog56 send a private message View Space | Friends | Playbook |
bigdog56
Participation Meter
Prospect
Joined: Apr 2006
Posts: 35
Location:
#46
Posted: 5/2/2012 4:28:18 PM
Very much so!! Thanks again for all your hard work on this.
quote
CanisMajor send a private message View Space | Friends | Playbook | My Sportsbook: Top Bet |
CanisMajor
Participation Meter
Prospect
Joined: Jan 2012
Posts: 111
Location: Texas
#47
Posted: 5/3/2012 5:07:53 PM

A new version of the RPI Chase 2012 with Tracking is now available.  This version has historical capability.

Navigate through days on the RPI Chase sheet and all results will show as they were on that day using the history.  If you want to see just the data, go to the MLB DB tab and select the date to filter on.

Screen Shot #1

Screen Shot #2

Download Here

History is available starting on 4/30/2012 and is current through today, 5/3/2012.  You will need to make sure to run the updates every morning to ensure functionality.  I have not tested with missing dates.  I MAY make history available as a weekly download but I can not guarantee that.

Thanks again to DegenGamble for his collaboration.  I know he has just completed something very similar and urge you to check it out as well.

quote
TheMoneyTeam send a private message View Space | Friends | Playbook | My Sportsbook: 5Dimes |
TheMoneyTeam
Participation Meter
Prospect
Joined: Mar 2012
Posts: 204
Location: Texas
#48
Posted: 5/3/2012 6:22:04 PM
Great stuff Canis!! 
quote
TheMoneyTeam send a private message View Space | Friends | Playbook | My Sportsbook: 5Dimes |
TheMoneyTeam
Participation Meter
Prospect
Joined: Mar 2012
Posts: 204
Location: Texas
#49
Posted: 5/3/2012 6:24:26 PM
I wish I can run the macros on Mac Excel 2011. It seems to run errors whenever I try to runt them. I guess I have to boot up parallels to run this awesome spreadsheet.
quote
DegenGamble send a private message View Space | Friends | Playbook |
DegenGamble
Participation Meter
Veteran
Joined: Oct 2011
Posts: 1052
Location: New Jersey
#50
Posted: 5/4/2012 10:03:01 AM
[Quote: Originally Posted by CanisMajor]

A new version of the RPI Chase 2012 with Tracking is now available.  This version has historical capability.

Navigate through days on the RPI Chase sheet and all results will show as they were on that day using the history.  If you want to see just the data, go to the MLB DB tab and select the date to filter on.

Screen Shot #1

Screen Shot #2

Download Here

History is available starting on 4/30/2012 and is current through today, 5/3/2012.  You will need to make sure to run the updates every morning to ensure functionality.  I have not tested with missing dates.  I MAY make history available as a weekly download but I can not guarantee that.

Thanks again to DegenGamble for his collaboration.  I know he has just completed something very similar and urge you to check it out as well.

[/Quote

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

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