I have DegenGambles excel sheet that imports covers data for an entire MLB season. From that I want to determine if a 2,3 or 4 game series has a game won by the underdog and which game the underdog won A,B,C or D. If the dog wins game A of the series I need look no further, if not check the B game etc.
I'm sure there is a formula to do this, maybe some helper columns are required but I'm stumped. I've searched the net but haven't come up with anything yet, so I thought I'd try here. I'm no excel guru by any means. Thanks for reading.
0
To remove first post, remove entire topic.
I have DegenGambles excel sheet that imports covers data for an entire MLB season. From that I want to determine if a 2,3 or 4 game series has a game won by the underdog and which game the underdog won A,B,C or D. If the dog wins game A of the series I need look no further, if not check the B game etc.
I'm sure there is a formula to do this, maybe some helper columns are required but I'm stumped. I've searched the net but haven't come up with anything yet, so I thought I'd try here. I'm no excel guru by any means. Thanks for reading.
This is interesting. I've started a backtest on it too. I don't have a real formula, but I'm going through each series and marking it down W/L. Then I'll go back and get the Dog winning spread and total it all up. Don't forget that if a chase goes to the C game that it's 7 units x the ML (+120 etc.).
0
Oil, I have that spreadsheet also.
This is interesting. I've started a backtest on it too. I don't have a real formula, but I'm going through each series and marking it down W/L. Then I'll go back and get the Dog winning spread and total it all up. Don't forget that if a chase goes to the C game that it's 7 units x the ML (+120 etc.).
I've done 4 teams (Arz,Atl,Bal,and Bos) on their home series only, so far, for 2003....just a tip of the iceberg. It's at 79%, 70-19, +12.11 units. Boston, is 13-8, -25.95 units; one team that is killing the chase. I started the chase at the beginning of the season, so I gotta get going to get some seasons backtested. I'm gonna finish 2003 and do 2013 next.
As far as money management...well, you are playing every series (I avoided 2g series for the backtest)...at least, every A game, which will be 15 units in play. If you go 7-8, that's near a wash or better, depending on the MLs of the dogs. If you lose a series, that's -7u.
My unit size is less than 1% of my bankroll to start the season. I have one other system I'm playing during April and that's the same unit size. More plays, less the unit size for me. I'll re access after April's over when 3 other systems come online. If this works, I'll increase this and decrease the others.
0
I've done 4 teams (Arz,Atl,Bal,and Bos) on their home series only, so far, for 2003....just a tip of the iceberg. It's at 79%, 70-19, +12.11 units. Boston, is 13-8, -25.95 units; one team that is killing the chase. I started the chase at the beginning of the season, so I gotta get going to get some seasons backtested. I'm gonna finish 2003 and do 2013 next.
As far as money management...well, you are playing every series (I avoided 2g series for the backtest)...at least, every A game, which will be 15 units in play. If you go 7-8, that's near a wash or better, depending on the MLs of the dogs. If you lose a series, that's -7u.
My unit size is less than 1% of my bankroll to start the season. I have one other system I'm playing during April and that's the same unit size. More plays, less the unit size for me. I'll re access after April's over when 3 other systems come online. If this works, I'll increase this and decrease the others.
I also would recommend putting a portion on each dog on the RRL as well. Maybe a full unit on the ML and a half unit on the RRL, be interesting to see how that affects the profits
0
I recommend not avoiding the 2 game series.
I also would recommend putting a portion on each dog on the RRL as well. Maybe a full unit on the ML and a half unit on the RRL, be interesting to see how that affects the profits
Right now I'm doing 2013 season. I figured to start here and go backwards. When I mean Home...I'm just doing the home series and when an Away dog wins, I'll go back and plug in the ML.
Also, right now, I'm just doing a 3g chase for 3 and 4 game series. I'll go back and check the D games when I'm done, and also the 2g series too.
Right now I'm doing 2013 season. I figured to start here and go backwards. When I mean Home...I'm just doing the home series and when an Away dog wins, I'll go back and plug in the ML.
Also, right now, I'm just doing a 3g chase for 3 and 4 game series. I'll go back and check the D games when I'm done, and also the 2g series too.
Hot Forum Topics
