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. 
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.
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.
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
@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.
@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.
New version of the RPI Chase 2012 workbook is now available for download here.
Fixes:
New:
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.
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.
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.
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.
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
Established in 1995,
Hot Forum Topics
){kind=link}
){kind=link}
){kind=link}