Completed

website data extraction into excel

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: Data Mining, Data Processing, Excel, Web Scraping

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

About the Employer:
( 4 reviews ) Stockton, Australia

Project ID: #2428616

Awarded to:

vbexcel

Web scraping pro with particular expertise in working with sports related web sites - ten years experience.

$390 USD in 5 days
(28 Reviews)
5.4

13 freelancers are bidding on average $345 for this job

mantislin

Hi sir, Please check PM.

$500 USD in 4 days
(90 Reviews)
6.3
l2factory

Hello. I can do this work.

$280 USD in 5 days
(54 Reviews)
5.7
Alexod

I can help you

$550 USD in 7 days
(5 Reviews)
3.7
andlommy

Hi! I got quite some experience dealing with betting sites such as betfair or bet365, and i can do a scraper you are asking for.

$270 USD in 5 days
(3 Reviews)
3.1
Magicspell

Experienced scrapper developer here. Please check your PMB for details.

$255 USD in 3 days
(6 Reviews)
3.1
getndone

this project seems to need scraping results from another website. please see pm.

$500 USD in 7 days
(3 Reviews)
2.2
sureshoragadam

Hi, i have expert knowledge in building utility tools using Excel macro. I will complete this. Please see your PM

$275 USD in 3 days
(3 Reviews)
2.1
aravinthvba

Greeetings! I am interested in this project. Kindly let me know if i can work with you, Good day!

$400 USD in 3 days
(2 Reviews)
1.9
exopad

Hi, Please give me the website so I can check If there are any possibilities using a webquery in Excel. The list updating and emailing (via Outlook I assume) are things i've f done many times before. Thanks, Ex More

$309 USD in 3 days
(2 Reviews)
1.7
ErArshabh

hi there, i recently scraped data from [login to view URL] there was an API available to extract data from the database. please provide me with the site that you want to scrape and i will get back to you if i can do this pr More

$250 USD in 7 days
(3 Reviews)
1.0
nbhattacharjee

Hi, Please send me the details. I'll complete your work before time. Thanks

$250 USD in 3 days
(0 Reviews)
0.0
Vmarks

hi, I am interested in the project. I could create excel crawler(Macro) to crawl the website and scrape the required fields. kindly let me know the url to scrape. I assure you of good quality worm. Regards, shanker

$250 USD in 10 days
(0 Reviews)
0.0