Member-only story
Creating an Arbitrage Alert System from scratch using Python and Supabase Day 6— Team Data CSVs Finished
Hi Guys, and welcome back to this series. We are on Day 6 of Articles and today we are focusing on adding all of our team data to our database table. This will be a relatively small article as I just want to share the CSV files with you.
After quite some time I have finally finished scraping the teams from each website. The websites I have scraped are Bwin, PaddyPower, Bet365, Pinnacle and SkyBet. The CSV files can be found in this repo.
Simply download each websites respective CSV file and in the database table — football_teams_sites click the green insert button and then Import data from csv and select a file and click import. Repeat for each file and you are done!
The only issue I have faced with scraping these teams is the fact that some teams were missing from each site. For example, there were some National League teams missing from Bwin, presumably because Bwin does not offer odds on matches too far in advance. To combat this I will re-scrape the teams for each site regularly. I will offer updates when I do with the corrected files.
This is not a major issue as of yet, but once we begins scraping odds data we should start to find discrepancies which I can correct relatively easily.
That is all for today! We can now get into the fun stuff with this project, creating scrapers for each site and then finding the arb opportunities.
I hope you enjoyed, consider dropping a follow and clap if you did.
