Money last price not updating
This page describes using Excel web queries to get refreshable stock quotes in Excel.
Sometimes, however, data for just one company isn’t enough – you need to compare the relative performance of several companies.
If you misspell a ticker or leave a blank, the VBA is clever enough to skip over or ignore the error. You’ll also get a list of tickers for which no data was found. I’ve tested the spreadsheet by downloading historical quotes for 180 ticker symbols.
Everything worked perfectly, with 180 new sheets added to the workbook, each filled with historical data.
For security, you should only use the Google Sheet to list the stock quotes.
Don't add other personal financial data to the published sheet.
If you asked the spreadsheet to export the data, you’ll find a CSV file for each ticker in the folder you specified.