Profile | Entries | Thread Author | Posts | Activity |
---|---|---|---|---|
Quote Originally Posted by flemingon: UPDATE not Working.. PitchersAL.Range("A1").QueryTable.Refresh BackgroundQuery:=False <----------- Have error Not sure what is going on but I use mine everyday and it is working.
|
DegenGamble | 866 |
|
|
DegenGamble | 866 |
|
||
Quote Originally Posted by thedavid101:
Is there anyway to get this spreadsheet to update based on overnight lines? I've changed the date field in A44 manually, but the matchups don't get updated correctly the night before. I think there is great value in getting down on reduced overnight lines that this system could really benefit from.
This isn't very helpful but if you refresh the odds after midnight eastern it brings over the new schedule and odds but have to wait until the morning to get the starting pitchers because of the website I use for the daily lineups. |
DegenGamble | 866 |
|
|
I don't have time to do this right now. I can look over the next week or so to see but not sure how to code that so might not be able to do it. I have modified the file to make it so that you can select the casino that you want to see the odds for. https://drive.google.com/file/d/0B3o_3q8GwdsEb2psU2w3VzQxaVk/edit?usp=sharing |
DegenGamble | 866 |
|
|
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 |
DegenGamble | 866 |
|
|
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! 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. |
DegenGamble | 866 |
|
|
Thanks Buckeye. I saw that this morning. Making the changes now. Thanks. Should be fixed by mid week.
|
DegenGamble | 866 |
|
|
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. |
DegenGamble | 866 |
|
|
I finally got this to work and update. I am not sure how to use google docs. Can someone message me instructions on how to upload the file? I have it set to use bovada sportsbook. Others will be able to update if they want but I just wanted to put up a file that was working. |
DegenGamble | 866 |
|
|
After you update the queries...you need to unhide the tab titled Covers URL and replace 2013 with 2014 so that the 2014 season data is brought into the file. You also need to modify the formulas but I haven't had time to look at that yet. |
DegenGamble | 866 |
|
|
Hey Guys. I did the research for the past 5 years and if you bet $25 a game for the games that meet the criteria, you would be up $2706. If you continue to bet through the rest of the year, you are only up $66 over the same five years.
|
DegenGamble | 866 |
|
If you choose to make use of any information on this website including online sports betting services from any websites that may be featured on this website, we strongly recommend that you carefully check your local laws before doing so. It is your sole responsibility to understand your local laws and observe them strictly. Covers does not provide any advice or guidance as to the legality of online sports betting or other online gambling activities within your jurisdiction and you are responsible for complying with laws that are applicable to you in your relevant locality. Covers disclaims all liability associated with your use of this website and use of any information contained on it. As a condition of using this website, you agree to hold the owner of this website harmless from any claims arising from your use of any services on any third party website that may be featured by Covers.