Since Yahoo terminated their API back in the May/June time frame, I was still able to get web-based data to download into EXCEL from a query such as:
https://download.finance.yahoo.com/d/quotes.csv?s=SPY+DIA&f=sl1d1t1c1ohgv&e=.csv
The above web query would yield:
spy 257.15 10/31/2017 4:00pm 0.4 257.18 257.44 256.8 60304781
dia 233.63 10/31/2017 4:00pm 0.3 233.64 233.91 233.2 1772047