Excel Stock function - Does it work with Office Professional Plus 2019?

Occasional Visitor

I have tried to pull stock data on many different attempts and although it will convert the stock ticker to the full stock name with the ticker that seems to be the extent it will accomplish.


I have gone over various videos and sites and after I convert the symbols and the names update that is the furthest it reaches. There is no Symbol or add column icons that appear or can be used to edit or add after that. The image I uploaded only shows a few stocks I tried to get to work out of a random set of stocks, I only attempted to try it with a few in this image.


I have updated my office to the most recent version, I am signed in, and I assume it is the version that is the issue?



1 Reply
This feature is unavailable in Excel 2019 I'm afraid. You would need an Office 365 subscription to use it.