I need an application or program that collects data from a website and put them in a spreadsheet.
It should work on mac, and should work for matches played and matches to be played. It should work for any tennis match.
- example for matches that have been played:
- example for today's games:
I will enter the url in the application and I need the application to open all links called "info", and inside collect the following data for each match:
1 - Player 1's name will go to the column "a" of the spreadsheet.
Take it from the above list because I need Ferrer D. (no David Ferrer)
2 - Name of player 2 will go to the column "b" of the spreadsheet
3 - average odds player 1, the column "d"
4 - average odds player 2, the column "e"
5 – GAMES handicap bet365 (not sets) Example: -3.5 (The column "j")
6 - over / under total GAMES bet365. Example: 22.5 (in the column "k")
7 - result (if played) a figure in each column.
games won by player 1 in set one: column w
games won by player 2 in set one: column x
games won by player 1 in set 2: column and
games won by player 2 in set 2: column z
games won by player 1 in set 3: column aa
games won by player 2 in set 3: column ab
games won by player 1 in set 4: column ac
games won by player 2 in set 4: column ad
games won by player 1 in set 5: column ae
games won by player 2 in set 5: column af
8 - date (column cw)
9- location (column cu)
10 - tournament category (column cx) eg. Masters
11 - surface (column c) eg. indoors
12 - round (column cz) eg. semifinals
It is important that I can modify the code to keep it running when tennisexplorer changes his web design for example.
Keep in mind that I will gather them on every day before they play the matches. And the next day will include the results in the spreadsheet. Tennisexplorer always placed before the player has won the game, so may have changed the order of the players in sereral matches. Any ideas to fix this other than manually?