Common Stock Equity (Historical)
Returns common stock equity (book value) from historical balance sheets.
Syntax
=hf_Common_stock_equity(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Common stock equity (book value)
Examples
=hf_Common_stock_equity("AAPL", 2023, 4)=hf_Common_stock_equity("MSFT", "ly", 2)When to Use
- Book value analysis
- Price-to-book calculations
- Return on equity calculations
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total equity | hf_Total_equity() |
| Need preferred equity | hf_Preferred_stock_equity() |
Common Issues & FAQ
Is this the same as book value?
Yes, common stock equity is the book value of common shareholders' equity.
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
▶
How does MarketXLS work?