I was wondering if it was possible for excel to get information from the internet (say on stocks), several times a day, and add it to NEW cells automatically (thus updating charts, conditional statements, calculations, etc), but not replacing old data?

Alternatively, is excel able to keep a semi-static variable, like total profit, if only one cell is set up to auto-update?

For example: in cell a1 I have the stock price, b1 is the calculation of gains (or losses) for the day, and c1 is the net value. I know how to set a1 to get new data, but not how to keep c1 up to date.

Thanks