Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Track Stock Prices in Excel (2 Simple Methods)

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.

Track Stock Prices in 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.

Step 1:

  • Select stock names from the dataset and choose the “Stocks” option from the “Data” option.

Utilize Stock Option to Track Stock Prices in Excel

  • 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.

Utilize Stock Option to Track Stock Prices in Excel

  • A new window will open.
  • Click the “Price” option from the list.

Utilize Stock Option to Track Stock Prices in Excel

  • 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?

Step 2:

  • To refresh data we will choose “Refresh All Connections” from the “Data” tab.

Utilize Stock Option to Track Stock Prices in Excel

  • Click on “Learn more” from the “Disclaimer” at the top of the dataset.

Utilize Stock Option to Track Stock Prices in Excel

  • A new window will appear covering all the refreshed data from the stocks.

Read More: How to Import Stock Prices into Excel from Google Finance (3 Methods)


Similar Readings


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-

Step 1:

  • Go to the “Insert” option and choose “Office Add-ins”.

Use Stock Connector Option to Track Stock Prices in Excel

  • The “Office Add-ins” window will open.
  • Choose “Store” and then search for the “Stock Connector” tool in the search option.

Use Stock Connector Option to Track Stock Prices in Excel

  • When the searching is complete, you will get the tool “Stock Connector”.
  • Choose the “Stock Connector” and click the “Add” option.

Use Stock Connector Option to Track Stock Prices in Excel

  • On the right side of the excel workbook, the “Stock Connector” add-in will appear.

Step 2:

  • Select a stock name from the dataset and it will appear in the “Connect” option of the “Stock Connector” automatically.
  • Hit the “Connect” button.

Use Stock Connector Option to Track Stock Prices in Excel

  • From the drop-down list choose your preferred stock.

Use Stock Connector Option to Track Stock Prices in Excel

  • A new window will appear where we have to confirm a location to get the price.
  • Press OK after selecting the cell.

Use Stock Connector Option to Track Stock Prices in Excel

  • 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.

Read More: Get Stock Quote with Excel Add-in (With Easy Steps)


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.

Conclusion

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.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo