Data Trends for Investment Professionals

GO TO QUANDL.COM ⟶

Finding and using stock fundamentals data

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:

Complete US Fundamentals

600 indicators and ratios, 19,500 companies, history from 1979, from Zacks Research.

Core US Fundamentals

150 indicators, 6,500 firms, 11 years of data. Inc/ex restatements, point-in-time, delisted.

Extended US Fundamentals

200 indicators, 17,000 companies, history from 1979, from Zacks Research.

Zacks Company Profiles

Descriptive information and ratios for 6,000 companies, from Zacks Research.

Standard US Fundamentals

90 indicators, 17,000 companies, history from 1979, from Zacks Research.

Industry Level Fundamentals

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:

Robur Select Global Fundamentals

75 harmonized indicators, 4,000 select global stocks, 6 years history. Focus on Asia & Europe.

D-Market India Stock Fundamentals

165 indicators and ratios for 4000 Indian stocks on BSE and NSE. 11 years historical data.

DataYes China Stock Fundamentals

150 fundamental indicators for 3000 Chinese stocks on Shanghai, Shenzhen exchanges. History to 2006.

DataYes China Stock Financial Ratios 

100 financial ratios for 3000 Chinese stocks. Based on audited statements and third-party review.

Fundamental Indicators

Here are some indicators that are available in these fundamentals databases.

Balance Sheet Income Statement Cash Flow Statement Financial Ratios

Cash & Equivalents

Investments

Receivables

Property & Equipment

Goodwill & Intangibles

Total Assets

Accounts Payable

Long-Term Debt

Total Liabilities

Common Stock

Total Revenue

Cost of Goods Sold

Sales, G and A

Research & Development

Depreciation & Amortization

Operating Expenses

Operating Income

Investment Income

Non-Operating Income

Pre-Tax Income

Cash from Operations

Cash from Investments

Cash from Financing

FX Adjustment

Capital Expenditure

Starting Cash

Ending Cash

Earnings per Share

Price/Earnings Ratio

EBIT

EBITDA

Gross Margin

Profit Margin

Free Cash Flow

Asset Turnover

Inventory Turnover

Receivable Turnover

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

Data on Quandl is available from within R, Python and Excel using free packages that use our APIs and make it easy to begin your analysis.

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. 
Fix This
Created with Sketch.