Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
The new Stock data type lets you track the largest companies market capitalization in real-time using Excel.
There’s news about the changing #1 position between Apple and Microsoft. As stock prices change, the two companies switch positions.
It’s strangely compelling to watch the market caps change by billions in the blink of an eye.
Excel 365’s Stock data type has the essential information to calculate market capitalization with changing values in real-time.
Stock data type has fields for Shares Outstanding and stock Price. Multiply the two for the Market Capitalization*.
Refreshing the prices changes the market capitalization.
Bonus – Real-Time Excel
After requests from customers we’ve added the above worksheet to the example worksheets in Real-Time Excel – get live stock prices, currency rates and more Past purchasers can download the latest ebook release.
Market Capitalizations.xlsx also includes an example of the upcoming function Sortby() which automatically re-sorts a table without VBA.
The ebook has comprehensive coverage of the Stock data type used to calculate market capitalizations in real-time.
Real-Time Excel – get live stock prices, currency rates and more is only US$6.95 and includes examples of getting real time data into Excel for Windows (365, 2019, 2016 or 2013).
* Market Capitalization can get more complicated when the company has multiple share classes. Happily for the likes of AAPL and MSFT, there’s one share class so the calculation is simple.
Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.