Export data from Yahoo Finance into Excel Spreadsheet

In Progress

SUMMARY:

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.

REQUIREMENTS:

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.

CONSIDERATIONS:

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.

Skills: Data Entry, Data Mining, Excel

See more: excel yahoo spreadsheet, export yahoo finance, export yahoo finance excel, export yahoo finance data excel, yahoo finance export excel, yahoo-finance, within my capability, sorted data, process of data entry in a computer, how to automate data entry in excel, excel spreadsheet companies, daily finance, spreadsheet yahoo finance, excel workbook companies, temporary data entry, finance in excel, finance excel, finance excel data, export data, excel finance, excel automate, data entry summary, data range, multiple excel, finance data excel

About the Employer:
( 1 review ) Cochrane, Canada

Project ID: #4341878