We begin by creating a Stock Data Type. The Stock Data Type is located on the Data tab in the Data Types group labeled Stocks.
This feature can convert company names or stock ticker symbols (ex: MSFT for Microsoft) to get current stock price information like price, volume, and company information.
Start by entering a company name or known company ticker symbol into a cell. We will use MSFT to look up stock information on Microsoft.
With the cell containing the company name/symbol selected, click Data (tab) -> Data Types (group) -> Stocks.
The Stocks feature will attempt to convert the cell data into a Rich Data Type. We see that it is having a bit of difficulty doing this only because there are several potential exchanges to choose from, such as Nasdaq, Borsa Italiana, SIX Swiss, etc.
Selecting one of these exchanges will complete the conversion process. We will select the Nasdaq exchange for this demonstration.
Observe how our entry of MSFT has been converted into the proper name of the company along with the exchange and ticker symbol. There is also a small icon to the left that looks like a tiny rendition of the New York Stock Exchange building.
The resemblance is uncanny.
The icon indicates that this is now a Rich Data Type. If you click the icon, you are presented with a card that displays a tremendous amount of information about the selected company.
You see information such as stock price, headquarters office address, and even number of employees.