Project Description:
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
US English - Level 1
