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.

READ The market is officially on crack... Buy is more vicious than sell since MARCH 23 2020?

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.

READ The market may be ready for a 1987 style crash led by tech.

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

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

534 views

Leave a Comment Cancel reply