Is it possible to have a excel sheet that auto updates from a website
whenever the website is updated?

Now I understand the excel file would have to open for the update to occur.
But the main part of this question is really broken into two parts.

1. Can you reference online data?

2. How fast can the refresh rate be on the calculations?