OK, I'm just a guy who likes to place bets on the outcome of sporting events for fun in my retirement. I'm not looking for anything fancy at this stage, I will be the sole user so no need for it to be super user friendly though the screen interface must be sensible!
So start at [login to view URL] (UK greyhound racing for the day). Choose a race at a venue (I won't be more specific because your work schedule and time differences may result in you seeing a different page than the one I'm seeing today).
Table1: Follow to a race and you will be taken to a page showing the race details, the runners and some stats on each. Scrape and format the data into a table showing Date, Time, Venue, Distance, Grade, PrizeMoney, DogName (including the superscripted notation alongside as a separate column), TrainerName, Additional Dogs (the dogs named below the trainer). I will normalise after extraction.
Table2: For each runner listed in the race details page follow the link "Form" and a list of that runner's previous races and performance stats will show. Scrape all the data (already tabular) and include the runner's name, today's race venue and today's race time in each record for matching with Table1. Again I will normalise into a relational database after extraction.
Table3: Go to [login to view URL] and follow the link to "Yesterday" to obtain a list of yesterday's races and follow the link for each race and scrape the results of each race into a table detailing the Date, Venue, Time, DogName, Position, Odds, Split, Time, RaceComments so that I can match the data with the race details extracted the previous day.
After completing Table3 the app should ask if I want to also create a Results Table for an earlier date still available on the Results webpage (just in case I was not able to run the app on an earlier day) or if I want to close the app. The app will list the dates results are still available for as links to extract the additional day's results after which it will again ask if I want further day's results or to close the app. The app will keep looping until I click that I want to close it.
On running the app the 3 tables will be produced and saved to Desktop as Table1 = "GreyhoundRaces_yyyy/mm/dd", Table2 = "GreyhoundForm_yyyy/mm/dd" and Table3 = "GreyhoundResults_yyyy/mm/dd-1" (note date is previous day). All tables to be Excel/csv files. The extraction app should run from my (Windows10) PC.
Any questions please ask.
34 freelancers are bidding on average £172 for this job
ok understood, if you don't want any fancy GUI then i can make a python script for you, don't worry you will get custom user input, message me so we can discuss? thanks!