Data Trends for Investment Professionals


China Stock Data


China Stock Data

Quandl has a comprehensive and accurate collection of Chinese stock market data. Data coverage includes stock fundamentals, financial ratios, and key indicators for thousands of Chinese companies.

Stock prices on the Shenzhen and Shanghai exchanges, stock indexes, securities master data, and other related databases will be added to Quandl soon.

Stock Fundamentals Data

Quandl’s DY1 database, published by DataYes, is the most comprehensive and accurate source of Chinese stock fundamentals data. This database provides current and historical data for 150 key fundamental indicators and financial ratios for more than 2900 Chinese companies trading at the Shanghai and Shenzhen stock exchanges.

Stock fundamentals data can help investors choose the best Chinese stocks to buy. Investing in the Chinese stock market is made easy by Quandl’s Chinese equity research data.

Indicators Available

Company fundamentals include balance sheet, cash flow, and income statements. The indicators included in the DY1 database are listed below.

Balance Sheet

Income Statement

Cash Flow Statement

Cash and cash equivalents

Total revenue

Cash from sales of goods and services

Settlement provision


Net deposits increase from clients and banks and financial inst

Loans to other banks and financial

Interest income

Net increase in borrowings from central bank

Trading financial assets

Premium earned

Net increase in borrowings from other financial institutions

Notes receivable

Commissions income

Cash from insurance premium of original contract

Accounts receivable

Total cost of goods sold

Net cash from reinsurance premium


Cost of goods sold

Net increase in policy holder deposits and investment funds

Premium receivable

Interest expenses

Net increase in disposal of trading financial assets

Reinsurance receivable

Commissions expenses

Cash increase from interests, fees and commissions

Reserves for reinsurance contract receivable

Premiums refund

Net increase from borrowings

Interest receivable

Net compensation payout

Net capital increase of repurchase

Dividend receivable

Reserved for insurance contract

Refunds of taxes

Other receivables

Policy dividend payment

Cash from other operating activities

Purchase for resale financial assets

Reinsured expenses

Cash inflows from operating activities


Business taxes and surcharges

Cash paid for goods and services

Non-current assets due within one year

Selling expenses

Net increase in disbursement of loans and advances

Other current assets

Administration expense

Net increase in deposits in central bank and other banks

Total current assets

Financial expenses

Cash paid for indemnity of original insurance contract

Disbursement of loans and advances

Assets impairment loss

Cash paid for interests, fees and commissions

Available for sale financial assets

Fair value change gain

Cash paid for policy dividends

Held to maturity investment

Investment income

Cash paid to and on behalf of employees

Long term accounts receivable

Investment income from associate and joint venture

Cash paid for taxes

Long term equity investment

Foreign exchange gain

Cash paid for other operating activities

Investment on real estate

Operating profit

Cash outflows from operating activities

Fixed assets

Non-operating gain

Net cashflow from operation activities

Construction in process

Non-operating loss

Proceeds from sell of investment

Construction materials

Non-current assets disposal loss

Gain from investing

Fixed assets disposal

Total profit

Disposal of fixed assets and others

Productive biological assets

Income tax

Net cash from disposal of subsidiaries and other business units

Oil and gas assets

Net income

Cash from other investing activities

Intangible assets

Net income attributable to parent company owners

Cash inflows from investing activities

Research and development expenditure

Minority interests gain

Purchases of fixed assets and others


Basic EPS

Cash paid for investments

Long term amortizations expenses

Diluted eps

Net increase in pledge loans

Deferred tax assets

Other comprehensive income

Net cash paid for acquisitions

Other non-current assets

Total comprehensive income

Cash paid for other investing activities

Total non-current assets

Comprehensive income attributable to parent company owners

Cash outflows from investing activities

Total assets

Comprehensive income attributable to minority shareholders

Net cash flows from investing activities

Short term borrowings

Cash from capital contributions

Borrowings from central bank

Cash from minority shareholders of subsidiaries


Cash from borrowings

Loans from other banks and financial

Cash from issuing bonds

Trading financial liabilities

Cash from other financing activities

Notes payable

Cash inflows from financing activities

Accounts payable

Cash paid for debts

Advance receipts

Cash paid for dividends, profits or interests

Sold for repurchasing financial assets

Cash paid dividends and profits by subsidiaries to minority sha

Commissions payable

Cash paid for other financing activities

Payroll payable

Cash outflows from financing activities

Taxes payable

Net cashflow from financing activities

Interests payable

Foreign exchange effects

Dividends payable

Net change in cash

Other payables

Net cash and cash equivalents beginning balance

Reinsurance payable

Net cash and cash equivalents ending balance

Reserves for insurance contract

Funds from securities trading agency

Funds from securities underwriting agency

Non-current liabilities due within 1 year

Other current liabilities

Total current liabilities

Long term borrowings

Bond payable

Long term accounts payable

Accounts payable special funds

Estimated liabilities

Deferred tax liabilities

Other non-current liabilities

Total non-current liabilities

Total liabilities

Paid in capital

Capital reserve

Treasury share

Special reserve

Surplus reserve

Ordinary risk reserve

Retained earnings

Foreign exchange difference

Total equity attributable to parent company owners

Minority interest

Total shareholder equity

Total liabilities and equity

Each of these indicators are available in two variants: “As-Reported” and “Most-Recently-Reported”. The “As-Reported” view excludes restatements and is typically suitable for back-testing, whereas the “Most-Recently-Reported” view includes restatements and is thus suitable for assessing business performance after restatements for mergers/divestitures.

Using the Data

All of Quandl’s stock market data is available to download in any format; via our API and our tools; and via our Excel addin.

To find the data you need, you can go to the DY1 database page on Quandl. Click on the documentation tab to learn more about the data and how it is organized, or search within the database to find the specific datasets you need. Visit individual dataset pages to download or export the data.

Premium Data

DY1 is a premium database, designed for professional users. As such, it is guaranteed to be accurate, timely, well-documented and comprehensive. Simply register for a free Quandl account to get a free trial for this data.

About DataYes

DataYes is a leading vendor of Chinese economic and market data. DataYes was founded by experts in finance and financial technology, and is backed by the Wanxiang Group, one of China’s largest non-state-owned conglomerates. DataYes uses new-generation financial data processing technology, backed by a committed team of over 200 data analysts and engineers, to create world-class financial data and services. DataYes has offices in Shanghai and in Silicon Valley, and serves 1000s of clients around the world.

API Access

All datasets on Quandl are available via a single uniform API. Here are two example calls for Bank of China revenue and profits:

Terms and Licensing

DY1 is a premium commercial database. To see the prices and subscription licenses, please visit the DY1 subscription page. We offer extremely liberal terms of use, explained in clear language with minimal legalese.

DY1 offers a speculative developer license, giving developers and startups full usage and distribution rights at a much reduced price. Registered Quandl users get free trial access to this database.


To start your free trial of Quandl’s China stock fundamentals data, please register for a free Quandl API key:

Get Your Free API Key

Why register?

Registered users enjoy unlimited downloads, unlimited API usage and free trials of all premium databases.

Fix This
Created with Sketch.