Which team are you choosing to chase starting in game 1? The favorite?
I tracked chasing for 4 scenarios using 2 factors, whether they were a dog or a favorite, and whether it was game 1 or 2. FF=Favored in both, FD= Favored in first, dog in 2nd... etc.
I also changed my results to reflect the data that is erroneously missing by the database. Estimating winning percentage for the missing games by taking the average, here's what I got.
<table style="border-collapse: collapse; width: 493px; height: 43px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 19pt;" width="25"> <col style="width: 47pt;" width="63"> <col style="width: 42pt;" width="56"> <col style="width: 48pt;" width="64"> <col style="width: 50pt;" width="67"> <col style="width: 65pt;" width="86"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 19pt;" width="25" align="left" height="20">
</td> <td style="width: 47pt;" width="63" align="left">SERIES W</td> <td style="width: 42pt;" width="56" align="left">SERIES L</td> <td style="width: 48pt;" width="64" align="left">AVG WIN</td> <td style="width: 50pt;" width="67" align="left">AVG LOSS</td> <td style="width: 65pt;" width="86" align="left">NET PROFIT</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="left" height="20">FF</td> <td align="left">2784</td> <td align="left">232</td> <td class="xl66" align="left">100</td> <td align="left">-906</td> <td class="xl67" align="left"> $ 68,208.00 </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="left" height="20">FD</td> <td align="left">798</td> <td align="left">99</td> <td class="xl65" align="left">104.37</td> <td align="left">-704</td> <td class="xl67" align="left"> $ 13,593.97 </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="left" height="20">DF</td> <td align="left">793</td> <td align="left">113</td> <td class="xl65" align="left">111.10</td> <td align="left">-666</td> <td class="xl67" align="left"> $ 12,842.48 </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" align="left" height="20">DD</td> <td align="left">2414</td> <td align="left">593</td> <td class="xl65" align="left">140.48</td> <td align="left">-600</td> <td class="xl67" align="left"> $ (16,682.97)</td> </tr> </tbody></table>
In a perfect world, the total FF games would equal the DD games and the FD games would equal the DF games, but the database is missing games when I enter in the queries.
I also estimated if we were to ignore the games, and if we were to count them all as losses. Here's those results (although the above table is likely the most accurate results).
MISSING GAMES IGNORED:
<table style="border-collapse: collapse;" width="499" border="0" cellpadding="0" cellspacing="0" height="100"><col style="width: 19pt;" width="25"> <col style="width: 47pt;" width="63"> <col style="width: 42pt;" width="56"> <col style="width: 48pt;" width="64"> <col style="width: 50pt;" width="67"> <col style="width: 65pt;" width="86"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 19pt;" width="25" height="20">
</td> <td style="width: 47pt;" width="63">SERIES W</td> <td style="width: 42pt;" width="56">SERIES L</td> <td style="width: 48pt;" width="64">AVG WIN</td> <td style="width: 50pt;" width="67">AVG LOSS</td> <td style="width: 65pt;" width="86">NET PROFIT</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">FF</td> <td align="right">2748</td> <td align="right">210</td> <td class="xl66" align="right">100</td> <td align="right">-906</td> <td class="xl67"> $ 84,540.00 </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">FD</td> <td align="right">782</td> <td align="right">91</td> <td class="xl65" align="right">104.37</td> <td align="right">-704</td> <td class="xl67"> $ 17,556.00 </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">DF</td> <td align="right">778</td> <td align="right">101</td> <td class="xl65" align="right">111.10</td> <td align="right">-666</td> <td class="xl67"> $ 19,168.01 </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">DD</td> <td align="right">2372</td> <td align="right">546</td> <td class="xl65" align="right">140.48</td> <td align="right">-600</td> <td class="xl67"> $ 5,616.90 </td> </tr> </tbody></table>
I don't really have a reason as to why these numbers aren't identical to the numbers posted in post #1. The query is the same, yet it's punching out different results.
MISSING GAMES COUNTED AS LOSSES:
<table style="border-collapse: collapse;" width="507" border="0" cellpadding="0" cellspacing="0" height="63"><col style="width: 19pt;" width="25"> <col style="width: 47pt;" width="63"> <col style="width: 42pt;" width="56"> <col style="width: 48pt;" width="64"> <col style="width: 50pt;" width="67"> <col style="width: 65pt;" width="86"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 19pt;" width="25" height="20">
</td> <td style="width: 47pt;" width="63">SERIES W</td> <td style="width: 42pt;" width="56">SERIES L</td> <td style="width: 48pt;" width="64">AVG WIN</td> <td style="width: 50pt;" width="67">AVG LOSS</td> <td style="width: 65pt;" width="86">NET PROFIT</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">FF</td> <td align="right">2748</td> <td align="right">261</td> <td class="xl66" align="right">100</td> <td align="right">-906</td> <td class="xl67"> $ 38,334.00 </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">FD</td> <td align="right">782</td> <td align="right">108</td> <td class="xl65" align="right">104.37</td> <td align="right">-704</td> <td class="xl67"> $ 5,588.00 </td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">DF</td> <td align="right">778</td> <td align="right">137</td> <td class="xl65" align="right">111.10</td> <td align="right">-666</td> <td class="xl67"> $ (4,807.99)</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">DD</td> <td align="right">2372</td> <td align="right">628</td> <td class="xl65" align="right">140.48</td> <td align="right">-600</td> <td class="xl67"> $ (43,583.10)</td> </tr> </tbody></table>