Money last price not updating

Posted by / 08-Apr-2020 14:39

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.

money last price not updating-50money last price not updating-78money last price not updating-3

If you asked the spreadsheet to export the data, you’ll find a CSV file for each ticker in the folder you specified.