How to view current stock prices and other quotes in Excel

Excel 365
Current stock prices and other quotes require the new Excel feature - Data Types. Unfortunately, this feature doesn’t work at the moment for Excel 2016.

See more about current stock prices and other quotes in Excel for Microsoft 365.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

How to view current stock prices and other quotes in Excel

How to view current stock prices and other quotes in Excel

Current stock prices and other quotes require the new Excel feature - Data Types. Unfortunately, this feature doesn’t work at the moment for Excel 2016.
How to view current stock prices and other quotes in Excel

How to view current stock prices and other quotes in Excel

There are countless reasons why you might need actual stock information, such as stock prices and changes, in your Excel spreadsheet. Previously, you had to copy and paste from Yahoo Finance or another financial service.
Unrealized Gain and Loss

Unrealized Gain and Loss

To show the unrealized gain and loss require the new Excel feature - Data Types. Unfortunately, this feature doesn’t work at the moment for Excel 2016.