1. Products

How to Pull Historical Data (Marketcap Example)

Intrinio provides historical marketcap data dating back to 2008 for US securities. Here’s how to pull the data in Excel or via our Web API.

We get quite a few questions about marketcap. We provide that data going back to 2008 for US securities. If you want to access that data through the API, here is a great tutorial walking you through the web API.

If you want to work with Excel, here is the tutorial for the Excel add in:


In the API, a historical marketcap call would look like this:

To get the current marketcap, you would use this:

In Excel, historical marketcap:

Or, the most recent marketcap in Excel: