Example Excel Downloads
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.
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.
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.
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.
File: Goal Sequence
Explanation of example: File will show how to display the sequence of goals scored in a game using our goal times column. Firstly the goal times columns (Home and Away) are copied into Column BU and BT respectively. We then use Excel's "Text to Columns" function to split out the goal times by minute. We allow 12 columns for each team as it is extremely unlikely a single team will score more than 12 goals in a competitive league fixture.
Then in columns CS:DG (shaded green) the sequence of goals are displayed. Where there are 2 goals scored in the same minute there is no way to differentiate so the formula skips this and doesn't favour either home or away side without having the knowledge of exactly who scored first.
This can help assess how often teams, or certain leagues see teams come from behind to win or draw, and by adding additional formula yourself you can expand on this further.
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.