For bets in rows 7 through 39 the most recently concluded game was played on 10/9 from approximately 20:00 to 23:00 (games last three hours). So, we sum profits from the first 6 rows and obtain 8.33. In rows 40 through 50 the most recently concluded games are contained on rows 7 through 39, so we sum those profits and obtain 32.49. Etc.... Things get messy starting on row 88 because there (through row 103) we need to sum rows 60, 61, 62, 63, 64, 65, 66, 67, 68, 70, 71, 72, 74, 75, 76, 78, 79, 80, 82, 83, 85, and 87. This amalgamation of rows reflect games starting on 10/22 at approximately 13:00 (and concluding at 16:00). At the point in time at which bets on rows 88 through 103 were made, these represent the most recently concluded games. The Excel spreadsheet that I attached is color coded to clearly show these issues, though I realize it can be risky to open unknown Excel files. It's easy to establish blocks for game days/game times and I have done this, but this path has not been helpful since I cannot figure out how to match these blocks properly with the relevant bets.
... View more
