All Forums | Systems & Strategies

T/R Home/Away Power Rankings

Participants:
Search
Views: 29692
Posts: 243
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #176
Plays for 7/29
Official:
Cleveland
Cincinnati

Unofficial:
Cleveland
Atlanta
Nym
Oakland
Cincinnati

A Bets for Tomorrow 7/30 (The numbers shouldn't change)
Official:
Baltimore
Boston

Unofficial:
Baltimore
Philadelphia
Boston
Kansas City

A couple of 2g series on July 30th, if you wish to play...not part of the system:

TR Pred (Official):
Detroit
Tampa Bay

TR H/A (Unofficial)
Detroit
Tampa Bay
Nyy


Thanx Greg
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #177
Plays for 7/29
Official:
Cleveland Win
Cincinnati Loss

Unofficial:
Cleveland Win
Atlanta Win
Nym Win
Oakland Win
Cincinnati Loss

Plays for 7/30 
Official:
Baltimore
Boston
Cincinnati B

Unofficial:
Baltimore
Philadelphia
Boston
Kansas City
Cincinnati B

A couple of 2g series on July 30th, if you wish to play...not part of the system:

TR Pred (Official):
Detroit
Tampa Bay

TR H/A (Unofficial)
Detroit
Tampa Bay
Nyy
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #178
Playing around with a copy of the spreadsheet and found out that the Sagarin ratings have not updated since mid May.  B E Autiful!!
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #179
Plays for 7/30 
Official:
Baltimore Won
Boston Won
Cincinnati Loss

Unofficial:
Baltimore Won
Philadelphia Won
Boston Won
Kansas City Won
Cincinnati Loss

A couple of 2g series on July 30th, if you wish to play...not part of the system:

TR Pred (Official):
Detroit Won
Tampa Bay Won

TR H/A (Unofficial)
Detroit Won
Tampa Bay Won
Nyy Loss

Plays for 7/31
Official:
Cincinnati C

Unofficial:
Cincinnati C

2g series on July 31,...not part of the system:

TR Pred (Official):
no play

TR H/A (Unofficial)
Nyy B


 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #180
Plays for 7/31
Official:
Cincinnati Won

Unofficial:
Cincinnati Won

2g series on July 31,...not part of the system:

TR Pred (Official):
no play

TR H/A (Unofficial)
Nyy Won
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #181
Ok, like I'm an idiot.  I left my laptop at work, with all my excel files on it.  I tried d loading the excel I have posted on here but there's only an expired trail version of Microsoft Office on this laptop....so I had to do this by manual labor!!!
Please correct me if this is wrong:

Plays for 8/01
Official:
No plays

Unofficial:
Texas
LaDodgers
Toronto

 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #182
I hope Texas wins cause that game against Arizona must be a rain out make up game and not a 3 game series.  Tomorrow Texas plays Oakland.
 
Prospect
Participation Meter
Joined: Jun, 2013
Posts: 41
Posted: #183
hello everybody, I would like to know if you have problems during update on the tabs away, home, and OUAway OUhome for me this morning that changed my lines and hit it against myself of NA ds tab summary
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #184
My hours at work have changed, I'd appreciate it if someone would post the plays, if I haven't,and if it's about an hour before gametime.  I wouldn't have been able to if we had a 12pm start today.

literato, I'm checking my copy now

Sunday, evening I hope to have a new copy up, with Sagarin fixed.  We don't use the Covers data that downloads all the time, so I will get rid of that.  That will cut almost all the refresh time down to 30 secs, give or take.
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #185
Ok, my copy sux.  So I'm going to fix and get that copy up Sunday.  I will use my copy each day, so I will know if there is a problem.

Today's Plays 8/2
Official:
Det
Atl
Pit
Bos
KC
Cle
Sf
Hou
Nyy

Unofficial
Same as official but add:
Oak
Bal
Tor B

ATLANTA is not an unofficial
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #186
cancel all that, this copy down loaded wrong too.
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #187
I gotta go back to work, I'll try to fix this later tonight.
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #188
official:
Bal
det
atl
bos
kc
cle


 
Prospect
Participation Meter
Joined: Nov, 2012
Posts: 99
Posted: #189
what about TB?
 
Prospect
Participation Meter
Joined: Jun, 2013
Posts: 41
Posted: #190

I struggled to find a compromise on the macro and here I I put

Sub UpdateAwayPowerRankings()

    'https://www.teamrankings.com/mlb/ranking/last10-power-ranking-by-team
    'https://www.teamrankings.com/mlb/ranking/overall-power-ranking-by-team
   
    'set worksheets
    Call SetWorksheets
   
    'get L10 Rankings
    Call IEScreenScrape("https://www.teamrankings.com/mlb/ranking/away-power-ranking-by-team")

    'Delete rows we don't need
    Temp.Rows("6:105").Delete Shift:=xlUp
    Temp.Rows("42:225").Delete Shift:=xlUp

    'Copy and paste into L10 tab
    With Temp
        .Range("A12:I45").Copy
        Away.Range("A1").PasteSpecial xlPasteValues
    End With

    'Cleanup
    Temp.Cells.ClearContents

End Sub


Sub UpdateHomePowerRankings()

    'https://www.teamrankings.com/mlb/ranking/last10-power-ranking-by-team
    'https://www.teamrankings.com/mlb/ranking/overall-power-ranking-by-team
   
    'set worksheets
    Call SetWorksheets
   
    'get L10 Rankings
    Call IEScreenScrape("https://www.teamrankings.com/mlb/ranking/home-power-ranking-by-team")

    'Delete rows we don't need
    Temp.Rows("6:105").Delete Shift:=xlUp
    Temp.Rows("42:225").Delete Shift:=xlUp

    'Copy and paste into powe rankings tab
    With Temp
        .Range("A12:I45").Copy
        Home.Range("A1").PasteSpecial xlPasteValues
    End With

    'Cleanup
    Temp.Cells.ClearContents

End Sub

Sub UpdateOverUnderAway()

    'https://www.teamrankings.com/mlb/ranking/last10-power-ranking-by-team
    'https://www.teamrankings.com/mlb/ranking/overall-power-ranking-by-team
   
    'set worksheets
    Call SetWorksheets
   
    'get L10 Rankings
    Call IEScreenScrape("https://www.teamrankings.com/mlb/trend/ou_trends/is_away")

    'Delete rows we don't need
    Temp.Rows("6:105").Delete Shift:=xlUp
    Temp.Rows("40:225").Delete Shift:=xlUp

    'Copy and paste into powe rankings tab
    With Temp
        .Range("A10:e40").Copy
        OUAway.Range("A1").PasteSpecial xlPasteValues
    End With

    'Cleanup
    Temp.Cells.ClearContents

End Sub
Sub UpdateOverUnderHome()

    'https://www.teamrankings.com/mlb/ranking/last10-power-ranking-by-team
    'https://www.teamrankings.com/mlb/ranking/overall-power-ranking-by-team
   
    'set worksheets
    Call SetWorksheets
   
    'get L10 Rankings
    Call IEScreenScrape("https://www.teamrankings.com/mlb/trend/ou_trends/is_home")

    'Delete rows we don't need
    Temp.Rows("6:105").Delete Shift:=xlUp
    Temp.Rows("40:225").Delete Shift:=xlUp

    'Copy and paste into powe rankings tab
    With Temp
        .Range("A10:e40").Copy
        OUhome.Range("A1").PasteSpecial xlPasteValues
    End With

    'Cleanup
    Temp.Cells.ClearContents

End Sub

 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #191
Quote Originally Posted by NoSoLucky:

what about TB?
yep, Tb too.  I was hurrying while I was comparing numbers and I must have missed it.  My new schedule has me working until 7 pm, I don't have the time any more if there's problems, until the next day, or after the EST games start.  Quick fix is done....Sagarin and the TR away, home and pred tabs are fixed, and finally Covers no longer updates, which means that the refresh time is under a minute.  I'm not going to make a full repair of the spreadsheet, like changing web sites that I use to pull info off of (odds, pitchers etc, not the TR info) until next year.  I wanna start doing NFL stuff.
Version 5

https://docs.google.com/file/d/0Bynr1eDtdk5ZblZxaktiYXNIelE/edit?usp=sharing

 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #192
The reason the spreadsheet was screwed up is that the TR website did a minor adjustment on it's rankings page.
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #193
Plays for 8/01
Official:
No plays

Unofficial:
LaDodgers
Toronto
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #194
Plays for 8/01
Official:
No plays

Unofficial:
LaDodgers Won
Toronto Loss


Plays for 8/02
Official:
Detroit
Pittsburgh
Boston
Cleveland
Tampa Bay

Unofficial:
Toronto B
Baltimore
Detroit
Pittsburgh
Boston
Kansas City
Cleveland
Tampa Bay
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #195
Add Atlanta to Official, gotta find the reason it didn't show


Thanx Literato
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #196
Ok, I found the problem why Atlanta didn't show up.  I forgot that Predicitive was a filter when I started using it.  Along the way, I started using it as the Official part, by itself, without the Home/Away part. Look at the far right, under the column Team Pred.  If the difference between the 2 numbers is .9 or more, the higher number is a play.
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #197
Through games ending 7/31:

Official YTD 35-1 +22.92u (Thread Only)
Official YTD:  102-5, +68.69u
Unofficial YTD 127-11 33.07u (Thread Only)
Unofficial YTD 203-17 +83.91u

Post #91 for the difference in Official/Unofficial

*Based on Covers' closing line

Link to current spreadsheet:  Version 5

https://docs.google.com/file/d/0Bynr1eDtdk5ZblZxaktiYXNIelE/edit?usp=sharing

 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #198
Horrible day.

Plays for 8/02
Official:
Detroit Won
Pittsburgh Loss
Boston Loss
Cleveland Loss
Tampa Bay Loss
Atlanta Won

Unofficial:
Toronto B Loss
Baltimore Won
Detroit Won
Pittsburgh Loss
Boston Loss
Kansas City Loss
Cleveland Loss
Tampa Bay Loss


Plays for 8/03
Official:
Pittsburgh B
Boston B
Cleveland B
Tampa Bay B

Unofficial:
Toronto C
Pittsburgh B
Boston B
Kansas City B
Cleveland B
Tampa Bay B

 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #199
NICE DAY, except for Toronto.  I rechecked to see if they were even a play.....and they were.  Still made a profit on the Unofficial, of .91u!!!

Plays for 8/03
Official:
Pittsburgh Won
Boston Won
Cleveland Won
Tampa Bay Won

Unofficial:
Toronto Loss
Pittsburgh Won
Boston Won
Kansas City Won
Cleveland Won
Tampa Bay Won

 
 
Veteran
Participation Meter
Joined: Jan, 2013
Posts: 1447
Posted: #200
Official YTD  (Thread Only) 41-1 28.92u
Official YTD:  108-5 74.69u
Unofficial YTD (Thread Only) 135-12 33.98u
Unofficial YTD 211-18 84.82u

Post #91 for the difference in Official/Unofficial

*Based on Covers' closing line

Link to current spreadsheet:  Version 4

https://docs.google.com/file/d/0Bynr1eDtdk5ZblZxaktiYXNIelE/edit?usp=sharing

All Forums | Systems & Strategies
About Us
Contact Us
Careers
Our Team
Brand
Testimonials
Betting Guides
Sportsbook Reviews
Betting News
Podcasts
Responsible Gambling
Betting Sites
US Betting Sites
Canada Betting Sites
Canada Casinos
Best Betting Apps
Contests
Streak Survivor
King of Covers
Office Pools
The Covers community has
810,221
lifetime members worldwide
Covers 30 Years Logo Established in 1995,
Covers is the world
leader in sports
betting information.
21+
Gambling problem? Call 1-800-GAMBLER
Help Privacy Privacy Choices Terms of Service Cookies Sitemap Forum
Covers is verified safe by:
Evalon Logo Logo GPWA Logo GDPR logo Logo GeoTrust logo Logo
Covers Logo
Copyright © 1995 - 2026 Genius Sports. 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.