The power of fundamental analysis to ascertain the value of a company is based on the idea that all businesses essentially carry out the same, common activities. These activities can range from salaries and marketing spend to spending on research and capital assets, and receiving investment income.
Because these activities can all be reduced to financial quantities, they can therefore be directly compared across companies. Analysts can use common metrics like revenues, R&D spend, COGS and free cash flow to create an accurate assessment of comparative value between, for example, a software stock versus an auto stock.
Between the advent of common accounting standards and regulator-mandated timely, standardized filings by all public companies, it has become easier to compare companies even if they come from different industries. Further, data firms have aggregated this wealth of data, harmonizing it across reporting companies and packaging it for analysis.
Quandl has several stock fundamentals and financial ratio databases from multiple data publishers, allowing you to instantly compare different companies with each other and over time.
US Stock Fundamentals Data
These databases cover the US equity market with varying degrees of depth, granularity and aggregation:
600 indicators and ratios, 19,500 companies, history from 1979, from Zacks Research.
150 indicators, 6,500 firms, 11 years of data. Inc/ex restatements, point-in-time, delisted.
200 indicators, 17,000 companies, history from 1979, from Zacks Research.
Descriptive information and ratios for 6,000 companies, from Zacks Research.
90 indicators, 17,000 companies, history from 1979, from Zacks Research.
Fundamental indicators and financial ratios aggregated for 250+ distinct industry groups.
Global Stock Fundamentals Data
Accurate fundamentals data for global stocks is difficult to come by. They are either expensive, unreliable or limited in scope (especially historical coverage and coverage for smaller countries).
The following four databases on Quandl are unique in that they each offer high-quality fundamental indicators and financial ratios for select global markets in a trustworthy, accessible package.
These four databases cover stock fundamentals data for India, China, Europe and emerging Asia:
75 harmonized indicators, 4,000 select global stocks, 6 years history. Focus on Asia & Europe.
165 indicators and ratios for 4000 Indian stocks on BSE and NSE. 11 years historical data.
150 fundamental indicators for 3000 Chinese stocks on Shanghai, Shenzhen exchanges. History to 2006.
100 financial ratios for 3000 Chinese stocks. Based on audited statements and third-party review.
Here are some indicators that are available in these fundamentals databases.
|Balance Sheet||Income Statement||Cash Flow Statement||Financial Ratios|
Cash & Equivalents
Property & Equipment
Goodwill & Intangibles
Cost of Goods Sold
Sales, G and A
Research & Development
Depreciation & Amortization
|Cash from Operations
Cash from Investments
Cash from Financing
Earnings per Share
Free Cash Flow
Accessing and analyzing stock fundamentals data
Quandl users can easily access several stock fundamentals and financial ratio databases via our RESTful APIs, the guide to which can be found in our API documentation.
The benefits of using premium data
While free data may suffice in some circumstances, investment professionals should stick to premium (that is, paid) data for a number of key reasons:
- Quandl’s premium data undergoes strict evaluation by financial experts, so you know that you’re using trusted sources to inform your decisions.
- Our premium data also comes with robust documentation detailing collection methods, observation times and more, so that you know where your data is coming from.
- Quandl constantly monitors premium data feeds to give you peace of mind for quality control and support.