Example Excel Downloads

Football Bet Data Image

For the purpose of the example files, the data used is taken from the English Premier League, Season 2017-18 from the month of January, with Score Predictions all checked and all other filters left as default, although the dataset used is not critical.

File: FBD 1st Goal

Explanation of example: This download shows you how you can quickly find the times of the first goal. Column BU shows the formula to find the time of the first home goal (where no goal is scored this is left blank). Column BV shows the formula for the first away goal time, and then column BW shows the time of the first goal scored in the match.

The simple pivot chart and graph show the count of first goals scored within 10 minute brackets. Any goal scored in added on time falls within the 90 minute bracket. Goals scored in the 9th minute and 1 second would count as the 10th Minute in terms of publishing and therefore under the bracket 10.

Football Bet Data Example Excel File Download One

File: FBD Last Goal

Explanation of example: This download shows you how you can quickly find the times of the last goal. Column BU removes any "+1, +2, +3" etc from the official goal time of the home team where a goal has been scored in injury time. This accounts for up to 12 minutes of injury time, if you want to extend this please amend the formula further out than 12 minutes. Column BV removes any "+1, +2, +3" etc from the official goal time of the away team where a goal has been scored in injury time. This accounts for up to 12 minutes of injury time, if you want to extend this please amend the formula further out than 12 minutes. Column BW shows the time of the last goal scored by the home team in the game, and column BX shows the last goal time of the away side. Column BY therefore shows the overall last goal time.

The simple pivot chart and graph show the count of the last goal scored within 10 minute brackets. Any goal scored in added on time falls within the 90 minute bracket. Goals scored in the 89th minute and 1 second would count as the 90th minute in terms of publishing and therefore under the bracket 90.

Football Bet Data Example Excel File Download Two

File: FBD Last 10

Explanation of example: This example download shows the amount of goals scored in the last 10 minutes of games (including injury time). Columns BV:CD show the formula used to count the amount of goals scored in each minute listed in row 1. Column CE sums the amount of goals scored in the 10 minute period.

The basic pivot table and pie chart show the breakdown of games where goals have or haven't been scored in the last 10 minutes.

Football Bet Data Example Excel File Download Three

File: Over 2.5

Explanation of example: a basic formula to calculate games where the predicted number of goals in the game is more than 2, and the actual average over 2.5 odds is greater than the predicted over 2.5 odds. The formula then works out the profit or loss if you had back each qualifying game for a 10 pint level stake. In this example you can see only 2 matches meet the criteria - Everton vs Manchester United and Huddersfield vs West Ham. Over profit is 3.8 points.

This is just a demonstration as to how you can use the data to test and create systems and is no means meant as a way to guarantee a long term profit.

Football Bet Data Example Excel File Download Four