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

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

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.

track the largest companies market caps real time in excel office 365 24812 - Track the largest companies market caps, real time, in Excel

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.

subs profile e1563205311409 - Track the largest companies market caps, real time, in Excel
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