Intrinio is on a mission to make financial data affordable and easy to access, and one way we do that is by providing historical market cap in Excel and API formats. Our support team, who you can chat with by clicking the green icon on the bottom right-hand corner of this page, get a lot of questions about market capitalization, so we figured it must be a data point that many analysts and developers need.
This blog shows how to get historical market cap data, as well as hundreds of other financial metrics, in Excel. If you’d like to skip ahead, or follow along, download the Excel template that I’ll be demonstrating here. By the end of this blog you’ll be able to pull in historical time series data for any US security.
Feel free to start with this video: