App to download stock prices into excel

To make this work, create a new Google Sheets from the online service not the downloadable software. Go to Google Drive and make a new sheet. Add to the sheet codes you want to look up, then a column with calls to GoogleFinance to lookup those codes.

Sheets works similarly to Excel for these operations. The usual 21 st century disclaimers, use at your own risk etc. Once you have a simple sheet to start with, the next step is to publish it in a form that Excel can understand. Go to File Publish to the Web. Copy the supplied link so you can use it in Excel. You can then import the data into Excel via a web query that uses the Google Sheet as the data source. To do this, follow the steps below:. You can make a copy of that template and update it with your own list of stocks and mutual funds.

To add a new stock symbol to the Google Sheet, type the symbol in column A, then copy the formulas from previous rows. To connect your Google Sheet document with Excel, first publish your Google Sheet document to the web. From the dropdown box, select the StockQuotes worksheet. Then click the "Publish" button and copy the URL that is shown highlighted, like in the screenshot below. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions.

Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. The last column I shows how each stock is trending for the day, which comes directly from information gathered by Stock Connector.

To make gains and losses obvious at a glance, I took advantage of Excel's conditional formatting. This is just a basic example, but with a little imagination you can use other conditional formatting techniques to convey even more detailed information. Stock Connector will update the stock price instantly when you enter the ticker symbol for the first time and every 15 seconds after that for as long as you have the Excel worksheet open.

The add-in works in the Excel Desktop version as well as online. This means you can use One Drive and other cloud storage services for your stock-tracking Excel worksheets and not lose the Stock Connector features. Stock Connector can retrieve information about any stock, indexes, ETFs, etc. However, for more obscure securities you may have to do some research to find the right ticker symbol.

I used Excel for the example in this article, but the add-in was originally designed for Excel and presumably works in that version as well.

Note that while Stock Connector does not cost any money to install and use, it does display a small advertisement in the lower portion of its window. It is unobtrusive, but it is there nonetheless and you may notice it from time to time. Do you have a favorite add-in that brings more power or convenience to Excel? Share your recommendations with fellow TechRepublic members.