I need to automate the attached spreadsheet.
The only input is the list of stocks (Column A of the 'Stocks' tab).
The rest must be generated automatically by 1. query the price history from Yahoo, and 2. calculate the correlation using proper formula.
Input will be provided in simple input file (one symbol per line).
Output can be Excel file or HTML TABLE in html file.