Hello
Currently, I'm working on a project where I will collect some soccer stats. Instead of doing it manually, there must be an easy way to collect this via VBA. However, I have been searching around the internet without luck and as I'm not the best one at VBA (hence only basic VBA knowledge), this seems to be difficult for me. However, I don't think this is complicated at all for people with VBA experience.
I am interested in scraping the data marked with yellow below, i.e. the data for the 19/20 season. Furthermore, I am interested in the possibility of changing this to another season or to another team, meaning that I would like to type in the saison_id and/or the team id into two cells in the excel spreadsheet, so that I can change it as wanted. This means that instead of just doing this for team name "Leicester" (id "1003" from link below) and saison_id = "2019", I could also be interested in doing the same for for instance team name "Everton" (id "29" in the link below) and "2019" or "2018" for instance, "Newcastle" and "2019" or "2018" for instance and so forth for other teams. In other words, in cell A1 for instance I will need to type in team id and in cell A2 for instance I will need to type in the saison id so that it will scrape the data.
Can someone please help me out? Thank you very much in advance!
1003/plus/0?saison_id=2019&wettbewerb_id=&day=&heim_gast=&punkte=&datum_von=-&datum_bis=-
29/plus/0?saison_id=2019&wettbewerb_id=&day=&heim_gast=&punkte=&datum_von=-&datum_bis=-
Currently, I'm working on a project where I will collect some soccer stats. Instead of doing it manually, there must be an easy way to collect this via VBA. However, I have been searching around the internet without luck and as I'm not the best one at VBA (hence only basic VBA knowledge), this seems to be difficult for me. However, I don't think this is complicated at all for people with VBA experience.
I am interested in scraping the data marked with yellow below, i.e. the data for the 19/20 season. Furthermore, I am interested in the possibility of changing this to another season or to another team, meaning that I would like to type in the saison_id and/or the team id into two cells in the excel spreadsheet, so that I can change it as wanted. This means that instead of just doing this for team name "Leicester" (id "1003" from link below) and saison_id = "2019", I could also be interested in doing the same for for instance team name "Everton" (id "29" in the link below) and "2019" or "2018" for instance, "Newcastle" and "2019" or "2018" for instance and so forth for other teams. In other words, in cell A1 for instance I will need to type in team id and in cell A2 for instance I will need to type in the saison id so that it will scrape the data.
Can someone please help me out? Thank you very much in advance!
Most valuable clubs
www.transfermarkt.com
Most valuable clubs
www.transfermarkt.com