Using Excel to pull data
-
First post! I have created my first strategy that I am looking to test and have about 6 weeks worth of selection to fill data in for. Is there a quicker way than doing this manually? I am hoping that I can set up excel/google sheets to do this for me, rather than trawling through every match individually. At this stage only final score would be required.
Any help would be greatly appreciated, thanks in advance.
-
@alexander-hughes
Cheers, I will check it out. Looks very interesting. -
https://x.com/paspuggie48/status/1733452320761844217?s=20
You can use this to get the scores. Go to the data ribbon and click refresh to update it. Then extract the scores and merge with your file.
Or go directly to https://www.football-data.co.uk/ and pull the information through via power query as the twitter link only covers 11 countries. Right click the files to get the direct link(s) to use.
Merging