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.).

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.

Activities offered by advertising links to other sites may be deemed an illegal activity in certain jurisdictions. Viewers are specifically warned that they should inquire into the legality of participating in any games and/or activities offered by such other sites. The owner of this website assumes no responsibility for the actions by and makes no representation or endorsement of any of these games and/or activities offered by the advertiser. As a condition of viewing this website viewers agree to hold the owner of this website harmless from any claims arising from the viewer’s participation in any of the games and/or activities offered by the advertiser.