Excel 2016 itself does not have this feature. You may follow Jim's advice from
this thread and use an add-in from the Office Store called
Stock Connector. Please note that this is a third-party add-in, so issues with this add-in needs to be handled by the provider.
If you would like Excel to have this feature built-in, given the situation, we suggest you submit your idea via
UserVoice; this is the best way to make our products and services better for you and others.
11 people were helped by this reply
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.