Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
01-12-2019 03:29 AM - last edited 01-22-2019 00:58 AM
Market Capitalization is the measure that is mostly used by analysts to assess hegemony of a company over a sector, an industry, and even over the entire economy.
GAFAM are the new superpowers of our time. These 5 tech giants are also the 5 most valuable companies in the world. As Apple lost 75 Billion USD in trading day of January 3rd, 2019, which is quite much for a single company, I wanted to create a dashboard that shows market cap evolution of GAFAM since their IPO.
In order to do that, I collected the adjusted closing price of each company, each day, since 12/12/1980 (Apple's IPO), which I multiplied by the number of outsanding shares for each of them. The Result of that calculation is the firm's market capitalization.
PS : Several methods exist to calculate market capitalization. My own method is the following one :
Market Cap = [company's adjusted stock value as of YYYY//MM/DD] * [number of diluted outstanding shares as of YYYY//MM/DD]
Sources :
SEC (Securities and Exchange Commission) | https://www.sec.gov/
Yahoo Finance | https://fr.finance.yahoo.com/
Macrotrends | https://www.macrotrends.net/
Shares Outstanding History | https://www.sharesoutstandinghistory.com/apple/
Enjoy,
Augustin de la Fouchardiere
Senior Business Intelligence Consultant
Former Consultant at Societe Generale, CGI, Banque de France.
eyJrIjoiODY2MjYwMzUtODllNC00YTU0LWI3NDAtYjY5NDcwN2NjY2RmIiwidCI6Ijg5NWQ0YTRiLTE1NGYtNDUzNy04NzAyLTc4YWQ0MDE1Y2Y0YSIsImMiOjl9