Download Market Data sometimes crashes with "Run-time Error '13': Type Mismatch". When this happens, the debugger shows a blank value for 'querydate' in the 'ProcessSymbol_AV' function. It doesn't seem to be related to the symbol. Using the same symbol in another column works.
I'm using the latest version of the spreadsheet with Adj Close Data Type and Alpha Vantage data source.
Quandl API downloads the data but I can't find the symbol for the S&P 500 index with this data source. Also, the data values appear to be different for these two sources.
I can download all of the data by using multiple copies of the spreadsheet with some of the symbols in one and the ones that didn't load after the crash in the other one.
