data extraction tool

I need an application or program that collects data from a website and put them in a spreadsheet.

web: tennisexplorer

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:

[url removed, login to view]

- example for today's games:

[url removed, login to view]

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?

Upload a video in which red lights where each data on the web, and a number indicating what data we are lighting

Wprowadzanie danych Excel

Numer ID Projektu: #4074519

O projekcie