using Excel for Stock Market Graphs - simplify/automate?

[erickguz]

Hi,

I presently dl historical data from Google Finance for stocks. I copy and paste to excel. In excel, I have formulas from the downloaded data, that I graph (I graph the formulas). I track 2,000 stocks. Of course, my graphs are updated only when I paste the downloaded stock data.

Is there a better way to do this automatically?

Thanks,
Erick