For those of you who use the Covers Data 2 tab to track, and you're sick of scrolling down to the current date every day, here's the fix:
On the sheet, any tab click on VIEW, Click on View Macros (on right in 2013 version of Excel), Click on Covers (macro name) and then Edit.
You should have opened up a new window. On the right pane you should see Covers Macro under Sub Covers (). Go down to the 5th "End With". Below that should be Rows "("3:3") . Select"
3 rows below that is "Rows ("3:702")
Change the 702 to whatever row you want to hide to. Click the Run button (arrow pointing to the right) and it will do it for you without updating the whole page. Click the to right X to get out of that window. Done.
Found another stupid mistake, just on Covers Data 2, not for anything else.
0
Quote Originally Posted by BuckeyeKaptn:
For those of you who use the Covers Data 2 tab to track, and you're sick of scrolling down to the current date every day, here's the fix:
On the sheet, any tab click on VIEW, Click on View Macros (on right in 2013 version of Excel), Click on Covers (macro name) and then Edit.
You should have opened up a new window. On the right pane you should see Covers Macro under Sub Covers (). Go down to the 5th "End With". Below that should be Rows "("3:3") . Select"
3 rows below that is "Rows ("3:702")
Change the 702 to whatever row you want to hide to. Click the Run button (arrow pointing to the right) and it will do it for you without updating the whole page. Click the to right X to get out of that window. Done.
Found another stupid mistake, just on Covers Data 2, not for anything else.
As far as the RLs, I'm not chasing RLs on a ML win, for example Oakland's win. I am chasing RLs on ML losses....Col, Atl. For the thread, I will be counting the RL from Oak as a loss
I will be making a set form for the plays and recap.
0
Yesterdays 6/6
Oak Win (Lost both RLs)
Phi Win (Won both RLs)
Col Loss
Nyy Win (Won both RLs)
Atl Loss
Atl B on 6/7
Col B on 6/7
As far as the RLs, I'm not chasing RLs on a ML win, for example Oakland's win. I am chasing RLs on ML losses....Col, Atl. For the thread, I will be counting the RL from Oak as a loss
I will be making a set form for the plays and recap.
*Units based on 5dimes, when I make my bets. These are the odds I got, some lines may be the reduced juice.
If you don't chase RL losses on ML wins maybe you should adjust the unit sizes for ML and RL so if you win the ML but lose the RL you still are plus for the bet.
Example:
ML 1 Unit, RL (or RRL for dogs) .25 unit, -2.5 RL .25 units
this way in the above case you win .5 units on a ML win and RL and -2.5 RL loss.
Just a thought....
0
Quote Originally Posted by BuckeyeKaptn:
6/6 ML Plays: YTD: 3-0...2 Pending.
Oak Win
Phi Win
Col Loss B on 6/7
Nyy Win
Atl Loss B on 6/7
RL -1.5: 2-1...2 Pending
YTD 2-1 +2.15u
Oak Loss -1.00
Phi Win +1.80
Nyy Win +1.35
RL -2.5: 2-1...2 Pending
YTD 2-1 +3.70
Oak Loss -1.00
Phi Win +2.65
Nyy Win +2.05
RL Total units: +5.85
*Units based on 5dimes, when I make my bets. These are the odds I got, some lines may be the reduced juice.
If you don't chase RL losses on ML wins maybe you should adjust the unit sizes for ML and RL so if you win the ML but lose the RL you still are plus for the bet.
Example:
ML 1 Unit, RL (or RRL for dogs) .25 unit, -2.5 RL .25 units
this way in the above case you win .5 units on a ML win and RL and -2.5 RL loss.
I had given that thought, I think you or someone else mentioned it a day or so ago (which I forgot about when I made my wagers!). I figure if I just keep each at 1 unit, people can see it as all bets being equal, and can adjust as they wish to a half unit or what they wish. That said, the -2.5 RL took home the most units last night. This is the test year, sorta kinda...see if we could make any filters etc, like UD to make it stronger.or open it up more, somehow. Open to suggestions.
0
I had given that thought, I think you or someone else mentioned it a day or so ago (which I forgot about when I made my wagers!). I figure if I just keep each at 1 unit, people can see it as all bets being equal, and can adjust as they wish to a half unit or what they wish. That said, the -2.5 RL took home the most units last night. This is the test year, sorta kinda...see if we could make any filters etc, like UD to make it stronger.or open it up more, somehow. Open to suggestions.
Bos has a doubleheader tomorrow. If a 1pm loss, chase at 7pm. Nym currently don't have a doubleheader. Check to see if one shows up on the schedule for Sunday before 1pm. If there is, Nym is a play. No play if not, as then it drops to a 2g series. If anyone cares, Min/Was have a doubleheader for Sunday.
0
Bos has a doubleheader tomorrow. If a 1pm loss, chase at 7pm. Nym currently don't have a doubleheader. Check to see if one shows up on the schedule for Sunday before 1pm. If there is, Nym is a play. No play if not, as then it drops to a 2g series. If anyone cares, Min/Was have a doubleheader for Sunday.
Using today's approximate lines from Detroit at -210 ML, we have even money (+100) at -1.5 and +165 at -2.5. Using these numbers, here's how the units come out against W/L as I don't chase a RL loss after a ML win (the play wins by 1 or 2).
RL -1.5 (+100) is 68-36 w/l...+32u 65%
RL -2.5 (+165) is 59-45 w/l...+52u. 56%
That's just using a -200ml favorite. These ^^^ numbers are the low end of the profit margin. Yesterday, I got Phi at +134ml, -1.5 +190, -2.5 +265. All 3 won. 5.89u
The system for the year at ML is 100/6 w/l, +50.93u via Covers closing line. If I added correctly, 46 went to the B game (including tonight's two), 17 lost and went to the C Bet, which 6 lost.
A Bets: 60-46 56%
B Bets: 29-17 63%
C Bets: 11-6 64%
0
YTD to 6/6 -1.5 & -2.5 RL plays.
Using today's approximate lines from Detroit at -210 ML, we have even money (+100) at -1.5 and +165 at -2.5. Using these numbers, here's how the units come out against W/L as I don't chase a RL loss after a ML win (the play wins by 1 or 2).
RL -1.5 (+100) is 68-36 w/l...+32u 65%
RL -2.5 (+165) is 59-45 w/l...+52u. 56%
That's just using a -200ml favorite. These ^^^ numbers are the low end of the profit margin. Yesterday, I got Phi at +134ml, -1.5 +190, -2.5 +265. All 3 won. 5.89u
The system for the year at ML is 100/6 w/l, +50.93u via Covers closing line. If I added correctly, 46 went to the B game (including tonight's two), 17 lost and went to the C Bet, which 6 lost.
do does it make sense to play all ml, rl -1.5 and rl -2.5 for the same to win one unit?
That's what I do, however, it's solely up to you. The run lines winning percentage isn't as great. Last night, -2.5 lost -1.8 units. The way I look at it, I play all RL plays as a whole, one emmcompassing play, so to speak. With all plays, not including the chase plays (ML losses that continue today), the night was up 2.5 units. I can go more into it later.
0
Quote Originally Posted by 730champ:
do does it make sense to play all ml, rl -1.5 and rl -2.5 for the same to win one unit?
That's what I do, however, it's solely up to you. The run lines winning percentage isn't as great. Last night, -2.5 lost -1.8 units. The way I look at it, I play all RL plays as a whole, one emmcompassing play, so to speak. With all plays, not including the chase plays (ML losses that continue today), the night was up 2.5 units. I can go more into it later.
I guess, check pitchers w/l, L10 etc. In a basketball forum, a few people would say that if you have the opposites for 2 different systems, you play them both!!! That is with spreads too, so you would always lose on juice. "I always play every play!!" I never played the two opposing plays.
In this case, do what I said above or just don't play either. I'm finally almost to the point where I have everything on my spreadsheets set, that I can check out pitchers etc, before betting. By next week, for sure.
It looks like we have
Boston on a B play at 7pm. Not yet official. One inning to go.
0
I guess, check pitchers w/l, L10 etc. In a basketball forum, a few people would say that if you have the opposites for 2 different systems, you play them both!!! That is with spreads too, so you would always lose on juice. "I always play every play!!" I never played the two opposing plays.
In this case, do what I said above or just don't play either. I'm finally almost to the point where I have everything on my spreadsheets set, that I can check out pitchers etc, before betting. By next week, for sure.
It looks like we have
Boston on a B play at 7pm. Not yet official. One inning to go.
So far this group of plays are up 3.5 units. I need do more of a backtest on the RLs. The ML plays are 8-0 with 2 pending...Tex and Hou. The RLs are negative units. Filters need to be found. If anyone has ideas, it would be great. DeGen, your idea of .5 units would have minimalized the losses.
I will uploading a new version of the spreadsheet. In it on the summary tab, next to the RPI plays, will be the same for the T/R plays. Also on it will be for Over/Under plays, if you follow such plays. These 2 are also adjustable like the RPI plays. I'd like to thank DeGen for all this. I was able to dissect his spreadsheets to come up with this. Also, this format is his original 2013 RPI sheet. Give credit where it's due.
0
So far this group of plays are up 3.5 units. I need do more of a backtest on the RLs. The ML plays are 8-0 with 2 pending...Tex and Hou. The RLs are negative units. Filters need to be found. If anyone has ideas, it would be great. DeGen, your idea of .5 units would have minimalized the losses.
I will uploading a new version of the spreadsheet. In it on the summary tab, next to the RPI plays, will be the same for the T/R plays. Also on it will be for Over/Under plays, if you follow such plays. These 2 are also adjustable like the RPI plays. I'd like to thank DeGen for all this. I was able to dissect his spreadsheets to come up with this. Also, this format is his original 2013 RPI sheet. Give credit where it's due.
One filter that I already established for myself is that if a team qualifies they have to have a record above .500. Thus, I didn't bet the Houston/KC series. The whole idea to me is to bet on superior teams against crap teams.
I am however on the C game today with Texas. I will be playing Texas +1.5 today as they are a dog. As I mentioned before, I play all dogs +1.5. Is it more expensive up front...of course it is. However, it saves your behind more often then not, prevents losses and avoids many C plays.
For example; Atlanta won last night 2-1 in a nail biter on the C game. If you had played it the night before taking Atlanta +1.5 you had already won on the B game and weren't sweating it.
Hope this is of help. I am still working on more filters and back testing myself. Good luck to you and everyone else trying this system!
0
Buckeye:
One filter that I already established for myself is that if a team qualifies they have to have a record above .500. Thus, I didn't bet the Houston/KC series. The whole idea to me is to bet on superior teams against crap teams.
I am however on the C game today with Texas. I will be playing Texas +1.5 today as they are a dog. As I mentioned before, I play all dogs +1.5. Is it more expensive up front...of course it is. However, it saves your behind more often then not, prevents losses and avoids many C plays.
For example; Atlanta won last night 2-1 in a nail biter on the C game. If you had played it the night before taking Atlanta +1.5 you had already won on the B game and weren't sweating it.
Hope this is of help. I am still working on more filters and back testing myself. Good luck to you and everyone else trying this system!