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

CTP · Mar 24, 2010

Here is a chart that deals with wins by home team according to ML category. First or to the left is by year starting May 1 and the 2 to the right are by last 21 days. Don't think I have public numbers can't remember from last year. It was an interesting trend to follow meaning 21 days and quite profitable.

<TABLE style="WIDTH: 300pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=399><COLGROUP><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><TBODY><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 26.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=35 width=109>HF1 107-91</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD1 110-94</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF1 17-15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD1 14-5</TD></TR><TR style="HEIGHT: 45.75pt" height=61><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 45.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=61 width=109>HF2 85-78</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD2 67-67</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF2 8-7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD2 8-11</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset" height=35><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 26.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=35 width=109>HF3 161-128</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD3 58-68</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF3 21-16</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD3 10-6</TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 26.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=35 width=109>HF4 170-106</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD4 31-54</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF4 14-9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD4 6-6</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=21 width=109>HF5 136-93</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD5 18-31</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF5 16-14</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD5 3-7</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=21 width=109>HF6 109-71</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD6 9-15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF6 15-15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD6 3-7</TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 26.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=35 width=109>HF7 98-44</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD7 0-8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF7 22-10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD7 0-1</TD></TR></TBODY></TABLE>

I have so much stuff like this sometimes hard to see the forest.

pops69 · Mar 24, 2010

here's a couple to look at today. very limited bet pools on mlb pre game but based on what the data shows and i'll take the 1st two games today

atl ol -125 should move down

tb ol -130 should move up

these are all based on ol ml ranges vs public numbers

we'll see said the blind man

IrishTim · Mar 24, 2010

oilbarrel said:
IT- you have mail

Just got it. Let me take a look and get back to you.

IrishTim · Mar 24, 2010

CTP said:
Here is a chart that deals with wins by home team according to ML category. First or to the left is by year starting May 1 and the 2 to the right are by last 21 days. Don't think I have public numbers can't remember from last year. It was an interesting trend to follow meaning 21 days and quite profitable.

<TABLE style="WIDTH: 300pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=399><COLGROUP><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width=93><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><TBODY><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 26.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=35 width=109>HF1 107-91</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD1 110-94</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF1 17-15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD1 14-5</TD></TR><TR style="HEIGHT: 45.75pt" height=61><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 45.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=61 width=109>HF2 85-78</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD2 67-67</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF2 8-7</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD2 8-11</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset" height=35><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 26.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=35 width=109>HF3 161-128</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD3 58-68</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF3 21-16</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD3 10-6</TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 26.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=35 width=109>HF4 170-106</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD4 31-54</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF4 14-9</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD4 6-6</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=21 width=109>HF5 136-93</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD5 18-31</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF5 16-14</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD5 3-7</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 15.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=21 width=109>HF6 109-71</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD6 9-15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF6 15-15</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD6 3-7</TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 82pt; HEIGHT: 26.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 height=35 width=109>HF7 98-44</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 80pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=107>HD7 0-8</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=93>HF7 22-10</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl4086 width=90>HD7 0-1</TD></TR></TBODY></TABLE>

I have so much stuff like this sometimes hard to see the forest.

I just did a similar thing for last 5 years of college hoops (can send/attach if you want) but like you said, not really sure what you get out of it. Don't want to lose the forest in the trees.

Only thing even somewhat promising was that (from Nov 8, 2005 to March 10, 2010) there were 2,214 games with a spread b/w 14 and 25, and the dogs covered 1,185 of them or 53.52%. So if you'd bet $110 to win $100 on every dog b/w +14 and +25 in the last 5 years you would be up $5,310.

oilbarrel · Mar 24, 2010

pops or anyone else who may know something about sportsoptions- are their any plans for a mobile version or a web based version. the java one gets blocked by a firewall and doesn't help me much. I am a big fan of SO

oilbarrel · Mar 24, 2010

IrishTim said:
I just did a similar thing for last 5 years of college hoops (can send/attach if you want) but like you said, not really sure what you get out of it. Don't want to lose the forest in the trees.

Only thing even somewhat promising was that (from Nov 8, 2005 to March 10, 2010) there were 2,214 games with a spread b/w 14 and 25, and the dogs covered 1,185 of them or 53.52%. So if you'd bet $110 to win $100 on every dog b/w +14 and +25 in the last 5 years you would be up $5,310.

going from memory one year maybe 2007 may have scewed the results a bit, I could be wrong, but recall one year we had 15 as a magic number

IrishTim · Mar 24, 2010

oilbarrel said:
going from memory one year maybe 2007 may have scewed the results a bit, I could be wrong, but recall one year we had 15 as a magic number

I just sent you back an e-mail. More to come, but I'm running off to class.

Just a quick glance at my NCAAB line db, I see 33 games in '07 with a spread of exactly 15, and the favorites covered 18 of them. This what you were referring to?

pops69 · Mar 24, 2010

pops69 said:
here's a couple to look at today. very limited bet pools on mlb pre game but based on what the data shows and i'll take the 1st two games today

atl ol -125 should move down

tb ol -130 should move up

these are all based on ol ml ranges vs public numbers

we'll see said the blind man

maybe i got lucky

atl cl -115
tb cl -130 no change (but it was wtf up b4 some profit taking)

i'll see how many pop up tomorrow

pops69 · Mar 24, 2010

oilbarrel said:
pops or anyone else who may know something about sportsoptions- are their any plans for a mobile version or a web based version. the java one gets blocked by a firewall and doesn't help me much. I am a big fan of SO

so will not work on any mobile device right now. they are looking into a iphone/ipad program, but noting in the near future

oilbarrel · Mar 24, 2010

pops69 said:
so will not work on any mobile device right now. they are looking into a iphone/ipad program, but noting in the near future

is SO capable of issuing email alerts? Such as lineups or who is umping a game?

pops69 · Mar 24, 2010

oilbarrel said:
is SO capable of issuing email alerts? Such as lineups or who is umping a game?

i passed that on and suggested an option for specific alerts that susp signed up for. we'll see what they say

MNNAT · Mar 24, 2010

Pops-

Thanks for answering my question on page 5. I've developed another if you don't mind answering. I'm VERY familiar with Excel and have had the opportunity to explore your sheet over the last 24 hours. I'm seeing things clearly with it (cough...like trying to find games where the humidity is less than 24% in April and May, even though I realize this is only the tip of the iceberg on any given game...cough).

My question is this: if the intent is to scalp/middle, are you also trying to set a "fair" opening line whether o/u or ML? In reference to the above example, sure you'd take a good look at 'over 7' runs, but would you also take a look at 'over 12' runs? Does the ultimate wager decision hinge on the particular game's appearance 'on paper' to go over such number?

pops69 · Mar 24, 2010

MNNAT said:
Pops-

Thanks for answering my question on page 5. I've developed another if you don't mind answering. I'm VERY familiar with Excel and have had the opportunity to explore your sheet over the last 24 hours. I'm seeing things clearly with it (cough...like trying to find games where the humidity is less than 24% in April and May, even though I realize this is only the tip of the iceberg on any given game...cough).

My question is this: if the intent is to scalp/middle, are you also trying to set a "fair" opening line whether o/u or ML? In reference to the above example, sure you'd take a good look at 'over 7' runs, but would you also take a look at 'over 12' runs? Does the ultimate wager decision hinge on the particular game's appearance 'on paper' to go over such number?

no i dont set lines like some do. no my lines. the line is the line period. i use the pitching data worksheet as my guide and than add in the external factors, weather, indoors out doors and umps to determine it it shades to the over or under

madsigner · Mar 24, 2010

found this article today, thought it might be helpful to some

umpire data

IrishTim · Mar 24, 2010

MNNAT said:
Pops-

Thanks for answering my question on page 5. I've developed another if you don't mind answering. I'm VERY familiar with Excel and have had the opportunity to explore your sheet over the last 24 hours. I'm seeing things clearly with it (cough...like trying to find games where the humidity is less than 24% in April and May, even though I realize this is only the tip of the iceberg on any given game...cough).

My question is this: if the intent is to scalp/middle, are you also trying to set a "fair" opening line whether o/u or ML? In reference to the above example, sure you'd take a good look at 'over 7' runs, but would you also take a look at 'over 12' runs? Does the ultimate wager decision hinge on the particular game's appearance 'on paper' to go over such number?

MNNAT, hope you stick around. There will be some good info in this thread, no doubt.

I've got an excel query with you. I have columns for "Home Score", "Away Score", "Home Spread", "Visitor Spread" (redundant I know), among others but those are the relevant ones. What would the logic be if I was trying to use this info to create a column that indicates whether "Dog" or "Fave" covered. It's easy in baseball because if the team with a lower moneyline won, then the dog won. I'm having trouble getting the if/and logic to work out. Thanks. If you're interested in seeing the database for yourself in return for help with the if statements, just shoot me a PM.

MNNAT · Mar 24, 2010

IrishTim said:
MNNAT, hope you stick around. There will be some good info in this thread, no doubt.

I've got an excel query with you. I have columns for "Home Score", "Away Score", "Home Spread", "Visitor Spread" (redundant I know), among others but those are the relevant ones. What would the logic be if I was trying to use this info to create a column that indicates whether "Dog" or "Fave" covered. It's easy in baseball because if the team with a lower moneyline won, then the dog won. I'm having trouble getting the if/and logic to work out. Thanks. If you're interested in seeing the database for yourself in return for help with the if statements, just shoot me a PM.

Thanks for the kind wishes, IrishTim. I'll certainly be around.

As for your question, I'll see if I understand your dilemna. Assuming the 4 columns you mention, the 5th column could be set up with the "IF" function in Excel. Let's try an example, and we'll simple it down:

Cell A1 = 5 (fav score)
Cell A2 = 4 (dog score)
Cell A3 = -150 (fav ML)
Cell A4 = 135 (dog ML)
Cell A5 = "=IF(A1>A2, "fav","dog") -it's basically reasoning out "if A1 is greater than cell A2, then the fav won/covered, if not, the dog won/covered."

If I've horribly simplified your request, we'll clear it up tomorrow.

:toast:

IrishTim · Mar 24, 2010

MNAT, that how I did it for the bases db which only deals with MLs. But if I have something like:

H score.........V score.........H-spreadD.........V-spread
88................ 83................ -9............... 9
92................ 95................ 2.5................ -2.5
101................ 96................ -3 ................ 3

I want to create a separate column now for "Dog" and "Fave". No rush, I'll be out of town for a couple days.

Pops, for some reason my e-mail to you keeps getting sent back. I was using a different database that wasn't nearly as extensive as yours. The strongest correlation was b/w certain umps and the line moves (for totals), but you already knew that.

The reason I don't think I found anything was because all of this info is already available so there's really no reason for it to cause a line move. But now that I have your master handy, there is a lot more stuff for me to work with. I'm out of town from tomorrow until Monday, but I'll get my hands dirty starting monday night.

pops69 · Mar 25, 2010

thursday march 25th

beware of the ides of march

now were starting to cook. that what i love to see guys talking numbers etc

not sure if everyone saw this post but i said that i would include data calc and pivots on things that they felt were important. no reason to keep a couple of extra master files around if not necessary

post em if you got em

MNNAT · Mar 25, 2010

pops, any chance you have 2008's full master, which games could be added to the current master. Intent, obviously, is to just have a little bit larger sample size to draw from. On the flip side, I understand how much teams change, situations change, etc., but some of these cats/pivots would benefit from multiple years of sample size. How about a PDWS with 2008's games? Will that bring the current master sheet to its knees? lol

CTP · Mar 25, 2010

There are other years available but data is not necessarily in the same columns. You would have to organize it by col. A big task because of the size.