How can we perform calculations on data which is dynamic?

E.g. I need to perform statistical calculations on daily stock market price and volume data (i.e. changes daily). I don't wish to enter each day's price manually. Is there a way, I can hook up Excel with market price provider where the data is will be entered automatically and calculations performed in the same way?