Stock and Geography for Excel is live, give it a try

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

A truly interesting new Excel feature is now going public. Stock and Geography are the first two Linked Data Types (LDT) that bring stock prices and geographic info direct into Excel 365.

Stock data type gives you information on stocks and indexes from over 60 global stock exchanges.

excel stock and geography features reach slow insiders 22668 - Stock and Geography for Excel is live, give it a try

No messing about with PowerQuery, ‘Get and Transform’, data feeds and all that technobabble.

We’ve been trying out the Stock and Geography data types for months and have written about them already.

Our book Real Time Excel has special and detailed chapters on Linked Data Types plus the specifics and problems of Stock and Geography feeds. Real Time Excel has been updated in mid-November 2018 to reveal the latest changes and tricks available.

There are still problems with the incoming data but the underlying technology appears to work well.

What you need

Stock and Geography data types are getting a low-key and slow rollout. None of the usual Microsoft hype and fanfare, for the moment.

Eventually all Office 365 for Windows customers will get this feature. That’s Office 2016 for Windows with an Office 365 subscription.

At first, it’s available to English language Office 365 for Windows. Starting with version 1811 or above (check File | About).  If you don’t have v 1811, try Update | Update Now on the same pane.

Linked Data Types also needs the necessary data connection.  The rollout to Microsoft’s global server network is also underway.

Support for other languages is planned later in this slow rollout.

Most Excel 365/Windows/English customers should have Linked Data Types now or in the next week or two.

Do I have Linked Data Types?

See if you have Linked Data Types from Excel’s Data tab.

stock and geography for excel is live give it a try microsoft excel 24687 - Stock and Geography for Excel is live, give it a try

If the Data Types section is there with Stocks and Geography options (see image above) then you’re good to go.

subs profile e1563205311409 - Stock and Geography for Excel is live, give it a try
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address