Is it possible to get excel or some program to update from online.

So if I was looking at basketball stats I could have it automatically update every day from basketball-reference.com/ and pull all 30 NBA teams + all players + all opponents stats. From there I would want it to calculate a few different stats that I have created that are not currently published such as Points Per Shot (PPS) instead of Field Goal % (FG%).

If possible can someone please write a code that would allow me to do this. Thank you.