Historical Market Cap
The historical market capitalisation for a company can be access in 2 ways. You can either retrieve a single date in history which is done through using the "historicals" data type or you can return an entire time-series between 2 dates by using the SF_TECHNICAL() function. Both are shown below:
Historical Market Cap - Single Date
=SF("AAPL", "historical", "marketCap", "2001-07-24")
6834000000Historical Market Cap - Time-series
=SF_TECHNICAL("AAPL", "marketCap&all", "", "2015-07-24", "2022-11-29")
[multi-cell array]Note: All the same functionality of SF_TECHNICAL() is available such as formatting the output with options or only displaying certain metrics. The only available metrics for marketCap are marketCap and date. Read more on SF_TECHNICAL().
Was this helpful?
Was this helpful?