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.

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.

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.

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.

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