Follow us :
expectedscore.com

CSV method for retrieving the matches

Content:

Appeal to the method

This method is used to retrieve the file with the matches, their parameters and odds.
At the current moment, only csv format is available.
url: https://offvariance.com/api/public/csv/matches/{type}/?key={key}

The method is divided into two types: finished and future.
- finished - retrieving the ended matches.
- future - retrieving the future matches (+21 days from the current moment)

An example of a request for retrieving future matches:
https://offvariance.com/api/public/csv/matches/future/?key=demokey
An example of a request for retrieving the ended matches:
https://offvariance.com/api/public/csv/matches/finished/?key=demokey

Parameters of the request:
Parameter
Description
key
Your API key
type
Type of the method: 
- finished
- future

Fields of the file

Main parameters
Field
Description
id
Match ID
date_match
Date of the match. Format "d.m.Y H:i:s" .
date_match_unix
Date of the match in the Unix format.
time_first
Duration of the first half
time_match
Duration of the whole match
team_#N#_id
  • team_1_id - id of the home team
  • team_2_id - id of the away team
team_#N#_name
  • team_1_name - Name of the home team
  • team_2_name - Name of the away team
team_#N#_goal
  • team_1_goal - Goals for the home team
  • team_2_goal - Goals for the away team
country_id
ID of the country
country_name
Name of the country
league_id
ID of the leagues
league_name
Name of the league
season_id
ID of the season
season_name
Name of the season
tour_id
ID of the day
tour_name
Name of the day
odds_open_win1
Opening odds. Home team win. 
odds_open_draw
Opening odds. Draw.
odds_open_win2
Opening odds. Away team win.
odds_open_tb25
Opening odds. TotalOver 2,5.
odds_open_tm25
Opening odds. TotalUnder 2,5.
odds_close_win1
Closing odds. Home team win.
odds_close_draw
Closing odds. Draw.
odds_close_win2
Closing odds. Away team win.
odds_close_tb25
Closing odds. TotalOver 2,5.
odds_close_tm25
Closing odds. TotalUnder 2,5.
VI_OVER25_HOME
Parameter Variance Index Over 2,5 for the home team
VI_OVER25_AWAY
Parameter Variance Index Over 2,5 for the away team
VI_UNDER25_HOME
Parameter Variance Index Under 2,5 for the home team
VI_UNDER25_AWAY
Parameter Variance Index Under 2,5 for the away team
VI_WIN_HOME
Parameter Variance Index Win for the home team
VI_WIN_AWAY
Parameter Variance Index Win for the away team
VI_NOLOSE_HOME
Parameter Variance Index NoLose for the home team
VI_NOLOSE_AWAY
Parameter Variance Index NoLose for the away team

xG parameters

The name of the xG parameters formed by the next structure: 
#Team#_#Type#_#Group of the parameters#_#Parameter#_#Subparameter#

An example:
team2_home_xg90-03_zero_xga90 - parameter of the away team, calculated by the ended home matches, xg90-03 group of the parameters, zero parameter (for 0-0 score), xga90 subparameter.


Field
Description
#Team#
team1 or team2. Home or Away team, correspondingly.
#Type#
all, home, away.
- all - general parameter, calculated for home and away games.  
- home - parameter, calculated only for the home games. 
- away - parameter, calculated only for the away games. 

#Group of the parameters#
- classic - group of the general statistician parameters;
- xg90 - group of the xg90 parameters;
- five - group of the Last Five parameters;
- xg90-03 - group of the xg90 0,3 max parameters;
- xgpower - group of the xgpower parameters;
- xgpower-03 - group of the xgpower 0,3 max parameters.

Information about the parameters in the spreadsheets.
#Subparameter#
Information about the parameters in the spreadsheet "Description of the parameters in draw, zero, cxp, cop, com, cxm, xg"

Available demo data

You can retrieve demo data with the key: ?key=demokey
Available tournament: England —> Premier League