I need to:
1. Modify an Excel spreadsheet so that it updates closing stock prices from Yahoo finance upon opening and deletes one day a year ago to end up with one year of prices.
2. Dynamically update charts with the updated prices as is shown in attached spreadsheet.
3. Generate additional charts to match same parameters as is shown on present charts, based on a check mark beside the stock symbol in the Correlation Box on the "Calculations" sheet. In other words, for all symbols check, confirm that a chart is set up on one of the sheets and if not, generate one.