MarketXLS

Market Capitalization (Historical)

Returns the historical market capitalization for a company at the end of a specified period.

Formula

Market Cap = Share Price x Shares Outstanding

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year or period code
Quarter No Quarter 1-4
TTM No "TTM" for trailing twelve months

Syntax

=hf_Market_Capitalization(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Market capitalization in USD

Examples

=hf_Market_Capitalization("AAPL", 2023, 4)
Q4 2023 market cap
=hf_Market_Capitalization("MSFT", "ly")
Last year market cap
=hf_Market_Capitalization("GOOGL", 2023, , "TTM")
TTM market cap

When to Use

  • Historical valuation analysis
  • Size comparison over time
  • Building historical models
  • Market cap trend analysis

When NOT to Use

Scenario Use Instead
Current market cap MarketCapitalization()
Enterprise value hf_Enterprise_Value()
Real-time valuation Current market cap functions

Common Issues & FAQ

Why does historical market cap differ from current?

Market cap changes with stock price and shares outstanding.

What price is used?

Typically the period-end closing price.

Excel Templates Using Market Capitalization (Historical)

These ready-made MarketXLS templates call hf_Market_Capitalization() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Market Capitalization (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions