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

[oilbarrel]

i see the prob fixing now

this is what wrong

=IF(ISBLANK(F2),"",Y2-AJ2)

should be (isblank (Y2-aj2)

i'll upload a revised pdws in a couple of min and correct the master

tks

master looked OK when i did some spot checks

 

[pops69]

master looked OK when i did some spot checks

i ran them all just in case. not sure when that poped up plus ran the macro again to gen the cat so all should be good to go. i'll do the refresh tomorrow am as i have limited data in there for today to gen the zen and game of a series numbers and a refresh now would cause problems that i dont want to play with now

tks for the heads up

 

[cigar]

Good morning Pops, or possibly afternoon depending on Somewhere in time.

3 Waldos possible, or 3 will be in play?

whats the difference between a zen 1 and a zen 5, strength of play?

 

[pops69]

Good morning Pops, or possibly afternoon depending on Somewhere in time.

3 Waldos possible, or 3 will be in play?

whats the difference between a zen 1 and a zen 5, strength of play?

right now only 22 games have shown based on the data since may 1st

nothing again today

worst is tp1 which are overs 3-3-1
tp2 nl under which is 1-1
tp3 al ov which is 2-1
tp4 nl ov which is 0-1
tp5 al un which is 7-2 so the best right now

 

[cigar]

I'd think in doing what you do that Atlanta/Milwaukee game would be a good one for ya, thought that last night just looking at Atlantas road record. I know it probably varies but roughly what percentage of the card are you looking at to get a scalp on, course all of it at first but are you usually concentrating on a few games a day or is it closer to most of them?

 

[pops69]

I'd think in doing what you do that Atlanta/Milwaukee game would be a good one for ya, thought that last night just looking at Atlantas road record. I know it probably varies but roughly what percentage of the card are you looking at to get a scalp on, course all of it at first but are you usually concentrating on a few games a day or is it closer to most of them?

i have a program that d/l the current lines on all the games every 5 min and triggers a bet with the appropriate amounts than i just put in those bets

so to answer your question. every number at every OS i currently have

 

[IrishTim]

Pops, I didn't know you had an autobot placing the bets for you. I've been working on something real basic like this with another guy, my question is how do you protect against "bad lines"? For instance if you have Boston -125 and New York +230 at one shop when it's New York +115 to +130 every where else?

Because obviously the bad line will be cancelled and now you're stuck holding an enormous position that you wanted no part of. Something like that could wipe out the profits from 100 scalps.

 

[TyBounce]

damn first time thi year i play dontrel and now he's scratched .

 

[pops69]

damn first time thi year i play dontrel and now he's scratched .

i had a decent scalp on that one and now it 86

 

[pops69]

Pops, I didn't know you had an autobot placing the bets for you. I've been working on something real basic like this with another guy, my question is how do you protect against "bad lines"? For instance if you have Boston -125 and New York +230 at one shop when it's New York +115 to +130 every where else?

Because obviously the bad line will be cancelled and now you're stuck holding an enormous position that you wanted no part of. Something like that could wipe out the profits from 100 scalps.

no it does not place the bets. i do that myself, plus as you said you bet into an obvious bad line your holding one side that you might not want. and believe me they will cancel those and than cancel your account as well

 

[pops69]

was able to get un 8- plus 105 on nym tomorrow

pinny

 

[pops69]

tuesday may 11th

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

now cubs o/u OL

2 waldo's left. one today at hp but number is now 8 under vs 8- ov

 

[TyBounce]

just about time to fade b zit . i'm gettin that now.

 

[CTP]

What happens to the Zen numbers once they leave the PDWS?

 

[pops69]

What happens to the Zen numbers once they leave the PDWS?

they go to zen heaven

 

[pops69]

cubs o/u 8- no susp there

 

[patswin]

pops on the master in the cat pivots tab, you show pivots for hd's and hf's 1-7. how could I do this for VF and Vd' so I could see the opposite results? Wanting to know how the visiting fav's have been doing this year. Thanks

 

[pops69]

pops on the master in the cat pivots tab, you show pivots for hd's and hf's 1-7. how could I do this for VF and Vd' so I could see the opposite results? Wanting to know how the visiting fav's have been doing this year. Thanks

i'll put one right next to the home one, but not as many just a basic vis cat and it will be in the master tomorrow

just remember when you look at anything based on the visitor that the w/l is backwards so L means the vis won

 

[pops69]

pops on the master in the cat pivots tab, you show pivots for hd's and hf's 1-7. how could I do this for VF and Vd' so I could see the opposite results? Wanting to know how the visiting fav's have been doing this year. Thanks

<table style="border-collapse: collapse; width: 384pt;" width="511" border="0" cellpadding="0" cellspacing="0"><col style="width: 101pt;" width="134"> <col style="width: 87pt;" width="116" span="2"> <col style="width: 61pt;" width="81"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt; width: 101pt; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="134" height="20">Week #</td> <td class="xl95" style="width: 87pt; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="116">(All)</td> <td class="xl95" style="width: 87pt;" width="116">
</td> <td class="xl95" style="width: 61pt;" width="81">
</td> <td class="xl96" style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Month</td> <td class="xl95" style="background: none repeat scroll 0% 0% rgb(219, 229, 241);">May</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl96">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">League</td> <td class="xl95" style="background: none repeat scroll 0% 0% rgb(219, 229, 241);">N</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl96">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Home Team</td> <td class="xl95" style="border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">(All)</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl96">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl96">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Count of Home W/L</td> <td class="xl95" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);">Home W/L</td> <td class="xl95" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);">
</td> <td class="xl95" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Visitor Category</td> <td class="xl95" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">W</td> <td class="xl95" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">L</td> <td class="xl95" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">Grand Total</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VD1</td> <td class="xl95">2</td> <td class="xl95">2</td> <td class="xl95">4</td> <td class="xl96">50%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VD2</td> <td class="xl95">5</td> <td class="xl95">2</td> <td class="xl95">7</td> <td class="xl96">71%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VD3</td> <td class="xl95">4</td> <td class="xl95">3</td> <td class="xl95">7</td> <td class="xl96">57%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VD4</td> <td class="xl95">3</td> <td class="xl95">3</td> <td class="xl95">6</td> <td class="xl96">50%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VD5</td> <td class="xl95">5</td> <td class="xl95">2</td> <td class="xl95">7</td> <td class="xl96">71%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VD6</td> <td class="xl95">7</td> <td class="xl95">3</td> <td class="xl95">10</td> <td class="xl96">70%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VD7</td> <td class="xl95">4</td> <td class="xl95">1</td> <td class="xl95">5</td> <td class="xl96">80%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VF1</td> <td class="xl95">3</td> <td class="xl95">5</td> <td class="xl95">8</td> <td class="xl96">38%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VF2</td> <td class="xl95">2</td> <td class="xl95">4</td> <td class="xl95">6</td> <td class="xl96">33%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VF3</td> <td class="xl95">4</td> <td class="xl95">5</td> <td class="xl95">9</td> <td class="xl96">44%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VF4</td> <td class="xl95">2</td> <td class="xl95">2</td> <td class="xl95">4</td> <td class="xl96">50%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VF5</td> <td class="xl95">3</td> <td class="xl95">1</td> <td class="xl95">4</td> <td class="xl96">75%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VF6</td> <td class="xl95">
</td> <td class="xl95">2</td> <td class="xl95">2</td> <td class="xl96">0%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">VF7</td> <td class="xl95">
</td> <td class="xl95">1</td> <td class="xl95">1</td> <td class="xl96">0%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Grand Total</td> <td class="xl95" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">44</td> <td class="xl95" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">36</td> <td class="xl95" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">80</td> <td class="xl96">55%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl95" style="height: 15pt;" height="20">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl95">
</td> <td class="xl96">
</td> </tr> </tbody></table> <table style="border-collapse: collapse; width: 395pt;" width="526" border="0" cellpadding="0" cellspacing="0"><col style="width: 112pt;" width="149"> <col style="width: 87pt;" width="116" span="2"> <col style="width: 61pt;" width="81"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; width: 112pt; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="149" height="20">Week #</td> <td style="width: 87pt; background: none repeat scroll 0% 0% rgb(219, 229, 241);" width="116">(All)</td> <td class="xl97" style="width: 87pt;" width="116">
</td> <td class="xl97" style="width: 61pt;" width="81">
</td> <td class="xl98" style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Month</td> <td style="background: none repeat scroll 0% 0% rgb(219, 229, 241);">May</td> <td class="xl97">
</td> <td class="xl97">
</td> <td class="xl98">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">League</td> <td style="background: none repeat scroll 0% 0% rgb(219, 229, 241);">A</td> <td class="xl97">
</td> <td class="xl97">
</td> <td class="xl98">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Home Team</td> <td style="border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">(All)</td> <td class="xl97">
</td> <td class="xl97">
</td> <td class="xl98">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">
</td> <td class="xl97">
</td> <td class="xl97">
</td> <td class="xl97">
</td> <td class="xl98">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Count of Home W/L</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);">Home W/L</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);">
</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; background: none repeat scroll 0% 0% rgb(219, 229, 241);">
</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Visitor Category</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">W</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">L</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(219, 229, 241);">Grand Total</td> <td>
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VD1</td> <td class="xl97">2</td> <td class="xl97">1</td> <td class="xl97">3</td> <td class="xl98">67%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VD2</td> <td class="xl97">5</td> <td class="xl97">3</td> <td class="xl97">8</td> <td class="xl98">63%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VD3</td> <td class="xl97">6</td> <td class="xl97">2</td> <td class="xl97">8</td> <td class="xl98">75%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VD4</td> <td class="xl97">5</td> <td class="xl97">3</td> <td class="xl97">8</td> <td class="xl98">63%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VD5</td> <td class="xl97">6</td> <td class="xl97">3</td> <td class="xl97">9</td> <td class="xl98">67%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VD6</td> <td class="xl97">2</td> <td class="xl97">2</td> <td class="xl97">4</td> <td class="xl98">50%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VD7</td> <td class="xl97">4</td> <td class="xl97">4</td> <td class="xl97">8</td> <td class="xl98">50%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VF1</td> <td class="xl97">2</td> <td class="xl97">4</td> <td class="xl97">6</td> <td class="xl98">33%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VF2</td> <td class="xl97">
</td> <td class="xl97">1</td> <td class="xl97">1</td> <td class="xl98">0%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VF3</td> <td class="xl97">2</td> <td class="xl97">4</td> <td class="xl97">6</td> <td class="xl98">33%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VF4</td> <td class="xl97">5</td> <td class="xl97">1</td> <td class="xl97">6</td> <td class="xl98">83%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt;" height="20">VF5</td> <td class="xl97">1</td> <td class="xl97">1</td> <td class="xl97">2</td> <td class="xl98">50%</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl97" style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);" height="20">Grand Total</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">40</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">29</td> <td class="xl97" style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: 0.5pt medium medium; border-style: solid none none; border-color: rgb(149, 179, 215) -moz-use-text-color -moz-use-text-color; background: none repeat scroll 0% 0% rgb(219, 229, 241);">69</td> <td class="xl98">58%</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> <td>
</td> <td>
</td> <td>
</td> <td class="xl98">#DIV/0!</td> </tr> </tbody></table>

 

[patswin]

thanks for posting, nice results for VF4 and 5 in both leagues.
VD6 and 7 in NL is a nice find. Just trying to figure out how these large fav's have been doing this year. Been doing pretty well so far taking the large dogs on the overpriced fav's