All Forums | Systems & Strategies

MLB Underdog Systems - Anyone want to track this for the season?

...
Participants:
Search model icon
Views: 106099
Posts: 866
 
Prospect
Participation Meter
Joined: Mar, 2014
Posts: 6
Posted: #826
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.
 
Prospect
Participation Meter
Joined: Mar, 2014
Posts: 11
Posted: #827

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

 
Prospect
Participation Meter
Joined: Mar, 2014
Posts: 11
Posted: #828
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.

 
Prospect
Participation Meter
Joined: Dec, 2013
Posts: 11
Posted: #829
Quote Originally Posted by jwenthur:

 

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.



What teams should win today?

Divisional Underdog OR MLB Underdog System ?
 
Prospect
Participation Meter
Joined: Dec, 2013
Posts: 11
Posted: #830
jwenthur 

When I click Update, I get an error and the debug takes me to this line:

[URL=https://www.subirimagenes.com/otros-error-8871239.html][IMG]https://s2.subirimagenes.com/otros/previo/thump_8871239error.jpg[/IMG][/URL]
 
Prospect
Participation Meter
Joined: Dec, 2013
Posts: 11
Posted: #831
Check This:

https://s2.subirimagenes.com/otros/previo/thump_8871239error.jpg

[url=https://www.subirimagenes.com/otros-error-8871239.html]Ver Imagen: https://s2.subirimagenes.com/otros/previo/thump_8871239error.jpg[/url]
 
Banned
Participation Meter
Joined: Feb, 2009
Posts: 8426
Posted: #832
 
Banned
Participation Meter
Joined: Feb, 2009
Posts: 8426
Posted: #833
[Quote: Originally Posted by juniorknot]

 

What teams should win today?

Divisional Underdog? or MLB Underdog System?
[/Quote]good questions;  that deserve 'good' answers.....
 
Prospect
Participation Meter
Joined: Oct, 2011
Posts: 130
Posted: #834
Anyone know last year's record of the 6 hit system? I can not get the database query to work.
 
Prospect
Participation Meter
Joined: Jan, 2014
Posts: 3
Posted: #835
jwenthur..

    'Get Pitcher Ratings
    
    PitchersAL.Range("A1").QueryTable.Refresh BackgroundQuery:=False
    PitchersAL.Range("A500").QueryTable.Refresh BackgroundQuery:=False
    PitchersNL.Range("A1").QueryTable.Refresh BackgroundQuery:=False
    PitchersNL.Range("A500").QueryTable.Refresh BackgroundQuery:=False


Not work..
 
Banned
Participation Meter
Joined: Feb, 2009
Posts: 8426
Posted: #836
Quote Originally Posted by reaptherewards:

Anyone know last year's record of the 6 hit system? I can not get the database query to work.
they are posted in this thread by Danrules24 in the conclusion of his tracking every play the sheet produced, including the 6 hit system. they are clearly visible throughout, you just need to look, they're their...
 
Prospect
Participation Meter
Joined: Oct, 2011
Posts: 130
Posted: #837
Thanks for all of your help sports_Network, but the system count is not the answer to my question, or maybe I can't read, or am blind. But I really do appreciate your guiding my me through 835 posts for a total waste of my time, which I did before asking the question. Good luck.
 
Prospect
Participation Meter
Joined: Mar, 2014
Posts: 11
Posted: #838

https://drive.google.com/file/d/0B3o_3q8GwdsEaG1rV2xJMll0dTA/edit?usp=sharing

 

This one is working

 
Prospect
Participation Meter
Joined: Jan, 2014
Posts: 3
Posted: #839
Quote Originally Posted by jwenthur:

https://drive.google.com/file/d/0B3o_3q8GwdsEaG1rV2xJMll0dTA/edit?usp=sharing

 

This one is working


I'll try and comment if it works well, do not tell me what should be the odds?

What teams should win today?

Divisional Underdog? or MLB Underdog System?
 
Prospect
Participation Meter
Joined: Jan, 2014
Posts: 3
Posted: #840
Quote Originally Posted by jwenthur:

https://drive.google.com/file/d/0B3o_3q8GwdsEaG1rV2xJMll0dTA/edit?usp=sharing

 

This one is working


UPDATE not Working..


    PitchersAL.Range("A1").QueryTable.Refresh BackgroundQuery:=False <----------- Have error
 
Prospect
Participation Meter
Joined: Mar, 2014
Posts: 11
Posted: #841
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.
 
Prospect
Participation Meter
Joined: Dec, 2013
Posts: 11
Posted: #842
Quote Originally Posted by jwenthur:


Not sure what is going on but I use mine everyday and it is working.

please cant create macros only for Pitchers-ERA-AL and Pitchers-ERA-NL and update sagarin?

 
Prospect
Participation Meter
Joined: Dec, 2013
Posts: 11
Posted: #843
?
 
Banned
Participation Meter
Joined: Feb, 2009
Posts: 8426
Posted: #844
a good system out the gate, unfortunately, that's where it ends, melting qown before the All Star break.
 
Prospect
Participation Meter
Joined: Dec, 2014
Posts: 11
Posted: #845
Is anyone going to update the sheet for upcoming season? It would be greatly appreciated.
Also, I would like to ask how DogEFF/RRL plays were selected? Thanks.
 
Veteran
Participation Meter
Joined: Oct, 2011
Posts: 1150
Posted: #846
I plan to - any takers in tracking?
 
Prospect
Participation Meter
Joined: Dec, 2014
Posts: 11
Posted: #847
Thats wonderful to hear. I plan on playing one of the system outlined so I could be tracking it but I need to get used to how the systems work. There were too many tweaks that it is difficult to follow which one is the best. Still don't understand how DogEFF/RRL plays were selected for example.
 
Prospect
Participation Meter
Joined: Jan, 2015
Posts: 11
Posted: #848
Hey Degen, sent a friend request, have some questions about the system, if you some free time!  
 
Prospect
Participation Meter
Joined: Mar, 2015
Posts: 34
Posted: #849
How to make this spreadsheet to work for this season ?


 
 
Prospect
Participation Meter
Joined: Dec, 2014
Posts: 11
Posted: #850
Degen, any timetable on updating the spreadsheet? Thanks.
All Forums | Systems & Strategies
About Us
Contact Us
Careers
Our Team
Brand
Testimonials
Betting Guides
Sportsbook Reviews
Sports Betting News
Podcasts
Responsible Gaming
Sports Betting
US Betting Sites
Canada Betting Sites
Canada Casinos
Best Betting Apps
Contests
Streak Survivor
King of Covers
Ultimate Race
Office Pools
The Covers community has
618,670
lifetime members worldwide
Covers 25 Years Logo Established in 1995,
Covers is the world
leader in sports
betting information.
Site Map Help Privacy Terms of Service youtube logo facebook logo twitter logo instagram logo linkedin logo google news logo
Covers is verified safe by: Evalon Logo GPWA Logo GDPR Logo GeoTrust Logo Evalon Logo
Copyright © 1995 - 2024 CS Media Limited All Rights Reserved.

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.