Getting Started with Excel 365’s Stock Data Type


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

Give Stock or Geography linked data types a try in Excel 365 for Windows.  It really is a great innovation and will be better once Microsoft sorts out the data issues.

Getting started

At its simplest, type in the name of a company and click on Data | Data Types | Stocks

getting started with excel 365s stock data type microsoft excel 24660 - Getting Started with Excel 365's Stock Data Type

Excel goes off to Microsoft’s servers and grabs info about that company.  As a Linked Data Type, the cell gets a little logo and an icon prompt at right.  Click on that to see the many data fields available.

getting started with excel 365s stock data type microsoft excel 24661 - Getting Started with Excel 365's Stock Data Type

Add a few fields and there’s the latest price data for the stock.  It’ll update whenever you click ‘Refresh All’ on the data tab.

getting started with excel 365s stock data type microsoft excel 24662 - Getting Started with Excel 365's Stock Data Type

Choosing the right one

That’s how some demos are likely to show it.  The reality is a little more complicated because big companies are listed on multiple stock changes.  There’s two ways to handle this

The Data Selector may appear if Excel isn’t sure which company or location you mean.  Scroll down the list and select the right one.

getting started with excel 365s stock data type microsoft excel 24663 - Getting Started with Excel 365's Stock Data Type

Or open the Data Selector by right-clicking on a Linked Data Cell to Data Type | Change …

getting started with excel 365s stock data type microsoft excel 24664 - Getting Started with Excel 365's Stock Data Type

Add as many companies as you like and update as often as you like.

getting started with excel 365s stock data type microsoft excel 24667 - Getting Started with Excel 365's Stock Data Type

subs profile e1563205311409 - Getting Started with Excel 365's Stock Data Type
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