How to Get Stock Prices in Excel (3 Easy Methods)

Here’s a small sample dataset that demonstrates how you can extract stock prices in Excel.

Method 1 – Combining STOCKHISTORY and TODAY Functions in Excel

Steps

• Input the stock symbol or the company ticker symbols in Excel.
• Enter the symbol AAPL in cell D5 for the Apple corporation.

• Enter the symbol MSFT and SONY from Microsoft and Sony corporations, respectively, in cells D6 and D7.

• Enter the following formula in the cell E5:

• Drag the Fill Handle icon to cell E7.

Method 2 – Get Stock Prices by Utilizing the Built-in Stocks Command

Steps

• Select the company name and go to the Data tab.
• Click on the Stocks icon.

• All of the company names now change to their official full form with the Stock symbol or the Ticker symbol with them.
• The company may be listed in multiple exchanges in different parts of the world at once. Excel will open a sliding side menu in that case.
• Select the stock exchange you intend to use. We chose NYC here for example.

• The range of cells is now filled with the company’s name with the appropriate ticker symbol.
• There is also an Add-column icon on the top corner of the cell. You can use this to get various stock information about different companies.

• Click on the add column sign.
• Click on Price.

• You’ll get a new column to the right with the updated value of all stocks presented.

• Click on the add column sign and select Change.

• You’ll get a new column with a percentage change of stock values.

• Click on the add column and select the Beta option.

• You’ll get the information about the stock’s beta value.

• Clicking the stock icon on the left of each row in the company column provides more information.

• If you want to refresh the stock data, go to the Data tab and click the Refresh All command.

How to Choose a Different Stock Exchange

• Select the cells of which companies exchange you want to alter, then right-click and select Data Type.
• Click on Change.

• In the options panel, delete the ticker symbol and the identifier at the end of the Company Name.
• Click the search icon.
• Choose an exchange and click on Select.

• Here’s the result.

Read More: How to Import Stock Prices into Excel from Yahoo Finance

Method 3 – Using the Stock Connector Add-in to Get Stock Prices

Steps

• Input the company names in the range of cell B5:B7.
• From the Insert tab, click on the Get Add-ins icon on the Add-ins group.

• You will be taken to the Office Add-ins store.
• Search for Stock.
• In the search result, look for Stock Connector.
• Click on the Add button on the corner of the Stock Connector add-in.

• The stock connector add-in is now available on your Excel sheet in the Home tab.

• Copy the contents of cells B5:B7 to cells C5:C7.

• In the Home tab, click on the Stock Connector Launch icon.
• The Stock Connector will launch in the side panel.
• Select the company name cells in the worksheet.
• Click on Connect.

• You will be asked where would be the output value will be placed.
• Select cell C5 and click OK.

• The stock price of Microsoft Corporation is now showing in cell C5.

• Repeat the same process for other companies.
• For some companies, the add-ins may ask you which stock exchange value of the selected company you want to show.
• For example, in our case, Apple Inc is listing multiple stock exchanges. We selected the US stock exchange.

• We have the stock prices of different companies in the range of cells C5:C7.
• The values will update every 30 seconds automatically in the cells.
• In the sliding panel, we can also see the percentage of their stock price increase.

Download the Practice Workbook

Related Articles

• How to Get the Current Stock Price of India in Excel
• How to Import Stock Prices into Excel from Google Finance

<< Go Back to Stocks In Excel| Excel for Finance | Learn Excel