BvD Amadeus - Financials


	WRDS Demos

	Compustat
	CRSP
	I/B/E/S
	TAQ
	BVD (Amadeus)
	BVD (Osiris)
	PACAP
	IRRC
	comScore

	Databases

	Features

	FAQs

	Support

	Subscribers

	Request more Information

Bureau van Dijk (Amadeus) Demo

This demo will enable you to extract a subset of BvD (AMADEUS) data. Amadeus is a pan-European financial database. It contains up to 10 years of detailed accounting information (consolidated statements are also provided when available). In the following query, you may change the default selections at each step or hit the submit button to start extracting data.

Please see the subsample of firms available for this demo. WRDS provides for subscribers Amadeus data that contains information on over 10 million companies from 41 countries, including all the EU countries and Eastern Europe.

Step One: Date Range

Beginning Ending

Select date range of data. This demo shows data from 1997. In WRDS, Amadeus has up to 10 years of financial information per company.

Step Two: Search

Search By

Choose 1 Of 3 Methods

	1.	Company Codes
		Code Lookup. Selected Sample from Top "200,000" Companies
	2.	File Containing Company Codes

	3.	Entire Database

Select a Dataset

Conditional Statements (Optional)

AND OR

Select the variable used to search the database.
Enter the companies using 1 of 3 methods.

1.	Codes separated by a single space. Example: CH0000027942C FR552043002U
2.	A file on your local computer with codes entered one per line. (Disabled in this demo).
3.	All companies (all the subsample of firms available in this demo)

In this demo, the only database available is: Top "200,000" Companies. WRDS provides also access to: Top "1,000,000" Companies and All-Amadeus Companies.

Optional
Build conditional statements using the list of variables, comparison operators, desired values, and logical operators. Most data items are represented in units of millions (see documentation for more information).

Example:
CNTRYCDE = FR
AND
TOAS > 1000

Step Three: Variables

Identification Codes
BvD ID Number Current ISIN Number Current SEDOL Number Current Ticker Symbol Dataset

General Information
Company Name Address Zip Code City Region Country Name Country Code Phone Fax Web Site Address

Structural Information
Legal Form Quoted Company Date of Incorporation (SAS format) Year of Incorporation Date of Incorporation (original format)

Company Activity Codes
National Industry Code Type Primary CSO Code Primary NACE1 Code Primary US-SIC Code Primary NAICS Code

Reporting Information�Header Type
Last Year Number Years of Financial Data Date of First Financial Report Date of Last Financial Report Consolidation Code

Reporting Information�Year Specific
Number of Months Covered Unit Currency Exchange Rate to US$

Balance Sheet Items
Fixed Assets Intangible Fixed Assets Tangible Fixed Assets Other Fixed Assets Current Assets Stocks Debtors Other Current Assets Cash & Cash Equivalent Total Assets Shareholder's Funds Capital Other Shareholder's Funds Non-Current Liabilities Long-Term Debt Other Non-Current Liabilities Current Liabilities Loans Creditors Other Current Liabilities Total Share Funds & Liabilities Working Capital Number of Employees

Profit & Loss Items
Operating Revenue/Turnover Sales Cost of Goods Sold Gross Profit Other Operating Expenses Operating P/L Financial Revenue Financial Expenses Financial P/L P/L before Tax Taxation P/L after Tax Extraordinary Revenue P/L for Period Material Costs Costs of Employees Depreciation Interest Paid Cash Flow Added Value EBIT EBITDA

Financial Ratios
Current Ratio Liquidity Ratio Shareholders Liquidity Ratio Solvency Ratio (%) Gearing Share Funds per Employee Working Capital per Employee Total Assets per Employee Profit Margin Return on Shareholders Funds Return on Capital Employed Return on Total Assets Interest Cover Stock Turnover Collection Period (days) Credit Period (days) Net Assets Turnover Cost of Employees/Op. Rev. Operating Revenue/Employee Average Cost of Employee/Year Profit per Employee Cash Flow/Turnover

Select variables to be included in the output. See documentation for a description of each data item.

NOTE: Items in the top block of variables are the same for every company record (i.e., header-type constants) and only show the most recent available values. Items in the lower block are year specific.

Step Four: Output

Output Format

Compression Type

E-Mail Address (Optional)

Select desired format of the output file. For large data requests, select a compression type to expedite downloads. If you enter your email address, you will receive an email that contains a URL to the output file when the data request is finished processing.

Example:
username@school.edu