Export one year of data from YAHOO FINANCE CANADA into one EXCEL spreadsheet per list of companies.
Approximately 2000 companies on my list.
Automate the process above so it can be run on a daily basis.
Automate the process so that any updates to the company list will be included when the routine is run.
Include variable start and stop dates to determine the data range.
These start and stop dates will be entered into the relevant YAHOO FINANCE CANADA webpage.
Webpage data exported into a temporary EXCEL spreadsheet and sorted in chronological order (oldest to newest).
Once sorted the data is copied into the correct columns of the appropriate company EXCEL spreadsheet.
Not sure how many spreadsheets can be safely contained within one EXCEL workbook (computer capability dependent I assume).
Therefore multiple EXCEL workbooks may be required to accommodate approximately 2000 companies.