Microsoft’s decade long catch up for Market Capitalization

via swapripper:

One of the biggest news this week was Mircrosoft briefly overtaking Apple as the biggest company in terms of market cap. I thought it would be a good idea to graph this decade long catch-up.

Since I could not get historical market cap data as far out as 2010 directly using any API(without paying), I decided to use historical ticker prices & historical outstanding shares

Data

Historical ticker prices fetched using AlphaVantage API.

Historical number of outstanding shares – Got this from sharesoutstandinghistory.com

We are primarily funded by readers. Please subscribe and donate to support us!

Formula for Market Cap

Market Cap = Number of Outstanding Shares * Closing price

Tools used

Python 3.6 Matplotlib Pandas AlphaVantage API

Github link

github.com/spsphulse/Microsoft-Vs-Apple

 

Views:

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.