2010 mlb capping & betting #102 - daily key info plus q&a

[mason456]

not speaking for him but i know it was b4 2pm pst that i saw the notice from SO on him and the line was 9- plus 105 when i pick it up as well

Don't think anyone faster with info then SO

 

[CHITOWNODAWG]

Cant help but pound the col un9 de la rosa is another stud in that rotation i see him having little trouble with the nats tonight

 

[pops69]

eddings at 3rd in hou so 2nd game of next series should be an early catch

nothing for any of the other. not sticking for the oak game

 

[cigar]

g nite pops

 

[IrishTim]

Excel question for the gurus.

I attached a sample from one of my MLB dbs. I want to look at the different scoring distributions between leagues. Thus I need to create a column in my data base that distinguishes between AL, NL, and IL (interleague play). I can't seem to get the correct if-statements. I will send the data from '07 to '09 to anyone who can get this done for me.

The following are the team abbreviations:

AL
BAL
BOS
NYA
TBA
TOR
CHA
CLE
DET
KCA
MIN
ANA
OAK
SEA
TEX

NL
ATL
FLO
NYN
PHI
WAS
CIN
HOU
MIL
PITT
SLN
ARI
COL
LAN
SDN
SFN
CHN

Thanks fellas.

 

[oilbarrel]

Licking my wounds from fletch...at least it was over quick.

IT- what i would suggest is you create a quick lookup table and then do a vlookup off the data- shud take you all of 5mins. if you don't know how to let me know and i can walk you thru

 

[IrishTim]

Licking my wounds from fletch...at least it was over quick.

IT- what i would suggest is you create a quick lookup table and then do a vlookup off the data- shud take you all of 5mins. if you don't know how to let me know and i can walk you thru

Same re: fletch

Just sent you an e-mail kev.

 

[MNNAT]

Irish, might be a little tedious, but a snip-it of a table such as this:

<table style="border-collapse: collapse; width: 240pt;" width="320" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64" span="5"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" width="64" height="20">
</td> <td style="width: 48pt;" width="64">NYY</td> <td style="width: 48pt;" width="64">TEX</td> <td style="width: 48pt;" width="64">STL</td> <td style="width: 48pt;" width="64">ATL</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">NYY</td> <td class="xl63">N/A</td> <td class="xl63">AL</td> <td class="xl63">I</td> <td class="xl63">I</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">TEX</td> <td class="xl63">AL</td> <td class="xl63">N/A</td> <td class="xl63">I</td> <td class="xl63">I</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">STL</td> <td class="xl63">IL</td> <td class="xl63">IL</td> <td class="xl63">N/A</td> <td class="xl63">NL</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">ATL</td> <td class="xl63">IL</td> <td class="xl63">IL</td> <td class="xl63">NL</td> <td class="xl63">N/A</td> </tr> </tbody></table>
Just do a 2-way lookup function predicated on the home team. Minimal data entry, but should achieve your desired result. You can also incorporate an ISERROR in there in case you get 2 teams that are mixed up (producing the N/A).

:toast:

 

[MNNAT]

Sorry, IL=Interleague. "I" is the same thing. Probably obvious, but just clarification....

 

[oilbarrel]

IT sent you a quick easy example. the first step you should make is but each team in a column and put the league next to them or whatever you want to assign to them.

Mnnat's version will work as well, but I think its more work. I like easy, but could be in the eye of the beholder

 

[pops69]

Wednesday April 21st

today's pdws and updated mlb master and sharing info below

was vs roc is off the charts. what goes up must come down

looks like a bunch of old business. love it

 

[pops69]

Excel question for the gurus.

I attached a sample from one of my MLB dbs. I want to look at the different scoring distributions between leagues. Thus I need to create a column in my data base that distinguishes between AL, NL, and IL (interleague play). I can't seem to get the correct if-statements. I will send the data from '07 to '09 to anyone who can get this done for me.

The following are the team abbreviations:

AL
BAL
BOS
NYA
TBA
TOR
CHA
CLE
DET
KCA
MIN
ANA
OAK
SEA
TEX

NL
ATL
FLO
NYN
PHI
WAS
CIN
HOU
MIL
PITT
SLN
ARI
COL
LAN
SDN
SFN
CHN

Thanks fellas.

thats already in my mlb master plus conf as well. not sure what's diff in your vs what's already there

 

[CTP]

Change the row number and good to go. Lookup would be smaller file size. Need same for Vis TM. I use this as the PDWS did not have the the divisions until the next day.

IF(OR(G4420="CWS",G4420="CLE",G4420="DET",G4420="KAN",G4420="MIN"),"ALC",IF(OR(G4420="BAL",G4420="BOS",G4420="NYY",G4420="TAM",G4420="TOR"),"ALE",IF(OR(G4420="LAA",G4420="OAK",G4420="SEA",G4420="TEX"),"ALW","")))&IF(OR(G4420="ARI",G4420="COL",G4420="LOS",G4420="SDG",G4420="SFO"),"NLW",IF(OR(G4420="CUB",G4420="CIN",G4420="HOU",G4420="MIL",G4420="PIT",G4420="STL"),"NLC",IF(OR(G4420="ATL",G4420="FLA",G4420="NYM",G4420="PHI",G4420="WAS"),"NLE","")))

 

[CTP]

The above separates into divisions. If you want by just league add the rest to one of the statements and done.

 

[IrishTim]

You guys are the best. To think where I would be without pops' thread.

thats already in my mlb master plus conf as well. not sure what's diff in your vs what's already there

There's no difference but I wanted to know the logic/mechanics of getting including a col for AL/NL/IL for the line data I have back to '03. The specific division isn't important to me (unless there is a reason to believe scoring patterns differ from division to division), just the different scoring distribution between AL and NL.

I'm looking at a bunch of things, one is run line probabilities and these are dependent on what league the teams are in (i.e. what DH/pitching rules they are playing with as well as the stylistic differences between leagues).

 

[pops69]

You guys are the best. To think where I would be without pops' thread.



There's no difference but I wanted to know the logic/mechanics of getting including a col for AL/NL/IL for the line data I have back to '03. The specific division isn't important to me (unless there is a reason to believe scoring patterns differ from division to division), just the different scoring distribution between AL and NL.

I'm looking at a bunch of things, one is run line probabilities and these are dependent on what league the teams are in (i.e. what DH/pitching rules they are playing with as well as the stylistic differences between leagues).

a much simpler way (just make sure all cols are the same and naming as well) just drag from newer up thru the older data and it will all just fill in

 

[pops69]

tim, the one piece of data that i always wanted but could never figure out a way to get it easy and a bunch of work

pitcher year of contract

 

[bluelabga]

Pops - noticed that the line moves on o/u's yesterday mostly won - I usually fade them but yesterday was a different story? How long would you consider fading the lines moves on o/u's from the opening line?

 

[pops69]

Pops - noticed that the line moves on o/u's yesterday mostly won - I usually fade them but yesterday was a different story? How long would you consider fading the lines moves on o/u's from the opening line?

historically they are around 50/50 each way. u need to really look at the reason (external factors or other) and the amount of the move as well vs just fadding or following all. take a look at last years pivots in the LM tab and this years as well

 

[pops69]

didnt have much move on todays games yesterday but getting a bunch now

most numbers are moving with fav right now

let's get it on