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:
`=STOCKHISTORY(D5,TODAY(),,2,0,1)`

• Drag the Fill Handle icon to cell E7.

Breakdown of the Formula

TODAY(): Returns todayâ€™s date.

STOCKHISTORY(D5,TODAY(),,2,0,1): This function returns the history of stocks, from a specific opening date to another specific closing date. If one single date is used, todayâ€™s date, it returns only that day’s stock price.

Note:

• You can only get the price information of the Stock data.
• Need to be connected online in order to fetch data.
• This option is only available in Excel 365 or the online version of Excel.

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.

Note:

Beta value denotes the volatility of a stock. If a stocks’ beta value is above 1, then the stock is more volatile.

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.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Rubayed Razib Suprov

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

INVESTEC WORLD AXIS PCC INVESTEC CORE FUND IWCF
Satrix MSCI World ETF SWIX
Satrix RESI ETF SATRIXRESI
Coronation Global Capital Plus [ZAR] Feeder CPLSZ
Ninety One Equity Fund NINEQ

No amount of permutations work
Rob Davidowitz

Rubayed Razib Suprov Jan 26, 2023 at 1:58 PM

Greetings Rob,
Thanks a lot for commenting on this article. Unfortunately, we managed to find only the last three companies and the INVESTEC CORE FUND IWCF among the companies you metioned in the database. Rest of them are not enlisted in the database. I have given the dataset link containing the stock informations of the Satrix RESI ETF SATRIXRESI, Coronation Global Capital Plus [ZAR] Feeder CPLSZ, Ninety One Equity Fund NINEQ, INVESTEC CORE FUND IWCF etc.

Thanks and Regards
Rubayed Razib

2. Why would a NYSE ticker (SNOW for Snowflake) not be included in the excel database? Is there a way to get around this?

• Hello JZ,

NYSE ticker SNOW for Snowflake is included in Excel database.
To get the data follow the steps below.
Insert SNOW in any cell then click on Stocks from Data tab.

You will get all the data by selecting the fields.

Regards
ExcelDemy

Advanced Excel Exercises with Solutions PDF