Spreadsheet: 713045d1610540748-fixed-formula-for-running-p-l-excel-sample-1-
Sheet: Sheet1

Match Details |  |  |  |  |  | [NAME] |  | League Pos |  | Home Team All |  |  | Home Team - HOME |  |  | Away Team All |  |  | Away Team AWAY |  |  | Combined O/U |  | Home Team Score Line Stats |  |  |  |  |  |  |  |  |  |  | Away Team Score Line Stats |  |  |  |  |  |  |  |  |  |  | First Half Goal Stats |  |  |  | Second Half Goal Stats |  |  |  | Match Odds |  |  |  |  |  |  |  |  |  |  |  |  | Under / Over 2.5 |  |  |  |  |  |  |  |  | Correct Score |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Results & Goal Times |  |  |  |  |  |  |  |  |  |  | Lay | CS | Lay | 2nd Half |  | Running total
Date | Time | Competition | HomeTeam | AwayTeam | Iso3 | All | HA | Home | Away | Pl | Sco | Con | Pl | Sco | Con | Pl | Sco | Con | Pl | Sc | Con | CO1.5% | CO2.5% | HFT0-0H% | HFT1-1H% | HFT2-0H% | HFT2-1H% | HcsnT% | HbttsyH% | HbttsyT% | Led by 2H% | Led by 2T% | Trail by 2 H% | Trail by 2 T% | AFT0-0A% | AFT1-1A% | AFT2-0A% | AFT2-1A | AcsnT% | AbttsyA% | AbttsyT% | Led by 2A% | Led by 2T% | Trail by 2 A% | Trail by 2 T% | P1HgipYh% | P1HgipYt% | P1AgipYa% | P1AgipYt% | [NAME] | P2HgipYt% | P2AgipYa% | P2AgipYt% | Vol | Home | PL | Home | PL | Away | PL | Away | PL | Draw | PL | Draw | PL | Vol | U2.5 | PL | U2.5 | PL | O2.5 | PL | O2.5 | PL | Vol | 0-0 | 0-1 | 0-2 | 0-3 | 1-0 | 1-1 | 1-2 | 1-3 | 2-0 | 2-1 | 2-2 | 2-3 | 3-0 | 3-1 | 3-2 | 3-3 | aoHw | aoAw | aoD | HT | FT | HT1X2 | FT1X2 | GT-HA | GT1(1:45) | GT1(46:90) | HThg | Htag | HTtg | FTtg | Selection | Price | Price | Goal | PL |  | Home Team Home | Inverse | Price | Value | Home Team Total | Inverse | Price | Value | Away Team Away | Inverse | Price | Value | Away Team Away | Inverse | Price | Value | ALL | Inverse | Price | Value
2017-09-07 00:00:00 | 2017-09-07 00:30:00 | MLS | New York City | Kansas City | USA |  |  | 2 | 3 | 6 | 10 | 9 | 3 | 7 | 4 | 6 | 8 | 6 | 2 | 1 | 2 | 1.8333 | 0.8333 | 0 | 0 | 0 | 0.6667 | 0.8333 | 1 | 0.6667 | 0.3333 | 0.3333 | 0 | 0.1667 | 0 | 0.5 | 0 | 0 | 0.8333 | 0.5 | 0.6667 | 0 | 0.3333 | 0 | 0 | 0.3333 | 0.3333 | 1 | 0.6667 | 1 | 1 | 0.5 | 0.8333 | 279241 | 2.74 |  | 2.78 |  | 3.95 |  | 4 |  | 2.58 |  | 2.6 |  | 83890 | 1.19 |  | 1.2 |  | 6 |  | 6.2 |  | 25318 | 4 | 7.2 | 25 | 130 | 5.4 | 7.8 | 29 | 190 | 14.5 | 22 | 80 | 450 | 65 | 100 |  |  | 250 |  |  | 0-0 | 1 - 0 | X | 1 | 85(H) | -1 | 85 | 0 | 0 | 0 | 1
2017-09-08 00:00:00 | 2017-09-08 12:35:00 | Chinese Super League | Guangzhou FC | [NAME] | CHN |  |  | 1 | 10 | 6 | 14 | 7 | 2 | 4 | 1 | 6 | 7 | 7 | 4 | 5 | 5 | 1.8333 | 1 | 0 | 0 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 1 | 0.6667 | 0 | 0.1667 | 0 | 0.25 | 0 | 0 | 0.8333 | 0.5 | 0.6667 | 0.25 | 0.1667 | 0.25 | 0.1667 | 0 | 0.5 | 0.75 | 0.6667 | 1 | 1 | 1 | 1 | 173069 | 1.2 |  | 1.22 |  | 26 |  | 27 |  | 7.2 |  | 7.6 |  | 39532 | 2.16 |  | 2.18 |  | 1.85 |  | 1.86 |  | 21678 |  |  |  |  | 6.2 | 10.5 | 55 | 280 | 5 | 8.2 | 34 | 210 | 8 | 14.5 | 55 | 380 | 9 |  |  | 1-0 | 3 - 1 | 1 | 1 | 26(H),59(H),62(A),66(H) | 26 | 59 | 1 | 0 | 1 | 4
2017-09-08 00:00:00 | 2017-09-08 17:00:00 | Polish Ekstraklasa | [NAME] | Wisla Plock | POL |  |  | 2 | 12 | 6 | 10 | 4 | 3 | 7 | 0 | 6 | 3 | 7 | 3 | 2 | 5 | 1.1667 | 0.6667 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0.5 | 0.6667 | 0.3333 | 0 | 0.1667 | 0 | 0.3333 | 0 | 0 | 0.6667 | 0.3333 | 0.1667 | 0 | 0 | 0.3333 | 0.1667 | 0.6667 | 0.3333 | 1 | 0.6667 | 1 | 1 | 0.3333 | 0.5 | 24874 | 1.06 |  | 1.07 |  | 110 |  | 120 |  | 19 |  | 19.5 |  | 6438 | 4.3 |  | 4.5 |  | 1.29 |  | 1.3 |  | 4932 |  |  |  |  |  |  |  |  | 4.5 | 7.6 | 24 | 170 | 5 | 8.6 | 29 | 180 | 4.7 |  |  | 2-0 | 2 - 2 | 1 | X | 34(H),36(H),57(A),69(A) | 34 | 57 | 2 | 0 | 2 | 4
2017-09-08 00:00:00 | 2017-09-08 17:00:00 | [NAME] | AC Horsens | FC Nordsjaelland | DNK |  |  | 5 | 1 | 6 | 6 | 5 | 3 | 5 | 1 | 6 | 17 | 9 | 2 | 7 | 5 | 1.3333 | 1 | 0.3333 | 0 | 0 | 0 | 0.6667 | 0.3333 | 0.3333 | 0.3333 | 0.1667 | 0 | 0.1667 | 0 | 0 | 0 | 0 | 0.6667 | 1 | 0.6667 | 0.5 | 0.3333 | 0.5 | 0.1667 | 0.6667 | 0.5 | 1 | 1 | 0.3333 | 0.6667 | 1 | 0.8333 | 99017 | 4.4 |  | 4.5 |  | 2.34 |  | 2.38 |  | 2.86 |  | 2.9 |  | 100114 | 1.29 |  | 1.31 |  | 4.2 |  | 4.4 |  | 18566 | 5.2 | 5.3 | 11 | 34 | 8.8 | 7.8 | 15.5 | 55 | 27 | 25 | 50 | 180 | 130 | 140 | 260 | 1000 |  | 65 |  | 0-0 | 2 - 2 | X | X | 61(H),77(A),81(H),90(A) | -1 | 61 | 0 | 0 | 0 | 4
2017-09-08 00:00:00 | 2017-09-08 17:30:00 | German Bundesliga 2 | FC Heidenheim | Jahn [NAME] | DEU |  |  | 15 | 14 | 6 | 6 | 7 | 3 | 5 | 4 | 6 | 10 | 9 | 3 | 6 | 4 | 1.3333 | 1.1667 | 0 | 0 | 0 | 0.6667 | 0.8333 | 1 | 0.5 | 0 | 0 | 0 | 0.1667 | 0 | 0 | 0 | 0.3333 | 0.8333 | 0.6667 | 0.6667 | 0.3333 | 0.3333 | 0 | 0.1667 | 0.3333 | 0.3333 | 0.6667 | 0.6667 | 1 | 1 | 1 | 0.8333 | 52064 | 2.42 |  | 2.46 |  | 4.3 |  | 4.4 |  | 2.78 |  | 2.82 |  | 25104 | 1.26 |  | 1.28 |  | 4.5 |  | 4.8 |  | 7035 | 4.7 | 8.4 | 26 | 140 | 5.4 | 8 | 27 | 150 | 11.5 | 17 | 55 | 430 | 42 | 65 | 190 | 1000 | 65 | 250 |  | 0-0 | 1 - 3 | X | 2 | 67(A),85(H),88(A),90+4(A) | -1 | 67 | 0 | 0 | 0 | 4
2017-09-08 00:00:00 | 2017-09-08 17:30:00 | German Bundesliga 2 | [NAME] | [NAME] | DEU |  |  | 13 | 18 | 6 | 10 | 13 | 3 | 2 | 5 | 6 | 4 | 10 | 3 | 2 | 5 | 1.5 | 1.1667 | 0 | 0.3333 | 0 | 0 | 0.8333 | 0.3333 | 0.6667 | 0 | 0.1667 | 0.3333 | 0.1667 | 0 | 0.3333 | 0 | 0 | 1 | 0.6667 | 0.6667 | 0 | 0 | 0.3333 | 0.3333 | 0.3333 | 0.6667 | 0.6667 | 0.6667 | 1 | 1 | 1 | 1 | 186873 | 1.34 |  | 1.36 |  | 14 |  | 14.5 |  | 5.2 |  | 5.3 |  | 44700 | 1.91 |  | 1.93 |  | 2.08 |  | 2.1 |  | 20888 |  |  |  |  | 5.1 | 7.4 | 23 | 160 | 5.6 | 7.8 | 24 | 130 | 12 | 17 | 55 | 340 | 17 | 180 |  | 1-0 | 1 - 1 | 1 | X | 36(H),82(A) | 36 | 82 | 1 | 0 | 1 | 2
2017-09-08 00:00:00 | 2017-09-08 18:00:00 | French Ligue 1 | Lille | Bordeaux | FRA |  |  | 13 | 5 | 6 | 7 | 10 | 3 | 6 | 2 | 6 | 11 | 8 | 3 | 6 | 6 | 2 | 1.1667 | 0 | 0 | 0 | 0 | 0.6667 | 0 | 0.1667 | 0.6667 | 0.3333 | 0.3333 | 0.5 | 0 | 0.3333 | 0 | 0 | 0.8333 | 1 | 0.8333 | 0 | 0.3333 | 0.3333 | 0.1667 | 0.6667 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 | 495061 | 7.8 |  | 8 |  | 1.87 |  | 1.88 |  | 2.94 |  | 2.96 |  | 138947 | 1.23 |  | 1.24 |  | 5.1 |  | 5.2 |  | 40315 | 4.6 | 4.3 | 7.4 | 24 | 13.5 | 10.5 | 19.5 | 60 | 90 | 65 | 1000 |  |  |  |  |  |  | 46 |  | 0-0 | 0 - 0 | X | X |  | -1 | -1 | 0 | 0 | 0 | 0