Closed

website data extraction into excel - repost

Project Data Extraction from a horse racing website into an excel spreadsheet there is probs in excess of 20,000 results, which will then have to automatically update itself with new results.

Excel spreadsheet will have macros within the spreadsheet to perform different functions,

Update button – this will check for new results that have just completed and if not in the spreadsheet it will update the spreadsheet with these results.

Search features – text box within the spreadsheet to search between dates for winners, trifecta which is a sequence of first three horses for the race, and quinella which is the first two places for the race.

Format of exported data for main table

Game Date Time Distance First Second Third

1399882 27/07/2012 20:27 800 8 5 2

There is another table required which will display the results of the last 20 games, this will update as more results are updated to the spreadsheet.

Horse Number First Second Third Fourth

1 8 4 2 1

2 2 10 1 1

3 2 1 1 1

4 1 1 1 2

5 1 1 1 1

6 5 4 2 2

7 3 0 1 1

8 5 4 2 1

9 4 3 2 2

10 0 1 1 2

11 0 0 2

12 0 0 3 4

Email function within the spreadsheet when certain results come through need to be able to send an email, would like to be able to change or add new criteria easily for example if horse number 12 hasn’t won for 30 races send email.

The website where the data is stored uses tables to store the information, please contact me for website address if you are interested in this project.

Please contact me for more details.

Thanks

Skills: Copy Typing, Data Entry, Data Processing, Excel, Microsoft Exchange

See more: features of data processing, uses for excel, text macros, excel uses, send email excel, horse racing results, horse box, excel function, excel 2013, data-extraction, project contact spreadsheet excel, excel distance, add macros, text box excel, date last change website, excel spreadsheet check check, horse races, text function excel, excel change data format, excel add macros, excel spreadsheet horse racing, excel data tables, excel macros email, date extraction, horse racing data

About the Employer:
( 0 reviews ) India

Project ID: #4161894

5 freelancers are bidding on average $670 for this job

romanzuev93

I'm ready to work with you.

$500 USD in 14 days
(3 Reviews)
4.8
ksnrajesh912

I ma very good in excel and writing macros. Ready to work with you

$300 USD in 15 days
(2 Reviews)
2.3
html5guru

Please explain more

$1750 USD in 50 days
(1 Review)
1.6
nanotech3309

data experts here

$550 USD in 12 days
(0 Reviews)
0.0
Itdap

Hello Sir, My name is Diego and I have 14 year of IT experience. I have the following certifications: MCITP, MCP, MCTS and STS also coursed CCNA, MCSE and MCDBA. I provide all kind of support services including: Micr More

$250 USD in 5 days
(0 Reviews)
0.0