I am interested in downloading daily open, high. low, close data for many stocks. I would then run some math on these prices, and put the output in a specific range. Ideally, another sheet would reference these output ranges for each stock, and aggregate everything. I would like to do this with 1000 stocks, but I'm not sure if it is feasible in Excel. I was thinking that each stock would have it's own workbook, and would update automatically once a day without being opened? Is this possible? I have little experience with importing external data, so and advice is appreciated. Thanks.
Paul