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

[pops69]

important things to remember

1. for the month of april i use the 2009 era and whip numbers. if no 2009 numbers the fill numbers are 4.50 for era and 1.250 for whip. if you see those numbers you need to look into those pitchers b4 you make the jump

2. starting in may i use the 2010 numbers, but same applies for no start in 2010 data with the 4.50 and 1.250. also be careful for real odd ball numbers from either god like 1st game or real blow out. what goes up must come down and vice versa

 

[pops69]

i dont have a miller for o's , there is kevin millwood.

MY bad i read it wrong he's a gone

tks

 

[pops69]

this is what i have right now for o's, so i know a bunch more will be added

<table style="border-collapse: collapse; width: 127pt;" width="169" border="0" cellpadding="0" cellspacing="0"><col style="width: 127pt;" width="169"> <tbody><tr style="height: 40.5pt;" height="54"> <td class="xl66" style="height: 40.5pt; width: 127pt;" width="169" height="54">BAL</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">ALBERS, M</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">MILLWOOD, K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">UEHARA, K</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">BERGESEN, B</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">BERKEN, J</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl64" style="height: 12.75pt;" height="17">JOHNSON, Jim</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">GUTHRIE, J</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">HENDRICKSON, M</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">HERNANDEZ, D</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">MATUSZ, B</td> </tr> </tbody></table>

 

[FairWarning]

Pops - here is your Miller. This is a scouting report from last year to give you an idea of him:

http://orioles.scout.com/2/720410.html

 

[oilbarrel]

pops- my entire question didn't post right last nite- did you ever hear anything back from SO on email updates for specific info?

2nd question- any thought about bring game of series back in? I think i would be interesting to see umps by series game as we certainly have a feel belief for some of them...

 

[pops69]

pops - here is your miller. This is a scouting report from last year to give you an idea of him:

http://orioles.scout.com/2/720410.html

tks fair

 

[DollarDay]

Decent scalp sitting between Matchbook and Wagerstreet for pre-season ball.

MB's got Kansas City +122 for $190.00
Wagerstreet Showing Tejas -110.00


Bet #1: $100.00
Bet #2: $116.29

Total Bet: $216.29
$ Profit: $5.71
% Profit: 2.6420%

Pops - I don't know if you bother with such a low payout but it's pre-season ball and it's there for the taking as I already put in my play and this is left.

 

[pops69]

pops- my entire question didn't post right last nite- did you ever hear anything back from SO on email updates for specific info?

2nd question- any thought about bring game of series back in? I think i would be interesting to see umps by series game as we certainly have a feel belief for some of them...

nothing back from them on that option

i would love to incorporate the game of the series info into the data base but i'm sure not going to fat finger the data into the pdws as that's the only way i know how to capture it at this point as none of my sources have that number

if you have an ideas fire away. dont even think about any everyone turn bull shit as that's a real pain in the ass

 

[twjd]

this is what i have right now for o's, so i know a bunch more will be added

<TABLE style="WIDTH: 127pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=169><COLGROUP><COL style="WIDTH: 127pt" width=169><TBODY><TR style="HEIGHT: 40.5pt" height=54><TD style="WIDTH: 127pt; HEIGHT: 40.5pt" class=xl66 height=54 width=169>BAL</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17>ALBERS, M</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" class=xl65 height=17>MILLWOOD, K</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17>UEHARA, K</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17>BERGESEN, B</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17>BERKEN, J</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" class=xl64 height=17>JOHNSON, Jim</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17>GUTHRIE, J</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17>HENDRICKSON, M</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" class=xl65 height=17>HERNANDEZ, D</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17>MATUSZ, B</TD></TR></TBODY></TABLE>

This what they have on their official web-site
<TABLE border=0 cellSpacing=0 cellPadding=0 width="98%" bgColor=white align=center><TBODY><TR height=20><TD bgColor=white> </TD><TD bgColor=white>37 Matt Albers </TD><TD bgColor=white>L/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>35 Brad Bergesen </TD><TD bgColor=white>L/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>49 Jason Berken </TD><TD bgColor=white>R/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>51 Michael Gonzalez </TD><TD bgColor=white>R/L</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>46 Jeremy Guthrie </TD><TD bgColor=white>R/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>27 Mark Hendrickson </TD><TD bgColor=white>L/L</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>63 David Hernandez </TD><TD bgColor=white>R/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>43 Jim Johnson </TD><TD bgColor=white>R/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>17 Brian Matusz </TD><TD bgColor=white>L/L</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>26 Cla Meredith </TD><TD bgColor=white>R/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>31 Kam Mickolio </TD><TD bgColor=white>R/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>34 Kevin Millwood </TD><TD bgColor=white>R/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD><TD colSpan=2></TD></TR><TR height=20><TD bgColor=white> </TD><TD bgColor=white>19 Koji Uehara </TD><TD bgColor=white>R/R</TD><TD bgColor=white></TD><TD bgColor=white></TD><TD bgColor=white></TD></TR></TBODY></TABLE>

 

[oilbarrel]

nothing back from them on that option

i would love to incorporate the game of the series info into the data base but i'm sure not going to fat finger the data into the pdws as that's the only way i know how to capture it at this point as none of my sources have that number

if you have an ideas fire away. dont even think about any everyone turn bull shit as that's a real pain in the ass

i figured ctp could just fat finger them all in...

 

[oilbarrel]

nothing back from them on that option

i would love to incorporate the game of the series info into the data base but i'm sure not going to fat finger the data into the pdws as that's the only way i know how to capture it at this point as none of my sources have that number

if you have an ideas fire away. dont even think about any everyone turn bull shit as that's a real pain in the ass

formula written and headed your way. i guess ctp is off the hook

 

[pops69]

This what they have on their official web-site
<table width="98%" align="center" bgcolor="white" border="0" cellpadding="0" cellspacing="0"><tbody><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">37 Matt Albers </td><td bgcolor="white">L/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">35 Brad Bergesen </td><td bgcolor="white">L/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">49 Jason Berken </td><td bgcolor="white">R/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">51 Michael Gonzalez </td><td bgcolor="white">R/L</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">46 Jeremy Guthrie </td><td bgcolor="white">R/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">27 Mark Hendrickson </td><td bgcolor="white">L/L</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">63 David Hernandez </td><td bgcolor="white">R/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">43 Jim Johnson </td><td bgcolor="white">R/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">17 Brian Matusz </td><td bgcolor="white">L/L</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">26 Cla Meredith </td><td bgcolor="white">R/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">31 Kam Mickolio </td><td bgcolor="white">R/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">34 Kevin Millwood </td><td bgcolor="white">R/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td colspan="2">
</td></tr><tr height="20"><td bgcolor="white">
</td><td bgcolor="white">19 Koji Uehara </td><td bgcolor="white">R/R</td><td bgcolor="white">
</td><td bgcolor="white">
</td><td bgcolor="white">
</td></tr></tbody></table>

close enough for gov work. i'll put this one to bed

tks

 

[pops69]

formula written and headed your way. i guess ctp is off the hook

u got it. i was thinking about some sort of a form that might work

i'll put it into the new master as well as the 2009 for shit's and giggles

tks

p.s. one other step which would also help for o/u etc

if home team traveled or back to back home stands

 

[oilbarrel]

u got it. i was thinking about some sort of a form that might work

i'll put it into the new master as well as the 2009 for shit's and giggles

tks

p.s. one other step which would also help for o/u etc

if home team traveled or back to back home stands

should be doable- need to think of how the formula might look

do you think we should care about how many series they have been at home?

 

[oilbarrel]

to add if they are home for a week is that diff than if they are home for two weeks?

 

[CTP]

To track games of a series I had a formula I used last year. A bit funky but it worked. Goes like this

Col IB had a formula that read G4899&" - "& P4899
Col IC had a formula that read

IF(SUMPRODUCT((B4837:B4884>B4899-4)*(IB4837:IB4884=IB4899))>=1,SUMPRODUCT((B4837:B4884>B4899-4)*(IB4837:IB4884=IB4899))+1,1)

IB joined the home and away together to make it look like this <TABLE style="WIDTH: 69pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=92><COLGROUP><COL style="WIDTH: 69pt; mso-width-source: userset; mso-width-alt: 3364" width=92><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 69pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl4083 height=17 width=92>SEA - TEX</TD></TR></TBODY></TABLE>

Then IC gave the series number based on a match of IB

Will have to modify the cols and row numbers to suit.

 

[CTP]

I had that formula in the master not sure if doable in the PDWS

 

[IrishTim]

Also - got a tip from a guy I trust on an AFL game. Tampa Bay -1.5 (it was +2). Might be worth a few shillings, but tread lightly. The models aren't "well connected" until the teams have played 3 or 4 games and a decent sample of data can be collected.

Tampa Bay -7 now. Nuts. Hope someone jumped in with me.

 

[IrishTim]

Just read through the last few pages. God, I missed this thread. More helpful info in here than all the other threads combined.

 

[pops69]

should be doable- need to think of how the formula might look

do you think we should care about how many series they have been at home?

y plus multiple road travels