Increase capability of STOCKHISTORY function
The STOCKHISTORY function is great for getting the price history of one stock. Three suggestions:
1. It could offer more utility if it could get the stock history for multiple stocks, and align the values with respect to dates. For example, if I wanted monthly close values for 8 stocks over a 4-year time range, it could return an array of 9 columns (1 date and 8 stock values) and 49 rows (1 header row and 48 monthly data rows).
2. In addition to "daily", "weekly" and "monthly", it would be nice to have interval choices of "quarterly" and "yearly".
3. It would be nice to be able to import major indexes like Dow Jones index and S&P 500 index, which aren't technically stocks.