Spreadsheet: 766346d1643857390-need-help-with-a-formula-to-calculate-last-7-and-last-30-results-of-data-last7help
Sheet: data

Date | Type | Risk | To Win | Status | Sport | Description | Win | Loss | $
2021-12-16 00:00:00 | ML | 118 | 130 | Loss | NHL | Capitals
2021-12-17 00:00:00 | Total | 200 | 166.67 | Win | NHL | Vegas / NY Under 6
2021-12-18 00:00:00 | Prop | 100 | 160 | Loss | MMA | [NAME]
2021-12-18 00:00:00 | ML | 300 | 240 | Loss | MMA | [NAME]
2021-12-18 00:00:00 | ML | 100 | 71.43 | Win | NHL | Flyers
2021-12-18 00:00:00 | Total | 200 | 181.82 | Win | NFL | NE / IND Under 22.5
2021-12-19 00:00:00 | Prop | 110 | 100 | Loss | NFL | [NAME] Over 207.5
2021-12-19 00:00:00 | Prop | 110 | 187 | Win | NFL | AJ Dillon TD
2021-12-19 00:00:00 | ML | 220 | 176 | Win | NFL | Steelers
2021-12-20 00:00:00 | Total | 220 | 183 | Win | NFL | LV / Cle Under 20.5
2021-12-20 00:00:00 | Total | 110 | 110 | Loss | NHL | Minnesota Under 6
2021-12-28 00:00:00 | Prop | 120 | 100 | Loss | NBA | [NAME] Over 6.5
2021-12-28 00:00:00 | Prop | 120 | 90 | Loss | NBA | [NAME] Under 9.5
2021-12-28 00:00:00 | Prop | 120 | 85 | Loss | NBA | [NAME] Under 4.5
2021-12-28 00:00:00 | Prop | 120 | 88.89 | Win | NBA | [NAME] Under 2.5
2022-01-01 00:00:00 | ML | 160 | 84.21 | Win | CFB | Ohio State
2022-01-01 00:00:00 | ATS | 110 | 104.76 | Win | NFL | Arizona +6.5
2022-01-01 00:00:00 | Prop | 110 | 95.65 | Win | NFL | [NAME]
2022-01-05 00:00:00 | ML | 220 | 183.33 | Win | Tennis | Ana Konjuh
2022-01-07 00:00:00 | Total | 120 | 114.5 | Loss | NHL | Flames / Hurricanes Under 6
2022-01-08 00:00:00 | ML | 120 | 100 | Loss | NHL | Lightning
2022-01-08 00:00:00 | Total | 240 | 200 | Win | NHL | Sharks / Flyers Under 6
2022-01-08 00:00:00 | Prop | 120 | 104.35 | Win | NFL | DK Metcalf Over 55.5
2022-01-08 00:00:00 | ATS | 120 | 109.09 | Win | NFL | Jaguars +15.5
2022-01-08 00:00:00 | Total | 120 | 109.5 | Loss | NFL | [NAME] Over 278.5
2022-01-10 00:00:00 | ATS | 120 | 104.35 | Win | CFB | Georgia -2.5
2022-01-10 00:00:00 | ML | 240 | 200 | Loss | Tennis | [NAME]
2022-01-10 00:00:00 | ML | 240 | 200 | Loss | Tennis | Ana Gasnova
2022-01-10 00:00:00 | ML | 240 | 200 | Loss | Tennis | [NAME]
2022-01-10 00:00:00 | ML | 240 | 160 | Win | Tennis | [NAME]
2022-01-11 00:00:00 | ML | 240 | 120 | Win | Tennis | [NAME]
2022-01-11 00:00:00 | Total | 120 | 100 | Loss | Tennis | [NAME] Over 24.5
2022-01-11 00:00:00 | Total | 120 | 100 | Loss | NHL | Canucks / Panthes Under 6.5
2022-01-12 00:00:00 | ML | 150 | 90.91 | Win | Tennis | [NAME] Zadoinov
2022-01-12 00:00:00 | ML | 150 | 100 | Loss | NBA | Lakers
2022-01-12 00:00:00 | ML | 120 | 100 | Loss | NBA | Mavericks
2022-01-13 00:00:00 | ATS | 120 | 100 | Loss | NFL | Arizona +4
2022-01-13 00:00:00 | ML | 30 | 150 | Loss | NFL | Raiders
2022-01-13 00:00:00 | ATS | 120 | 100 | Loss | NFL | Raiders +6.5
2022-01-14 00:00:00 | ML | 150 | 93.75 | Win | NHL | Wild
2022-01-20 00:00:00 | ML | 160 | 80 | Win | NHL | Stars
2022-01-20 00:00:00 | Total | 120 | 120 | Win | NHL | Capitals / Bruins Over 6
2022-01-21 00:00:00 | Prop | 120 | 100 | Loss | NFL | Geoff Swaim Over 11.5
2022-01-21 00:00:00 | ATS | 120 | 100 | Loss | NFL | Tennessee Titans -2.5
2022-01-21 00:00:00 | Prop | 120 | 150 | Loss | NFL | [NAME] by KO/TKO
2022-01-22 00:00:00 | ML | 120 | 192 | Win | MMA | [NAME]
2022-01-22 00:00:00 | Prop | 30 | 300 | Loss | NFL | Geoff Swaim TD
2022-01-22 00:00:00 | Prop | 120 | 160 | Loss | NFL | Stefon Diggs TD
2022-01-23 00:00:00 | Total | 120 | 109 | Win | NFL | LAR / TB Over 47.5
2022-01-24 00:00:00 | ML | 150 | 90.91 | Win | NHL | Rangers
2022-01-25 00:00:00 | ML | 240 | 165.52 | Win | NHL | Oilers
2022-01-27 00:00:00 | Prop | 120 | 104.35 | Win | NBA | [NAME] Under 0.5
2022-01-27 00:00:00 | ML | 120 | 88.89 | Win | NHL | Blues
2022-01-27 00:00:00 | ML | 180 | 100 | Loss | NHL | Rangers
2022-01-28 00:00:00 | Total | 120 | 100 | Win | NHL | Red Wings / Penguins Under 6.5
2022-01-27 00:00:00 | ML | 240 | 200 | Loss | NHL | [NAME]
2022-01-27 00:00:00 | Total | 240 | 218.18 | Win | NHL | Hurricanes / Senators Under 6.5
2022-01-28 00:00:00 | Total | 240 | 226.42 | Win | NHL | Bruins / Coyotes Under 6
2022-01-28 00:00:00 | ML | 120 | 246 | Win | MMA | [NAME]
2022-01-28 00:00:00 | ATS | 240 | 218.18 | Win | NFL | SF +3.5