Excel Live Stock Quotes Download Historical Stock

The template will show you the gain or loss for each stock between the original purchase and its current market value.

Excel Live Stock Quotes Download Historical Stock

For example, there are commercial add-ins that can download historical stock quotes into Excel and provide tools for analyzing the information, creating charts, and providing oodles of technical analysis functions.

The new Stock data type makes it a piece of cake to get stock data into Excel.

To see if your version of Excel works with this new feature, download the above template.

If the table of stock quotes works, and can be refreshed via Data Refresh All, you are good to go.

Note the disclaimer (not for professional or stock trading purposes or advice).

After creating a table for the symbols that you want, you can publish the sheet as a web page (via File Publish to the Web).

You can then import the data into Excel via a web query that uses the Google Sheet as the data source.

You can make a copy of that template and update it with your own list of stocks and mutual funds.

Then click the Publish button and copy the URL that is shown highlighted, like in the screenshot below.

For security, you should only use the Google Sheet to list the stock quotes.

Dont add other personal financial data to the published sheet.

Create a new Excel worksheet, then go to Data Get External Data From Web.

For example use a formula like INDEX(D:D,MATCH(MSFT,B:B,0)) to get the Price for MSFT.

Instead, Excel uses the new Stock data types, like those included in my template above.

This will download the data within the entire date range as a.csv file rather than just the stock quote data shown on the page.

They also sell other add-ins related to technical analysis, portfolio tracking, options, etc.

You can use the GOOGLEFINANCE function to get stock quote data into your Google Spreadsheet directly from Google Finance.

Please consult your financial advisor or lending institution before making any final financial decisions.

Microsoft and Microsoft Excel and Microsoft Word are registered trademarks of Microsoft Corporation.

Vertex42.com is not associated with Microsoft.

Excel For Mac Live Stock Quotes