Messages

Forum Index : Systems & Strategies : Messages Page 8 of 10 «  6 7 8 9 10   »
Author: [Systems & Strategies] Topic: T/R Home/Away Power Rankings
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#176
Posted: 7/29/2013 6:48:53 AM
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
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#177
Posted: 7/30/2013 6:45:56 AM
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
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#178
Posted: 7/30/2013 7:46:55 AM
Playing around with a copy of the spreadsheet and found out that the Sagarin ratings have not updated since mid May.  B E Autiful!!
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#179
Posted: 7/31/2013 6:59:42 AM
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


quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#180
Posted: 8/1/2013 7:05:47 AM
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
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#181
Posted: 8/1/2013 7:23:36 AM
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

quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#182
Posted: 8/1/2013 7:44:56 PM
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.
quote
literato
RSI Wagerline RSI Rating
send a private message View Space | Friends | Playbook |
literato
Participation Meter
Prospect
Joined: Jun 2013
Posts: 34
Location: France
#183
Posted: 8/2/2013 5:37:00 AM
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
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#184
Posted: 8/2/2013 1:18:01 PM
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.
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#185
Posted: 8/2/2013 1:27:23 PM
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
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#186
Posted: 8/2/2013 1:28:45 PM
cancel all that, this copy down loaded wrong too.
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#187
Posted: 8/2/2013 1:29:54 PM
I gotta go back to work, I'll try to fix this later tonight.
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#188
Posted: 8/2/2013 1:32:03 PM
official:
Bal
det
atl
bos
kc
cle


quote
NoSoLucky send a private message View Space | Friends | Playbook | My Sportsbook: Mirage |
NoSoLucky
Participation Meter
Prospect
Joined: Nov 2012
Posts: 99
Location: Illinois
#189
Posted: 8/2/2013 3:59:47 PM
what about TB?
Posted using a mobile device.
quote
literato
RSI Wagerline RSI Rating
send a private message View Space | Friends | Playbook |
literato
Participation Meter
Prospect
Joined: Jun 2013
Posts: 34
Location: France
#190
Posted: 8/2/2013 4:09:30 PM

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

Sub UpdateAwayPowerRankings()

    'http://www.teamrankings.com/mlb/ranking/last10-power-ranking-by-team
    'http://www.teamrankings.com/mlb/ranking/overall-power-ranking-by-team
   
    'set worksheets
    Call SetWorksheets
   
    'get L10 Rankings
    Call IEScreenScrape("http://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()

    'http://www.teamrankings.com/mlb/ranking/last10-power-ranking-by-team
    'http://www.teamrankings.com/mlb/ranking/overall-power-ranking-by-team
   
    'set worksheets
    Call SetWorksheets
   
    'get L10 Rankings
    Call IEScreenScrape("http://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()

    'http://www.teamrankings.com/mlb/ranking/last10-power-ranking-by-team
    'http://www.teamrankings.com/mlb/ranking/overall-power-ranking-by-team
   
    'set worksheets
    Call SetWorksheets
   
    'get L10 Rankings
    Call IEScreenScrape("http://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()

    'http://www.teamrankings.com/mlb/ranking/last10-power-ranking-by-team
    'http://www.teamrankings.com/mlb/ranking/overall-power-ranking-by-team
   
    'set worksheets
    Call SetWorksheets
   
    'get L10 Rankings
    Call IEScreenScrape("http://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

quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#191
Posted: 8/2/2013 8:50:58 PM
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

quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#192
Posted: 8/2/2013 8:52:47 PM
The reason the spreadsheet was screwed up is that the TR website did a minor adjustment on it's rankings page.
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#193
Posted: 8/2/2013 8:53:40 PM
Plays for 8/01
Official:
No plays

Unofficial:
LaDodgers
Toronto
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#194
Posted: 8/2/2013 8:56:57 PM
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
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#195
Posted: 8/2/2013 8:59:00 PM
Add Atlanta to Official, gotta find the reason it didn't show


Thanx Literato
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#196
Posted: 8/2/2013 9:06:16 PM
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.
quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#197
Posted: 8/2/2013 9:20:07 PM
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

quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#198
Posted: 8/3/2013 6:43:22 AM
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

quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#199
Posted: 8/4/2013 11:00:08 AM
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

quote
BuckeyeKaptn send a private message View Space | Friends | Playbook |
BuckeyeKaptn
Participation Meter
Rookie
Joined: Jan 2013
Posts: 577
Location: Ohio
#200
Posted: 8/4/2013 11:00:36 AM
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

quote
Forum Index : Systems & Strategies : Messages Page 8 of 10 «  6 7 8 9 10   »
You have entered the forum as a GUEST. 
You must login/register to post or reply.