Posted:
#801
Anyone able to get this sheet working for 2014 season?
0
MLB Underdog Systems - Anyone want to track this for the season?
Posted:
#802
oil
Yes, based on last years results, I have incorporated it into the 2014 version, however, I'm using the modified system that DG initiated in the middle of the thread that included the (reverse) RL works well with no adjustments other than the innovation of the RRL. I'm quite sure by feedback; that I'm not the only capper who is 'able'
0
Posted:
#803
Quote Originally Posted by sports_Network:
oil
Yes, based on
last years results, I have incorporated it into the 2014 version, however, I'm using the modified system that DG initiated in the middle of the thread that included the (reverse) RL works well with no adjustments other than the innovation of the RRL. I'm quite sure by feedback; that I'm not the only capper who is 'able'
Would you be able to post a link to the revised sheet, similar to what DG has done in the past via google docs?
0
Posted:
#805
Quote Originally Posted by sports_Network:
no need of repetition, the links to everything are posted throughout the thread, and are clearly comprehensible to application
Yes, as to what the sheet produces....but the actual working excel file is not updated to function this season....formatting with vegasinsider.com has changed causing the sheet to 'malfunction' and render itself useless until it can be repaired.
0
Posted:
#808
I hope this will help or may be what is needed to help the spreadsheet get functional. I only spent a little time on this so I may have missed somthing, I did not check it functionality compared to the system rules. Please let me know if it is not functional and I can see what i can do.
https://drive.google.com/file/d/0B9UBaNk9s7UjZEp2cnRDNWJBckE/edit?usp=sharing
0
Posted:
#815
https://drive.google.com/file/d/0B3o_3q8GwdsEQ1Nzb3pvTXliU00/edit?usp=sharing
I think this is the link to get the file. Hope this works for everyone.
0
Posted:
#816
Quote Originally Posted by DegenGamble:
oilcountry99: review the beginning of the thread, take it for what it is and simply coordinate it with the 2014 MLB season, it appears that your problem is not the Sheet itself; but rather the IT application involving the re-attachment of the links to the 2014 season, this is understandable, as you have clearly indicated previously in your commentary regarding the vegasinsider.com links, that are different by the year, as are numerous others that need an upgrade; below are the games produced from yesterday's Sheet (Thursday 04/03/14) as an example to comprehension>>
Below is the spreadsheet for some MLB underdog systems - As I have have mentioned in numerous threads - I am HORRIBLE at tracking systems and maintaining threads....it's just not my thing (sorry)
I was wondering if someone wanted to volunteer to track each system using the spreadsheet of course to see if they actually provide a positive ROI. I tried to make it as easy as possible - press a button and post the plays each day.
Hope someone steps up to the plate 
MLB Underdog Systems
This spreadsheet automates the MLB underdog systems listed on the the following websites:
https://www.betfirms.com/baseball-betting-systems-underdogs/
https://www.vegasinsider.com/mlb/story.cfm/story/571442/
Now the VegasInsider.com link just goes into more detail of the last system of the Bet Firms Link
https://docs.google.com/file/d/0B5dydT9Oe6JbRXhKaVRGT2lkSXc/edit?usp=sharing
It takes a good 3-5 minutes to pull all the data needed but it shows what teams it's downloading in the lower left hand corner of excel - so just grab a cup of coffee in the mean time. You only need to run it once each morning. In addition, for the <6 hits system - you just have to manually check if the team allowed less than 6 hits in their privious game and enter it in the field. I didn't automate it because I didn't want to slow it down any more for data that would only be used IF the team happens to be a play for that system.
Features:
· All plays and data needed for the day are updated upon clicking the “Update” button
· You can download from the link above:
*Just a reminder that the <6 hits system needs some manual inputs
CHC+148 -vs- PIT WIN
StL-102 -vs- CIN-105 WIN
BOS+105 -vs- BAL WIN
SEA+132 -vs- OAK LOSS
MIN+128 -vs- CHW WIN
S.F.+115 -vs- ARI WIN
the system is 21-2 for the 2014 season, coinciding with last years pre All Star game results.......take care
0
Posted:
#817
Hey...I was able to download the V14 file successfully. I was even able to update the spreadsheet after changing the date to today's date (it populated plays for the Divisional Underdog and the MLB Underdog System). I really appreciate you updating the spreadsheet! Is it good to go? Also what system would you suggest I play? I was browsing through the plays last season and it seemed that some systems did better at different points in the season. Which system would you suggest I follow from now until the all-star break? Thank you so much for your help!
0
Posted:
#819
Nice job on the update. However, I found a couple of problems that I made a quick fix for. If you have updated for today (April 5th) you will see in the Nyy/Tor game that both pitchers are Dickey. This is because Dickey has periods in his first name. This causes a problem for your formula in Col Z of the Schedule tab.
If you change the formula to:
=IFERROR(MID(K2,SEARCH("vs.",K2,1),SEARCH("(",K2,SEARCH("vs.",K2,1))-SEARCH("vs.",K2,1)),"")
...don't forget the period after vs. and change Col AA to:
=IFERROR(TRIM(RIGHT(Z2,LEN(Z2)-3)),"")
this will fix that problem.
The other problem I saw was that pitchers for the respective teams are backward. On Col G of the Summary tab, in the Away pitcher formula the Col should be AD not U and the opposite for Home pitcher...U not AD.
0
Posted:
#822
Quote Originally Posted by Mest16:
Hey...I was able to download the V14 file successfully. I was even able to update the spreadsheet after changing the date to today's date (it populated plays for the Divisional Underdog and the MLB Underdog System). I really appreciate you updating the spreadsheet! Is it good to go? Also what system would you suggest I play? I was browsing through the plays last season and it seemed that some systems did better at different points in the season. Which system would you suggest I follow from now until the all-star break? Thank you so much for your help!
Hey...I was able to download the V14 file successfully. I was even able to update the spreadsheet after changing the date to today's date (it populated plays for the Divisional Underdog and the MLB Underdog System). I really appreciate you updating the spreadsheet! Is it good to go? Also what system would you suggest I play? I was browsing through the plays last season and it seemed that some systems did better at different points in the season. Which system would you suggest I follow from now until the all-star break? Thank you so much for your help!
From my research, the underdogs system are extremely profitable through June. Start with that and track the others as you get comfortable. I am making the fixes to the file and it will be ready by mid week.
0
Posted:
#823
Quote Originally Posted by BuckeyeKaptn:
Nice job on the update. However, I found a couple of problems that I made a quick fix for. If you have updated for today (April 5th) you will see in the Nyy/Tor game that both pitchers are Dickey. This is because Dickey has periods in his first name. This causes a problem for your formula in Col Z of the Schedule tab.
Nice job on the update. However, I found a couple of problems that I made a quick fix for. If you have updated for today (April 5th) you will see in the Nyy/Tor game that both pitchers are Dickey. This is because Dickey has periods in his first name. This causes a problem for your formula in Col Z of the Schedule tab.
If you change the formula to:
=IFERROR(MID(K2,SEARCH("vs.",K2,1),SEARCH("(",K2,SEARCH("vs.",K2,1))-SEARCH("vs.",K2,1)),"")
...don't forget the period after vs. and change Col AA to:
=IFERROR(TRIM(RIGHT(Z2,LEN(Z2)-3)),"")
this will fix that problem.
The other problem I saw was that pitchers for the respective teams are backward. On Col G of the Summary tab, in the Away pitcher formula the Col should be AD not U and the opposite for Home pitcher...U not AD.
Please Reupload the spreadsheet
0
Posted:
#824
Alright guys. Here is the updated spreadsheet. I also saw that Bovada wasn't refreshing so I fixed that as well. Please review the spreadsheet and let me know if you find anything not working correctly. Once this is working correctly, I will modify the vba code to allow for sportsbook selection.
https://drive.google.com/file/d/0B3o_3q8GwdsEYzRiYkc5c1ZuVTg/edit?usp=sharing
0
Hot Forum Topics
