Bookie Website Odds Comparison Excel VBA Scraper

I am looking for some software that will automatically scrape golf odds from a large selection of UK bookies in excel. I want this to include every single golf price a bookie offers. An example of the markets that are likely to be found are: • Winner • Top 5 • Top Continental Euro • 3 way 18 holers • 2 way 18 holers • 2 way 72 hole matches • 72 Hole Groups Etc…. The most important data to scrape from these websites will be: • Tournament Name – For example -The Masters • Market Name – For example, tournament winner, top European, 72 hole match bet etc. • Bookie – For example, Ladbrokes, bet365 etc. • Odds – For example, 10/11, 16/1 etc. These should be expressed in what is known as decimal odds. This is just a different way of recording these fractions. Put simply, if a website records their odds in fractions then 10/11 becomes 1.909009, 11/8 becomes 2.375, 16/1 becomes 17.0. It is basically the fractional odds +1. Some bookies such as pinnacles and betfair already record their odds in decimal. • Each way terms – this is split into two factors. Each way places and each way fraction. For example, on a golf win market you will typically see ¼ 1,2,3,4,5. This means that the number of each way places is 5, and the fraction is ¼. The data collated should then be rearranged to create an odds comparison grid. This will probably require some manual lookups to define how each bookie writes a market or player name. For example Ladbrokes may call one market “Tournament Winner” and bet365 may call the same market “to win outright”. In addition to market name differences, player name differences will also happen. For example, Rafa Cabrera Bello v Rafael Cabrera-Bello. Similarly, tournament name will require lookups. For example, The Masters v US Masters.  The current list of bookies I would like to scrape is below. I can provide urls to the data but the successful applicant will have to find the data feeds themselves: • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL]  • [login to view URL] • [login to view URL] • betfair exchange - [login to view URL] • betfair sportsbook - [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] I understand that the websites that I will be scraping will constantly be updating. Therefore, the successful applicant will probably get more work in the future as the feeds break down because of website changes or when new betting websites are created. The code in this project should be openly accessible to me, i.e. no passwords or similar should be used to restrict access. Unfortunately the last person to attempt this project did not complete it but some of the code that was written you can find the in the attached spreadsheets. I would prefer for this to be written in VBA. I understand this is not the best code for scraping but I would like i to be fully contained within excel. Please look through the attached spreadsheets before applying for this job. They show the basic process I would like. I would like all data to be imported into something like the "Golf Odds Scraper Example". This data should be cleansed at that point before the data for a specific tournament can be exported in to a grid comparison in a spreadsheet like "Tournament Export Example". The end product should look something like [login to view URL] and all the other markets but I don't want to be reliant on them mapping markets so I want software to do it directly with the bookie websites mentioned above.