WRDS
Wharton Penn
 
 
 
 
 
 
 
 
 





Bureau van Dijk (OSIRIS) Demo

This demo will enable you to extract a subset of BvD OSIRIS data. OSIRIS is s a database containing financial information on globally listed public companies, including banks and insurance firms from over 190 countries. The combined industrial company dataset contains standardized and as reported financials, including restated accounts, for up to 20 years on over 55,000 companies. 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.

Step One: Date Range
Begining Ending

Select date range of data.

Step Two: Search
Search By
Choose 1 Of 3 Methods

1. Company Codes
 
Selected Sample.
2. File Containing Company Codes
 
3. Entire Database
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:
AR30026LAC FR548503135C


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)



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    Select All    Clear
BvD ID Number Current ISIN Number Current SEDOL Number Current Ticker Symbol Current WvB Number Current Valor Number Current CIK Number

General Information    Select All    Clear
Company Name BvD Data Release Date BvD Independence Indicator Listed/Unlisted/Delisted status Main Stock Exchange Previous Company Name Name Change Date Name Change Year Name Change Month Name Change Day-of-Month Postal Code City Province Country Name Country Code Phone Fax Web Site Address Email Address

Structural Information    Select All    Clear
Company Status Incorp. Date (Original Value) Year of Incorp. Month of Incorp. Day of Incorp. Date Became Inactive Year Inactive Month Inactive Day Inactive

Core Activity Codes    Select All    Clear
Industrial Classification Benchmark US SIC, Core Code NAICS Core Code NACE Rev 1, Core Code,

Reporting Information—Header Type    Select All    Clear
Number Years of Financial Data Latest Available Year Lastest Statement Date Lastest Statement Year Lastest Statement Month Lastest Statement Day Currency of the Statement Template Name Template Category Type of Statement Available Consolidation Code Number of Managers Number of Advisors
Reporting Information—Year Specific
Company Fiscal Year End Date Number of Months Covered Unit Currency Exchange Rate to US$ Audit Status Data Source

Balance Sheet Items - Assets    Select All    Clear
Total Current Assets Net Stated Inventory Raw Materials Work in Progress Finished Goods Inventory Prepayments Net Accounts Receivable Accounts Receivable Doubtful Accounts Others Other Current Assets Prepaid Expenses & Advances Deferred Charges Total Cash & Short Term Investment Cash or Equivalent Short Term Investment Fixed Assets Net Properly, Plant & Equipment Land Total Land Depreciation Net Stated land Buildings Total Buildings Depreciation Net Buildings Plant & Machinery Plant & Machinery Depreciation Net Stated Plant & Machinery Transportation Equipment Transportation Equipment Depreciation Net Transportation Equipment Leased Assets Leased Assets Depreciation Net Leased Assets Other Property Plant & Equipment Other Property Plant & Equipment Depreciation Net Other Property Plant & Equipment Intangibles Goodwill Other Intangibles Other fixed assets Exploration Long Term Receivables Investments Long Term Associated Companies Investment Properties Other Long Term Assets Total Assets

Balance Sheet Items - Liabilities    Select All    Clear
Total Current Liabilities Loans Current Long Term Debt Trade Creditors Other Other Short Term Debt Other Creditors Income Tax Payable Social Expenditure Payable Dividends Payable Other Current Liabilities Non Current Liabilities Total LT Interest Bearing Debt Bank Loans Debentures & Convertible Debt Lease Liabilities Other Long Term Interest Bearing Debt Other non-current liabilities Pension Fund Provisions Deferred Taxes Provisions Deferred Revenue Other LT Non-Interest Bearing Debt Minority Interest Total Liabilities and Debt Total Shareholders Equity Share Capital Common Stock/Shares Participation Shares Preferred Shares Redeemable Preferred Shares Other Share Premium Treasury Shares Revaluation Reserves Retained Earnings Other Shareholders Reserves Total Liabilities and Equity

Profit & Loss Items    Select All    Clear
Total revenues Gross sales Adjustments/excise tax Net sales Other revenues Cost of Goods Sold Research and Development Expenses Other Operating Items Earnings before Interest, Tax, Depreciation & Amortization Total Depreciation, Amortization & Depletion Depreciation Amortization & Depletion Operating Income after Depreciation & Amortization Unusual/Exceptional Items Earnings before Interest & Tax Interest income Interest expenses Net interest Other Non-Operating/ Financial Income/ Expenses Earnings before tax Income taxes Earnings after tax Minority interest Other Extraordinary items after tax Preferred dividends Net Profit Ordinary dividends Dividend share capital other

Other Financial Items    Select All    Clear
Net Assets Net Debt Enterprise Value

Financial Ratios    Select All    Clear
Profit Margin (%) Return on Shareholders Funds (%) Return on Total Assets (%) Return on Capital Employed (%) Cost of Empl./Op. Revenue (%) Operat. Rev. per Employee (th) Aver. Cost of Employee/Year (th) Profit per Employee (th) Cash Flow/Oper. Revenue (%) Gross Margin (%) EBIT Margin (%) EBITDA Margin (%) ROE (%) ROA (%) ROCE (%) EV / EBITDA Market Cap/Cash Flow from Operations Current ratio Liquidity ratio Interest Cover Collection Period (days) Credit Period (days) Share.Funds per Employee (th) Working Cap. per Employee (th) Total Assets per Employee (th) Stock Turnover Net Assets Turnover Shareholders Liquidity ratio Solvency ratio (%) Gearing (%)
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

Unless otherwise noted, all material is
Copyright 1994-2009: The Wharton School of the University of Pennsylvania
All rights reserved