Skip to content

Track the largest companies market caps, real time, in Excel

The Excel Stock data type lets you track the largest companies market capitalization in real-time.

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 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.

About this author

Office Watch is the independent source of Microsoft Office news, tips and help since 1996. Don't miss our famous free newsletter.