
Excel / VBA data scraping from Websites (may use Java/HTML)
- or -
Post a project like this2691
£50(approx. $68)
- Posted:
- Proposals: 3
- Remote
- #2108147
- Awarded
Description
Experience Level: Entry
I'd like a spreadsheet to import odds data from 6 leading bookmakers . Ultimately would like to expand this to more events but for now happy to focus on just Premier League .
Here's what the sheet should do:
STEP 1 : Macro button to trigger the "scrape" of data. The macro should go to the link below and download all the available games in the Premier League - sorted by date and time
https://www.pinnacle.com/en/odds/match/soccer/england/england-premier-league?sport=True
STEP 2 : The game should list the Pinnacle match odds for each game (using the above link).
STEP 3 : The macro should then scrape the data from 5 other leading bookmakers to pull in their current odds for the same events - using the following links
https://sports.ladbrokes.com/en-gb/betting/football/english/premier-league/
http://sports.williamhill.com/bet/en-gb/betting/t/295/English+Premier+League.html
https://m.skybet.com/football/coupon/10011434
https://www.betfair.com/exchange/plus/football/competition/10932509
https://www.bet365.com/#/AC/B1/C1/D13/E37628398/F2/
Obviously some of the links may change (specifically those with codes above) - ideally the macro will search/detect the correct link for the Premier League match odds
STEP 4 : The macro will continuously monitor the odds being offered on all those websites and update the Excel sheet as or when they change.
Here's what the sheet should do:
STEP 1 : Macro button to trigger the "scrape" of data. The macro should go to the link below and download all the available games in the Premier League - sorted by date and time
https://www.pinnacle.com/en/odds/match/soccer/england/england-premier-league?sport=True
STEP 2 : The game should list the Pinnacle match odds for each game (using the above link).
STEP 3 : The macro should then scrape the data from 5 other leading bookmakers to pull in their current odds for the same events - using the following links
https://sports.ladbrokes.com/en-gb/betting/football/english/premier-league/
http://sports.williamhill.com/bet/en-gb/betting/t/295/English+Premier+League.html
https://m.skybet.com/football/coupon/10011434
https://www.betfair.com/exchange/plus/football/competition/10932509
https://www.bet365.com/#/AC/B1/C1/D13/E37628398/F2/
Obviously some of the links may change (specifically those with codes above) - ideally the macro will search/detect the correct link for the Premier League match odds
STEP 4 : The macro will continuously monitor the odds being offered on all those websites and update the Excel sheet as or when they change.
Jonny E.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
18 Nov 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies