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 tutorial:

API Tutorial

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

https://intrinio.com/tutorial/excel

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

https://api.intrinio.com/historical_data?ticker=AAPL&item=marketcap&start_date=2014-01-01&end_date=2015-01-01

To get the current marketcap, you would do this:

https://api.intrinio.com/data_point?ticker=AAPL&item=marketcap

In Excel, historical marketcap:

=intriniohistoricaldata("AAPL", "marketcap", 2, "2009-01-01", "2011-01-01")

Or, the most recent marketcap in excel:

=intriniodatapoint("AAPL","marketcap")

The blog provides a lot more detail, including this template example.

Did this answer your question?