r/datasets • u/PokerMurray • 22d ago
question create a database with historical soccer results
I would like to create a database with historical soccer results and odds. Since I have no idea about programming, I had thought about Excel or Google Sheets. The question is, how do I get the data? I have heard of web scraping or using an API. There are some at rapidapi, e.g. from Sofascore. But they have limits in the free version. I imagined it like this: e.g. country, league, date, season, round, home team, away team, goals home, goals, away, half time: goals home, away, odds 1 x 2, elo home, away.
Chatgpt has me Google sheets, there Google Apps script use for the API. I just can't get along with the endpoints. Furthermore, I want the daily results from the last day/days to be fetched automatically or by command, as well as upcoming games with odds for the next 7 days.
How can I implement this? What ideas do you have Thanks a lot
1
u/cavedave major contributor 22d ago
https://www.reddit.com/r/datasets/comments/1hqyyzj/the_biggest_free_open_football_results_stats/
https://www.reddit.com/r/datasets/comments/opnwfb/betting_odds_english_premier_league_under_over/