To track stock prices we use apps to track them. Microsoft Excel has a powerful feature to track stock prices and update stocks. You can quickly get the updated stock price as it updates the price automatically. In this article, I will show you how you can track stock prices in excel.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
2 Quick Methods to Track Stock Prices in Excel
Following the article, I have explained two easy methods to track stock prices in excel.
Suppose we have a dataset of some company names and we will track the price with help of excel.
1. Utilize Stock Option to Track Stock Prices in Excel
In this method, we will use the “Stock” option to track the stock price. Basically, stock option is used to convert the company names into stock names. Follow the steps to get the precious result.
- Select stock names from the dataset and choose the “Stocks” option from the “Data” option.
- This way the company names will convert to stock names.
- Now select the stocks from the dataset and click on the “Extract price to grid” icon.
- A new window will open.
- Click the “Price” option from the list.
- This way you will get the prices of stocks. You can also add more options like Rating, Previous close, and Market cap from the “Grid” icon if you want to track. That’s it. Simple, Isn’t it?
- To refresh data we will choose “Refresh All Connections” from the “Data” tab.
- Click on “Learn more” from the “Disclaimer” at the top of the dataset.
- A new window will appear covering all the refreshed data from the stocks.
- How to Import Stock Prices into Excel from Yahoo Finance
- Download Historical Stock Data into Excel (with Easy Steps)
- How to Get Historical Data of NSE Stocks in Excel (2 Effective Ways)
2. Use Stock Connector Add-in to Track Stock Prices in Excel
Excel has some built-in add-ins to track stock prices easily. You can use the stock connector option to get the updated stock prices of your choice. In the following method, I have shown the process of using the stock connector option. Go through the process to learn-
- Go to the “Insert” option and choose “Office Add-ins”.
- The “Office Add-ins” window will open.
- Choose “Store” and then search for the “Stock Connector” tool in the search option.
- When the searching is complete, you will get the tool “Stock Connector”.
- Choose the “Stock Connector” and click the “Add” option.
- On the right side of the excel workbook, the “Stock Connector” add-in will appear.
- Select a stock name from the dataset and it will appear in the “Connect” option of the “Stock Connector” automatically.
- Hit the “Connect” button.
- From the drop-down list choose your preferred stock.
- A new window will appear where we have to confirm a location to get the price.
- Press OK after selecting the cell.
- This way you will get the updated price of the stock in your workbook.
- Now simultaneously connect all the stock in the connector to get the stock prices in your excel workbook.
- As you can see, after connecting all the stocks in the connector, the “Stock Connector” will automatically show the updates in the window. You can track all types of updates from the stock connector add-ins window.
Things to Remember
- You must have access to Microsoft 365 and a stable internet connection to always get updates on the price.
- To get the updated price automatically, you don’t have to refresh every time. Go through the commands to refresh automatically. Right-click a data type from the worksheet and go to Data Types > Refresh Settings. Choose “Automatically Every 5 Minutes”. Thus the data will update after every 5 minutes.
- While refreshing it takes time for the workbook to change the data.
In this article, I have tried to cover the simple and quickest methods to track stock prices in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.